⚠️

重要前提

安装AI Skills的关键前提是：必须科学上网，且开启TUN模式，这一点至关重要，直接决定安装能否顺利完成，在此郑重提醒三遍：科学上网，科学上网，科学上网。查看完整安装教程 →

Python股票筛选器：基于财务指标的多维度股票分析与对比工具

stock-screener by nicepkg/ai-workflow

56 周安装量

154 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/nicepkg/ai-workflow --skill stock-screener

Python Web框架数据分析金融科技

🇨🇳中文介绍

股票筛选器

根据财务指标筛选股票并进行对比分析。

功能特性

多指标筛选：市盈率、市净率、市值、股息率等。
自定义筛选器：保存并复用筛选条件组合。
对比分析：并排对比股票。
行业分析：按行业分组分析。
排名：根据标准对股票进行评分和排序。
导出：CSV、JSON、格式化报告。

快速开始

from stock_screener import StockScreener

screener = StockScreener()

# 加载股票数据
screener.load_csv("stocks.csv")

# 应用筛选条件
results = screener.filter(
    pe_ratio=(0, 20),
    market_cap_min=1e9,
    dividend_yield_min=2.0
)

print(results)

命令行使用

# 基础筛选
python stock_screener.py --input stocks.csv --pe-max 20 --div-min 2.0

# 多重筛选
python stock_screener.py --input stocks.csv --pe 5 25 --pb-max 3 --cap-min 1B

# 行业筛选
python stock_screener.py --input stocks.csv --sector Technology --pe-max 30

# 按指标排序
python stock_screener.py --input stocks.csv --rank-by dividend_yield --top 20

# 对比特定股票
python stock_screener.py --input stocks.csv --compare AAPL MSFT GOOGL

# 导出结果
python stock_screener.py --input stocks.csv --pe-max 15 --output screened.csv

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

相关 Skills

FlyClaw：零登录航班聚合查询工具，Python实现多源航班信息与价格搜索

4,000,000 周安装

Azure Data Explorer (Kusto) 查询技能：KQL数据分析、日志遥测与时间序列处理

161,200 周安装

专业SEO审计工具：全面网站诊断、技术SEO优化与页面分析指南

73,800 周安装

Python PDF处理教程：合并拆分、提取文本表格、创建PDF文件

69,800 周安装

symbol,name,sector,price,pe_ratio,pb_ratio,market_cap,dividend_yield,eps,revenue_growth,profit_margin
AAPL,Apple Inc,Technology,175.50,28.5,45.2,2.8e12,0.5,6.16,8.5,25.3
MSFT,Microsoft,Technology,380.00,35.2,12.8,2.8e12,0.8,10.79,12.3,36.7
JNJ,Johnson & Johnson,Healthcare,155.00,15.2,5.8,3.8e11,2.9,10.20,5.2,22.1

class StockScreener:
    def __init__(self)

    # 数据加载
    def load_csv(self, filepath: str) -> 'StockScreener'
    def load_dataframe(self, df: pd.DataFrame) -> 'StockScreener'

    # 筛选
    def filter(self, **criteria) -> pd.DataFrame
    def filter_by_sector(self, sectors: List[str]) -> 'StockScreener'
    def filter_by_metric(self, metric: str, min_val: float = None,
                         max_val: float = None) -> 'StockScreener'

    # 预设筛选器
    def value_screen(self) -> pd.DataFrame
    def growth_screen(self) -> pd.DataFrame
    def dividend_screen(self) -> pd.DataFrame
    def quality_screen(self) -> pd.DataFrame
    def custom_screen(self, criteria: Dict) -> pd.DataFrame

    # 分析
    def compare(self, symbols: List[str]) -> pd.DataFrame
    def rank_by(self, metric: str, ascending: bool = True) -> pd.DataFrame
    def sector_summary(self) -> pd.DataFrame
    def metric_distribution(self, metric: str) -> Dict

    # 评分
    def score_stocks(self, weights: Dict[str, float] = None) -> pd.DataFrame
    def percentile_rank(self, metrics: List[str]) -> pd.DataFrame

    # 导出
    def to_csv(self, filepath: str) -> str
    def to_json(self, filepath: str) -> str
    def summary_report(self) -> str

screener.filter(
    pe_ratio=(5, 20),      # 市盈率介于 5 到 20 之间
    pb_ratio_max=3.0,      # 市净率低于 3
    ps_ratio_max=5.0,      # 市销率低于 5
    peg_ratio_max=1.5      # PEG 比率低于 1.5
)

