Stocks Skill
56+ financial tools via Yahoo Finance. Prices, fundamentals, earnings, options, crypto, forex, commodities, news.
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 in TOOLS.md and the 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 <package_name>
- 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
```bash
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
See skill.json for the full list of 56+ functions, parameters, and trigger keywords. 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).
1---2name: stocks3description: 56+ financial data tools via Yahoo Finance. Auto-routes stock prices, fundamentals, earnings, dividends, options, crypto, forex, commodities, news, and more.4---56# Stocks Skill7856+ financial tools via Yahoo Finance. Prices, fundamentals, earnings, options, crypto, forex, commodities, news.910## Setup1112Run from the skill directory:1314```bash15python3 -m venv .venv16.venv/bin/python3 -m pip install -r requirements.txt17```1819> **Windows:** use `.venv\Scripts\python3` instead of `.venv/bin/python3`.2021## AGNOSTIC OS / One-shot Design ( Goals )22- This skill is designed to be agnostic to OS and execution environment.23- It loads only essential context on first use and uses a single-shot interaction pattern for reliability.24- Basic usage pattern provided in TOOLS.md and the All Functions list in SKILL.md body.2526## Quotation / Command Execution Reliability (common pitfall)27- 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.28- **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`.29- **Always use the full path to the venv's Python interpreter** for execution, e.g.:30 `/home/openclaw/.openclaw/venv/stocks/bin/python3`31- Ensure that all necessary packages (like `pydantic` for `yfinance-ai`) are installed within this specific venv using its associated `pip` command:32 `/home/openclaw/.openclaw/venv/stocks/bin/pip install <package_name>`33- Example robust pattern using a here-doc:3435```bash36/home/openclaw/.openclaw/venv/stocks/bin/python3 - << 'PY'37import asyncio, sys38sys.path.insert(0, '.')39from yfinance_ai import Tools4041t = Tools()42async def main():43 r = await t.get_key_ratios(ticker='UNH')44 print(r)45asyncio.run(main())46PY47```48- 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.4950## Agent Quick-Start5152After 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.5354**Replace `SKILL_DIR`** with the absolute path to this skill's directory (e.g. where `scripts/` and `.venv/` live).5556````markdown57# Stocks Skill5859## Usage6061```bash62cd SKILL_DIR/scripts && SKILL_DIR/.venv/bin/python3 -c "63import asyncio, sys64sys.path.insert(0, '.')65from yfinance_ai import Tools66t = Tools()67async def main():68 result = await t.METHOD(ARGS)69 print(result)70asyncio.run(main())71" 2>/dev/null72```7374Replace METHOD(ARGS) with any call below. Suppress stderr (2>/dev/null) to hide warnings.7576## Common Calls7778| Need | Method |79|---|---|80| Stock price | `get_stock_price(ticker='AAPL')` |81| Key ratios (P/E, ROE, margins) | `get_key_ratios(ticker='AAPL')` |82| Company overview | `get_company_overview(ticker='AAPL')` |83| Full deep-dive | `get_complete_analysis(ticker='AAPL')` |84| Compare stocks | `compare_stocks(tickers='AAPL,MSFT,GOOGL')` |85| Crypto | `get_crypto_price(symbol='BTC')` |86| Forex | `get_forex_rate(pair='EURUSD')` |87| Commodities | `get_commodity_price(commodity='gold')` |88| News | `get_stock_news(ticker='AAPL')` |89| Market indices | `get_market_indices()` |90| Dividends | `get_dividends(ticker='AAPL')` |91| Earnings | `get_earnings_history(ticker='AAPL')` |92| Analyst recs | `get_analyst_recommendations(ticker='AAPL')` |93| Options chain | `get_options_chain(ticker='SPY')` |94| Market open/closed | `get_market_status()` |9596## Routing9798- Price / quote → `get_stock_price`99- Ratios / valuation → `get_key_ratios`100- "Tell me about" → `get_company_overview`101- Deep dive → `get_complete_analysis`102- Compare → `compare_stocks`103- Crypto → `get_crypto_price`104- Forex → `get_forex_rate`105- Commodities → `get_commodity_price`106- News → `get_stock_news`107````108109---110111## All Functions112113See `skill.json` for the full list of 56+ functions, parameters, and trigger keywords. Categories:114115- **Quotes**: `get_stock_price`, `get_stock_quote`, `get_fast_info`, `get_historical_data`116- **Company**: `get_company_info`, `get_company_overview`, `get_company_officers`117- **Financials**: `get_income_statement`, `get_balance_sheet`, `get_cash_flow`, `get_key_ratios`, `get_financial_summary`118- **Earnings**: `get_earnings_history`, `get_earnings_dates`, `get_analyst_estimates`, `get_eps_trend`119- **Analyst**: `get_analyst_recommendations`, `get_analyst_price_targets`, `get_upgrades_downgrades`120- **Ownership**: `get_institutional_holders`, `get_insider_transactions`, `get_major_holders`121- **Dividends**: `get_dividends`, `get_stock_splits`, `get_corporate_actions`122- **Options**: `get_options_chain`, `get_options_expirations`123- **Market**: `get_market_indices`, `get_sector_performance`, `get_market_status`124- **Crypto/Forex/Commodities**: `get_crypto_price`, `get_forex_rate`, `get_commodity_price`125- **Compare**: `compare_stocks`, `get_peer_comparison`, `get_historical_comparison`126- **News**: `get_stock_news`, `get_sec_filings`127- **Utility**: `search_ticker`, `validate_ticker`, `run_self_test`128129## Notes130131- Data from Yahoo Finance. Slight real-time delays possible.132- All functions are async — the `asyncio.run()` wrapper handles this.133- Works on Linux, macOS, and Windows (adjust venv path for Windows).