Missing Data

[siddjain]

It seems simfin does not have data for all tickers. is that true? below is example where I could not find data for ALL (Allstate)

Code Example

 
>>> import pandas as pd
>>> df = pd.read_csv('~/simfin_data/us-balance-quarterly.csv', sep=';')
>>> for t in ['AAPL', 'MSFT', 'ALL']:
...   rows = df[df['Ticker'] == t].sort_values('Publish Date')
...   if rows.empty:
...     print(t, 'not found'); continue
...   r = rows.iloc[-1]
...   ltd, std, eq = r['Long Term Debt'], r['Short Term Debt'], r['Total Equity']
...   ltd = 0 if pd.isna(ltd) else ltd
...   std = 0 if pd.isna(std) else std
...   print(f"{t}: LTD={ltd:,.0f} STD={std:,.0f} Equity={eq:,.0f} D/E={(ltd+std)/eq:.3f} (as of {r['Publish Date']})")
...
AAPL: LTD=91,775,000,000 STD=9,923,000,000 Equity=65,830,000,000 D/E=1.545 (as of 2025-08-01)
MSFT: LTD=40,152,000,000 STD=2,999,000,000 Equity=343,479,000,000 D/E=0.126 (as of 2025-07-30)
ALL not found