Claude Excel workflows are transforming how investors and analysts interact with financial data. Instead of manually typing formulas into spreadsheet cells, copying data between browser tabs, and building models by hand, you can now ask Claude AI to pull live stock prices, option chains with Greeks, fundamental ratios, and technical indicators — all through a single connection to the MarketXLS MCP server. Whether you work in Excel with the MarketXLS add-in or prefer conversational AI through Claude Desktop, Cursor, or Windsurf, MarketXLS gives you access to over 1,100 financial functions covering equities, options, ETFs, mutual funds, and indices.
In this guide, you will learn exactly how to connect Claude to live market data, see real MarketXLS function examples in action, and discover why the MarketXLS MCP server is the only MCP server that delivers real-time options data with full Greeks.
Why Claude Excel Workflows Matter for Financial Analysis
Traditional financial analysis in Excel requires you to know the right formulas, find the right data sources, and manually wire everything together. That process works, but it is slow. You spend more time on data plumbing than on actual analysis.
Claude changes this equation. When connected to a financial data source, Claude can execute functions on your behalf, interpret the results, and help you build complete analyses through natural language conversation. Instead of typing =PERatio("AAPL") into a cell and then separately looking up =DividendYield("AAPL") and =RSI("AAPL"), you can simply ask Claude: "Give me a complete valuation snapshot of Apple including P/E ratio, dividend yield, RSI, and one-year price target."
The key insight is that Claude does not just analyze data you paste in — it actually executes MarketXLS functions through the MCP (Model Context Protocol) server and returns current values. This is not a static dataset. Every time Claude calls a function like =Last("AAPL") or =QM_GetOptionChain("^SPX"), it gets the current market value.
The Problem with Manual Excel Workflows
Consider what a typical stock screening workflow looks like without AI assistance:
- Open Excel with MarketXLS installed
- Type
=Last("AAPL")to get the current price - Type
=PERatio("AAPL")in another cell - Type
=Revenue("AAPL")somewhere else - Type
=DividendYield("AAPL")in yet another cell - Repeat for every ticker you want to compare
- Manually build a comparison table
- Format everything so it makes sense
- Try to draw conclusions from the raw numbers
That is easily 30 to 60 minutes of work for a proper multi-stock comparison. With Claude connected to MarketXLS via MCP, you describe what you want in plain English and get structured results in seconds.
What MCP Actually Does
MCP (Model Context Protocol) is an open standard created by Anthropic that lets AI applications connect to external data sources and tools. Think of it as a universal adapter. When you configure the MarketXLS MCP server in your AI client, Claude (or any other AI) can call MarketXLS functions directly.
Here is what happens when you ask Claude "What is Apple's current stock price?":
- Claude recognizes it needs live market data
- Claude calls the MarketXLS MCP server with the
Lastfunction for ticker AAPL - The MCP server executes
=Last("AAPL")against MarketXLS's data infrastructure - The current price is returned to Claude
- Claude presents the answer in natural language
This works with any AI client that supports MCP — Claude Desktop, Cursor, Windsurf, and others. It is not limited to Excel.
How to Set Up Claude with MarketXLS MCP Server
Setting up the connection between Claude and MarketXLS takes less than two minutes. Here is the complete process.
Step 1: Get a MarketXLS Account
You need a MarketXLS account on the Advanced plan or higher. The same account works for both the Excel add-in and the MCP server — there is no separate subscription. Visit the MarketXLS pricing page to see available plans.
Step 2: Configure Your AI Client
Add the MarketXLS MCP server to your AI client's configuration. The setup is identical regardless of which client you use.
For Claude Desktop, open your MCP configuration file and add:
{
"mcpServers": {
"marketxls": {
"url": "https://qm-mcp.marketxls.com/mcp"
}
}
}
For Cursor, Windsurf, or any other MCP-compatible client, use the same server URL: https://qm-mcp.marketxls.com/mcp
Step 3: Authenticate
When you first connect, you will be prompted to log in with your MarketXLS credentials. Once authenticated, Claude can immediately start calling any of the 1,100+ MarketXLS functions.
Step 4: Start Asking Questions
That is it. You can now ask Claude questions like:
- "What is the current P/E ratio, dividend yield, and RSI for Microsoft?"
- "Pull the full SPX option chain with Greeks"
- "Compare the fundamentals of AAPL, GOOGL, and MSFT"
- "What is Apple's implied volatility right now?"
Claude will execute the appropriate MarketXLS functions and return the results.
Real MarketXLS Functions You Can Use Through Claude
MarketXLS provides over 1,100 functions. Here are the most commonly used categories with specific function examples that Claude can execute via MCP.
Stock Price and Market Data
| Function | What It Returns | Example |
|---|---|---|
=Last("AAPL") | Current stock price | Latest trading price for Apple |
=QM_Last("AAPL") | Current price (QuoteMedia) | Real-time price from QuoteMedia feed |
=Change("AAPL") | Price change | Today's price change for Apple |
=MarketCapitalization("AAPL") | Market cap | Apple's total market capitalization |
=GetHistory("AAPL", "2025-01-01", "2025-12-31", "daily") | Historical prices | Daily price history for date range |
Fundamental Analysis
| Function | What It Returns | Example |
|---|---|---|
=PERatio("AAPL") | Price-to-earnings ratio | Apple's current P/E ratio |
=Revenue("AAPL") | Annual revenue | Apple's most recent annual revenue |
=DividendYield("AAPL") | Dividend yield percentage | Apple's current dividend yield |
=DividendPerShare("AAPL") | Dividend per share | Dollar amount of dividend per share |
=EPSEstimateCurrentYear("AAPL") | EPS estimate | Analyst consensus EPS for current year |
=PriceToBook("AAPL") | Price-to-book ratio | Apple's P/B ratio |
=TotalDebtToEquity("AAPL") | Debt-to-equity ratio | Apple's leverage ratio |
=Current_Ratio("AAPL") | Current ratio | Apple's liquidity ratio |
=Ex_DividendDate("AAPL") | Ex-dividend date | Next ex-dividend date |
Technical Indicators
| Function | What It Returns | Example |
|---|---|---|
=RSI("AAPL") | Relative Strength Index | Apple's 14-day RSI |
=SimpleMovingAverage("AAPL", 50) | 50-day SMA | Apple's 50-day simple moving average |
Options Data and Greeks
This is where MarketXLS stands apart from every other MCP server. The MarketXLS MCP server is the only MCP server that provides real-time options data with full Greeks.
| Function | What It Returns | Example |
|---|---|---|
=QM_GetOptionChain("^SPX") | Full option chain | Complete SPX option chain with all strikes |
=QM_GetOptionQuotesAndGreeks("^SPX") | Options with Greeks | SPX options with Delta, Gamma, Theta, Vega, Rho |
=OptionSymbol("AAPL","2026-03-21","C",200) | Option symbol | OCC symbol for specific contract |
=opt_ImpliedVolatility("AAPL") | Implied volatility | Apple's current implied volatility |
Analyst Estimates
| Function | What It Returns | Example |
|---|---|---|
=OneYrTargetPrice("AAPL") | 1-year price target | Consensus analyst price target |
=NumberOfAnalysts("AAPL") | Analyst coverage | Number of analysts covering the stock |
Practical Use Cases: Claude Excel Workflows in Action
Let us walk through several real-world scenarios where Claude connected to MarketXLS delivers immediate value.
Use Case 1: Quick Stock Screening
What you say to Claude: "Compare AAPL, MSFT, GOOGL, and AMZN on P/E ratio, dividend yield, RSI, revenue, and one-year price target."
What Claude does behind the scenes:
- Calls
=PERatio("AAPL"),=PERatio("MSFT"),=PERatio("GOOGL"),=PERatio("AMZN") - Calls
=DividendYield("AAPL"),=DividendYield("MSFT"),=DividendYield("GOOGL"),=DividendYield("AMZN") - Calls
=RSI("AAPL"),=RSI("MSFT"),=RSI("GOOGL"),=RSI("AMZN") - Calls
=Revenue("AAPL"),=Revenue("MSFT"),=Revenue("GOOGL"),=Revenue("AMZN") - Calls
=OneYrTargetPrice("AAPL"),=OneYrTargetPrice("MSFT"),=OneYrTargetPrice("GOOGL"),=OneYrTargetPrice("AMZN")
What you get: A formatted comparison table with all metrics, plus Claude's analysis of which stocks look undervalued, overbought, or have the strongest growth trajectory.
In Excel, building this same comparison manually would require 20 separate formula entries and manual table formatting. With Claude, it takes one sentence.
Use Case 2: Options Analysis with Greeks
What you say to Claude: "Show me the SPX option chain with Greeks for the nearest expiration. Identify any options with unusually high implied volatility."
What Claude does:
- Calls
=QM_GetOptionQuotesAndGreeks("^SPX") - Analyzes the full chain including Delta, Gamma, Theta, Vega, and Rho
- Identifies statistical outliers in implied volatility
No other MCP server can do this. If you try to get real-time options Greeks through any other AI data connection, you will not find one. For a deeper dive into AI-powered derivatives analysis, see our options AI guide. MarketXLS is the only provider that has built this into an MCP server.
Use Case 3: Dividend Income Portfolio Review
What you say to Claude: "I hold AAPL, JNJ, PG, KO, and VZ. Show me each stock's dividend yield, dividend per share, ex-dividend date, and payout sustainability based on current ratio and debt-to-equity."
What Claude does:
- Calls
=DividendYield(),=DividendPerShare(),=Ex_DividendDate(),=Current_Ratio(), and=TotalDebtToEquity()for each ticker - Organizes results into a portfolio dashboard view
- Flags any stocks with deteriorating payout sustainability
Use Case 4: Technical Momentum Scan
What you say to Claude: "Check RSI and 50-day moving average for AAPL, NVDA, TSLA, and META. Which ones are overbought and which are trading above their moving average?"
What Claude does:
- Calls
=RSI()and=SimpleMovingAverage(ticker, 50)and=Last()for each stock - Compares current price to the 50-day SMA
- Identifies overbought conditions (RSI above 70) and oversold conditions (RSI below 30)
Claude Excel vs. Other AI Financial Data Methods
How does using Claude with MarketXLS compare to other approaches? Here is a detailed breakdown:
| Method | Real-Time Data | Options and Greeks | Number of Functions | Natural Language | Works in Excel | Works in AI Clients |
|---|---|---|---|---|---|---|
| Claude plus MarketXLS MCP | Yes | Yes (full Greeks) | 1,100 or more | Yes | Yes (add-in) | Yes (any MCP client) |
| ChatGPT with browsing | Delayed | No | None | Yes | No | No |
| Manual Excel with data feeds | Yes | Limited | Varies | No | Yes | No |
| Python scripts | Depends on API | Depends on API | Custom built | No | No | No |
| Bloomberg Terminal | Yes | Yes | Thousands | No | Yes (plugin) | No |
| Claude without MCP | No (training cutoff) | No | None | Yes | No | Yes |
The key advantages of the Claude plus MarketXLS approach:
- Real-time data through function execution — Claude calls actual MarketXLS functions and gets current values, not cached or training data
- Options with Greeks — the only MCP server providing this capability
- Dual access — the same MarketXLS account works in Excel (add-in) and through any MCP-compatible AI client
- Natural language interface — no formula syntax to memorize
- 1,100+ functions — the broadest coverage of financial data points available through MCP
Excel Add-In and MCP: Two Interfaces, One Platform
A common question is whether you need to choose between using MarketXLS in Excel or through Claude via MCP. The answer is no — they complement each other.
When to Use the Excel Add-In
- Building structured financial models with linked cells
- Creating dashboards that auto-refresh
- Working with large datasets across many tickers
- Generating formatted reports for sharing
- Running custom calculations that reference multiple data points
In Excel, you type formulas directly into cells:
Cell A1: =Last("AAPL")
Cell B1: =PERatio("AAPL")
Cell C1: =DividendYield("AAPL")
Cell D1: =RSI("AAPL")
Cell E1: =SimpleMovingAverage("AAPL", 50)
These cells update with live data, and you can build complex models on top of them.
When to Use Claude via MCP
- Quick lookups without opening Excel
- Conversational analysis where you want AI interpretation
- Comparing multiple stocks with natural language
- Learning about financial concepts while seeing real data
- Screening stocks based on criteria you describe in plain English
- Getting options analysis with Greeks explained in context
The Best of Both Worlds
Many MarketXLS users use both approaches in the same session. They ask Claude to screen stocks and identify candidates via MCP, then build detailed models in Excel using the add-in for the shortlisted tickers. The same subscription covers both use cases.
Advanced Workflows: Combining Multiple Functions
The real power of Claude with MarketXLS emerges when you combine multiple functions in a single analysis. Here are some advanced workflows.
Comprehensive Valuation Analysis
Ask Claude: "Give me a complete valuation profile for AAPL including price, P/E ratio, price-to-book, EPS estimate for this year, revenue, market cap, analyst price target, and number of analysts covering it."
Claude will execute:
=Last("AAPL")— current price=PERatio("AAPL")— earnings valuation=PriceToBook("AAPL")— book value valuation=EPSEstimateCurrentYear("AAPL")— forward earnings=Revenue("AAPL")— top-line revenue=MarketCapitalization("AAPL")— total market value=OneYrTargetPrice("AAPL")— where analysts think it is heading=NumberOfAnalysts("AAPL")— coverage depth
That is eight function calls that Claude handles automatically. You get a complete valuation picture with AI commentary on what the numbers mean.
Options Strategy Evaluation
Ask Claude: "Pull the AAPL option chain for March 2026 expiration. Show me the at-the-money calls and puts with full Greeks. What does the implied volatility tell us about market expectations?"
Claude will call:
=Last("AAPL")to determine the at-the-money strike=QM_GetOptionQuotesAndGreeks("^SPX")for options data=OptionSymbol("AAPL","2026-03-21","C",200)for specific contracts=opt_ImpliedVolatility("AAPL")for IV context
You get not just the raw data but an AI interpretation of what the Greeks and implied volatility suggest about near-term price expectations.
Financial Health Assessment
Ask Claude: "Assess the financial health of AAPL by looking at its current ratio, debt-to-equity ratio, revenue, dividend sustainability, and how the stock is trading relative to its 50-day moving average."
Claude executes:
=Current_Ratio("AAPL")— liquidity check=TotalDebtToEquity("AAPL")— leverage assessment=Revenue("AAPL")— revenue trend=DividendPerShare("AAPL")— payout size=DividendYield("AAPL")— yield attractiveness=SimpleMovingAverage("AAPL", 50)— trend context=Last("AAPL")— current price vs. SMA
Getting the Most Out of Claude Excel Integration
Here are practical tips for maximizing your productivity with Claude and MarketXLS.
Tip 1: Be Specific About What You Want
Instead of asking "Tell me about Apple stock," say "Give me Apple's P/E ratio, RSI, dividend yield, and compare them to Microsoft." Specific requests produce better results because Claude knows exactly which functions to call.
Tip 2: Ask for Comparisons
Claude excels at multi-stock comparisons. Ask it to compare 5 to 10 stocks across multiple metrics. This is where the time savings over manual Excel work become dramatic.
Tip 3: Request Analysis, Not Just Data
Claude can interpret the numbers it retrieves. Ask "Is Apple overbought based on its RSI?" instead of just "What is Apple's RSI?" You get both the data point and the analysis.
Tip 4: Use It for Options Screening
Since MarketXLS is the only MCP server with real-time options data and Greeks, lean into this advantage. Ask Claude to find high-IV options, analyze put-call ratios, or evaluate covered call candidates.
Tip 5: Combine with Your Excel Models
Use Claude via MCP for quick screening and exploratory analysis. Then take your findings into Excel where you can use the same MarketXLS functions in a structured spreadsheet model. The transition is seamless because the functions are identical. You can also explore how ChatGPT works with Excel and live data for a similar workflow using a different AI client.
Why MarketXLS MCP Server Is Unique
There are many MCP servers available for various purposes, but for financial data, MarketXLS stands alone in several critical ways:
Real-time options data with Greeks — No other MCP server provides live option chains with Delta, Gamma, Theta, Vega, and Rho. If you trade options, this is the only MCP-based solution that works.
1,100+ financial functions — From basic price quotes to complex fundamental ratios, technical indicators, and analyst estimates. The breadth of coverage means Claude can answer virtually any financial data question.
Dual-mode access — The same subscription works in Excel (add-in) and through any MCP-compatible AI client. You are not paying twice for the same data.
Function execution, not data analysis — Claude does not just analyze data you paste in. It executes actual MarketXLS functions and receives current values. Every query returns live market data.
Works with any MCP client — Claude Desktop, Cursor, Windsurf, and any future MCP-compatible application. You are not locked into a single AI provider.
Frequently Asked Questions
Do I need a separate subscription for the MCP server and Excel add-in?
No. A single MarketXLS account on the Advanced plan or higher gives you access to both the Excel add-in and the MCP server. There is no additional cost for MCP access.
Does Claude need to be running inside Excel for this to work?
No. The MCP connection works independently of Excel. You can use Claude Desktop, Cursor, Windsurf, or any MCP-compatible client. Claude calls MarketXLS functions through the MCP server regardless of whether Excel is open.
What kind of options data can Claude access through MarketXLS?
Claude can pull full option chains with all strikes and expirations using =QM_GetOptionChain("^SPX"), and get complete Greeks (Delta, Gamma, Theta, Vega, Rho) using =QM_GetOptionQuotesAndGreeks("^SPX"). You can also look up specific option symbols with =OptionSymbol() and check implied volatility with =opt_ImpliedVolatility(). MarketXLS is the only MCP server offering real-time options data with Greeks.
How current is the data Claude retrieves?
Claude executes MarketXLS functions in real time through the MCP server. When Claude calls =Last("AAPL"), it gets the current market price at that moment — not cached or historical data. The data is as current as what you would see in the Excel add-in.
Can I use this with AI clients other than Claude?
Yes. The MarketXLS MCP server works with any AI client that supports the Model Context Protocol. This includes Claude Desktop, Cursor, Windsurf, and other MCP-compatible applications. The server URL is the same for all clients: https://qm-mcp.marketxls.com/mcp
What is the difference between using MarketXLS in Excel versus through Claude?
In Excel, you type formulas like =Last("AAPL") directly into cells and build structured models. Through Claude via MCP, you describe what you want in natural language and Claude executes the same underlying functions. Both access the same data. Excel is better for structured models and dashboards. Claude is better for quick lookups, comparisons, analysis, and exploring data conversationally.
Explore More
- MCP Stock Data: Connect Any AI to Live Market Prices & Fundamentals
- AI Stock Analysis: Real-Time AI-Powered Financial Research
- ChatGPT Excel: AI + Financial Spreadsheets with Live Market Data
- Options AI: AI-Powered Options Trading with Live Data & Greeks
Get Started with Claude and MarketXLS
Connecting Claude to live financial data through MarketXLS takes just two minutes. Add the MCP server configuration to your preferred AI client, log in with your MarketXLS credentials, and start asking questions about any stock, option, ETF, or index.
Whether you are screening stocks, analyzing options Greeks, reviewing dividend portfolios, or building comprehensive valuation models, the combination of Claude's analytical intelligence and MarketXLS's 1,100+ financial functions gives you a research workflow that is faster, more intuitive, and more powerful than manual spreadsheet work alone.
Ready to connect Claude to live market data? Visit MarketXLS to choose your plan on the pricing page, then follow the MCP setup instructions above to get started in minutes.
