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

question

Upvotes
Accepted
15 5 8 11

How to get price data for delisted RICs using old RICs?

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.

eikoneikon-data-api#product
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

· Write an Answer
Upvotes
Accepted
4.8k 13 2 7

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"
)

screenshot-2023-05-25-at-144028.png


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"
)

screenshot-2023-05-25-at-144215.png


Hope this helps.


Best regards,

Haykaz


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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.