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.

Best Answer

  • Gurpreet
    Answer ✓

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


    image


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