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
florent.martini avatar image
22 ●4 ●1 ●0

How do I get good dates

Hi,

Here is my code : 

Revenue_yoy, err = ek.get_data(flat_list_PG, ["TR.RevenueMean","TR.RevenueMean.Date"],{'Frq':'FY','Period':'FY1','SDate':'-1','EDate':'3'})
Revenue_yoy = Revenue_yoy.iloc[::-1]
Revenue_qoq, err = ek.get_data(flat_list_PG, ["TR.RevenueMean","TR.RevenueMean.Date"],{'Frq':'FQ','Period':'FQ1','SDate':'-1','EDate':'8'})
Revenue_qoq = Revenue_qoq.iloc[::-1]
Revenue_yoy


As you can see thereafter :

The dates are not right.

For the Dataframe Revenue_qoq it is the same.


Thanks for your help

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
1599076645406.png (78.8 KiB)
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.

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

@florent.martini

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If so please can you click the 'Accept' text next to the appropriate reply?

This will guide all community members who have a similar question.

Thanks,

AHS

1 Answer

· Write an Answer
Upvote
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @florent.martini

You can use "TR.RevenueMean.periodenddate" field.

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.