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
18 1 1 3

ek.get_data("AAPL.O", "TR.TRESGScore", {'Period': "CY2016"}) : At which point in time do data get pulled ?

Here the monitor displays the period-end-date of 2015 and 2016 as 26-09-2015 and 24-09-2016, respectively. Does this mean the formula above lets data be pulled out at any point in time from 27-09-2015 to 24-09-2016? Besides, is my understanding correct that the calendar year 2016 is from 27-09-2015 to 24-09-2016?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apiesgcalendar
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.

Upvote
Accepted
4.6k 26 7 22

@Yuma

Calendar year starts on the 1st of January and ends on the 31st of December:

What you are referring to, I am guessing, is Apple's fiscal year end, which is the 30th of September:

For instance, try this:

df, e = ek.get_data("AAPL.O", ['TR.TRESGScore.date', 'TR.TRESGScore'], {'Period': 'FY0', 'SDate':'-10', 'EDate':'0'}) 

I suggest you double-check this with your local Refinitiv support desk, but please make sure your question is about Eikon Excel and TR function, which somewhat equivalent to ek.get_data.


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.

Upvotes
18 1 1 3

The two commands, 'TR.TRESGScore.date' and 'TR.CompanyFYearEnd', pretty much sums up what I wanted to know. I greatly appreciate your support and my questions are cleared.

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.

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.