-
Notifications
You must be signed in to change notification settings - Fork 1
BD_HISTORY_KPI
| Syntax | Description | Required | Type | Sample |
|---|---|---|---|---|
| InstId | Instrument Id | yes | number | 3 |
| KpiId | Kpi Id | yes | number | 2 |
| ReportType | What report data is used for kpi calculation."year", "r12", "quarter" | yes | String | "year" |
| PriceType | What stockprice is used for historical kpis. | yes | String | "mean" |
| Standing | Show table as flatt or standing. 0=default | no | number | 0, 1 |
| RemoveRange | clear old data | no | string range | "A2:C100" |
Here you can see all Historical Kpis that is avaible.
https://github.com/Borsdata-Sweden/API/wiki/KPI-History
=BD_HISTORY_KPI(97;2;"year";"mean")
This will return current and historical P/E for Hennes & Mauritz (97). The PE value is calculated with Yearly Report data and the mean stockprice for one year.
=BD_HISTORY_KPI(3;2;"r12";"high")
This will return current and historical P/E for ABB (3). The PE value is calculated with Rolling 12 month (r12) Report data and use the highest stockprice for one year.
Same calls as Nordic
=BD_HISTORY_KPI(10214;"year";"mean")
This will return current and historical P/E for APPLE
Home
Installation
=BD_INSTRUMENTS()
=BD_INSTRUMENT_DESCRIPTION(InstId)
=BD_INSTRUMENTS_GLOBAL()
=BD_INSTRUMENTSEARCH()
=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_REPORT_CALENDAR(InstId)
=BD_DIVIDEND_CALENDAR(InstId)
=BD_HOLDINGS_INSIDER(InstId)
=BD_HOLDINGS_SHORTS()
=BD_HOLDINGS_BUYBACK(InstId)