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
Hi,
I have 2 questions:
1. I'm trying to fetch prices for few delisted RICs for eg APOL.OQ^B17 but I have the old RICs i.e APOL.OQ. Is there anyway to fetch the prices directly using the old ticker or convert the old RICs to new RICs (P.S. Have tried rdp.search('APOL.OQ') and ek.get_symbology, doesnt seem to work).
2. Can we generate a list of all stocks that existed in US markets (both listed and delisted as of now) and the RICs.
Hi @BlackBird ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar 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
Dear @BlackBird ,
Thank you for your question. In order to get the price data for the delisted assets you need to query with the delisted RIC:
df = rd.get_history('APOL.OQ^B17')
df
To get the delisted RIC you can use the Search capabilities of Refinitiv Data Library:
rd.discovery.search(
view = rd.discovery.Views.EQUITY_QUOTES,
query = 'APOL.OQ*',
top = 10,
filter = "SearchAllCategoryv2 eq 'Equities' and RCSIssuerCountryLeaf eq 'United States'",
select = "DTSubjectName,ExchangeName,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,CUSIP,CinCUSIP,SEDOL,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,RCSIssuerCountryLeaf,IsActive"
)
To answer your second question, you may use the following query and modify the select fields as necessary:
rd.discovery.search( view = rd.discovery.Views.EQUITY_QUOTES, top = 10, filter = "SearchAllCategoryv2 eq 'Equities' and RCSIssuerCountryLeaf eq 'United States'", select = "DTSubjectName,ExchangeName,RIC,IssueISIN,Gics,AssetState,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,CUSIP,CinCUSIP,SEDOL,RCSAssetCategoryLeaf,RCSCurrencyLeaf,ExDividendDate,RCSIssuerCountryLeaf,AssetState" )
Hope this helps.
Best regards,
Haykaz
