Magic Formula Analyzer

Upload a stock CSV and rank by a customizable composite of ROIC, ROIC 5y, EV/EBIT and FCF yield or P/FCF.

Loading…
Data

Expected columns: Ticker / Symbol, ROIC, EV/EBIT, FCF Yield or P/FCF, 1M %, 12M / 1Y %, Debt/FCF. Optional: ROIC 5y, company name, exchange, currency, sector, market cap, 3M %, 6M %. P/FCF is ranked lower-better (the inverse of FCF yield). Missing ROIC 5y defaults weights to 50 / 0 / 35 / 15. Percentages accepted as either decimals (0.15) or percents (15). Backfill older files by setting the as-of date before saving.

Composite Weights
Total: 100%
%
%
%
%
Ranked Results
Upload a CSV or load sample data to see rankings.