Stocks and Financial Data Pull

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. Also available for OpenWebUI. https://github.com/lkcair/yfinance-ai

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).