Skip to content

BD_STOCKPRICE_DATE

Henrik edited this page Apr 24, 2020 · 5 revisions

BD_STOCKPRICE_DATE(Date; RemoveRange)

Return stockprice list of all 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"

RemoveRange

Sample

=BD_STOCKPRICE_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.

Clone this wiki locally