-
Notifications
You must be signed in to change notification settings - Fork 0
BD_STOCKPRICE_GLOBAL_DATE
Henrik edited this page Sep 8, 2022
·
1 revision
Return stockprice list of Nordic+Global instruments for one specific date.
Syntax | Description | Required | Type | Sample |
---|---|---|---|---|
Date | Get stockprice for date | yes | date | "2018-02-02" |
RemoveRange | clear old data | no | string range | "A2:C100" |
=BD_STOCKPRICE_GLOBAL_DATE("2019-01-02")
Note. If you dont get any stockprice for a date then maybe this is a holliday or weekend?
Also make sure you have " " around date.
Home
Installation
=BD_INSTRUMENTS()
=BD_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)