{"skill":{"slug":"us-stock-financial-analyzer","displayName":"US Stock Financial Analyzer","summary":"Automated financial indicator analysis for S&P 500 and NASDAQ stocks. Score and rank stocks by weighted financial health metrics (PE, PB, ROE, debt/equity, r...","description":"---\nname: us-stock-financial-analyzer\ndescription: >\n  Automated financial indicator analysis for S&P 500 and NASDAQ stocks. Score and rank stocks\n  by weighted financial health metrics (PE, PB, ROE, debt/equity, revenue growth, net margin,\n  current ratio, dividend yield). Detect red flags and generate sector-level rankings.\n  Use when: (1) analyzing stock financial health from CSV/JSON data, (2) comparing stocks across\n  S&P 500 or NASDAQ, (3) generating financial screening reports, (4) identifying high-risk stocks\n  by red-flag count, (5) ranking sectors by average financial score, (6) configuring Feishu/Lark\n  document permissions for financial reports.\n---\n\n# US Stock Financial Analyzer\n\nAnalyze S&P 500 and NASDAQ stock financial data with weighted scoring, red-flag detection, and sector rankings.\n\n## Quick Start\n\n1. Prepare input data (CSV or JSON) with required fields. See [references/indicators.md](references/indicators.md) for schema.\n2. Run analysis:\n\n```bash\npython3 scripts/analyze_financials.py data.csv --output markdown --index all\n```\n\n3. For JSON output (pipeline integration):\n\n```bash\npython3 scripts/analyze_financials.py data.json --format json --output json --index sp500\n```\n\n## Input Format\n\nCSV example:\n```csv\nticker,name,sector,index,market_cap,pe_ratio,pb_ratio,roe,debt_to_equity,revenue_growth,net_margin,current_ratio,dividend_yield\nAAPL,Apple Inc.,Technology,nasdaq,2800000000000,28.5,45.2,0.147,1.76,0.08,0.25,0.93,0.006\n```\n\nJSON example:\n```json\n[{\"ticker\":\"MSFT\",\"name\":\"Microsoft Corp.\",\"sector\":\"Technology\",\"index\":\"sp500\",\"market_cap\":2600000000000,\"pe_ratio\":32,\"pb_ratio\":11.5,\"roe\":0.38,\"debt_to_equity\":0.42,\"revenue_growth\":0.12,\"net_margin\":0.34,\"current_ratio\":1.77,\"dividend_yield\":0.008}]\n```\n\n## Analysis Workflow\n\n1. **Load data** — CSV or JSON, auto-detected by file extension\n2. **Filter by index** — `--index sp500|nasdaq|all`\n3. **Score each stock** — weighted metrics normalized to 0–100\n4. **Detect red flags** — PE>35, D/E>1.5, low ROE, negative growth, current ratio<1\n5. **Rank sectors** — average score by GICS sector\n6. **Output** — Markdown report or structured JSON\n\n## Scoring Model\n\n8 metrics weighted by financial significance. ROE gets highest weight (20%); dividend yield lowest (5%). See [references/indicators.md](references/indicators.md) for full thresholds and scoring logic.\n\n## Feishu Permission Configuration\n\nWhen sharing reports via Feishu, apply minimum access:\n\n1. Default to **owner-only** on new documents\n2. Share with named individuals (not groups) unless approved\n3. Grant `view` first; `edit` only with justification\n4. Set `organization-internal` link type by default\n5. Disable `allow_share` for external collaborators\n6. Set access expiry for cross-org sharing\n\nSee [references/indicators.md](references/indicators.md) for the full permission matrix.\n\n## Data Sources\n\nRecommended free sources: SEC EDGAR, Yahoo Finance (yfinance), Financial Modeling Prep, Alpha Vantage. See [references/indicators.md](references/indicators.md) for URLs and details.\n","topics":["Financial","Stock","CSV","Feishu","Json"],"tags":{"latest":"1.2.0"},"stats":{"comments":0,"downloads":424,"installsAllTime":16,"installsCurrent":0,"stars":0,"versions":3},"createdAt":1778147431416,"updatedAt":1778544706735},"latestVersion":{"version":"1.2.0","createdAt":1778544434023,"changelog":"Added Feishu permission model, improved scoring and CSV handling","license":"MIT-0"},"metadata":null,"owner":{"handle":"terrycarter1985","userId":"s17brwfrqyjhbjgadkvar20h8x8492g8","displayName":"terrycarter1985","image":"https://avatars.githubusercontent.com/u/1542987?v=4"},"moderation":null}