360 Secure SkillHub
360 安全技能中心

US Stock Financial Analyzer

核心功能：基于PE、ROE等8项加权财务指标（ROE权重最高），给个股评分，识别风险红旗，生成个股及行业排名；典型场景：分析个股财务健康、跨股对比、生成筛选报告、排查高危股、行业排名、配置飞书文档权限；输入为含指定字段的CSV/JSON，输出Markdown报告或结构化JSON。

terrycarter1985
terrycarter1985
热度 29.75
最近更新 2026-05-12 08:11:46
分类：数据依赖：代码执行 / 读写文件应用场景：数据处理 / 报告撰写 / 财务

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add us-stock-financial-analyzer
Metadata
name
us-stock-financial-analyzer
description
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, revenue growth, net margin, current ratio, dividend yield). Detect red flags and generate sector-level rankings. Use when: (1) analyzing stock financial health from CSV/JSON data, (2) comparing stocks across S&P 500 or NASDAQ, (3) generating financial screening reports, (4) identifying high-risk stocks by red-flag count, (5) ranking sectors by average financial score, (6) configuring Feishu/Lark document permissions for financial reports.

US Stock Financial Analyzer

Analyze S&P 500 and NASDAQ stock financial data with weighted scoring, red-flag detection, and sector rankings.

Quick Start

  1. Prepare input data (CSV or JSON) with required fields. See references/indicators.md for schema.
  2. Run analysis:
python3 scripts/analyze_financials.py data.csv --output markdown --index all
  1. For JSON output (pipeline integration):
python3 scripts/analyze_financials.py data.json --format json --output json --index sp500

Input Format

CSV example:

ticker,name,sector,index,market_cap,pe_ratio,pb_ratio,roe,debt_to_equity,revenue_growth,net_margin,current_ratio,dividend_yield
AAPL,Apple Inc.,Technology,nasdaq,2800000000000,28.5,45.2,0.147,1.76,0.08,0.25,0.93,0.006

JSON example:

[{"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}]

Analysis Workflow

  1. Load data — CSV or JSON, auto-detected by file extension
  2. Filter by index — --index sp500|nasdaq|all
  3. Score each stock — weighted metrics normalized to 0–100
  4. Detect red flags — PE>35, D/E>1.5, low ROE, negative growth, current ratio<1
  5. Rank sectors — average score by GICS sector
  6. Output — Markdown report or structured JSON

Scoring Model

8 metrics weighted by financial significance. ROE gets highest weight (20%); dividend yield lowest (5%). See references/indicators.md for full thresholds and scoring logic.

Feishu Permission Configuration

When sharing reports via Feishu, apply minimum access:

  1. Default to owner-only on new documents
  2. Share with named individuals (not groups) unless approved
  3. Grant view first; edit only with justification
  4. Set organization-internal link type by default
  5. Disable allow_share for external collaborators
  6. Set access expiry for cross-org sharing

See references/indicators.md for the full permission matrix.

Data Sources

Recommended free sources: SEC EDGAR, Yahoo Finance (yfinance), Financial Modeling Prep, Alpha Vantage. See references/indicators.md for URLs and details.