-
Notifications
You must be signed in to change notification settings - Fork 1
Functions
BD_INSTRUMENTS()
BD_STOCKPRICE(InstId; StartDate; EndDate)
BD_STOCKPRICE(InstId; StartDate; EndDate)
BD_SCREENER_KPI(KpiId; CalcGroup; Calc; Standing)
BD_HISTORY_KPI(InstId; KpiId; ReportType; PriceType; Standing)
BD_KPI_SUMMARY(InstId; ReportType; Fixed)
BD_REPORT_YEAR(InstId; Standing; Fixed)
BD_REPORT_R12(InstId; Standing; Fixed)
BD_REPORT_QUARTER(InstId; Standing; Fixed)
Get list with all Instruments
=BD_INSTRUMENTS()
Get all Stockprice history for one instrument.
You can add a time range.
| Syntax | Description | Required | Type | Sample |
|---|---|---|---|---|
| InsId | Instrument ID | yes | number | 97 |
| StartDate | Oldest date from now | no | String | "2018-01-01" |
| EndDate | Closest date from now | no | String | "2018-02-01" |
=BD_STOCKPRICE(97)
Get all stockprice history of Stock Hennes & Mauritz B
=BD_STOCKPRICE(97;"2018-01-01";"2018-02-01")
Get stockprice history for a dateperiod
=BD_STOCKPRICE(B1;A1;A2)
Cell reference.
B1 is the number of instrument.
A1 and A2 is date.
#
=BD_STOCKPRICE(B1;A1;IDAG())
To get last date you can user formula =TODAY() or =IDAG()
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)