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
p.saffi avatar image
1 ●0 ●0 ●2

Trading volume and market capitalization data for delisted stocks

Hello,

I'm working with Brazilian data and trying to get price, return, trading volume and market capitalization (in units) for all firms in the past 15 years.

However, I'm having trouble getting the data for delisted stocks. I asked Refinitv Support and they told me the following:
"The information that exists for delisted Rics is scarce and includes only pricing data, usually Trade Price, Bid, Ask, Net asset value and Turnover.

TR.IssueMarketCap: The issue market capitalization represents the market value of the requested issue share type. It is calculated by multiplying the requested share type by the last close price. This item supports Default, free-float, and outstanding share types. The default share type is the most widely reported outstanding shares for a market and its most commonly issued, Outstanding, or Listed shares."

I can believe that Refinitv doesn't allow proper backtesting if they drop data on stocks that are delisted. Any info on whether that can be downloaded using Python?

For example, here is the formula for one delisted RIC (it was a large company around that time): =@TR("ELPL4.SA^K17","TR.CLOSEPRICE.date;TR.CLOSEPRICE(Adjusted=0),TR.CLOSEPRICE(Adjusted=1);TR.Volume;TR.DailyValueTraded","SDate=2012-01-01 EDate=2012-02-01 Frq=D CH=Fd RH=IN")

From the attached file with historical data on the internet, notice that, for example, on 02-Jan-2012, there is a return and trading volume, but the formula doesn't return any data. Could you let me know how to retrieve it? I would also like to get info on the variable TR.IssueMarketCap

For a listed stock, everything works fine: =@TR("MGLU3.SA","TR.CLOSEPRICE.date;TR.CLOSEPRICE(Adjusted=0),TR.CLOSEPRICE(Adjusted=1);TR.Volume;TR.DailyValueTraded;TR.TotalReturn.date;TR.TotalReturn;TR.TotalReturn1D;TR.IssueMarketCap","SDate=2012-01-01 EDate=2012-02-01 Frq=D CH=Fd RH=IN")

I really appreciate any help you can provide.

Pedro

screenshot-2024-03-19-at-13-59-59-elpl4-historico.png


#technology#contentpython api
screenshot-2024-03-19-at-13-59-59-elpl4-historico.png (97.9 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.

wasin.w avatar image   wasin.w

Hello @p.saffi

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

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


1 Answer

· Write an Answer
Upvotes
Accepted
aramyan.h avatar image
5k ●16 ●2 ●7

Hi @p.saffi ,


You can use Refinitv Data Libraries for Python to get the pricing data. See below:

import refinitiv.data as rd
rd.open_session()

rd.get_history("ELPL4.SA^K17", start = "2012-01-01", end = "2024-03-10")


screenshot-2024-03-19-at-175255.png

This returns all available fields. you can specify fields by using field parameter inside the get_history call.


As it comes to the market cap, it seems there is no market cap information for that specific instrument. I have checked for another delisted stock and we do have the market cap info for that:

rd.get_history("WORK.N^G21", fields = "TR.CompanyMarketCap", start = "2012-01-01", end = "2024-03-10")

screenshot-2024-03-19-at-175930.png

You can ask the content team for the missing instrument.

Hope this helps.


Best regards,

Haykaz


screenshot-2024-03-19-at-175255.png (92.4 KiB)
screenshot-2024-03-19-at-175930.png (32.6 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.

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.