Trying to pull prices for multiple funds for a certain day

peter.akester

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.

raksina.samasiri

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

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

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.

peter.akester

@raksina.samasiri Thank you for this! I ran this on a few other codes but it looks like this (B51SBJ3 ) doesnt have a value is there a way to drop NA types?