# 🔷 Prism A local financial analysis dashboard. Search any stock ticker to get a comprehensive view of financials, valuation, options flow, insider activity, SEC filings, and news — all in your browser. --- ## Features ### Market Bar Live S&P 500, NASDAQ, DOW, and VIX at the top of every page. ### Top Movers Day gainers, losers, and most-active tickers shown below the market bar — expandable from 3 to 8 entries per category. ### Overview - **Score card** — at-a-glance green/yellow/red signal badges for Valuation, Growth, Profitability, Leverage, Momentum, and Short Interest - **52-week range bar** — visual indicator showing where the current price sits between the 52W low and high, with % context - **Short interest** — % of float, days to cover, shares short vs. prior month - Price chart (1M / 3M / 6M / 1Y / 5Y), key stats (market cap, P/E, volume, beta) The sidebar also shows a live price (with day change), exchange, currency, sector, employee count, and website link for the selected ticker. ### Financials Annual and quarterly Income Statement, Balance Sheet, and Cash Flow Statement with year-over-year % change columns color-coded green/red (cost/debt rows are correctly inverted). CSV export on every statement. ### Valuation Seven sub-tabs: | Tab | Contents | |---|---| | Key Ratios | P/E, Forward P/E, P/S, P/B, EV/EBITDA, EV/Revenue, margins, ROE, ROA, ROIC, D/E, current/quick ratio, interest coverage, dividend yield, payout ratio | | Historical Ratios | Annual P/E, P/B, P/S, EV/EBITDA, margins, ROE, ROA, D/E charted over time | | Models | Four collapsible valuation models: **DCF** (adjustable WACC, terminal growth, projection years, FCF growth, waterfall chart), **EV/EBITDA**, **EV/Revenue**, and **P/B** — each with an implied price, bridge breakdown, and reasoning summary | | Comps | Peer valuation table with editable ticker set | | Forward Estimates | Analyst revenue, EPS, and EBITDA estimates with low/avg/high ranges and chart overlay | | Analyst Targets | Price target range (low/mean/median/high), upside to mean, recommendation distribution chart | | Earnings History | EPS actual vs. estimate, surprise %, color-coded table, chart; CSV export | > All Key Ratios are self-computed from raw yfinance quarterly statements — no FMP quota consumed. ### Options - Put/call ratio by volume and open interest (with Bullish / Neutral / Bearish label) - IV smile chart (calls and puts) with ATM marker - Open interest by strike (calls above axis, puts mirrored below) - Full options chain table (expandable) ### Insiders Buy/sell transaction history with monthly activity bar chart and filterable table. ### Filings Recent 10-K, 10-Q, and 8-K filings with direct EDGAR exhibit links, color-coded by type. ### News Recent articles with Bullish / Bearish / Neutral sentiment badges and a 7-day sentiment summary. --- ## Setup ### 1. Navigate to the project ```bash cd ~/Work/prism ``` ### 2. Activate the virtual environment ```bash source .venv/bin/activate ``` ### 3. Add API keys ```bash cp .env.example .env ``` Open `.env` and fill in your keys: ``` FMP_API_KEY=your_key_here FINNHUB_API_KEY=your_key_here ``` Both are **free**: - **FMP** (Financial Modeling Prep) — [financialmodelingprep.com](https://financialmodelingprep.com/developer/docs) — 250 requests/day - **Finnhub** — [finnhub.io](https://finnhub.io) — 60 requests/minute > **No keys?** Most of Prism still works. Overview, Financials, Key Ratios, Historical Ratios (yfinance fallback), Options, Insiders, Filings, and the DCF model all run without any API key. The Comps peer list, Forward Estimates, and News require FMP/Finnhub keys. ### 4. Run the app ```bash streamlit run app.py ``` Opens at `http://localhost:8501` --- ## Daily Usage ```bash cd ~/Work/prism source .venv/bin/activate streamlit run app.py ``` --- ## Project Structure ``` prism/ ├── app.py # Entry point — sidebar, market bar, tab routing ├── requirements.txt ├── .env # Your API keys (not committed) ├── .env.example # Key template ├── .streamlit/ │ └── config.toml # Dark theme + layout settings ├── assets/ │ └── logo.png # Sidebar logo ├── services/ │ ├── data_service.py # yfinance — price, financials, options, compute_ttm_ratios │ ├── fmp_service.py # FMP API — peers, forward estimates, news, historical ratios │ ├── news_service.py # Finnhub — news + sentiment │ └── valuation_service.py # DCF, EV/EBITDA, EV/Revenue, and P/B valuation engines ├── components/ │ ├── market_bar.py # Index metrics row │ ├── top_movers.py # Day gainers, losers, most active │ ├── overview.py # Score card, 52W bar, short interest, price chart │ ├── financials.py # Color-coded statement tables + CSV export │ ├── valuation.py # 7-tab valuation panel │ ├── options.py # Options flow — P/C ratio, IV smile, OI chart │ ├── insiders.py # Insider buy/sell history │ ├── filings.py # SEC filings │ └── news.py # News feed + sentiment └── utils/ └── formatters.py # Number formatting helpers ``` --- ## Valuation Models Notes The **Models** tab contains four collapsible valuation models, each computing an implied price per share with a bridge breakdown: ### DCF Uses historical **Free Cash Flow** from yfinance and projects forward: | Input | Default | Range | |---|---|---| | WACC | 10% | 5–20% | | Terminal Growth Rate | 2.5% | 0.5–5% | | Projection Years | 5 | 3–10 | | FCF Growth Rate | Historical median (uncapped) | −50–50% | Terminal value uses the **Gordon Growth Model**. Enterprise value is bridged to equity value using net debt. The FCF growth slider shows the raw historical median and can be overridden. ### EV/EBITDA Applies a target EV/EBITDA multiple to trailing EBITDA (sourced from income statement). Slider defaults to the current computed market multiple. ### EV/Revenue Applies a target EV/Revenue multiple to TTM revenue. Useful for pre-profit or high-growth companies. ### P/B (Price-to-Book) Applies a target P/B multiple to book value per share. Shown by default for financial companies (banks, insurance, REITs) and as a fallback when cash-flow models are not reliable. --- ## API Usage | Source | Limit | Used For | |---|---|---| | yfinance | None | Price, financials, options, insiders, filings, all key ratios | | FMP (free) | 250 req/day | Peer discovery, forward estimates, historical ratios, news | | Finnhub (free) | 60 req/min | News sentiment | All key ratios are computed locally from quarterly statements — Prism only calls FMP for data that cannot be derived from raw statements. Data is cached per session (financials: 1h, news: 10min, indices: 5min, options: 15min).