@pipeworx/alphavantage

Connect: https://gateway.pipeworx.io/alphavantage/mcp · Install: one-click buttons

Tools: 6

Alpha Vantage’s REST API for stock prices, fundamentals, technical indicators, forex, crypto, and economic indicators. ~20+ years of historical equities data, real-time-ish quotes (15-minute delayed on free tier), and structured fundamental data parsed from SEC filings.

Why this matters for AI agents

Where SEC EDGAR gives you raw filings, Alpha Vantage gives you cleaned-up structured data ready for analysis: income statements, balance sheets, cash flow, key ratios, recent earnings, technical indicators. For real-time-ish quotes during market hours, this is the source.

Common flows:

• Quote. “Where’s AAPL trading?” → av_quote({symbol: "AAPL"}) → latest price, change, volume.
• Income statement. “Apple’s last 4 quarters of revenue/income.” → av_income_statement({symbol: "AAPL"}).
• Earnings. “When does NVDA report next?” → av_earnings({symbol: "NVDA"}).
• Daily price history. “AAPL 1-year history.” → av_daily({symbol: "AAPL"}).

Used by the fintech_company_deep_dive compound for the quote + income statement layer alongside SEC EDGAR.

Auth

Free tier: 25 requests/day, 5 per minute, real key required. Get one in 30s at https://www.alphavantage.co/support/#api-key. Pass via _apiKey.

The “demo” key: Alpha Vantage advertises demo as a no-signup key, but it returns errors for most calls. Always use a real key — the gateway will surface the demo-key error if you forget.

Higher tiers ($50–250/mo) lift the daily cap and unlock real-time quotes (vs. 15-min delayed on free tier).

Update cadence

• Quotes: real-time on paid tiers, 15-minute delayed on free, market hours only
• Daily / weekly / monthly history: end-of-day, refreshes after market close
• Fundamentals: refreshes within ~24h of new SEC filings
• Earnings: refreshes after each company reports

Pipeworx caches with TTLs aligned to these.

Common pitfalls

• Free-tier 5/min limit. Bursting fails. Pace agent calls or upgrade.
• Symbol vs ticker. Mostly the same on Alpha Vantage, but a few non-US tickers need a suffix (e.g., BARC.LON). Default endpoints assume US-listed.
• “Real-time” definition. Free tier is 15-min delayed end-of-day-style snapshots. For algo trading, you want a paid tier. For agent research, free is fine.
• Earnings calendar isn’t always accurate. Companies move report dates; Alpha Vantage updates eventually but sometimes lags by a day or two.
• Adjusted vs unadjusted prices. Daily-adjusted returns split- and dividend-adjusted closes; daily returns raw closes. For long-horizon analysis you almost always want adjusted.

Tools

• av_quote — Get real-time stock price for a symbol (e.g., “AAPL”). Returns current price, change, percent change, and trading volume.
• av_daily — Get daily stock price history for a symbol (e.g., “AAPL”). Returns open, high, low, close, volume for recent days or full 20+ year history.
• av_overview — Get company fundamentals for a symbol (e.g., “AAPL”). Returns sector, market cap, P/E ratio, EPS, dividend yield, 52-week range, and analyst ratings.
• av_income_statement — Get annual and quarterly income statements for a symbol (e.g., “AAPL”). Returns revenue, gross profit, operating income, net income, and EBITDA.
• av_balance_sheet — Get annual and quarterly balance sheets for a symbol (e.g., “AAPL”). Returns total assets, liabilities, equity, cash, and debt.
• av_earnings — Get quarterly earnings data for a symbol (e.g., “AAPL”). Returns reported and estimated EPS, surprise amount, and surprise percentage.