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.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
0
●3 ●4 ●7
Trying to pull prices for multiple funds for a certain day
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
14.2k
●30 ●5 ●10
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.
@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?
hi @peter.akester ,
Thank you for your patience, you may add a code to filter only rows with no error returned from get_symbology call, for example
# Convert Instruments from SEDOLs to RICs
rics_df = ek.get_symbology(
['B563VJ3','B5N9ZW5','B4S5QZ1','3087914','B51SBJ3'],
from_symbol_type='SEDOL',
to_symbol_type='RIC')
#display(rics_df)
#rics_df[rics_df['error'].isna()]
# add the code below
rics_list = rics_df[rics_df['error'].isna()]['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')
