Shares Outstanding does not give back any values

JakobGruber
JakobGruber Newcomer
edited March 6 in Refinitiv Data Platform Libraries

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

Tagged:

Best Answer

  • jonathan.legrand0
    jonathan.legrand0 admin
    Answer ✓

    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:

    image.png



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

    image.png

Categories