Getting a stock price in Google Sheets is one of the most common tasks for investors, analysts, and portfolio managers who work in spreadsheets. Google Sheets has a built-in function called GOOGLEFINANCE that can pull basic stock prices. But anyone who has used it for more than a few weeks knows the frustrations: delayed data, missing attributes, random errors, and no way to get options data or detailed fundamentals.
In this guide, you will learn every way to get stock prices in Google Sheets, the limitations you will run into with GOOGLEFINANCE, and how to get real-time stock data in Google Sheets using MarketXLS with over 1,000 financial functions.
How to Get Stock Price in Google Sheets with GOOGLEFINANCE
The simplest way to get a stock price in Google Sheets is the built-in GOOGLEFINANCE function:
=GOOGLEFINANCE("AAPL")
This returns the current price for Apple stock. You can also specify the attribute:
=GOOGLEFINANCE("AAPL", "price")
=GOOGLEFINANCE("AAPL", "priceopen")
=GOOGLEFINANCE("AAPL", "high")
=GOOGLEFINANCE("AAPL", "low")
=GOOGLEFINANCE("AAPL", "volume")
=GOOGLEFINANCE("AAPL", "marketcap")
=GOOGLEFINANCE("AAPL", "pe")
=GOOGLEFINANCE("AAPL", "eps")
=GOOGLEFINANCE("AAPL", "high52")
=GOOGLEFINANCE("AAPL", "low52")
For historical stock prices in Google Sheets, you can add date parameters:
=GOOGLEFINANCE("AAPL", "close", DATE(2025,1,1), DATE(2025,12,31), "DAILY")
This returns a table of daily closing prices for Apple in 2025.
Why GOOGLEFINANCE Falls Short for Stock Prices in Google Sheets
GOOGLEFINANCE works fine for checking a single stock price. But the moment you try to build something more serious in Google Sheets, you run into real problems.
1. Stock Price Data is Delayed 20+ Minutes
The stock prices from GOOGLEFINANCE are not real-time. They are delayed by approximately 15 to 20 minutes during market hours. You cannot change this. There is no setting to enable real-time stock prices in Google Sheets using GOOGLEFINANCE. For anyone making trading decisions or monitoring a portfolio during the trading day, this delay makes the data unreliable.
2. Only About 18 Attributes Available
GOOGLEFINANCE gives you roughly 18 data attributes for stocks: price, open, high, low, volume, market cap, PE, EPS, 52-week high/low, change, change percent, previous close, shares outstanding, currency, trade time, data delay, and average volume. That is the entire list. There are no financial statements, no cash flow data, no dividend details, no technical indicators, and no options data.
3. Frequent Errors and Missing Data
If you have used GOOGLEFINANCE in a Google Sheets spreadsheet with more than a few dozen formulas, you have almost certainly seen #N/A errors. The function breaks regularly, returns stale data, and sometimes just stops working for certain tickers. There is no official SLA or support from Google for this function.
4. No Options Data in Google Sheets
GOOGLEFINANCE has zero support for options data. You cannot get option chains, strike prices, expiration dates, implied volatility, or Greeks using GOOGLEFINANCE. If you trade options and want to track them in Google Sheets, GOOGLEFINANCE cannot help you at all.
5. No Financial Statements
You cannot pull revenue, net income, balance sheet data, or cash flow statements using GOOGLEFINANCE. The function gives you PE ratio and EPS, but nothing deeper. For fundamental analysis in Google Sheets, you need a different tool.
6. No Technical Indicators
Building technical indicators like RSI, MACD, or moving averages from GOOGLEFINANCE data requires complex manual formulas. There is no built-in way to get =RSI("AAPL") or =SimpleMovingAverage("AAPL", 50) from GOOGLEFINANCE. You would have to pull historical prices and build the indicator calculations yourself, which is tedious and error-prone.
7. Cannot Control Refresh Timing
GOOGLEFINANCE refreshes on its own schedule. You cannot force a refresh or control when stock prices update in your Google Sheets spreadsheet. Sometimes the data updates every few minutes, sometimes it takes much longer.
How to Get Real-Time Stock Prices in Google Sheets with MarketXLS
MarketXLS is a Google Sheets add-on that gives you over 1,000 financial functions for stock data, options, fundamentals, technical indicators, and more. You install it directly from the Google Workspace Marketplace and use simple formulas just like GOOGLEFINANCE, but with far more data and reliability.
Get Real-Time Stock Prices
To get a real-time stock price in Google Sheets with MarketXLS:
=Last("AAPL")
That is it. One formula, current stock price. No 20-minute delay.
For real-time data powered by QuoteMedia, you can also use:
=QM_Last("AAPL")
The QM_Last function pulls the latest traded price directly from QuoteMedia's real-time data feed. This is the same data feed used by professional trading platforms.
More Stock Price Functions
MarketXLS gives you every price data point you could need in Google Sheets:
=Last("AAPL") // Last traded price
=Bid("AAPL") // Current bid price
=Ask("AAPL") // Current ask price
=Volume("AAPL") // Trading volume
=DaysHigh("AAPL") // Today's high
=DaysLow("AAPL") // Today's low
=PreviousClose("AAPL") // Yesterday's close
=OpenPrice("AAPL") // Today's open
=ChangeinPercent("AAPL") // % change from close
=DaysRange("AAPL") // Today's range
=FiftyTwo_weekHigh("AAPL") // 52-week high
=FiftyTwo_weekLow("AAPL") // 52-week low
You can also get real-time quotes for multiple data points at once using QuoteMedia functions:
=QM_Last("AAPL") // Real-time last price
=QM_Bid("AAPL") // Real-time bid
=QM_Ask("AAPL") // Real-time ask
=QM_Change("AAPL") // Real-time change
=QM_ChangePercent("AAPL") // Real-time % change
=QM_ShareVolume("AAPL") // Real-time volume
=QM_MarketCap("AAPL") // Real-time market cap
Historical Stock Prices in Google Sheets
For historical stock price data in Google Sheets, MarketXLS provides:
=QM_GetHistory("AAPL")
This returns a full table of historical prices with open, high, low, close, and volume. You can also get specific historical prices:
=Close_Historical("AAPL", "2024-01-15")
=Open_Historical("AAPL", "2024-01-15")
=High_Historical("AAPL", "2024-01-15")
=Low_Historical("AAPL", "2024-01-15")
Build a Stock Price Tracker in Google Sheets
Here is how to build a simple stock price tracker in Google Sheets using MarketXLS:
Column A: Stock symbols (AAPL, MSFT, GOOGL, AMZN, TSLA)
Column B: =Last(A2) for current price
Column C: =ChangeinPercent(A2) for daily change
Column D: =Volume(A2) for trading volume
Column E: =PERatio(A2) for P/E ratio
Column F: =DividendYield(A2) for dividend yield
Column G: =FiftyTwo_weekHigh(A2) for 52-week high
Column H: =FiftyTwo_weekLow(A2) for 52-week low
Copy these formulas down for each stock in your list. You now have a professional stock tracker in Google Sheets with real-time data, key ratios, and dividend yields. This is something you cannot build with GOOGLEFINANCE alone because it does not provide dividend yield or reliable real-time prices.
Go Beyond Stock Prices in Google Sheets
Once you have MarketXLS installed in Google Sheets, you can do much more than just track stock prices.
Fundamental Analysis in Google Sheets
Pull complete financial statements into Google Sheets:
=hf_revenue("AAPL", 2024) // Annual revenue
=hf_net_income("AAPL", 2024) // Net income
=hf_gross_profit("AAPL", 2024) // Gross profit
=hf_ebit("AAPL", 2024) // EBIT
=hf_total_assets("AAPL", 2024) // Total assets
=hf_total_debt("AAPL", 2024) // Total debt
=hf_free_cash_flow("AAPL", 2024) // Free cash flow
=hf_cash_and_equivalents("AAPL", 2024) // Cash on hand
MarketXLS has 337 fundamental data functions covering income statements, balance sheets, and cash flow statements going back 10+ years. GOOGLEFINANCE has none of this.
Technical Indicators in Google Sheets
Calculate technical indicators with simple formulas:
=RSI("AAPL") // Relative Strength Index
=SimpleMovingAverage("AAPL", 50) // 50-day SMA
=ExponentialMovingAverage("AAPL", 12) // 12-day EMA
=MACD("AAPL") // MACD
=BollingerBand("AAPL", 20) // Bollinger Bands
=AverageTrueRange("AAPL") // ATR
=VWAP("AAPL") // VWAP
=Stochastic("AAPL") // Stochastic Oscillator
No more building complex array formulas from raw historical data. Each indicator is a single function call.
Options Data in Google Sheets
Get full options chain data in Google Sheets:
=QM_GetOptionChain("AAPL")
This returns the complete options chain with bid, ask, volume, open interest, implied volatility, and Greeks for every strike and expiration. MarketXLS is one of the only Google Sheets add-ons that provides live options data. GOOGLEFINANCE has zero options support.
Dividend Data in Google Sheets
Track dividends for any stock in Google Sheets:
=DividendYield("AAPL")
=DividendPerShare("AAPL")
=Ex_DividendDate("AAPL")
=PayoutRatio("AAPL")
Stock Screening in Google Sheets
MarketXLS includes built-in stock screening functions that let you filter stocks by dividend yield, value metrics, growth rates, and momentum. You can screen thousands of stocks directly from Google Sheets without leaving your spreadsheet.
GOOGLEFINANCE vs MarketXLS for Stock Prices in Google Sheets
| Feature | GOOGLEFINANCE | MarketXLS |
|---|---|---|
| Stock price | 20-min delay | Real-time via =Last() and =QM_Last() |
| Bid/Ask | Not available | =Bid(), =Ask(), =QM_Bid(), =QM_Ask() |
| Historical prices | Basic daily/weekly | Full OHLCV via =QM_GetHistory() |
| Intraday data | Not available | 1-min and 5-min bars via QuoteMedia |
| Financial statements | None | 337 fundamental functions (hf_*) |
| Technical indicators | None | RSI, SMA, EMA, MACD, Bollinger, ATR, VWAP |
| Options data | None | Full chains via =QM_GetOptionChain() |
| Dividend data | None | Yield, per share, ex-date, payout ratio |
| Portfolio analytics | None | Sharpe ratio, Sortino ratio, beta, VaR |
| Stock screener | None | Built-in screening functions |
| Total functions | 1 function, ~18 attributes | 1,000+ dedicated functions |
| Reliability | Frequent errors | Professional data feeds |
| Platform | Google Sheets only | Google Sheets and Excel |
How to Get Started
Getting stock prices in Google Sheets with MarketXLS takes less than 5 minutes:
- Install the add-on from the Google Workspace Marketplace
- Get your license from the MarketXLS pricing page
- Enter your license key in the MarketXLS sidebar inside Google Sheets
- Type your first formula:
=Last("AAPL")in any cell
That is all you need. You now have access to over 1,000 financial functions in Google Sheets.
Who Needs Better Stock Prices in Google Sheets
- Active traders who need real-time stock prices, not 20-minute delayed quotes from GOOGLEFINANCE
- Financial advisors who build client-facing dashboards in Google Sheets and need reliable, professional data
- Options traders who need options chains, Greeks, and implied volatility in Google Sheets
- Dividend investors who want to track yield, ex-dates, and payout ratios in their Google Sheets portfolio tracker
- Portfolio managers who need risk analytics like Sharpe ratio, beta, and Value at Risk
- Mac and Chromebook users who cannot install Windows-only Excel add-ins and need a full-featured stock data solution in Google Sheets
Frequently Asked Questions
How do I get a stock price in Google Sheets?
The simplest way is =GOOGLEFINANCE("AAPL") for a free but delayed price. For real-time stock prices in Google Sheets, install MarketXLS and use =Last("AAPL") or =QM_Last("AAPL").
Can I get real-time stock prices in Google Sheets?
Not with GOOGLEFINANCE. GOOGLEFINANCE data is delayed by 15 to 20 minutes. MarketXLS provides real-time stock prices in Google Sheets through functions like =Last("AAPL") and =QM_Last("AAPL") powered by professional data feeds.
How do I get stock prices in Google Sheets without GOOGLEFINANCE?
Install the MarketXLS add-on from the Google Workspace Marketplace. MarketXLS provides over 1,000 financial functions including =Last("AAPL") for stock prices, =hf_revenue("AAPL", 2024) for fundamentals, =RSI("AAPL") for technical indicators, and =QM_GetOptionChain("AAPL") for options data.
Why does GOOGLEFINANCE show wrong stock prices?
GOOGLEFINANCE data is delayed by approximately 20 minutes during market hours. The price you see is not the current market price. Additionally, GOOGLEFINANCE can return stale data, #N/A errors, or stop updating entirely. These issues are well-documented and there is no fix within Google Sheets itself.
Can I get options data in Google Sheets?
Not with GOOGLEFINANCE. GOOGLEFINANCE has zero options support. MarketXLS is one of the only Google Sheets add-ons that provides full options chain data with =QM_GetOptionChain("AAPL"), including bid, ask, volume, open interest, Greeks, and implied volatility.
Does MarketXLS work on Mac?
Yes. MarketXLS for Google Sheets works on any device that runs Google Sheets, including Mac, Windows, Chromebook, and Linux. There is no software to install on your computer.
How much does MarketXLS for Google Sheets cost?
MarketXLS for Google Sheets is included with your MarketXLS subscription at no extra cost. The same plan works for both Google Sheets and Excel. Visit the pricing page for current plans.
Summary
Getting stock prices in Google Sheets starts with GOOGLEFINANCE, but it ends there too. The 20-minute delay, missing data attributes, frequent errors, and lack of options or fundamental data make GOOGLEFINANCE insufficient for serious analysis.
MarketXLS for Google Sheets solves every one of these limitations. With over 1,000 functions, real-time stock prices via =Last() and =QM_Last(), complete financial statements via hf_* functions, full options chains via =QM_GetOptionChain(), and technical indicators like =RSI() and =SimpleMovingAverage(), you can turn Google Sheets into a professional financial workstation.
Get started with MarketXLS for Google Sheets | View Pricing | Install from Google Workspace
