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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
0 1 2 4

Trying to pull prices for multiple funds for a certain day

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.


pythonexcelpython api
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
5.1k 8 5 8

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.


1655379295065.png (28.8 KiB)
1655379510980.png (132.0 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.

@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?