Eikon not pulling correct CY data

Arpit Jain

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]

raksina.samasiri

@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

• Contact Us capability in your Eikon application
• or by calling the Helpdesk number in your country.
• or at https://my.refinitiv.com/content/mytr/en/productsupport.html