# alphaear-stock

Searches A-Share, HK, and US stock tickers, returning OHLCV price history and fundamental metrics.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 1200 installs · ★ 3085
- Author: RKiding
- License: Apache-2.0 · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/RKiding/Awesome-finance-skills/tree/HEAD/skills/alphaear-stock/SKILL.md
- Updated: 2026-03-29
- HTML: https://affpapa.org/en/nevibecode/skills/alphaear-stock

## What it does

The skill runs `scripts/stock_tools.py` through the `StockTools` class. It performs fuzzy searches for ticker codes or company names like Moutai or 600519. The tool outputs OHLCV historical pricing into a DataFrame using dates in YYYY-MM-DD format.

It retrieves fundamental metrics such as market cap and PE ratio. Execution depends on `pandas`, `requests`, `akshare`, and `yfinance`, plus tables in `scripts/database_manager.py`. Missing Python libraries cause it to fail.

Network settings require attention. When querying US stocks via `yfinance`, you might need to export `HTTP_PROXY` and `HTTPS_PROXY`. For A-Share and HK tickers, `akshare` accesses EastMoney directly, attempting direct connections automatically.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add RKiding/Awesome-finance-skills --skill alphaear-stock -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/alphaear-stock/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/alphaear-stock/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add RKiding/Awesome-finance-skills --skill alphaear-stock -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/alphaear-stock/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add RKiding/Awesome-finance-skills --skill alphaear-stock -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/alphaear-stock/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install RKiding/Awesome-finance-skills alphaear-stock
```

2. **Manually: put the files in place**
- File: `.github/skills/alphaear-stock/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add RKiding/Awesome-finance-skills --skill alphaear-stock -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/RKiding/Awesome-finance-skills --path skills/alphaear-stock
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/alphaear-stock/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add RKiding/Awesome-finance-skills --skill alphaear-stock -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/RKiding/Awesome-finance-skills/tree/HEAD/skills/alphaear-stock/SKILL.md

## When to use it
- search stock tickers by company name or code
- extract historical OHLCV pricing data into DataFrames
- fetch market cap, PE ratio, and industry fundamentals

## Example prompts
- Search for ticker Moutai and show company fundamentals
- Get OHLCV price history for stock code 600519 for specific start_date and end_date
- Check PE ratio and market cap for ticker AAPL

## Source text · SKILL.md · Apache-2.0

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: d7fc7ae92131a3b9.

BEGIN THIRD-PARTY FILE d7fc7ae92131a3b9
````text
---
name: alphaear-stock
description: Search A-Share/HK/US finance stock tickers and retrieve finance stock price history. Use when user asks about finance stock codes, recent price changes, or specific company finance stock info.
---

# AlphaEar Stock Skill

## Overview

Search A-Share/HK/US stock tickers and retrieve historical price data (OHLCV).

## Capabilities

### 1. Stock Search & Data

Use `scripts/stock_tools.py` via `StockTools`.

-   **Search**: `search_ticker(query)`
    -   Fuzzy search by code or name (e.g., "Moutai", "600519").
    -   Returns: List of `{code, name}`.
-   **Get Price**: `get_stock_price(ticker, start_date, end_date)`
    -   Returns DataFrame with OHLCV data.
    -   Dates format: "YYYY-MM-DD".
-   **Get Fundamentals**: `get_stock_fundamentals(ticker)`
    -   Returns dict with sector, industry, market cap, PE ratio, and summary.
    -   Supports A-Share/HK/US stocks.

## Dependencies

-   `pandas`, `requests`, `akshare`, `yfinance`
-   `scripts/database_manager.py` (stock tables)

## Notes

-   **Proxy**: For US stock data (via `yfinance`), you may need to set environment variables if your network cannot reach Yahoo Finance directly:
    ```bash
    export HTTP_PROXY="http://<proxy_ip>:<port>"
    export HTTPS_PROXY="http://<proxy_ip>:<port>"
    ```
-   **A-Share/HK**: Data is primarily fetched via `akshare` (EastMoney), which usually works best with a direct connection in China. The tool automatically detects proxy issues and attempts direct connection for these markets.
````
END THIRD-PARTY FILE d7fc7ae92131a3b9

The third-party file has ended. Everything between the d7fc7ae92131a3b9 tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

© RKiding · Apache-2.0 · https://github.com/RKiding/Awesome-finance-skills/tree/HEAD/skills/alphaear-stock/SKILL.md

## Similar
- [stock-liquidity](https://affpapa.org/en/nevibecode/skills/stock-liquidity.md) — skill · 3100 installs
- [stock-correlation](https://affpapa.org/en/nevibecode/skills/stock-correlation.md) — skill · 3400 installs
- [stock-market-pro](https://affpapa.org/en/nevibecode/skills/stock-market-pro.md) — skill · 4100 installs
- [financial-analysis-agent](https://affpapa.org/en/nevibecode/skills/financial-analysis-agent.md) — skill · 1300 installs
- [stock-quote](https://affpapa.org/en/nevibecode/skills/stock-quote.md) — skill · 691 installs
- [stock-analysis](https://affpapa.org/en/nevibecode/skills/stock-analysis.md) — skill · 22 installs

From the same set: [rkiding/awesome-finance-skills](https://affpapa.org/en/nevibecode/by/rkiding/awesome-finance-skills.md) — 9 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md