The Stock Market Skillset is a comprehensive stock market analysis toolkit based on the Alpha Vantage API. Once enabled, the AI agent can retrieve real-time quotes, historical data, financial statements, market news, insider transactions, and technical indicators to support investment research and financial analysis.

Stock Market Skillset Guide

This guide introduces a comprehensive stock market analysis toolkit based on the Alpha Vantage API, designed to help users with investment research, financial analysis, and market monitoring.

Overview

This toolkit provides the following core capabilities:

Real-time quote retrieval
Historical data queries
Financial statement analysis (income statement, balance sheet, cash flow)
Market news and sentiment analysis
Insider transaction monitoring
Stock symbol search
Technical indicator analysis

Configuration

Authentication Setup

Before using this skillset, you need to configure your Alpha Vantage API Key:

Parameter	Type	Required	Description
alphaVantageApiKey	string	Yes	Alpha Vantage API key

Get API Key: Visit https://www.alphavantage.co/support/#api-key to request an API key.

get_latest_price - Get Latest Stock Price

Tool Key: get_latest_price

Description

Retrieve the latest real-time price and trading information for a specific stock, supporting global market ticker symbols.

Parameters

Parameter	Type	Required	Default	Description
symbol	string	Yes	-	Stock ticker symbol (e.g., AAPL, TSM, 300135.SHZ)

Prompt Example

Input:

> What's the latest price for AAPL?
> Get current stock price for Tesla
> Show me the real-time quote for stock symbol MSFT

Output:

## Stock Quote for AAPL:

- Open: $246.60
- High: $248.84
- Low: $244.70
- Price: $247.77
- Volume: 35,477,986
- Latest Trading Day: 2025-10-14
- Change: $0.11
- Change Percent: 0.0444%

get_historical_stock_data - Get Historical Stock Data

Tool Key: get_historical_stock_data

Description

Retrieve historical stock price data for a specified time period, including daily open, high, low, close prices and volume.

Smart Data Switching:

When lookBackDays ≤ 90: returns daily data
When lookBackDays > 90: automatically switches to weekly adjusted data for better performance

Parameters

Parameter	Type	Required	Default	Description
symbol	string	Yes	-	Global stock ticker symbol (e.g., AAPL, 600104.SHH)
currentDate	string	Yes	-	End date in YYYY-MM-DD format
lookBackDays	integer	No	30	Number of days to look back, max 365

Prompt Example

Input:

> Get historical trading data for AAPL over the past 30 days
> Show me the last 90 days of stock data for TSLA, ending on October 15, 2025
> Retrieve stock price history for MSFT from August 1, 2025 to October 15, 2025

Output:

## Stock data for AAPL from 2025-09-14 to 2025-10-14

Date; Open; High; Low; Close; Volume
2025-10-14; 246.60; 248.84; 244.70; 247.77; 35,477,986
2025-10-13; 249.38; 249.69; 245.56; 247.66; 38,142,942
...

get_income_statement - Get Income Statement

Tool Key: get_income_statement

Description

Retrieve annual or quarterly income statements for a company, showing revenue, costs, profits, and other key financial metrics.

Parameters

Parameter	Type	Required	Default	Description
symbol	string	Yes	-	Stock ticker symbol (e.g., AAPL, 600104.SHH)
reportPeriod	string	No	quarterly	Reporting period: "annual" or "quarterly"

Prompt Example

Input:

> Show me the quarterly income statement for AAPL
> Get the annual income statement for Microsoft
> What's the latest income statement for TSLA?

Output:

## QUARTERLY Income Statement for AAPL:

### Fiscal Date Ending: 2025-06-30 (Currency: USD)

**Revenue & Profitability:**
- Total Revenue: 94.04 billion
- Gross Profit: 43.72 billion
- Net Income: 23.43 billion

get_balance_sheet - Get Balance Sheet

Tool Key: get_balance_sheet

Description

Retrieve annual or quarterly balance sheets for a company, showing assets, liabilities, and shareholder equity.

Parameters

Parameter	Type	Required	Default	Description
symbol	string	Yes	-	Stock ticker symbol (e.g., AAPL, 600104.SHH)
reportPeriod	string	No	quarterly	Reporting period: "annual" or "quarterly"

Prompt Example

Input:

> Show me the balance sheet for AAPL
> Get the quarterly balance sheet for Google
> What are the assets and liabilities for TSLA?

Output:

## QUARTERLY Balance Sheet for AAPL:

### Fiscal Date Ending: 2025-06-30 (Currency: USD)

**Assets:**
- Total Assets: 331.50 billion
- Cash & Equivalents: 36.27 billion

**Liabilities:**
- Total Liabilities: 265.67 billion
- Long Term Debt: 82.43 billion

**Shareholder Equity:**
- Total Equity: 65.83 billion

get_cash_flow - Get Cash Flow Statement

Tool Key: get_cash_flow

Description

Retrieve annual or quarterly cash flow statements for a company, showing cash flows from operating, investing, and financing activities.

Parameters

Parameter	Type	Required	Default	Description
symbol	string	Yes	-	Stock ticker symbol (e.g., AAPL, 600104.SHH)
reportPeriod	string	No	quarterly	Reporting period: "annual" or "quarterly"

Prompt Example

Input:

> Show me the cash flow statement for AAPL
> Get the quarterly cash flow for Amazon
> What's the operating cash flow for MSFT?

Output:

## QUARTERLY Cash Flow for AAPL:

### Fiscal Date Ending: 2025-06-30 (Currency: USD)

**Operating Activities:**
- Operating Cash Flow: 27.87 billion

**Investing Activities:**
- Investing Cash Flow: 5.07 billion

**Financing Activities:**
- Financing Cash Flow: -24.83 billion
- Dividend Payout: 3.94 billion

get_market_news - Get Market News

Tool Key: get_market_news

Description

Retrieve live and historical market news and sentiment analysis from premier news outlets worldwide, covering stocks, cryptocurrencies, forex, and various asset classes.

Parameters

Parameter	Type	Required	Default	Description
ticker	string	Yes	-	Stock/crypto/forex ticker (e.g., "AAPL", "CRYPTO:BTC", "FOREX:USD")
currentDate	string	No	Today	End date in YYYY-MM-DD format
limit	integer	No	50	Number of articles to return, max 1000
sort	string	No	LATEST	Sort order: "LATEST", "EARLIEST", or "RELEVANCE"
lookBackDays	integer	No	90	Number of days to look back, max 365
topics	array	No	-	News topics filter (e.g., blockchain, earnings, ipo, mergers_and_acquisitions)

Prompt Example

Input:

> Get the latest 5 news articles about AAPL
> Show me recent news about Tesla from the past 30 days
> Find earnings-related news for Microsoft, sorted by relevance
> What's the market sentiment for Bitcoin over the last week?

Output:

- Article #1 
  - **Title**: Tim Cook Courts Beijing As Trump Threatens Tariffs
  - **Summary**: Apple CEO vows to boost investments in China
  - **Source**: Benzinga
  - **Published At**: 20251015T075759
  - **Sentiment for AAPL**: Somewhat-Bullish

get_insider_transactions - Get Insider Transactions

Tool Key: get_insider_transactions

Description

Retrieve stock purchase and sale records from company executives and directors, providing insights into insider perspectives on company prospects.

Parameters

Parameter	Type	Required	Default	Description
symbol	string	Yes	-	Stock ticker symbol (e.g., AAPL, 600104.SHH)
currentDate	string	No	Today	Current trading date in YYYY-MM-DD format
lookBackDays	integer	No	30	Number of days to look back, max 365

Prompt Example

Input:

> Show me insider transactions for AAPL over the past 30 days
> What insider trading activity has occurred for Tesla recently?
> Get insider transactions for MSFT from September to October 2025

Output:

## Insider Transactions for AAPL from 2025-09-15 to 2025-10-15:

Transaction Date; Acquisition/Disposal; Executive Title; Security Type; Share Price; Shares
2025-10-02; Disposal; Director, Chief Executive Officer; Common Stock; 256.62; 39293
2025-10-01; Disposal; Director, Chief Executive Officer; Common Stock; 255.45; 147243

search_stock_symbols - Search Stock Symbols

Tool Key: search_stock_symbols

Description

Search for matching stock ticker symbols and basic information using keywords via the Alpha Vantage API.

Parameters

Parameter	Type	Required	Default	Description
keywords	string	Yes	-	Search keywords (e.g., "microsoft", "tesco", "apple", "BA")

Prompt Example

Input:

> Search for Apple stock symbol
> Find the ticker symbol for Microsoft
> What's the stock symbol for Tesla?
> Search for companies with keyword "technology"

Output:

[
  {
    "currency":"USD",
    "name":"Apple Inc",
    "region":"United States",
    "symbol":"AAPL",
    "type":"Equity"
  },
  {
    "currency":"EUR",
    "name":"Apple Inc",
    "region":"XETRA",
    "symbol":"APC.DEX",
    "type":"Equity"
  }
]

get_technical_indicators - Get Technical Indicators

Tool Key: get_technical_indicators

Description

Retrieve technical indicator analysis for a specific stock, supporting moving averages, MACD, RSI, Bollinger Bands, ATR, MFI, and more.

Parameters

Parameter	Type	Required	Default	Description
symbol	string	Yes	-	Stock ticker symbol (e.g., AAPL, TSM, GOOGL)
indicator	string	Yes	-	Technical indicator type (see supported list below)
currentDate	string	Yes	-	Current trading date in YYYY-MM-DD format
lookBackDays	integer	No	30	Number of days to look back, max 200

Supported Technical Indicators

Indicator Code	Description
close_50_sma	50-day Simple Moving Average
close_200_sma	200-day Simple Moving Average
close_10_ema	10-day Exponential Moving Average
macd	MACD Line
macds	MACD Signal Line
macdh	MACD Histogram
rsi	Relative Strength Index
boll	Bollinger Band Middle
boll_ub	Bollinger Band Upper
boll_lb	Bollinger Band Lower
atr	Average True Range
mfi	Money Flow Index

Prompt Example

Input:

> Calculate the RSI for AAPL over the past 30 days
> Show me the 50-day moving average for Tesla
> Get MACD indicator for MSFT as of October 15, 2025
> What's the Bollinger Bands for Google stock?

Output:

Technical indicator data for the requested stock and time period

Known Issues

This tool may currently have functional limitations. Some technical indicator requests may return errors:

{"error":{"message":"Failed to fetch technical indicators","details":"Unsupported indicator: SMA"}}

If you encounter this issue:

Try using different indicator codes
Calculate basic indicators manually using historical price data
Wait for future updates to fix the issue

Data Accuracy Notes

Real-time price data may have 15-20 minute delays
Financial statement data comes from company public disclosures, updated quarterly/annually
News sentiment analysis is algorithmically generated and should be used as reference only

Skillset Information

Plugin Key: stock_market
Display Name: Stock Market
Data Source: Alpha Vantage API
Help Documentation: help/guide/ai/skillset-stock-market

Recommend AI Automation Templates

Email Marketer

Automate lead generation, outbound email automation, and 3-day follow-up email sequences with Bika.ai. Create automated follow-up emails, email automation flows, and email reminders efficiently. Boost sales, BD, and marketing campaigns with AI-powered email automation, streamline lead research, and manage automated email outreach effortlessly.

Lead Notification Automation and AI-Driven Strategies

Use the Lead Notification Automation and AI-Driven Strategies template as a lead management template that connects your lead capture form and lead intake form to fully automated lead follow up. When a new client submits information, triggers and rules route the lead into your MQL database, AI generates follow‑up suggestions, and email plus Slack notifications are sent automatically. This reduces response times, supports consistent follow‑up from sales and support teams, and drives customer satisfaction improvement by ensuring every lead is acknowledged and handled promptly.

Invoice collation reminders

Simplify finance workflows with automated invoice reminders, collection, tracking, and submission. This template streamlines expense reimbursement, enables quick photo uploads, provides a centralized invoice database, and ensures accurate, timely management for finance and administrative teams.

Agile Workflow

Use the Agile Workflow template as a centralized project management workspace for your Agile team. Streamline sprint tracking and backlog management, handle backlog prioritization with clear views, and improve project visibility across tasks, stories, and sprints. Built‑in agile automation and automated reminders power daily scrum standups, sprint start and end notifications, and overdue task alerts, helping teams stay aligned, reduce manual follow‑up, and keep every sprint on track.

Community Reporter

Community Reporter generates AI-powered community reports and activity reports, providing clear community insights, analytics, and highlights. Track interactions, monitor trends, and get actionable community analysis quickly and efficiently.

Base team

Base Template In Every Need Members Database

Stock Market Skillset

Recommend AI Automation Templates

On this page