Claude can answer questions with current stock data once you add the MarketXLS MCP connector. The connector gives Claude access to MarketXLS quotes, fundamentals (P/E, revenue, margins, debt), option chains with Greeks and implied volatility, historical prices, and screening, so answers come from a data call instead of the model's training data. You add it in Claude under Settings, then Connectors, with the URL https://connect.mcp.marketxls.com/mcp, and sign in with your MarketXLS account. It is included with the MarketXLS Standard, Advanced, and Business plans; real-time quotes and options data require Advanced or Business. This guide explains what data is available, how to set it up, example prompts, and a companion Excel workbook built on the same functions.
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
Stock data in Claude: live snapshot from the MarketXLS data layer
Here is the kind of grounded quote board Claude can return when the MarketXLS MCP connector is active. Every figure below was pulled from the MarketXLS data layer using the same functions the connector exposes (data as of 2026-07-18).
| Ticker | Last Price | Change % | P/E | Div Yield | Beta |
|---|---|---|---|---|---|
| AAPL | $333.74 | +0.14% | 34.2 | 0.40% | 0.84 |
| MSFT | $393.82 | -1.82% | 36.5 | 0.65% | 1.23 |
| NVDA | $202.81 | -2.21% | 38.3 | 0.02% | 1.89 |
| GOOGL | $346.77 | -2.17% | 26.5 | 0.25% | 1.21 |
| AMZN | $247.23 | -1.06% | 32.2 | 0.00% | 1.46 |
| META | $646.01 | -2.79% | 28.1 | 0.32% | 1.53 |
| TSLA | $380.84 | -2.61% | 416.4 | 0.00% | 1.62 |
The point is not the exact prices, which move constantly. The point is that these are real, sourced data points, not something the model invented. That difference is the whole reason to connect Claude to a live financial-data feed.
What it means to access stock data in Claude
Accessing stock data in Claude means Claude looks up market data through a connected tool instead of relying on its training data, which has a knowledge cutoff and contains no real-time prices, you can connect it to a live financial-data feed and ask questions that require current market information.
This is made possible by the Model Context Protocol (MCP), an open standard that lets AI assistants call external tools during a conversation. MarketXLS, which provides financial data functions for Excel and Google Sheets, offers an MCP connector that exposes those data tools to AI assistants including Claude and ChatGPT.
The result is a conversational interface where you can ask "What is Apple's current P/E ratio?" or "Show me the implied volatility on near-term SPY options" and receive a grounded, data-backed answer rather than a hallucinated estimate.
How the MarketXLS MCP connector works
The MarketXLS MCP connector acts as a bridge between Claude's reasoning engine and MarketXLS's financial-data infrastructure. When you ask a market-related question, Claude recognizes that it needs live or historical data, calls the appropriate MarketXLS tool through the MCP interface, receives a structured response, and then synthesizes that data into a coherent answer.
This architecture has several important implications:
- Claude does the reasoning; MarketXLS does the data retrieval. Claude is not guessing prices or fundamentals, it is fetching them from MarketXLS's data layer.
- The connection is session-aware. You can ask follow-up questions that build on earlier data fetches within the same conversation.
- No spreadsheet is required. The entire workflow can happen inside the Claude chat interface, though you can export results to Excel or Google Sheets when you need a persistent workbook.
This separation matters when you judge the output. When Claude cites a stock price or earnings figure, that number came from a MarketXLS data call, not from the model's weights. Under the hood, the same function names you would type in a cell, such as =QM_Last("AAPL") or =PERatio("AAPL"), are the functions the connector invokes on your behalf.
What types of financial data are available
Through the MarketXLS MCP connector, Claude can access a broad range of financial data categories. While the exact scope depends on your MarketXLS plan and the tools exposed by the connector, the general categories include:
Quotes (15-minute delayed on Standard, real-time on Advanced and Business)
- Last price, bid, ask, volume, and daily change for equities and ETFs
- Intraday snapshots for active trading sessions
Fundamental data
- Income statement metrics: revenue, earnings per share, net income, operating margin
- Balance sheet data: total assets, debt levels, cash and equivalents
- Valuation ratios: P/E, P/B, EV/EBITDA, price-to-sales
Historical price data
- Daily OHLCV (open, high, low, close, volume) going back years
- Adjusted close prices that account for splits and dividends
- Custom date-range queries for backtesting or trend analysis
Options data
- Options chains with strikes, expirations, bid/ask, open interest, and volume
- Greeks: delta, gamma, theta, vega
- Implied volatility for individual contracts and aggregate IV metrics
Screening and comparison
- Multi-ticker comparisons across fundamental or technical metrics
- Sector and industry groupings
When you frame a question in Claude, the MCP connector selects the appropriate MarketXLS tool automatically. You do not need to know the underlying function names, but knowing a few of them helps you understand exactly what you are getting.
The MarketXLS functions behind the answers
The data Claude returns through the connector comes from MarketXLS functions that you can also enter in an Excel cell. A few of the core ones:
=QM_Last("AAPL") Last traded price
=QM_ChangePercent("AAPL") Percent change vs previous close
=QM_Volume("AAPL") Shares traded on the day
=PERatio("AAPL") Trailing P/E ratio
=DividendYield("AAPL") Trailing dividend yield
=Beta("AAPL") Volatility vs the market
=MarketCapitalization("AAPL") Market capitalization
=SimpleMovingAverage("AAPL","50") 50-day simple moving average
=RelativeStrengthIndex("AAPL","14") 14-period RSI
=FiftyTwoWeekHigh("AAPL") 52-week high
=FiftyTwoWeekLow("AAPL") 52-week low
=QM_GetHistory("AAPL") Historical price series
=QM_GetOptionChainActive("SPY") Live option chain
Formula documentation: QM_Last, QM_ChangePercent, QM_Volume, PERatio, DividendYield, Beta, MarketCapitalization, SimpleMovingAverage, RelativeStrengthIndex, FiftyTwoWeekHigh, FiftyTwoWeekLow, QM_GetHistory, QM_GetOptionChainActive
When you ask Claude "What is NVDA trading at, and how does that compare to its 52-week high?", the connector calls QM_Last and FiftyTwoWeekHigh behind the scenes and Claude does the arithmetic on the returned values. Because the same functions are available in Excel, you can reproduce and audit a conversational result in a workbook.
Step-by-step: setting up the MarketXLS MCP connector with Claude
Setting up the connector requires a MarketXLS subscription (Standard, Advanced, or Business) and a Claude Pro, Max, Team, or Enterprise plan. It works in Claude on the web and in the desktop app. Full steps are in the MarketXLS MCP docs.
Step 1 - Open connector settings In Claude, go to Settings → Connectors and click "Add custom connector".
Step 2 - Paste the server URL
Enter https://connect.mcp.marketxls.com/mcp and click Add.
Step 3 - Sign in to MarketXLS Claude redirects you to the MarketXLS login page. Enter your MarketXLS account credentials and authorize the connection. Sign-in uses OAuth, so there is no API key to copy.
Step 4 - Test the connection Start a new conversation and ask a simple question such as: "What is the current price of Microsoft stock?" If the connector is working, Claude will call the MarketXLS tool, retrieve the quote, and display it with a source attribution. If you see Claude respond from training data alone (for example, citing a price from over a year ago), the connection is not yet active.
Step 5 - Explore available tools Ask Claude: "What financial data tools do you have access to?" Claude will enumerate the MarketXLS tools registered in the session, giving you a clear picture of what queries are supported.
Running your first stock data queries in a conversation
Once the connector is live, you can ask questions like these:
Simple quote lookup
"What is NVDA trading at right now, and how does that compare to its 52-week high?"
Claude will fetch the current quote and the 52-week high from MarketXLS and compute the percentage gap in its response.
Fundamental comparison
"Compare the P/E ratios of Apple, Microsoft, and Alphabet. Which looks most expensive on that metric?"
Claude will retrieve the P/E for each ticker and provide a ranked comparison with brief commentary. Note that this is data presentation and ratio comparison, not investment advice.
Historical trend query
"Pull the monthly closing prices for Tesla over the past two years and describe the trend."
Claude will fetch the historical OHLCV data, summarize the price trajectory, and can identify notable drawdowns or rallies.
Options analysis
"Show me the implied volatility on SPY options expiring in the next 30 days across a range of strikes."
Claude will retrieve the options chain, filter by expiration, and present IV figures in a readable format. You can then ask follow-up questions about specific strikes or compare IV to historical volatility.
Screening query
"Which S&P 500 technology stocks have a P/E below 20 and a dividend yield above 1%?"
Claude will use MarketXLS screening tools to filter the universe and return a list of qualifying tickers.
Combining conversational analysis with spreadsheet handoff
The MarketXLS MCP connector and the Excel and Google Sheets add-ins draw on the same MarketXLS data, so a workflow that begins in Claude can move to a spreadsheet for deeper modeling.
A typical combined workflow looks like this:
- Explore in Claude - Use conversational queries to identify the tickers, metrics, or date ranges you care about. Claude's natural-language interface is faster for exploratory research than building formulas from scratch.
- Refine the question - Ask follow-up questions to narrow your focus. For example, after a screening query returns 15 tickers, ask Claude to rank them by revenue growth.
- Export to a spreadsheet - Once you know exactly what data you need, open Excel or Google Sheets with the MarketXLS add-in and pull the same data using MarketXLS functions. The data definitions are consistent across both interfaces.
- Model and visualize - Use the spreadsheet for DCF models, scenario analysis, or charting that benefits from a persistent, editable grid.
This hybrid approach plays to the strengths of each tool: Claude for speed and natural-language reasoning, spreadsheets for structured modeling and auditability. The companion workbook below is built for that handoff.
The companion workbook: from conversation to spreadsheet
To make the handoff concrete, this post ships with a two-file Excel workbook that mirrors the connector's capabilities. Both files carry a six-sheet structure so you can go from a quick quote board to position sizing without leaving Excel.
- How To Use - The workflow, MCP connector notes, and links, plus an example Claude prompt for each concept.
- Main Dashboard - A live quote board across seven mega-cap names with yellow input cells for portfolio size, an alert threshold, a maximum P/E flag, and a minimum dividend yield. Signals flow from your inputs.
- Scenario Analysis - A beta-implied move table. Enter a market move in the yellow cell and each stock's estimated move is calculated as beta times the market move.
- Watchlist / Signals - A live trend and momentum read using 50-day and 200-day moving averages, RSI, and the 52-week range (educational only).
- Portfolio / Allocation - An inverse-beta weighting model that sizes positions from your portfolio input, giving lower-volatility names more weight.
- Comparison / MCP - A side-by-side metrics grid paired with ready-to-paste Claude MCP prompt ideas for each ticker.
The sample file is pre-filled with the static snapshot shown above (data as of 2026-07-18) so you can study the layout with no add-in installed, and it lists the exact MarketXLS formula next to each value. The template file swaps those static values for live MarketXLS formulas such as =QM_Last(A9), =PERatio(A9), and =Beta(A9), so it refreshes when you recalculate. Every sheet includes a "MarketXLS Functions Used" box so you always know which formula powers which cell.
Download the templates:
- - Pre-filled with current data
- - Live-updating formulas
Validating data quality and understanding data types
Not all financial data is the same, and responsible use of the MarketXLS MCP connector requires understanding what you are actually receiving.
Live vs. delayed data US stock quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans; options data is end-of-day on Standard. Always check the timestamp on a quote before making time-sensitive decisions. Claude will typically surface the timestamp returned by MarketXLS in its response.
Adjusted vs. unadjusted historical prices Historical close prices can be split-adjusted, dividend-adjusted, or unadjusted. When asking for historical data, specify which you need. For return calculations, adjusted prices are generally appropriate. For reconstructing a specific past price, unadjusted prices are more accurate.
Point-in-time vs. restated fundamentals Fundamental data such as earnings or revenue may reflect the most recently reported figures, which could include restatements. If you are doing historical fundamental analysis, be aware that the figures available today may differ from what was reported at the time.
AI synthesis vs. raw data Claude's conversational response is a synthesis of the raw data returned by MarketXLS. For high-stakes decisions, cross-reference the raw figures in a spreadsheet or directly on the exchange or company filings. Use Claude's analysis as a starting point, not a final source. This is exactly where the companion workbook earns its keep: it gives you an auditable grid of the same values.
Practical use cases for investors and analysts
Portfolio monitoring Ask Claude to pull current prices and daily changes for a list of tickers, then summarize which positions are outperforming or underperforming the broader market that day.
Earnings research Before an earnings release, ask Claude to retrieve the last four quarters of EPS and revenue, compare them to analyst consensus estimates, and summarize the trend. After the release, ask it to update the data and assess the beat or miss.
Options strategy research Use Claude to explore the options chain for a stock you are considering, identify strikes with favorable risk/reward profiles based on IV and delta, and compare current IV to historical norms.
Sector rotation analysis Ask Claude to compare valuation multiples across sectors using ETF proxies or sector indices, helping you identify where the market is pricing in optimism or pessimism.
Due diligence on individual stocks Pull a comprehensive fundamental snapshot such as revenue growth, margins, debt ratios, and valuation multiples for a stock you are researching, and ask Claude to flag any metrics that stand out relative to industry peers.
None of these are recommendations. They are research workflows. The data and the analysis are inputs to your own judgment, not a substitute for it.
Troubleshooting common issues
Claude responds with training-data prices instead of live data This means the MCP connector is not active in the session. Check that the MarketXLS connector is added and enabled under Settings → Connectors and that you are signed in to an active MarketXLS account.
Data is returned but seems stale Check the timestamp on the returned data. If markets are closed, you will see the most recent closing price. If markets are open and the data still seems old, you may be on a delayed-data plan or the connector may be experiencing a cache issue.
Claude says it cannot find a ticker Some tickers, particularly OTC stocks, foreign-listed equities, or recently IPO'd companies, may not be in the MarketXLS coverage universe. Try the primary exchange ticker format (for example, use the NYSE or NASDAQ symbol rather than an OTC pink-sheet symbol).
Options chain returns no results Confirm that the ticker has listed options. Not all stocks have options markets. Also check that your expiration date query is formatted correctly and falls within available expiration dates.
Connector authentication errors Disconnect the MarketXLS connector in Settings → Connectors, reconnect it, and sign in again. If the error persists, contact support@marketxls.com.
FAQ
Does this work with the free version of Claude? Custom connectors such as MarketXLS require a Claude Pro, Max, Team, or Enterprise plan, according to the MarketXLS MCP setup docs. Check Anthropic's current documentation for any changes.
Is the data the same as what I get in the MarketXLS Excel add-in? Yes. The MCP connector draws from the same MarketXLS data infrastructure as the Excel and Google Sheets add-ins, so figures should be consistent across interfaces.
Can I use this for automated trading signals? MarketXLS provides data and Claude provides analysis. Neither constitutes a trading system, and neither should be used as the sole basis for automated order execution. Always apply your own risk management and compliance review.
How do I know when Claude is using MarketXLS data vs. its training data? When the MCP connector is active and Claude calls a MarketXLS tool, it will typically indicate the data source in its response. If you are unsure, ask Claude directly: "Did you fetch that price from MarketXLS or is that from your training data?"
Can I ask about international stocks? Coverage of international equities depends on your MarketXLS plan and the exchanges supported by the connector. Ask Claude to attempt a query on the ticker you need; if the data is unavailable, it will say so rather than fabricating a figure.
What happens if MarketXLS is down? If the MarketXLS data service is unavailable, the MCP tool call will fail and Claude will inform you that it could not retrieve the data. It should not fall back to inventing figures from its training data.
The bottom line
With the MarketXLS MCP connector, Claude answers market questions from MarketXLS data instead of memory. The MarketXLS MCP connector supplies live quotes, fundamentals, options, and historical data, while Claude handles the reasoning and synthesis, and the shared data layer means your conversation flows straight into an auditable Excel workbook when you are ready to model. Start by testing a simple quote query, then work up to comparisons, screens, and options analysis, and lean on the companion template whenever a decision deserves a spreadsheet.
To see the connector and the underlying data functions in action, explore MarketXLS or book a demo to walk through the setup with the team.
This article is for educational purposes only and does not constitute investment advice. Market data are third-party data points, not recommendations or guarantees.