Get a value on a specific date

zeeshine

Hi,

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.

chavalit-jintamalit

Hi @zeeshine

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:

zeeshine

https://community.developers.refinitiv.com/discussion/comment/47719#Comment_47719

hi Chavalit, thanks, may i ask further that in the first TR formula, I'm using =TR("GOOGL.O","TR.CLOSEPRICE.value",), however, Parameter(s) shows blank, shouldn't the date(or other available argument) be shown in a drop down list? thanks again.

chavalit-jintamalit

https://community.developers.refinitiv.com/discussion/comment/47720#Comment_47720

In your picture, you selected CF_CLOSE as explained in my answer.

You can select TR.CLOSEPRICE as below picture:

nick.zincone

Hi @zeeshine,

Within the formula builder, you can select the "Parmaeters & Quick Functions" tab on the upper right to apply additional parameters, including date.