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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 1 1

How to get Asia or Europe close price via python get_timeseries or get_data function

Similar function to that in excel:

=@RHistory("BRTCALAMc1","TRADE PRICE EUROPE.Timestamp;TRADE PRICE EUROPE.Close","START:"2021-04-01" END:"2021-04-20" INTERVAL:1D",,"TSREPEAT:NO SORT:ASC CH:Fd",B6)


using either the get_timeseries or get_data function in python.

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apitime-seriestimestamp
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

Upvotes
Accepted
16.7k 43 12 19

Hi @Ruofan.Wang,

You can use the get_data API call to get similar information from the Data API. Please note that all the information available in RHistory is not available, or same as Eikon Data API.

df, err = ek.get_data('BRTCALAMc1', ['TR.USCLOSINGTRADEPRICE', 'TR.USCLOSINGTRADEPRICE.timestamp'], {'SDate':'2021-04-01', 'EDate':'2021-04-20'})



Please use TR.EUROPECLOSINGTRADEPRICE field to get European Closing Trade Price.


1619023093354.png (30.8 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.