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
hi, I have some tickers that I want to drag in EUR prices for;
TICKERS = ['4958.TW', '2899.HK', 'ZBH.N', 'ZI.OQ', '3092.T']
get_pricing_1 = ek.get_timeseries(TICKERS, fields='CLOSE',start_date='2023-09-28',end_date='2023-10-27')
Can I amend that to get EUR prices on each underlying? Thx
Hi @c.dass ,
As much as I know ek.get_timeseries doesn't support currency conversion. However, you can use ek.get_data instead:
TICKERS = ['4958.TW', '2899.HK', 'ZBH.N', 'ZI.OQ', '3092.T']
get_pricing_1, err = ek.get_data(TICKERS, fields=['TR.Close', 'TR.Close.date'],parameters = {'Sdate': '2023-09-28', 'Edate':'2023-10-27', 'curn':'EUR'})
get_pricing_1
And if you want to tramsform the data into a similar format that ek.get_timeseries returns, you can use pivot:
pivot_df = get_pricing_1.pivot(index='Date', columns='Instrument', values='Price Close') pivot_df
Hope this helps.
Best regards,
Haykaz
