Trying to pull prices for multiple funds for a certain day

peter.akester
peter.akester Newcomer
in Eikon Data APIs

Hi all, im trying to pulling historical market price data for the 15/05/2022 for alot of SEDOLs eg(B563VJ3,B5N9ZW5,B4S5QZ1,3087914) in either Python or Excel. any help would be appreciated on how to achieve this. Thanks in advance.


Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hi @peter.akester ,

    For Python, the code below can be used (To create app key, you can follow this quick start guide)

    import refinitiv.dataplatform.eikon as ek
    ek.set_app_key('## YOUR APP KEY ##')

    # Convert Instruments from SEDOLs to RICs
    rics_df = ek.get_symbology(
        ['B563VJ3','B5N9ZW5','B4S5QZ1','3087914'], 
         from_symbol_type='SEDOL', 
         to_symbol_type='RIC')
    rics_list = rics_df['RIC'].to_list()

    # get the price of rics list above using get_timeseries function
    ek.get_timeseries(rics_list, 
                      start_date='13-05-2022', 
                      end_date='16-05-2022', 
                      interval='daily')

    However, the result of 15-05-2022 is not returned

    1655379295065.png

    So I tried to check using Excel formula and found that there're no data on this date (15-05-2022)

    1655379510980.png

    To clarify the reason that the data of this date is missing, the ticket to the Refinitiv helpdesk can be submitted at MyRefinitiv (please also mention that the data is missing when using Eikon Excel formula and you may attach the screenshot of Excel above) so they can refer the case to the content specialist and they will contact you directly to provide an information.

Answers

Categories