screener.filter(
    market_cap_min=1e9,    # 最小市值 10 亿美元
    market_cap_max=10e9,   # 最大市值 100 亿美元（中盘股）
    revenue_min=500e6      # 最小营收 5 亿美元
)

screener.filter(
    dividend_yield_min=2.0,  # 最小股息率 2%
    dividend_yield_max=8.0,  # 最大股息率 8%（避免股息陷阱）
    payout_ratio_max=75      # 可持续的派息率
)

screener.filter(
    revenue_growth_min=10,   # 最小营收增长率 10%
    earnings_growth_min=15,  # 最小盈利增长率 15%
    eps_growth_min=10        # 最小每股收益增长率 10%
)

screener.filter(
    profit_margin_min=15,    # 最小利润率 15%
    roe_min=15,              # 最小净资产收益率 15%
    debt_to_equity_max=1.0,  # 最大负债权益比 1.0
    current_ratio_min=1.5    # 最小流动比率 1.5
)

results = screener.value_screen()
# 寻找被低估的股票：
# - 市盈率 < 15
# - 市净率 < 2
# - 股息率 > 2%
# - 利润率 > 10%

results = screener.growth_screen()
# 寻找成长股：
# - 营收增长率 > 15%
# - 盈利增长率 > 20%
# - PEG 比率 < 2

results = screener.dividend_screen()
# 寻找股息股：
# - 股息率 2-8%
# - 派息率 < 75%
# - 5 年以上股息支付历史

results = screener.quality_screen()
# 寻找高质量股票：
# - 净资产收益率 > 15%
# - 利润率 > 15%
# - 负债权益比 < 0.5
# - 流动比率 > 2

comparison = screener.compare(["AAPL", "MSFT", "GOOGL"])
# 返回：
#                  AAPL    MSFT    GOOGL
# price           175.50  380.00  140.00
# pe_ratio        28.50   35.20   25.30
# market_cap      2.8T    2.8T    1.7T
# dividend_yield  0.50    0.80    0.00
# profit_margin   25.30   36.70   22.50
# ...

按单一指标排名

# 按股息率排名前 20
top_dividend = screener.rank_by("dividend_yield", ascending=False).head(20)

# 使用自定义权重对股票评分
scores = screener.score_stocks({
    "pe_ratio": -0.2,        # 越低越好
    "dividend_yield": 0.3,   # 越高越好
    "profit_margin": 0.3,    # 越高越好
    "revenue_growth": 0.2    # 越高越好
})
# 返回按综合评分排序的股票

# 查看每只股票在多个指标上的排名位置
ranked = screener.percentile_rank(["pe_ratio", "dividend_yield", "profit_margin"])
# 返回每个指标的百分位（0-100）

sector_stats = screener.sector_summary()
# 返回：
#   sector        | count | avg_pe | avg_div | avg_margin
#   Technology    | 45    | 28.5   | 1.2     | 22.3
#   Healthcare    | 32    | 18.2   | 2.1     | 18.7
#   Financials    | 28    | 12.5   | 3.2     | 25.1

寻找被低估的股息股

screener = StockScreener()
screener.load_csv("sp500.csv")

# 应用筛选条件
results = screener.filter(
    pe_ratio=(5, 15),
    dividend_yield_min=3.0,
    payout_ratio_max=70,
    profit_margin_min=10
)

# 按股息率排序
top = results.sort_values("dividend_yield", ascending=False).head(10)
print(top[["symbol", "name", "pe_ratio", "dividend_yield", "payout_ratio"]])

合理价格成长股 (GARP)

results = screener.filter(
    revenue_growth_min=15,
    earnings_growth_min=15,
    peg_ratio_max=1.5,
    pe_ratio_max=25
)

# 筛选科技行业
tech = screener.filter_by_sector(["Technology"]).filter(
    market_cap_min=10e9,
    profit_margin_min=15
)

# 对比顶级科技股
comparison = screener.compare(tech["symbol"].head(5).tolist())

screener.filter(pe_ratio_max=20).to_csv("value_stocks.csv")

screener.filter(dividend_yield_min=3).to_json("dividend_stocks.json")

report = screener.summary_report()
# 返回筛选结果的格式化文本摘要

pandas>=2.0.0
numpy>=1.24.0

2026 年 1 月 24 日

🇺🇸English

Stock Screener

Filter stocks by financial metrics and perform comparative analysis.

