Stocks Skill

56+ financial tools via Yahoo Finance. Prices, fundamentals, earnings, options, crypto, forex, commodities, news.

Github Open-Souce

Please star Github if you like the skill.

https://github.com/lkcair/yfinance-ai

Also available on OpenWebUI.

Also try SEC Data Pull

https://github.com/lkcair/sec-finance-ai

Available on OpenClaw as "openclaw skills install sec"

Also open-source.

Setup

Run from the skill directory:

python3 -m venv .venv
.venv/bin/python3 -m pip install -r requirements.txt

> Windows: use .venv\Scripts\python3 instead of .venv/bin/python3.

AGNOSTIC OS / One-shot Design ( Goals )

• This skill is designed to be agnostic to OS and execution environment.
• It loads only essential context on first use and uses a single-shot interaction pattern for reliability.
• Basic usage pattern provided and All Functions list in SKILL.md body.

Quotation / Command Execution Reliability (common pitfall)

• If a command invocation uses complex shell quoting, it may fail in various environments. Use a here-doc style or a tiny helper script to avoid escaping issues.
• Crucially, ensure you are executing Python scripts using the interpreter from the skill's virtual environment. Simply calling python3 might not use the correct interpreter if the venv is not activated, leading to ModuleNotFoundError.
• Always use the full path to the venv's Python interpreter for execution, e.g.:

/home/openclaw/.openclaw/venv/stocks/bin/python3

• Ensure that all necessary packages (like pydantic for yfinance-ai) are installed within this specific venv using its associated pip command:

/home/openclaw/.openclaw/venv/stocks/bin/pip install

• Example robust pattern using a here-doc:

/home/openclaw/.openclaw/venv/stocks/bin/python3 - << 'PY'
import asyncio, sys
sys.path.insert(0, '.')
from yfinance_ai import Tools

t = Tools()
async def main():
    r = await t.get_key_ratios(ticker='UNH')
    print(r)
asyncio.run(main())
PY

• If complex inline scripts are problematic, wrap the call in a small Python script file in the workspace (e.g., in scripts/) and execute that script using the venv's Python interpreter.

Agent Quick-Start

After setup, copy the template below into your agent's TOOLS.md (or whichever file your framework injects into every session). This is the single most important step — if the agent can see the invocation pattern, it will work every time.

Replace SKILL_DIR with the absolute path to this skill's directory (e.g. where scripts/ and .venv/ live).

# Stocks Skill

## Usage

cd SKILL_DIR/scripts && SKILL_DIR/.venv/bin/python3 -c "

import asyncio, sys

sys.path.insert(0, '.')

from yfinance_ai import Tools

t = Tools()

async def main():

result = await t.METHOD(ARGS)

print(result)

asyncio.run(main())

" 2>/dev/null

Replace METHOD(ARGS) with any call below. Suppress stderr (2>/dev/null) to hide warnings.

## Common Calls

| Need | Method |
|---|---|
| Stock price | `get_stock_price(ticker='AAPL')` |
| Key ratios (P/E, ROE, margins) | `get_key_ratios(ticker='AAPL')` |
| Company overview | `get_company_overview(ticker='AAPL')` |
| Full deep-dive | `get_complete_analysis(ticker='AAPL')` |
| Compare stocks | `compare_stocks(tickers='AAPL,MSFT,GOOGL')` |
| Crypto | `get_crypto_price(symbol='BTC')` |
| Forex | `get_forex_rate(pair='EURUSD')` |
| Commodities | `get_commodity_price(commodity='gold')` |
| News | `get_stock_news(ticker='AAPL')` |
| Market indices | `get_market_indices()` |
| Dividends | `get_dividends(ticker='AAPL')` |
| Earnings | `get_earnings_history(ticker='AAPL')` |
| Analyst recs | `get_analyst_recommendations(ticker='AAPL')` |
| Options chain | `get_options_chain(ticker='SPY')` |
| Market open/closed | `get_market_status()` |

## Routing

- Price / quote → `get_stock_price`
- Ratios / valuation → `get_key_ratios`
- "Tell me about" → `get_company_overview`
- Deep dive → `get_complete_analysis`
- Compare → `compare_stocks`
- Crypto → `get_crypto_price`
- Forex → `get_forex_rate`
- Commodities → `get_commodity_price`
- News → `get_stock_news`

All Functions

By Categories:

• Quotes: get_stock_price, get_stock_quote, get_fast_info, get_historical_data
• Company: get_company_info, get_company_overview, get_company_officers
• Financials: get_income_statement, get_balance_sheet, get_cash_flow, get_key_ratios, get_financial_summary
• Earnings: get_earnings_history, get_earnings_dates, get_analyst_estimates, get_eps_trend
• Analyst: get_analyst_recommendations, get_analyst_price_targets, get_upgrades_downgrades
• Ownership: get_institutional_holders, get_insider_transactions, get_major_holders
• Dividends: get_dividends, get_stock_splits, get_corporate_actions
• Options: get_options_chain, get_options_expirations
• Market: get_market_indices, get_sector_performance, get_market_status
• Crypto/Forex/Commodities: get_crypto_price, get_forex_rate, get_commodity_price
• Compare: compare_stocks, get_peer_comparison, get_historical_comparison
• News: get_stock_news, get_sec_filings
• Utility: search_ticker, validate_ticker, run_self_test

Notes

• Data from Yahoo Finance. Slight real-time delays possible.
• All functions are async — the asyncio.run() wrapper handles this.
• Works on Linux, macOS, and Windows (adjust venv path for Windows).