Get a value on a specific date

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.

Find more posts tagged with

python

eikon

workspace

eikon-com-api

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

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:

All comments

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

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.

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.

EXPLORE OUR SITES