Features

Multi-Metric Filtering : P/E, P/B, market cap, dividend yield, etc.
Custom Screens : Save and reuse filter combinations
Comparative Analysis : Side-by-side stock comparison
Sector Analysis : Group and analyze by sector
Ranking : Score and rank stocks by criteria
Export : CSV, JSON, formatted reports

Quick Start

from stock_screener import StockScreener

screener = StockScreener()

# Load stock data
screener.load_csv("stocks.csv")

# Apply filters
results = screener.filter(
    pe_ratio=(0, 20),
    market_cap_min=1e9,
    dividend_yield_min=2.0
)

print(results)

CLI Usage

# Basic screening
python stock_screener.py --input stocks.csv --pe-max 20 --div-min 2.0

# Multiple filters
python stock_screener.py --input stocks.csv --pe 5 25 --pb-max 3 --cap-min 1B

# Sector filter
python stock_screener.py --input stocks.csv --sector Technology --pe-max 30

# Rank by metric
python stock_screener.py --input stocks.csv --rank-by dividend_yield --top 20

# Compare specific stocks
python stock_screener.py --input stocks.csv --compare AAPL MSFT GOOGL

# Export results
python stock_screener.py --input stocks.csv --pe-max 15 --output screened.csv

Input Format

Stock CSV

symbol,name,sector,price,pe_ratio,pb_ratio,market_cap,dividend_yield,eps,revenue_growth,profit_margin
AAPL,Apple Inc,Technology,175.50,28.5,45.2,2.8e12,0.5,6.16,8.5,25.3
MSFT,Microsoft,Technology,380.00,35.2,12.8,2.8e12,0.8,10.79,12.3,36.7
JNJ,Johnson & Johnson,Healthcare,155.00,15.2,5.8,3.8e11,2.9,10.20,5.2,22.1

API Reference

StockScreener Class

class StockScreener:
    def __init__(self)

    # Data Loading
    def load_csv(self, filepath: str) -> 'StockScreener'
    def load_dataframe(self, df: pd.DataFrame) -> 'StockScreener'

    # Filtering
    def filter(self, **criteria) -> pd.DataFrame
    def filter_by_sector(self, sectors: List[str]) -> 'StockScreener'
    def filter_by_metric(self, metric: str, min_val: float = None,
                         max_val: float = None) -> 'StockScreener'

    # Screening Presets
    def value_screen(self) -> pd.DataFrame
    def growth_screen(self) -> pd.DataFrame
    def dividend_screen(self) -> pd.DataFrame
    def quality_screen(self) -> pd.DataFrame
    def custom_screen(self, criteria: Dict) -> pd.DataFrame

    # Analysis
    def compare(self, symbols: List[str]) -> pd.DataFrame
    def rank_by(self, metric: str, ascending: bool = True) -> pd.DataFrame
    def sector_summary(self) -> pd.DataFrame
    def metric_distribution(self, metric: str) -> Dict

    # Scoring
    def score_stocks(self, weights: Dict[str, float] = None) -> pd.DataFrame
    def percentile_rank(self, metrics: List[str]) -> pd.DataFrame

    # Export
    def to_csv(self, filepath: str) -> str
    def to_json(self, filepath: str) -> str
    def summary_report(self) -> str

Filtering Criteria

Valuation Metrics

screener.filter(
    pe_ratio=(5, 20),      # P/E between 5 and 20
    pb_ratio_max=3.0,      # P/B ratio under 3
    ps_ratio_max=5.0,      # Price/Sales under 5
    peg_ratio_max=1.5      # PEG ratio under 1.5
)

Size Metrics

screener.filter(
    market_cap_min=1e9,    # Min $1B market cap
    market_cap_max=10e9,   # Max $10B (mid-cap)
    revenue_min=500e6      # Min $500M revenue
)

Income Metrics

screener.filter(
    dividend_yield_min=2.0,  # Min 2% dividend
    dividend_yield_max=8.0,  # Max 8% (avoid yield traps)
    payout_ratio_max=75      # Sustainable payout
)

Growth Metrics

screener.filter(
    revenue_growth_min=10,   # Min 10% revenue growth
    earnings_growth_min=15,  # Min 15% earnings growth
    eps_growth_min=10        # Min 10% EPS growth
)

Quality Metrics

screener.filter(
    profit_margin_min=15,    # Min 15% profit margin
    roe_min=15,              # Min 15% return on equity
    debt_to_equity_max=1.0,  # Max 1.0 D/E ratio
    current_ratio_min=1.5    # Min 1.5 current ratio
)

