trail-fmp

Financial Modeling Prep data source for Trail, via the aiofmp async client.

FMP returns already-normalized statement line items, so trail-fmp maps them directly onto Trail's canonical schema and serves them at both annual and quarterly frequency - use the frequency prefix to pick, or reference bare fields for the annual default:

model growth at quarterly {
  export rev_ttm = ttm(quarterly.income.revenue)
  export roe     = fmp.roe
  export pe      = daily.price.adj_close / annual.income.eps_diluted
}

Provides

• Statements (annual + quarterly, 39 fields):
  • income.*: revenue, cogs, gross_profit, operating_income, net_income, interest_expense, income_tax_expense, income_before_tax, eps_diluted, weighted_average_shares_diluted, weighted_average_shares, ebitda, depreciation_amortization, sga
  • balance.*: total_assets, current_assets, current_liabilities, total_liabilities, long_term_debt, total_debt, total_equity, retained_earnings, accounts_receivable, inventory, accounts_payable, net_fixed_assets, cash_and_equivalents, cash_and_short_term_investments, minority_interest, common_stock, goodwill
  • cash.*: cfo, capex, free_cash_flow, stock_issued, cfi, cff, net_change_in_cash, dividends_paid (capex and dividends_paid are normalized to positive magnitudes)
• Meta: meta.sector, meta.exchange, meta.is_active, meta.country are a current snapshot broadcast onto every period; meta.country is normalized to ISO3, so it bridges to country-keyed sources like trail-gmd. meta.market_cap is real per-period data from key-metrics (naive placement - not filing-lag-adjusted).
• Price: price.adj_close - dividend-adjusted close, sampled at each period-end for statement frequencies, or one row per trading day at daily.
• fmp.* ratio / metric / score vocabulary (49 fields):
  • margins & profitability: gross_margin, net_margin, ebit_margin, ebitda_margin, operating_margin, pretax_margin, effective_tax_rate
  • liquidity & leverage: current_ratio, quick_ratio, cash_ratio, debt_to_equity, debt_to_assets, financial_leverage, interest_coverage
  • turnover: asset_turnover, inventory_turnover, receivables_turnover, payables_turnover
  • price multiples & dividends: pe, pb, ps, price_to_fcf, peg, dividend_yield, dividend_per_share, payout_ratio
  • returns & valuation: roe, roa, roic, roce, earnings_yield, ev_to_sales, ev_to_ebitda, ev_to_fcf, fcf_yield, enterprise_value, graham_number, graham_net_net, invested_capital, working_capital, income_quality, capex_to_revenue, capex_to_depreciation
  • operating cycle: dso, dio, dpo, ccc
  • quality scores (current snapshot): piotroski, altman_z
• Entity dimension: entity (tickers) - a plain entity-keyed source.
• Frequencies: annual, quarterly for statements/ratios/meta; daily for price.adj_close only (statements/ratios/meta have no daily axis).
• Unavailable: price.dividends - aiofmp has no historical per-share dividends endpoint; use fmp.dividend_yield / fmp.dividend_per_share instead.

Configure

# trail.yaml
sources:
  fmp:
    driver: fmp
    options:
      api_key: ${FMP_API_KEY}     # or set the FMP_API_KEY environment variable
      tickers: [AAPL, MSFT]        # or let a model's universe scope the fetch
      cached: true                 # optional: aiofmp's Parquet cache
      limit: 20                    # periods fetched per statement
precedence:
  default: [fmp]

Options

Point-in-time

Statement fields (income.*, balance.*, cash.*) and the fmp.* ratio/metric fields computed from them (the ratios and metrics endpoints) carry a __date:filing_date coordinate - taken from the statement's acceptedDate, falling back to filingDate - so the PIT engine places each value by when it was actually knowable (lookahead-safe) rather than at period-end.

Snapshot fields (meta.* profile fields and the fmp.* quality scores) and price.adj_close stay naive (period-end). Set options.pit: naive to disable PIT placement for this source entirely.

Querying fmp.* ratio/metric fields without any statement field alongside them loses the filing-date coordinate (only the statement loop attaches it) and falls back to naive placement - include a statement field in the same query to get lookahead-safe placement for those fmp.* fields too.

Notes

• meta.* (profile) and the fmp.* quality scores are current snapshots broadcast onto each period - not point-in-time series.
• Some balance/cash-flow wire names follow the standard FMP /stable spelling; if a field returns null across the board, verify it against a live pull (pytest -m live).
• A ticker that fails to load (paywalled endpoint, delisted symbol, transient error) is skipped with a warning rather than aborting the whole panel, unless every ticker fails or the error is auth/config-class.