Get Price History
Returns the price history of an instrument as a table for the given date range. (Similar to BBG BDH function)
GETPRICEHISTORY(instument_id, start_date, end_date)
The GETPRICEHISTORY function has the following arguments
- instrument_reference Required. The Instrument reference (Accepts either a Instrument Reference or a SICOVAM) of the instrument.
- start_date Optional. Start date of the price range.
- end_date Optional. End date of the price range.
A table array with the following columns
| Date | First | High | Low | Last | Theoretical | Bid | Ask | Volume |
| Formula | Result |
|---|---|
| =GETPRICEHISTORY(67123123) | An array of price history |
| =GETPRICEHISTORY(12345, "01-JAN-2019", "31-MAY-2019") | An array of price history with the given start and end dates |
