Get stock prices in Claude is one of those searches that sounds simple until you actually try it. You open Claude, ask "what is NVIDIA trading at right now," and you get a confident answer that may or may not reflect today. A language model on its own does not have a live quote feed. It reasons, it explains, and it writes clearly, but it does not inherently know the last traded price of any stock. This guide shows you how to close that gap: connect Claude to a licensed market data feed over the Model Context Protocol (MCP), then keep the same numbers live and auditable in an Excel workbook where every price is a MarketXLS formula you can refresh on any ticker.
Get Stock Prices in Claude: Why the Model Needs a Data Feed
Claude is excellent at the thinking parts of investing. It can explain what a P/E ratio means, structure a checklist for reviewing a stock, or draft a summary of a company's business. What it cannot do out of the box is quote a real-time price, because prices change every second and a model's knowledge is fixed at training time. When you ask a bare model for a quote, you are relying on a number that could be weeks or months stale.
The fix is to give Claude a phone line to a real data source. That is exactly what MCP does. Once Claude is connected to the MarketXLS MCP server, asking for a price stops being guesswork and becomes a live lookup.
| Task | Claude Alone | Claude + MarketXLS MCP |
|---|---|---|
| Explain what "last price" means | Strong | Strong, plus the live number beside it |
| Quote today's exact price for NVDA | Weak (may be stale) | Live via =QM_Last("NVDA") |
| Build a quote board for eight tickers | Tedious and error prone | One request, all live |
| Pull 12 months of closes for a chart | Not possible reliably | Live via =QM_GetHistory("NVDA") |
| Compare yields across a watchlist | Often outdated | Live via =DividendYield(Symbol) |
The pattern is consistent. Keep Claude for reasoning and narrative, and hand the numbers to a licensed data provider. This post pairs that idea with a downloadable workbook so every quote Claude reports has a live formula sitting behind it.
What Is MCP and How Does Claude Use It?
MCP stands for Model Context Protocol. It is an open standard that lets an assistant like Claude connect to outside tools and data sources during a conversation. Instead of answering only from memory, Claude can call a tool, receive fresh data, and then reason over it in the same reply.
MarketXLS runs an MCP server that exposes hundreds of financial functions to Claude. The connection endpoint is:
https://connect.mcp.marketxls.com/mcp
It authenticates against your MarketXLS account, so the functions you already use in Excel become available inside Claude. Once connected, Claude can look up a price, pull an options chain, read a company's fundamentals, or compare metrics across a list of tickers, all without you leaving the chat.
The MCP Tools Claude Gets
When the MarketXLS server is connected, Claude gains a small set of tools that do the actual work:
- search_functions - find the right function by describing what you want, such as "last price," "dividend yield," or "moving average."
- get_function_details - read the full documentation for a function, including its parameters and syntax, before calling it.
- call_function - run a single function, for example fetching the last price of one ticker.
- batch_call_functions - run many calls at once, which is how Claude builds a quote board for a whole watchlist in one step.
You do not need to memorize any of this. You describe what you want in plain language, and Claude chooses the tools. The value of the workbook in this post is that it gives you a permanent, refreshable copy of the same data, so you are never dependent on re-running a prompt to see today's numbers.
How to Get Stock Prices in Claude, Step by Step
Here is the practical workflow, from connecting the feed to verifying the number.
Step 1: Connect the MarketXLS MCP Server
In Claude, add the MarketXLS MCP server using the endpoint above. Claude Desktop and the Claude web app both support MCP connectors. Once the connector is authorized against your MarketXLS account, Claude can call the functions directly.
Step 2: Ask for a Price in Plain Language
Now you can simply ask. Some prompts that work well:
- "What is the current price of NVDA?"
- "Get the last price and previous close for AAPL, and show me the day's percent change."
- "Build a quote board for NVDA, AAPL, MSFT, GOOGL, AMZN, and META with last price, 50-day and 200-day moving averages, RSI, and dividend yield."
- "Pull the last 12 monthly closes for NVDA and calculate the month over month percent change."
Claude will call the MarketXLS tools, fetch the data, and return it formatted however you asked, whether that is a sentence, a table, or a short analysis.
Step 3: Verify and Keep the Number
This is where the workbook earns its place. A price you can see in a chat is useful, but a price you can refresh tomorrow without retyping anything is better. The template below rebuilds the same quote board in Excel using MarketXLS formulas, so you always have a live, auditable copy. When Claude quotes a price, you can confirm it against the exact formula in the workbook.
The MarketXLS Formulas Behind Every Quote
Whether the data flows through Claude over MCP or sits directly in your spreadsheet, the same MarketXLS functions do the fetching. These are the core price and quote formulas, all verified against the live function library:
=QM_Last("NVDA") Real-time last traded price
=Last("NVDA") Alias for last price
=PreviousClose("NVDA") Prior session close
=Name("NVDA") Issuer name from ticker
=Sector("NVDA") Sector classification
=MarketCapitalization("NVDA") Market capitalization
=DividendYield("NVDA") Trailing dividend yield
=Beta("NVDA") Beta versus the broad market
=SimpleMovingAverage("NVDA","50") 50-day simple moving average
=SimpleMovingAverage("NVDA","200") 200-day simple moving average
=RelativeStrengthIndex("NVDA","14") 14-period RSI
=FiftyTwoWeekHigh("NVDA") 52-week high
=FiftyTwoWeekLow("NVDA") 52-week low
=QM_GetHistory("NVDA") Historical price series (spills to a range)
=Stream_Last("NVDA") Streaming live price tick
Each of these can be called in Excel with the MarketXLS add-in, or invoked by Claude through the MCP server. The point is not to make you type them by hand, but to show you that there is a real, named, documented function behind every figure. That is what makes the data auditable in a way a raw model answer never is.
A Snapshot: Live Quotes as Claude Would Return Them
To make this concrete, here is a static snapshot of a mega-cap technology quote board captured on 2026-07-09. In the live template, every one of these cells is a formula that refreshes on demand.
| Ticker | Last Price | Prev Close | 50 DMA | 200 DMA | RSI 14 | Beta | Div Yield |
|---|---|---|---|---|---|---|---|
| NVDA | $202.01 | $200.44 | $206.04 | $191.30 | 48.6 | 1.89 | 0.02% |
| AAPL | $314.76 | $311.90 | $305.10 | $278.40 | 57.2 | 0.87 | 0.40% |
| MSFT | $379.93 | $377.10 | $384.20 | $402.60 | 44.1 | 1.24 | 0.65% |
| GOOGL | $355.59 | $352.80 | $340.10 | $288.20 | 61.4 | 1.20 | 0.00% |
| AMZN | $243.03 | $240.90 | $236.40 | $221.70 | 55.8 | 1.47 | 0.00% |
| META | $612.56 | $608.20 | $640.30 | $690.10 | 41.9 | 1.56 | 0.32% |
These figures are illustrative and shown only to explain how the workbook is laid out. They are not a recommendation to buy or sell anything. The value of the template is that you plug in your own tickers and let the formulas do the work.
Why Pair Claude With a Spreadsheet at All?
It is a fair question. If Claude can fetch a price over MCP, why keep an Excel workbook alongside it? Three reasons.
First, persistence. A chat is a moment in time. A workbook is a durable dashboard you can open every morning and refresh in one click. You do not have to reconstruct your watchlist prompt each day.
Second, auditability. When a number lives in a cell as =QM_Last("NVDA"), anyone can click the cell and see exactly where it came from and how to refresh it. A figure buried in a paragraph of AI text does not offer that.
Third, composition. Once prices are in cells, you can build on them with ordinary Excel: percent changes, custom moving averages, CORREL between two return series, position sizing, and simple alert logic. Claude is a superb partner for describing what to build, and the spreadsheet is where the build lives.
The healthiest workflow uses both. Ask Claude to explain a metric or draft a framework, let MCP pull the live numbers into the conversation, and keep the durable version in the workbook so nothing is lost when the chat scrolls away.
Inside the Template: Six Sheets, Every Price a Formula
The download includes two files. The static sample is pre-filled with the 2026-07-09 snapshot so you can see the structure immediately. The live template uses MarketXLS formulas throughout, so it refreshes on demand. Both files carry a "MarketXLS Functions Used" box on every sheet so you always know which formula powers which column.
Sheet 1 - How To Use. The workflow, a set of ready-to-paste Claude prompts, the MCP endpoint, and the MarketXLS links. Start here.
Sheet 2 - Live Price Dashboard. The core quote board. Type a ticker in the yellow cell and the row fills with last price via =QM_Last, previous close via =PreviousClose, day change, 50-day and 200-day moving averages via =SimpleMovingAverage, RSI via =RelativeStrengthIndex, beta via =Beta, dividend yield via =DividendYield, the 52-week high via =FiftyTwoWeekHigh, and market cap via =MarketCapitalization.
Sheet 3 - Watchlist Quotes. A cross-section of income and quality names, each pulling last price, yield, P/E via =PERatio, beta, and sector via =Sector. Swap in your own tickers to build a personal watchlist.
Sheet 4 - Historical Prices. A place for the =QM_GetHistory spill, plus a monthly closes table with change, percent change, and a short moving-average reference. This is the raw material for your own charts.
Sheet 5 - Price Alerts. Yellow buy-below and sell-above threshold cells with simple IF trigger logic, and a =Stream_Last column for tick-level updates. The logic is purely educational and is not a signal to trade.
Sheet 6 - Comparison Matrix. A single view of last price, trend versus the moving averages, RSI, beta, yield, and market cap across the whole board, with a row of averages at the bottom.
The input cells are highlighted in yellow so you always know where you can type. Everything else is a formula that flows from those inputs.
Download the templates:
- - Pre-filled with the 2026-07-09 snapshot so you can see the layout
- - Live-updating formulas that refresh on any ticker
A Realistic Workflow for Daily Use
Here is how the two tools fit together on a normal morning.
You open Claude and ask it to summarize what moved in your sectors overnight and to flag any names near their 52-week highs or lows. Claude uses the MarketXLS MCP tools to pull the relevant prices and reference levels, then writes you a short brief. You read it, decide which two or three tickers deserve a closer look, and drop them into the yellow cells of the Live Price Dashboard. The workbook fills in the full picture: price relative to both moving averages, RSI, beta, and yield. If a name is sitting well below your buy-below threshold on the Price Alerts sheet, the trigger cell flags it.
Nothing in that loop asks you to trust an unsourced number. Claude's narrative is grounded in live MarketXLS data, and your workbook holds a durable, refreshable copy. When someone asks where a figure came from, you can point at the exact formula.
Frequently Asked Questions
How do I get stock prices in Claude in real time?
Connect Claude to the MarketXLS MCP server at https://connect.mcp.marketxls.com/mcp and authorize it against your MarketXLS account. Then ask in plain language, for example "what is the current price of NVDA." Claude calls the MarketXLS tools and returns the live figure. Keeping the companion Excel template open gives you a refreshable copy of the same quote.
Can Claude fetch prices without any add-on?
Not reliably. A language model on its own answers from its training data, so any price it gives you may be stale. To get a genuine real-time quote you need to connect Claude to a live data feed, which is exactly what the MCP connection provides.
Which MarketXLS formula returns the last traded price?
=QM_Last("NVDA") returns the real-time last price for a ticker, and =Last("NVDA") is an alias for the same value. For the prior session close, use =PreviousClose("NVDA"). These are the same functions Claude calls behind the scenes when it fetches a quote over MCP.
Does the template work with any ticker?
Yes. The live template is built around input cells, so you type any supported ticker into the yellow cell and every formula in that row recalculates. You are not limited to the mega-cap names shown in the static sample.
Can I pull historical prices, not just the latest quote?
Yes. =QM_GetHistory("NVDA") returns a historical price series that spills into a range in Excel, which you can use for charts, custom moving averages, or correlation work. Claude can also request historical data through the same MCP tools.
Is this a substitute for investment advice?
No. The workbook and the formulas are educational tools for organizing market data. Nothing here is a recommendation to buy or sell any security. Always do your own research or consult a licensed professional before making an investment decision.
The Bottom Line
Getting stock prices in Claude comes down to one idea: let the model do the reasoning and let a licensed data feed do the quoting. Connect the MarketXLS MCP server and Claude can look up a live price, build a quote board, or pull a price history without guessing. Pair that with the Excel template in this post and you get a durable, auditable copy of every number, where each quote is a MarketXLS formula you can refresh on any ticker.
Download both files above, connect the MCP server, and you have a workflow that keeps the clarity of Claude's writing and the reliability of live, source-linked market data. To see everything MarketXLS can do inside Excel and Claude, visit MarketXLS or book a demo.
