Pull Stock Data in Claude Using the MarketXLS MCP Connector

To pull stock data in Claude, add the MarketXLS MCP connector: in Claude go to Settings, then Connectors, click "Add custom connector", paste https://connect.mcp.marketxls.com/mcp, and sign in with your MarketXLS account. Claude can then call MarketXLS tools mid-conversation to return quotes, fundamentals, option chains, and historical prices instead of guessing from training data. The connection works in Claude on the web and desktop, needs a Claude Pro, Max, Team, or Enterprise plan plus a MarketXLS subscription (Standard, Advanced, or Business), and real-time data requires the Advanced or Business plan. This guide covers setup, example prompts, and a companion Excel workbook that uses the same MarketXLS functions.

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

Pull stock data in Claude: a 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).

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 entire reason to connect Claude to a live financial-data feed rather than asking it to recall a number from training data.

What the MarketXLS MCP Connector Does for Claude Users

The MarketXLS MCP connector lets Claude call MarketXLS financial data tools during a conversation. The Model Context Protocol (MCP) is an open standard for connecting AI assistants to external tools. With the connector added, Claude can invoke those tools mid-conversation, fetching a stock quote, pulling an option chain, or retrieving historical prices, and weave the results directly into its response.

You ask in plain English, and Claude looks up the numbers through MarketXLS. The connector handles sign-in (OAuth with your MarketXLS account) and data formatting, so you do not write API calls.

Key capabilities the connector exposes include:

• Stock quotes (15-minute delayed on Standard, real-time on Advanced and Business) through functions like =QM_Last("AAPL") and =QM_ChangePercent("AAPL") for last price, percent change, and volume.
• Fundamental data such as =PERatio("AAPL"), =DividendYield("AAPL"), and =MarketCapitalization("AAPL") for valuation and balance-sheet metrics.
• Technical and risk measures including =Beta("NVDA"), =SimpleMovingAverage("NVDA","50"), and =RelativeStrengthIndex("NVDA","14").
• Historical price data using =QM_GetHistory("AMZN"), which returns an OHLCV series suitable for charting or quantitative work.
• Screening and comparison across a universe of stocks by criteria you specify conversationally.

Because the data comes from MarketXLS's existing infrastructure, the same coverage and quality you would get in an Excel workbook is available when you pull stock data in Claude.

Why Pull Stock Data Inside an AI Assistant?

Pulling stock data inside Claude saves you from looking up function names and cell references, and adds a reasoning step on top of the data.

When you pull stock data in Claude through the MarketXLS connector, you can:

1. Ask follow-up questions naturally. After fetching Apple's trailing P/E, you can immediately ask how it compares to the sector median without writing a new formula.
2. Combine data types in one prompt. Request a company's dividend yield alongside its beta and market cap, and let Claude synthesize all three into a coherent read.
3. Iterate faster. Changing your research angle means rephrasing a sentence, not restructuring a spreadsheet.
4. Reduce transcription errors. Data flows directly from MarketXLS into the conversation context, eliminating copy-paste mistakes.

This is not a replacement for rigorous spreadsheet modeling. It is a faster front end for exploration, screening, and hypothesis generation. The companion workbook below exists precisely so you can move from a quick conversational answer to an auditable, refreshable model without re-keying a single number.

Prerequisites Before You Connect

Before you can pull stock data in Claude, a few things need to be in place:

• A MarketXLS subscription. The AI connection is included with the Standard, Advanced, and Business plans; see MarketXLS pricing. Real-time quotes and options data require Advanced or Business.
• A Claude plan that supports custom connectors: Claude Pro, Max, Team, or Enterprise, on the web or desktop app.
• No configuration files or API keys. You paste one URL and sign in.

If you already use MarketXLS in Excel or Google Sheets, sign in with the same MarketXLS account.

Step-by-Step: Connecting MarketXLS to Claude

