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
1 1 2 6

Eikon not pulling correct CY data

I'm using the following code. Not able to get correct Calendar Year data. Data is the same for CY and FY data

df_test_3 = ek.get_data('EMR.N', ['TR.Revenue.fperiod' , 'TR.Revenue.periodenddate' , 'TR.Revenue' , 'TR.NetSales' , 'TR.CostofRevenueTotal' , 'TR.GrossProfitMarginIndustrialAndUtilityPct' , 'TR.RevenueperEmployeescalYrEnd'],{'SDate': '20120101' , 'EDate': '20211231' , 'FRQ': 'CY', 'Curn': 'USD' })[0]

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-data-platform-eikon
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
Upvotes
Accepted
14k 30 5 10

@Arpit Jain

According to 'Data Item Brower' (DIB) in Eikon desktop app, the description of the fields mentioned are the data of Fiscal year data. Plus, you can check which parameter is available for each field in the 'Parameters' tab of DIB (CY isn't available on these fields)

Please see the attached image for these fields' descriptions and available parameters in DIB

fy.png

To get the data you want, I'd suggest you check with Refinitiv Content Helpdesk who have expertise in the content, they will provide you the proper Eikon Excel formula and then you can convert that formula to Python code (which we're happy to help you convert that too, if needed)

The helpdesk can be reached using any method below



fy.png (107.7 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.

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.