Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aquilesjlp300 avatar image
98 ●27 ●33 ●35

On repeated dates inside a request

Hello everyone,

I've noticed that for some TR formulas, some values are consistently being repeated, but I'd like to know the criteria (if possible of course) to choose which dates to repeat.

I'll use as example the following code, that produces the data in the screenshot:

import eikon as ek
ek.set_app_id('xxxxxx')
out2 = ek.get_data(['AA.N'], ['TR.FCFMean', 'TR.FCFMean.date'],{'SDate':'-24M','EDate':'-10M','Frq':'M','Curn':'USD', 'Period':'FY1'}) 
print(out2)

captura.jpg

Same thing in Excel, notice the repeated dates on the end.

captura.jpg

My assumption is that, to fill the vacant slot of data for this company, it just repeats one of the values to complete the request. The same happens for other companies, but other dates are repeated, such is the case for companies like AAN.N.

How can we understand better this behavior? Would using .calcDate instead of date solve this more properly?

Thanks in advance.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-com-apiexcel
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvote
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

I believe your understanding is correct. TR.FCFMean.date represents the date the estimate was published, which can be repeated when the sampling period defined by Frq parameter is more granular than the interval between two consecutive estimates. Using your example that would be the case when there was no estimate update published within a month and the number from the previous month is repeated in the monthly series. TR.FCFMean.calcdate corresponds to the end of the sampling period (end of the month in your example), and therefore shouldn't have any repeat values.
This said to get an authoritative explanation on what these dates represent I suggest you contact Refinitiv Helpdesk and use Excel example to illustrate your question. The moderators on this forum do not have the deep content expertise required to provide an authoritative answer to your question. The Helpdesk on the other hand will either have this expertise ready available or can reach out to content experts for the specific type of content you're interested in.

icon clock
10 |1500

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

aquilesjlp300 avatar image aquilesjlp300

Thanks Alex!

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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