Connecting MarketXLS to Claude takes four steps (see 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. Claude redirects you to the MarketXLS login page. Enter your MarketXLS account credentials and authorize the connection (OAuth).

Step 4 - Verify the connection. In a new conversation, type something like: "What tools do you have available from MarketXLS?" Claude should list the financial data tools it can now call. If it does not, revisit the troubleshooting section below.

Core Workflows: Quotes, Fundamentals, Signals, and History

Once connected, you can pull stock data in Claude across several distinct workflows. Each one maps to a MarketXLS function you can also drop straight into a spreadsheet cell.

Live and Delayed Quotes

Ask Claude for a current quote in plain English:

"Pull the latest quote for MSFT including percent change and volume."

Claude calls the appropriate MarketXLS tool, receives the structured data, and presents it in a readable format. The Excel equivalents are =QM_Last("MSFT"), =QM_ChangePercent("MSFT"), and =QM_Volume("MSFT"). US stock quotes are 15-minute delayed on the Standard plan and real-time on the Advanced and Business plans.

Fundamental Analysis

Fundamental data works well in a conversational format:

"Pull the P/E, dividend yield, and market cap for NVDA and tell me how the valuation compares with its megacap peers."

Claude fetches the data using =PERatio("NVDA"), =DividendYield("NVDA"), and =MarketCapitalization("NVDA"), performs the comparison, and delivers an interpretation in one response. You remain responsible for validating the numbers, but you can iterate without building a spreadsheet first.

Trend and Momentum Signals

Technical context is a single prompt away:

"Pull the 50-day and 200-day moving averages and the 14-day RSI for AMZN and describe the trend."

The underlying functions are =SimpleMovingAverage("AMZN","50"), =SimpleMovingAverage("AMZN","200"), and =RelativeStrengthIndex("AMZN","14"). Claude can compare the last price against those averages and discuss what the current position might suggest, while being clear that this is analytical context, not investment advice.

Historical Price Data

Historical OHLCV data enables backtesting conversations:

"Fetch daily closing prices for AMZN over the past two years and calculate a simple moving average."

The function =QM_GetHistory("AMZN") returns a spillable price series you can chart or feed into your own calculations. Claude can perform the arithmetic inline and discuss the result while keeping the framing educational.

Combining AI Analysis with Live Market Data

The main benefit of pulling stock data in Claude is the synthesis step. Raw numbers from MarketXLS become inputs to Claude's reasoning, and you can direct that reasoning with follow-up prompts.

A practical research session might look like this:

1. Pull the current P/E, dividend yield, and beta for a watchlist of five stocks.
2. Ask Claude to rank them by relative valuation and flag any outliers.
3. Pull the 50-day and 200-day moving averages for the two cheapest names.
4. Ask whether price is above or below those averages and what that implies about trend.
5. Export the final table to Excel for further modeling.

Each step builds on the last, and the entire session is documented in the conversation transcript, giving you a natural audit trail for your research process.

Important distinction: Claude's analysis is based on the data MarketXLS provides plus its training knowledge. It does not have access to real-time news feeds, earnings call transcripts, or regulatory filings unless those are separately provided. Always verify AI-generated interpretations against primary sources before making financial decisions.

The Companion Template: The Same Functions, Now in Excel

To make the handoff concrete, this post ships with a two-file Excel workbook that mirrors what the connector does. Every data point in the workbook is powered by a MarketXLS function, so the number Claude quotes you in chat is the same number your spreadsheet recalculates on demand.

The workbook has six sheets:

The Main Dashboard is the heart of it. Each row is one ticker, and every metric is a live formula:

=QM_Last(A9)                  Last traded price
=QM_ChangePercent(A9)/100     Percent change vs previous close
=QM_Volume(A9)                Shares traded today
=PERatio(A9)                  Trailing P/E
=DividendYield(A9)            Trailing dividend yield
=Beta(A9)                     Volatility vs the market
=MarketCapitalization(A9)     Market cap

Formula documentation: QM_Last, QM_ChangePercent, QM_Volume, PERatio, DividendYield, Beta, MarketCapitalization

The yellow input cells at the top let you set a portfolio size, a change-percent alert threshold, a maximum P/E to flag, and a minimum dividend yield. Those inputs flow through the rest of the workbook, so the Scenario Analysis and Portfolio sheets react automatically when you change an assumption. The Comparison / MCP sheet pairs each live metric with a suggested Claude prompt, so you can move between the spreadsheet and the conversation without losing your place.

Download the templates:

• - pre-filled with the 2026-07-18 snapshot so you can see the layout immediately.
• - live formulas that refresh when you recalculate in Excel.

If you want to see how the same functions behave in Google Sheets or across other MarketXLS tools, the MarketXLS features page covers the broader platform.

Exporting Results to Excel or Google Sheets

MarketXLS is also a native Excel and Google Sheets add-in, which means the MCP connector and the spreadsheet workflows are complementary rather than competing.

A common pattern is to use Claude for rapid exploration, screening ideas, comparing metrics, and stress-testing assumptions conversationally, and then hand off the refined model to Excel for rigorous scenario analysis. To move data from a Claude session into a spreadsheet:

• Ask Claude to format the output as a CSV-compatible table.
• Paste the table into Excel or Google Sheets.
• Replace the static values with live MarketXLS functions such as =QM_Last("AAPL") so the data stays current and formula-driven from then on.

This hybrid approach gives you the speed of conversational research and the precision of a structured workbook.

Data Quality Checks and Validation Tips

Pulling data through an AI interface adds an abstraction layer, which makes validation more important, not less. Follow these practices:

Cross-check key figures. For any number that will influence a decision, verify it against a second source, whether your brokerage platform or the live formula in the companion workbook.

Confirm the data type. Ask Claude explicitly whether a figure is trailing twelve months, most recent quarter, or a forward estimate. Mixing these inadvertently is a common source of analytical error.

Check the quote timestamp. When working with price data, confirm whether the quote is real-time, delayed, or end-of-day. For streaming updates, =QM_Stream_Last("AAPL") refreshes automatically in Excel.

Watch for corporate actions. Historical price series should be adjusted for splits and dividends for most analytical purposes. Confirm which adjustment convention the data uses before drawing trend conclusions.

Treat AI interpretation as a starting point. Claude's synthesis of financial data is a useful first pass, not a final verdict. Use it to generate hypotheses you then test with your own analysis.

Troubleshooting Common Connection Issues

Claude does not list MarketXLS tools. Check that the connector URL is exactly https://connect.mcp.marketxls.com/mcp and that the connector is enabled in Settings → Connectors.

Authentication errors when fetching data. Disconnect and reconnect the connector, then sign in again with an active MarketXLS account.

Tool calls time out or return empty results. This can indicate a network issue, a rate limit, or a symbol format problem. Try a well-known ticker like AAPL to isolate whether the issue is with the connection or with a specific symbol. Some international symbols require an exchange suffix.

Claude says it does not have access to financial data tools. Confirm your Claude plan supports custom connectors (Pro, Max, Team, or Enterprise) and that the MarketXLS connector is turned on for the conversation.

Frequently Asked Questions

Does pulling stock data in Claude require a separate MarketXLS subscription? No separate product is needed. The AI connection is included with the MarketXLS Standard, Advanced, and Business plans; see the pricing page.

Is the data real-time or delayed? It depends on your MarketXLS plan. US stock quotes are 15-minute delayed on Standard and real-time on Advanced and Business. Options data is end-of-day on Standard and real-time on Advanced and Business.

Can I use the MCP connector with Claude on the web? Yes. The MarketXLS connector is a remote MCP server, so it works in Claude on the web and in the desktop app once added under Settings → Connectors. It also works in other MCP clients such as ChatGPT (which uses a separate URL listed in the MCP docs).

Is this suitable for automated trading decisions? No. The workflow described here is designed for research and analysis. Automated trading requires dedicated infrastructure with guaranteed latency, reliability, and compliance controls that a conversational AI interface is not designed to provide.

Can I pull data for ETFs and indices in addition to stocks? Yes. The template's market-pulse box uses =QM_Last("SPY") and =QM_Last("QQQ") for index ETFs, and MarketXLS supports a range of asset classes. The specific coverage available through the connector mirrors the broader platform.

What happens to my conversation data? Your prompts and Claude's responses are subject to Anthropic's privacy policy, and market data fetched through the connector is subject to MarketXLS's terms of service. Review both before using the workflow with sensitive or proprietary research.

The Bottom Line

Pulling stock data in Claude through the MarketXLS MCP connector lets you ask market questions in plain English and get answers based on MarketXLS data rather than a model's memory. Set up the connector once, validate your outputs carefully, and keep the companion workbook open so every figure Claude quotes has a live, auditable formula behind it.

Ready to build the workflow? Explore the full function library at MarketXLS, and if you want a guided walkthrough of the MCP connector and the Excel add-in together, book a demo.

Educational content only. This article does not constitute investment advice, and all tickers are used solely to illustrate how the functions work.