-
Notifications
You must be signed in to change notification settings - Fork 3
BD_SCREENER_GLOBAL_KPI
Borsdata Screener return one kpi value for Nordic+Global instruments.
The Kpi Value is calculated with the lastest report and stockprice data.
| Syntax | Description | Required | Type | Sample |
|---|---|---|---|---|
| KpiId | Kpi Id | yes | number | 247 |
| CalcGroup | Internal name for calculation | yes | String | "last" |
| Calc | Internal name for calculation | yes | String | "latest" |
| Standing | Show table as flatt or standing.1=default | no | number | 0, 1 |
To find the correct KpiId, CalcGroup and Calc, you can go to screener and use the API Url.
https://github.com/Borsdata-Sweden/API/wiki/KPI-Screener
Copy Screener API URL.
https://apiservice.borsdata.se/v1/instruments/kpis/247/last/latest?authKey=[YOUR_API_KEY]
In excel the same call will be…
=BD_SCREENER_GLOBAL_KPI(247; "last"; "latest")
=BD_SCREENER_GLOBAL_KPI(247; "last"; "latest",0)
Show as flatt table
=BD_SCREENER_GLOBAL_KPI(2;"last";"latest")
Lastest P/E
Get Started
=BD_INSTRUMENTS()
=BD_INSTRUMENT_SEARCH()
=BD_INSTRUMENTS_GLOBAL()
=BD_DESCRIPTION()
=BD_KPI_SUMMARY()
=BD_STOCKPRICE()
=BD_STOCKPRICE_DATE()
=BD_STOCKPRICE_GLOBAL_DATE()
=BD_STOCKPRICE_LAST()
=BD_STOCKPRICE_GLOBAL_LAST()
=BD_REPORT_QUARTER()
=BD_REPORT_R12()
=BD_REPORT_YEAR()
=BD_HISTORY_KPI()
=BD_SCREENER_KPI()
=BD_SCREENER_GLOBAL_KPI()
=BD_HOLDINGS_INSIDER()
=BD_HOLDINGS_SHORTS()
=BD_HOLDINGS_BUYBACK()