Output Schema — financial-data-collector
All monetary values in millions USD unless noted. Null means "not available from source."
Top-Level Fields
| Field |
Type |
Description |
ticker |
string |
Stock ticker symbol (e.g., "META") |
company_name |
string |
Full company name from yfinance |
data_date |
string |
ISO date when data was collected |
currency |
string |
Always "USD" for US equities |
unit |
string |
Always "millions_usd" |
data_sources |
object |
Attribution for each data section |
market_data
| Field |
Type |
Source |
Notes |
current_price |
float |
yf.Ticker.info["currentPrice"] |
USD per share |
shares_outstanding_millions |
float |
info["sharesOutstanding"] / 1e6 |
Diluted if available |
market_cap_millions |
float |
info["marketCap"] / 1e6 |
|
beta_5y_monthly |
float|null |
info["beta"] |
May be null for recent IPOs |
income_statement (keyed by year string)
| Field |
Type |
Source Row Index |
revenue |
float|null |
"Total Revenue" or "Revenue" |
ebit |
float|null |
"Operating Income" or "EBIT" |
ebitda |
float|null |
"EBITDA" (if available) |
tax_expense |
float|null |
"Tax Provision" or "Income Tax Expense" |
net_income |
float|null |
"Net Income" |
sbc |
float|null |
"Stock Based Compensation" (in cash_flow) |
_source |
string |
Data provenance |
cash_flow (keyed by year string)
| Field |
Type |
Source Row Index |
Sign |
operating_cash_flow |
float|null |
"Operating Cash Flow" |
Positive = inflow |
capex |
float|null |
"Capital Expenditure" |
Negative = outflow |
depreciation_amortization |
float|null |
"Depreciation And Amortization" |
Positive |
free_cash_flow |
float|null |
"Free Cash Flow" |
yfinance definition (see metadata) |
change_in_nwc |
float|null |
"Change In Working Capital" |
Negative = use of cash |
_source |
string |
|
|
balance_sheet (latest year only by default)
| Field |
Type |
Source Row Index |
total_debt |
float|null |
"Total Debt" or "Long Term Debt" + "Short Long Term Debt" |
cash_and_equivalents |
float|null |
"Cash And Cash Equivalents" + "Other Short Term Investments" |
net_debt |
float|null |
Computed: total_debt - cash_and_equivalents |
current_assets |
float|null |
"Current Assets" |
current_liabilities |
float|null |
"Current Liabilities" |
total_assets |
float|null |
"Total Assets" |
total_equity |
float|null |
"Stockholders Equity" |
_source |
string |
|
wacc_inputs
| Field |
Type |
Source |
risk_free_rate |
float|null |
yfinance ^TNX (10Y Treasury) |
beta |
float|null |
Same as market_data.beta_5y_monthly |
credit_rating |
string|null |
Not available from yfinance — null unless user provides |
analyst_estimates
| Field |
Type |
Source |
revenue_next_fy |
float|null |
yf.Ticker.analyst_price_targets or revenue_estimate |
revenue_fy_after |
float|null |
Same |
eps_next_fy |
float|null |
yf.Ticker.analyst_price_targets or eps_trend |
metadata
| Field |
Value |
_capex_convention |
"negative = cash outflow (yfinance convention)" |
_fcf_note |
"yfinance FCF = OperatingCF + CapEx. Does NOT deduct SBC." |
_nan_years |
List of years where yfinance returned NaN |
_collection_duration_seconds |
Time taken to collect all data |
2896870061