Description

Returns the price history of an instrument as a table for the given date range. (Similar to BBG BDH function)

Syntax

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.

Returns

A table array with the following columns

| Date | First | High | Low | Last | Theoretical | Bid | Ask | Volume |

Example

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

Demo