Hi Dev Team, Good morning.!
May I request for your assistance please. Client wants to pull data using FQ0. and needs code that to use for the LATEST AVAILABLE shares outstanding.
Script given by client:
import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = [
'NVDA.O','AJG','ABBV.K', 'ACCO.K', 'AMG', 'ALRS.O', 'AMP', 'AMTB.K', 'ACA', 'AXSM.O',
'BAX', 'TEAM.O', 'BFLY.K', 'BRKR.O', 'CAKE.O', 'CIFR.O', 'CMPO.K', 'DAR',
'D', 'DBRG.K', 'EW', 'EPD', 'EVR', 'FHI', 'FBRT.K', 'FORR.O', 'FRPT.O',
'FSTR.O', 'GL', 'HSII.O', 'IDXX.O', 'III.O', 'ILMN.O', 'ISTR.O', 'ITGR.K',
'IVR', 'KLAC.O', 'KEX', 'KOS', 'KRYS.O', 'KVUE.K', 'LEG', 'LQDA.O', 'MCS',
'MD', 'MRK', 'MRTN.O', 'NSSC.O', 'OFG', 'ON.O', 'OSBC.O', 'ZEUS.O', 'PKG',
'TXNM.K', 'DTIL.O', 'PIPR.K', 'RGEN.O', 'RMAX.K', 'RRR.O', 'ROKU.O', 'ROP.O',
'RSI', 'SCHW.K', 'SM', 'SAMG.O', 'SWKS.O', 'SBUX.O', 'SMBC.O', 'SO', 'SYK',
'TWLO.K', 'VRTS.K', 'AON.N', 'BIOX.OQ', 'YUMC.K', 'WALD.OQ', 'OSW.OQ',
'AMBK.PK', 'AMBZ.PK', 'ATLO.O', 'AMNF.PK', 'ARTNA.O', 'BBBK.PK', 'BFCC.PK',
'BNCC.PK', 'BVFL.O', 'BHRB.O', 'CNA', 'CSBB.PK', 'UAN', 'DXR.O', 'DFH',
'DSBX.PK', 'EXSR.PK', 'NVNO.O', 'FABP.PK', 'FACO.PK', 'FBAK.PK', 'FBSI.PK',
'FFMR.PK', 'FMCB.PK', 'FMFP.PK', 'FNWD.O', 'FGFH.PK', 'FIP.O', 'FNRN.PK',
'FPH', 'FRAF.O', 'GSIT.O', 'GAM', 'GBLI.K', 'GDVTZ.PK', 'GLBZ.O', 'GNE',
'HFBA.PK', 'MCHB.O', 'IROQ.O', 'BOTJ.O', 'ISBA.O', 'KCLI.PK', 'KEWL.PK',
'L', 'LYBC.PK', 'MFGI.PK', 'MHGU.PK', 'MLGF.PK', 'MNAT.PK', 'MPW', 'MSGS.K',
'TUSK.O', 'MRCR.PK', 'NACB.PK', 'NCSM.O', 'NKSH.O', 'NEXT.O', 'NTGR.O',
'PDER.PK', 'PKIN.PK', 'PDEX.O', 'PSMT.O', 'QNTO.PK', 'SPR', 'TDCB.PK',
'TPRP.PK', 'UNB.O', 'UNTC.PK', 'USLM.O', 'WCFB.PK', 'WLKP.K', 'WOLF.K',
'WTBFB.PK', 'ADSE.OQ', 'CREV.OQ', 'CRML.OQ', 'HTCO.OQ', 'ZDGE.K', 'APM.OQ',
'NNOX.OQ', 'SILC.OQ', 'SWVL.OQ', 'TK.N', 'UTSI.OQ'
],
fields = [
'TR.TickerSymbol',
'TR.F.ComShrOutsTot(SDate=2025-11-03,Period=FY0).fperiod',
'TR.F.ComShrOutsTot(SDate=2025-11-03,Period=FY0)',
'TR.F.ComShrOutsTot(SDate=2025-11-03,Period=FQ0).fperiod',
'TR.F.ComShrOutsTot(SDate=2025-11-03,Period=FQ0)',
'TR.F.ComShrOutsTot(SDate=2025-11-03,Period=FQ-1).fperiod',
'TR.F.ComShrOutsTot(SDate=2025-11-03,Period=FQ-1)',
'TR.F.ComShrOutsTot(SDate=2025-11-03).fperiod',
'TR.F.ComShrOutsTot(SDate=2025-11-03)',
'TR.NetprofitRepActReportDate(Period=FQ0)',
'TR.NetprofitRepActReportDate(Period=FY0)'
],
parameters={
# 'SDate': '2025-02-03',
# 'EDate': '2025-02-21',
'Scale':6,
},
)
display(df)
# Save to CSV
df.to_csv('shares_outstanding.csv', index=False)
print("Data saved to shares_outstanding.csv")
Here are some sample rows:
Instrument | Ticker Symbol | Financial Period Absolute | Common Shares - Outstanding - Total (FY)_ | Financial Period Absolute | Common Shares - Outstanding - Total (FQ0_ | Financial Period Absolute | Common Shares - Outstanding - Total (FQ-1) | Financial Period Absolute | Common Shares - Outstanding - Total | Report Date (FQ0) | Report Date (FY0) |
|---|
NVDA.O | NVDA | FY2025 | 24477 | FY2026Q2 | 24347 | FY2026Q1 | 24388 | FY2025 | 24477 | 8/27/2025 16:23 | 2/26/2025 16:20 |
AJG | AJG | FY2024 | 250 | FY2025Q3 | 256.805 | FY2025Q2 | 256.4 | FY2024 | 250 | 10/30/2025 16:15 | 1/30/2025 16:15 |
ABBV.K | ABBV | FY2024 | 1765.257 | | | FY2025Q2 | 1766.461 | FY2024 | 1765.257 | 10/31/2025 7:49 | 1/31/2025 7:36 |
You can see that ABBV has 0 shares outstanding for FQ0 because they reported and released an 8K but they have not produced a 10Q with share count.
Thus if I use the FQ0 code shares outstanding comes through as N/A. If I do not pass a date parameter I get the FY sharecount, which is different from the most recently quarterly sharecount that is available, FQ-1).
Thank you for your advance support!
