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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

Trying to download an assortment of fields (10Y history) for Honda motors. I am getting duplicate results, with inconsistent years and potential currency issues, with the following query.


df, err = ek.get_data(

instruments = 'JP3854600008 ',

# instruments = inputs,

fields = [

'TR.CashAndSTInvestments.date',

'TR.EV.value',

'TR.CompanyMarketCap.value',

'TR.CashAndSTInvestments.value',

'TR.TotalDebtOutstanding.value' ],

parameters = {'Frq':'FY','SDate':'0','EDate':'-10', 'CURN':'USD'}

)



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 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
1.7k 2 4 7

Hello @John.Simmons

Could you please share the output you got and point out the problem, so I could do further investigation

Below is the screenshot of the output I got, it doesn't seem to be duplicated and currency of each field is USD

qna-003.png


qna-003.png (80.3 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea