I'm trying to get an item value of an instrument on a specific date by using TR function in excel, but it looks the TR function always get the latest quote, it won't allow a specific date. I watched the user guide video which said the date argument can be defined as a parameter.
I also tried to use timeseries to retrieve the data but the issue is when it comes to timeseries, the field/items become lesser and all the values are showing "invalid field(s)" or #N/A.
Appreciate so much if anyone could help for this issue, thanks.
In your code sample, you are using TR.CLOSEPRICE field.
But in your Formula Builder, you are using CF_CLOSE field.
These 2 fields are from different database.
CF_CLOSE is on "real time" database and it does not support historical data.
TR.CLOSEPRICE is on "Timee Series" database and it supports historical data.
Here is sample code to define date with TR.CLOSEPRICE: