Trying to download an assortment of fields (10Y history) for Honda motors. I am getting duplicate...

John.Simmons

... 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'}

)

raksina.samasiri

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