Follow the instructions below to install the Excel Plugin. Check out the Example.xlsx file for a detailed usage example.
-
Download all the files in this repository by clicking on the green "Code" button and then on "Download ZIP". Unzip the files once downloaded. Alternatively you can also just download the SimFinApi.bas file.
-
Open Developer Tab in Excel (to show the developer tab, click here for instructions)
-
Click on "Visual Basic" then on "file" -> "Import File" -> Select SimFinAPI.bas that you downloaded from this repository.
The formula is:
=SimFin(Company Ticker As String; Year As Integer; Period As String; Columname As String; API-key As String; [optional] ttm as String = "false"; [optional] asReported as String = "false")
To see the inputs in the formula, type "=simfin(" and then press Ctrl + Shift + a
So for example:
=SimFin("AAPL"; 2020; "FY"; "Revenue"; "YOUR-API-KEY")
or if you want to retrieve TTM values for Q1 2020:
=SimFin("AAPL"; 2020; "Q1"; "Revenue"; "YOUR-API-KEY"; "true")
Your API-key and more info (for example all available lien item names) can be found at https://app.simfin.com/excel