Shares Outstanding does not give back any values

JakobGruber

Dear LSEG Community,

Iam looking to get a timeseries of shares oustanding of all S&P500 companies.

data = ld.get_history(
universe=RICS,
fields="TR.TOTALNUMBEROFSHARESOUTSTANDING",
start="2010-01-01",
end="2024-01-01",
interval="yearly"
)

RICS is defined as all Tickers from the S&P500. While the code works perfectly fine it dooesnt result in any numbers.

Greetings

Jakob

jonathan.legrand0

Hi @JakobGruber,

Please look into the DIB, you can find training for it here:
https://developers.lseg.com/en/video-catalog/data-item-browser

I would advise ticking the 'Blank Values' off:

Doing so, I got the following field item: "TR.F.ComShrOutsTot".

As can be seen below, not all companies publish this information at the same time; you may want to tidy the data once it is returned:

import lseg.data as ld

ld.open_session()

spx = ld.discovery.Chain(name="0#.SPX")

print(spx.constituents[0:10])
ld.get_history(

    universe=spx.constituents[0:10],

    fields="TR.F.ComShrOutsTot",

    start="2010-01-01",

    end="2024-01-01",

    interval="yearly")