For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
zeeshine avatar image
1 ●0 ●0 ●0

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.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-api
untitled.png (11.8 KiB)
untitled-2.png (61.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvote
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

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:


ahs0.png (82.1 KiB)
ahs.png (15.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

zeeshine avatar image 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.

chavalit-jintamalit avatar image chavalit-jintamalit zeeshine

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

You can select TR.CLOSEPRICE as below picture:

2019-08-22-22-11-48.png (108.3 KiB)
Upvotes
nick.zincone avatar image
9.7k ●49 ●38 ●60

Hi @zeeshine,

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


ahs.png (63.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea