Agent skill

Stock Historical Index

by OctagonAI in OctagonAI/skills

Retrieve full historical end-of-day price data for market indices using Octagon MCP.

MITAuto-check passedBusiness, Finance & HR

Install Stock Historical Index

skills CLI
$ npx skills add OctagonAI/skills --skill stock-historical-index -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install OctagonAI/skills stock-historical-index --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/OctagonAI/skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/stock-historical-index .claude/skills/stock-historical-index && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
stock-historical-index
GitHub stars
127
Token cost
~2k tokens
SKILL.md length
705 words
Files
5 (incl. references)
Skills in repo
53
Repo updated
First seen
Licence
MIT

At a glance

Retrieve full historical end-of-day price data for market indices using Octagon MCP.

  • Works in 4 steps: Identify Parameters → Execute Query via Octagon MCP → Expected Output → …
  • Analyzing index performance over time
  • SKILL.md covers Prerequisites, Workflow, Example Queries and Common Index Symbols, plus 5 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Stock Historical Index is an agent skill from OctagonAI/skills. Retrieve full historical end-of-day price data for market indices using Octagon MCP. Use when analyzing index performance over time, tracking market trends, calculating returns, and understanding market context for individual stock analysis.

Its SKILL.md is about 2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 5 other files, including reference files (for example `README.md`, `marketplace.json` and `references/interpreting-results.md`).

It sits in Business, Finance & HR, covering Stock and market analysis, Time tracking and reporting and MCP servers. It works with Model Context Protocol. The repository describes itself as: A collection of Claude skills for agentic financial research by Octagon. The licence is MIT.

When your agent uses it

  • Analyzing index performance over time
  • Tracking market trends
  • Calculating returns
  • Understanding market context for individual stock analysis

Example prompts

  • “/stock-historical-index”

Workflow steps

4 steps, taken from the step headings in SKILL.md.

  1. Identify Parameters
  2. Execute Query via Octagon MCP
  3. Expected Output
  4. Interpret Results

What it can do on your machine

Read from SKILL.md and the folder at commit 51e938c. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are json).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Stock Historical Index loads about 2k tokens when it runs, and up to ~4.5k if it reads all its reference files. Until then it costs about 66 tokens; SKILL.md has 705 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~66
When it runs · the whole SKILL.md, loaded when a task matches
~2k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~4.5k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from OctagonAI/skills at commit 51e938c, republished under its MIT licence (© OctagonAI). 705 words, ~1,986 tokens.

Download SKILL.mdSave it as .claude/skills/stock-historical-index/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.
name
stock-historical-index
description
Retrieve full historical end-of-day price data for market indices using Octagon MCP. Use when analyzing index performance over time, tracking market trends, calculating returns, and understanding market context for individual stock analysis.

Stock Historical Index

Retrieve full historical end-of-day price data for market indices using the Octagon MCP server.

Prerequisites

Ensure Octagon MCP is configured in your AI agent (Cursor, Claude Desktop, Windsurf, etc.). See references/mcp-setup.md for installation instructions.

Workflow

1. Identify Parameters

Determine your query parameters:

  • Index Symbol: ^GSPC (S&P 500), ^DJI (Dow), ^IXIC (NASDAQ), etc.
  • Start Date: Beginning of date range
  • End Date: End of date range
2. Execute Query via Octagon MCP

Use the octagon-agent tool with a natural language prompt:

Retrieve full historical end-of-day price data for the <INDEX> index from <START_DATE> to <END_DATE>.

MCP Call Format:

json
{
  "server": "octagon-mcp",
  "toolName": "octagon-agent",
  "arguments": {
    "prompt": "Retrieve full historical end-of-day price data for the ^GSPC index from 2025-01-01 to 2025-04-30."
  }
}
3. Expected Output

The agent returns comprehensive daily index data:

DateOpenHighLowCloseVolumeChangeChange %VWAP
2025-04-305,499.445,581.845,433.245,569.075.45B+69.63+1.27%5,520.90
2025-04-295,508.875,571.955,505.705,560.824.75B+51.95+0.94%5,536.84
...........................

Key Statistics:

  • Highest single-day volume: 9.49B on 2025-04-09
  • Largest daily gain: +9.90% on 2025-04-09
  • Largest daily loss: -4.12% on 2025-04-04
  • Trading days covered: 79

Data Sources: octagon-stock-data-agent

4. Interpret Results

See references/interpreting-results.md for guidance on:

  • Analyzing index price trends
  • Calculating period returns
  • Understanding volume patterns
  • Identifying significant market moves

Example Queries

S&P 500 History:

Retrieve full historical end-of-day price data for the ^GSPC index from 2025-01-01 to 2025-04-30.

NASDAQ Composite:

Get historical data for ^IXIC from 2024-01-01 to 2024-12-31.

Dow Jones:

Show ^DJI historical prices for Q1 2025.

Russell 2000:

Retrieve historical data for ^RUT from 2024-06-01 to 2025-06-01.

Multiple Indices:

Compare ^GSPC and ^IXIC performance from 2025-01-01 to 2025-03-31.

Common Index Symbols

US Major Indices
SymbolIndexDescription
^GSPCS&P 500500 large-cap US stocks
^DJIDow Jones30 blue-chip stocks
^IXICNASDAQ CompositeAll NASDAQ stocks
^NDXNASDAQ 100100 largest NASDAQ
^RUTRussell 20002000 small-cap stocks
Sector Indices
SymbolIndexDescription
^XLKTechnologyTech sector
^XLFFinancialsFinancial sector
^XLVHealthcareHealthcare sector
^XLEEnergyEnergy sector
^XLIIndustrialsIndustrial sector
Volatility Indices
SymbolIndexDescription
^VIXVIXMarket volatility
^VXNVXNNASDAQ volatility

Understanding Index Data

Price Components
FieldDescription
OpenFirst trade price of day
HighHighest price of day
LowLowest price of day
CloseLast trade price of day
VolumeTotal shares traded
ChangePoint change from prior close
Change %Percentage change
VWAPVolume-weighted average price
Daily Range Analysis
MetricCalculation
Daily RangeHigh - Low
Range %(High - Low) / Open
Position in Range(Close - Low) / (High - Low)

Return Calculations

Period Returns
PeriodFormula
Daily(Close - Prior Close) / Prior Close
Weekly(Friday Close - Monday Open) / Monday Open
Monthly(Month End - Month Start) / Month Start
YTD(Current - Year Start) / Year Start
Example

From the data:

  • Start (Jan 2): 5,868.56
  • End (Apr 30): 5,569.07
  • Return: (5,569.07 - 5,868.56) / 5,868.56 = -5.10%
Cumulative Returns
Cumulative = (1 + r1) × (1 + r2) × ... × (1 + rn) - 1

Volume Analysis

Volume Patterns
PatternInterpretation
High volume + upStrong buying
High volume + downStrong selling
Low volume + upWeak rally
Low volume + downLack of sellers
Volume Metrics
MetricPurpose
Average daily volumeBaseline
Volume spikeUnusual activity
Volume trendParticipation changes
Show full SKILL.md (283 more words)Show less
Example

From the data:

  • Highest volume: 9.49B on 2025-04-09
  • This coincided with +9.90% gain (major rally)

Trend Analysis

Trend Identification
PatternCharacteristics
UptrendHigher highs, higher lows
DowntrendLower highs, lower lows
ConsolidationRange-bound
ReversalTrend change
Moving Averages
MAUse
50-dayShort-term trend
200-dayLong-term trend
Golden Cross50 > 200 (bullish)
Death Cross50 < 200 (bearish)

Volatility Analysis

Measuring Volatility
MetricCalculation
Daily Range %(High - Low) / Close
Daily ChangeAbsolute daily change
Std DeviationDispersion of returns
Volatility Context
Daily Change %Market Condition
<0.5%Low volatility
0.5-1%Normal
1-2%Elevated
>2%High volatility
>4%Extreme
Example

From the data:

  • Largest gain: +9.90%
  • Largest loss: -4.12%
  • Range: 14.02%
  • Interpretation: Period of elevated volatility

Key Market Events

Identifying Significant Days
CriteriaThreshold
Big up day>2% gain
Big down day>2% loss
Volume spike>2x average
Range expansion>2x normal range
Event Analysis
From DataEvent
+9.90% on Apr 9Major rally
-4.12% on Apr 4Significant selloff
9.49B volumeHighest participation

Benchmarking Use

Stock vs. Index
ComparisonFormula
AlphaStock Return - Index Return
BetaStock Vol / Index Vol × Correlation
Relative StrengthStock / Index
Example Use
  • Your stock returned +15%
  • S&P 500 returned -5.10%
  • Alpha: +20.10% outperformance

Common Use Cases

Market Context
What was the overall market doing when my stock fell?
Return Comparison
How did the S&P 500 perform in Q1 2025?
Volatility Assessment
What were the biggest up and down days for the market in 2024?
Trend Analysis
Is the market in an uptrend or downtrend?
Volume Analysis
What were the highest volume days for the S&P 500?

Analysis Tips

  1. Use for context: Index performance explains stock moves.

  2. Calculate alpha: Your returns vs. market.

  3. Watch volume: High volume days are significant.

  4. Track extremes: Big up/down days signal sentiment.

  5. Compare indices: Different indices, different signals.

  6. Consider VIX: Volatility index for fear gauge.

Integration with Other Skills

SkillCombined Use
stock-performanceStock vs. index comparison
sector-performance-snapshotSector vs. index
stock-quoteCurrent vs. historical
historical-market-capMarket cap vs. index

© OctagonAI, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 4 other files (references) in skills/stock-historical-index of OctagonAI/skills.

  • SKILL.md
  • README.md
  • marketplace.json
  • references/interpreting-results.md
  • references/mcp-setup.md

Open the folder on GitHubat commit 51e938c

Compare with similar skills

Stock Historical Index next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Stock Historical Index compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Stock Historical Index this skillOctagonAI/skills127—~2kAutomated safety check: PassMIT
Tradingview MCPatilaahmettaner/tradingview-mcp5k—~1.3kAutomated safety check: PassMIT
Polymarket Tennislivetennisapi/livetennisapi-mcp152—~3kAutomated safety check: PassMIT
Okx Sentiment Trackerdex-original/okx-agent-trade-kit1101 repos~3.8kAutomated safety check: PassMIT
Wind MCP SkillWind-Alice/AliceMarket1341 repos~1.3kAutomated safety check: PassNone
Helium MCPcomposio-community/awesome-codex-skills17k—~599Automated safety check: PassNone

Similar skills

  • Tradingview MCP

    atilaahmettaner/tradingview-mcp

    AI Trading Intelligence — live prices, 30+ technical indicators, backtesting (6 strategies), walk-forward overfitting detection, trade logs, equity curves, licensed news sentiment (Marketaux), and…

    5k GitHub stars~1.3k tokensUpdated yesterday
    Business, Finance & HRAuto-check passed
  • Polymarket Tennis

    livetennisapi/livetennisapi-mcp

    Build observe-only Polymarket and Kalshi tennis market tooling on the polymarket-tennis Python package (MIT) plus the Live Tennis API free tier.

    152 GitHub stars~3k tokensUpdated 4 days ago
    Business, Finance & HRAuto-check passed
  • Okx Sentiment Tracker

    dex-original/okx-agent-trade-kit

    A skill your agent uses when the user asks about: 'any crypto news', 'latest news', 'market update', 'daily briefing', 'BTC news', 'ETH news', 'news on SOL', 'search SEC ETF', 'regulation news'…

    110 GitHub starsUsed in 1 repo~3.8k tokens
    Business, Finance & HRAuto-check passed
  • Wind MCP Skill

    Wind-Alice/AliceMarket

    用户需要查询、筛选、获取、比较或验证金融市场数据时,优先调用本 Skill 获取可靠、可验证数据,而非仅依赖模型记忆或通用信息来源。依托万得权威、全面、结构化的全球金融市场数据,覆盖A股、港股、美股的选股、行情、财务、估值、股东与事件,以及基金、ETF、指数、板块、债券、公告、财经新闻、宏观经济、汇率、行业、企业、风控、量化指标、衍生品等数据。

    134 GitHub starsUsed in 1 repo~1.3k tokens
    Business, Finance & HRAuto-check passed
  • Helium MCP

    composio-community/awesome-codex-skills

    Search real-time news with bias scoring, get live stock/ETF/crypto data with AI analysis, ML options pricing, balanced news synthesis, and meme search via the Helium MCP server.

    17k GitHub stars~599 tokensUpdated 2 mo ago
    Business, Finance & HRAuto-check passed
  • Tradingview MCP

    himself65/finance-skills

    Query TradingView market data through the bundled tradingview MCP server without a desktop app or login.

    3.4k GitHub stars~2.4k tokensUpdated 6 days ago
    Business, Finance & HRAuto-check passed

More from OctagonAI/skills

All 53 skills in this repo
  • Analyst Estimates

    OctagonAI/skills

    Retrieve analyst financial estimates including Revenue and EPS projections with low/high ranges and analyst coverage.

    127 GitHub stars~1.1k tokensUpdated 4 mo ago
    Auto-check passed
  • Balance Sheet

    OctagonAI/skills

    Retrieve detailed balance sheet statement data including Total Assets, Current Assets, Non-Current Assets, Liabilities, Equity, and Net Debt for public companies.

    127 GitHub stars~1k tokensUpdated 4 mo ago
    Auto-check passed
  • Balance Sheet Growth

    OctagonAI/skills

    Retrieve year-over-year growth in balance sheet items including Total Assets, Total Liabilities, Shareholders Equity, Cash, and Inventories.

    127 GitHub stars~940 tokensUpdated 4 mo ago
    Auto-check passed
  • Batch Market Cap

    OctagonAI/skills

    Retrieve market capitalization data for multiple companies at once using Octagon MCP.

    127 GitHub stars~1.6k tokensUpdated 4 mo ago
    Auto-check passed
  • Cash Flow Growth

    OctagonAI/skills

    Retrieve year-over-year growth in cash flow metrics including Operating Cash Flow, Free Cash Flow, and Net Cash Flow.

    127 GitHub stars~862 tokensUpdated 4 mo ago
    Auto-check passed
  • Cash Flow Statement

    OctagonAI/skills

    Retrieve real-time or historical cash flow statement data including Net Income, Operating Cash Flow, Investing Cash Flow, Financing Cash Flow, Free Cash Flow, and Cash Position for public companies.

    127 GitHub stars~1k tokensUpdated 4 mo ago
    Auto-check passed

Questions about Stock Historical Index

What does Stock Historical Index do?

Retrieve full historical end-of-day price data for market indices using Octagon MCP. Stock Historical Index is an agent skill from OctagonAI/skills. Retrieve full historical end-of-day price data for market indices using Octagon MCP.

When should I use Stock Historical Index?

Stock Historical Index fits situations like: analyzing index performance over time; tracking market trends; calculating returns; understanding market context for individual stock analysis.

How do I install Stock Historical Index in Claude Code?

Run `npx skills add OctagonAI/skills --skill stock-historical-index -a claude-code`. Or copy the skill folder (skills/stock-historical-index in OctagonAI/skills) into .claude/skills/stock-historical-index in your project. Claude Code loads it when a task matches its description.

How do I install Stock Historical Index in Codex?

Run `npx skills add OctagonAI/skills --skill stock-historical-index -a codex`. Or copy the skill folder (skills/stock-historical-index in OctagonAI/skills) into .agents/skills/stock-historical-index in your project. Codex loads it when a task matches its description.

Can I use Stock Historical Index in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add OctagonAI/skills --skill stock-historical-index -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/stock-historical-index, .gemini/skills/stock-historical-index, .github/skills/stock-historical-index and .opencode/skills/stock-historical-index in your project.

What does Stock Historical Index need to run?

SKILL.md names no scripts, command-line tools or credentials: Stock Historical Index is instructions for the agent only.

Does Stock Historical Index access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Stock Historical Index safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Stock Historical Index use?

Stock Historical Index is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Stock Historical Index use?

About 2k tokens (SKILL.md is roughly 7.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 2.5k tokens, read only when the agent opens those files.

What are the alternatives to Stock Historical Index?

Skills that share tags, products or a category with Stock Historical Index: Tradingview MCP (atilaahmettaner/tradingview-mcp, 5k stars), Polymarket Tennis (livetennisapi/livetennisapi-mcp, 152 stars), Okx Sentiment Tracker (dex-original/okx-agent-trade-kit, 110 stars) and Wind MCP Skill (Wind-Alice/AliceMarket, 134 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Stock Historical Index?

OctagonAI (a GitHub organization) maintains it in OctagonAI/skills, which has 127 GitHub stars. The repository holds 53 skills in this directory. The repository was last updated on June 5, 2026.

Source: OctagonAI/skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.