-
Notifications
You must be signed in to change notification settings - Fork 1
BD_KPI_SUMMARY
Return table of reportdata and Kpis.
Return global data if you have access.
Same data as you get from Borsdata Excel Export.
| Syntax | Description | Required | Type | Sample |
|---|---|---|---|---|
| InstId | Instrument Id | yes | number | 3 |
| ReportType | What report data is used for kpi calculation."year", "r12", "quarter" | yes | String | "year" |
| Fixed | Return Fixed number of history data. | no | number | 1 to 100 |
| RemoveRange | clear old data | no | string range | "A2:C100" |
| Original | Return original report currency, 0=default | no | number | 0,1 |
=BD_KPI_SUMMARY(3;"year")
Return table for ABB based on Year reports
=BD_KPI_SUMMARY(3;"r12";5)
Return table of last five, R12 reports for ABB.
=BD_KPI_SUMMARY(10214;"year")
Return table for Apple based on Year reports
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)