Skip to content

BD_SCREENER_KPI

Henrik edited this page Sep 13, 2022 · 2 revisions

BD_SCREENER_KPI(KpiId; CalcGroup; Calc; Standing)

Borsdata Screener return one kpi value for Nordic 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

Sample Nordic

Copy Screener API URL.
https://apiservice.borsdata.se/v1/instruments/kpis/247/last/latest?authKey=[YOUR_API_KEY]

In Add-on the same call will be…

=BD_SCREENER_KPI(247; "last"; "latest")
=BD_SCREENER_KPI(247; "last"; "latest",0)

Show as flatt table

=BD_SCREENER_KPI(2;"last";"latest")

Lastest P/E