Preset Screens

Value Screen

results = screener.value_screen()
# Finds undervalued stocks:
# - P/E < 15
# - P/B < 2
# - Dividend yield > 2%
# - Profit margin > 10%

Growth Screen

results = screener.growth_screen()
# Finds growth stocks:
# - Revenue growth > 15%
# - Earnings growth > 20%
# - PEG ratio < 2

Dividend Screen

results = screener.dividend_screen()
# Finds dividend stocks:
# - Dividend yield 2-8%
# - Payout ratio < 75%
# - 5+ years dividend history

Quality Screen

results = screener.quality_screen()
# Finds high-quality stocks:
# - ROE > 15%
# - Profit margin > 15%
# - D/E < 0.5
# - Current ratio > 2

Stock Comparison

comparison = screener.compare(["AAPL", "MSFT", "GOOGL"])
# Returns:
#                  AAPL    MSFT    GOOGL
# price           175.50  380.00  140.00
# pe_ratio        28.50   35.20   25.30
# market_cap      2.8T    2.8T    1.7T
# dividend_yield  0.50    0.80    0.00
# profit_margin   25.30   36.70   22.50
# ...

Ranking and Scoring

Rank by Single Metric

# Top 20 by dividend yield
top_dividend = screener.rank_by("dividend_yield", ascending=False).head(20)

Composite Scoring

# Score stocks with custom weights
scores = screener.score_stocks({
    "pe_ratio": -0.2,        # Lower is better
    "dividend_yield": 0.3,   # Higher is better
    "profit_margin": 0.3,    # Higher is better
    "revenue_growth": 0.2    # Higher is better
})
# Returns stocks ranked by composite score

Percentile Ranking

# See where each stock ranks on multiple metrics
ranked = screener.percentile_rank(["pe_ratio", "dividend_yield", "profit_margin"])
# Returns percentile (0-100) for each metric

Sector Analysis

sector_stats = screener.sector_summary()
# Returns:
#   sector        | count | avg_pe | avg_div | avg_margin
#   Technology    | 45    | 28.5   | 1.2     | 22.3
#   Healthcare    | 32    | 18.2   | 2.1     | 18.7
#   Financials    | 28    | 12.5   | 3.2     | 25.1

Example Workflows

Find Undervalued Dividend Stocks

screener = StockScreener()
screener.load_csv("sp500.csv")

# Apply filters
results = screener.filter(
    pe_ratio=(5, 15),
    dividend_yield_min=3.0,
    payout_ratio_max=70,
    profit_margin_min=10
)

# Rank by dividend yield
top = results.sort_values("dividend_yield", ascending=False).head(10)
print(top[["symbol", "name", "pe_ratio", "dividend_yield", "payout_ratio"]])

Growth at Reasonable Price (GARP)

results = screener.filter(
    revenue_growth_min=15,
    earnings_growth_min=15,
    peg_ratio_max=1.5,
    pe_ratio_max=25
)

Sector Comparison

# Filter to technology sector
tech = screener.filter_by_sector(["Technology"]).filter(
    market_cap_min=10e9,
    profit_margin_min=15
)

# Compare top tech stocks
comparison = screener.compare(tech["symbol"].head(5).tolist())

Output Format

CSV Export

screener.filter(pe_ratio_max=20).to_csv("value_stocks.csv")

JSON Export

screener.filter(dividend_yield_min=3).to_json("dividend_stocks.json")

Summary Report

report = screener.summary_report()
# Returns formatted text summary of screening results

Dependencies

pandas>=2.0.0
numpy>=1.24.0

Weekly Installs

Repository

nicepkg/ai-workflow

GitHub Stars

143

First Seen

Jan 24, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode38

gemini-cli32

cursor32

claude-code32

codex30

github-copilot24

前端代码审计工具 - 自动化检测可访问性、性能、响应式设计、主题化与反模式

57,700 周安装

Python股票筛选器：基于财务指标的多维度股票分析与对比工具

🇨🇳中文介绍

股票筛选器

功能特性

快速开始

命令行使用

相关 Skills

输入格式

股票 CSV 文件

API 参考

StockScreener 类

筛选条件

估值指标

规模指标

收益指标

增长指标

质量指标

预设筛选器

价值股筛选器

成长股筛选器

股息股筛选器

优质股筛选器

股票对比

排名与评分