# Real-Time Stock Prices in Google Sheets

> The GOOGLEFINANCE formula gives 15-min delayed stock prices. Get real-time stock prices into Google Sheets using the STOCKDATA formula.

Source: https://www.marketdata.app/sheets/stocks/how-to-get-real-time-stock-prices/

---

(image: Rows of five-decimal quotes such as 1.20506 and 1.18189 glowing green and blue on a dark screen.)

-   Stock Data
-   [Stocks in Google Sheets](/topics/sheets/stocks/)
-   [Tutorials](/tutorials/)

# How To Get Real-Time Stock Prices in Google Sheets

The GOOGLEFINANCE formula gives 15-min delayed stock prices. Get real-time stock prices into Google Sheets using the STOCKDATA formula.

-   Last updated March 3, 2024

Anyone who uses Google Sheets to track stocks has used the **GOOGLEFINANCE** formula to get 15-minute delayed stock prices. Even though **Google doesn’t offer real-time stock prices** through the **GOOGLEFINANCE** formula, **it is possible to get real-time prices using the STOCKDATA formula** by using Market Data’s [Google Sheets Add-On](/sheets/). Unlike an outdated midpoint stock price, the **STOCKDATA** formula will provide you with a real-time price in a single cell or a full level 1 quote with bid and ask prices along with volume, bid size, ask size, last trade, etc.

## Watch How Easy It Is To Get Real-Time Stock Quotes In Your Google Sheet

[How To Get Real-Time Stock Quotes In Your Google Sheet](https://youtube.com/watch?v=ut8tCP1jVrc)

## Real-Time Level 1 Stock Quote Table For Google Sheets

(image: A Google Sheet titled Market Data - Stock Series - Real Time Prices, filled by =STOCKDATA(A3,"all,noheaders"): thirty Dow tickers with company name, timestamp, bid, bid size, mid, ask, ask size, last and volume)One popular option to better organize your spreadsheet is to build a **real-time level 1 quote table** for all the stocks you need prices from. In a single sheet inside your Google Spreadsheet you can put all your real-time prices and then you can **then use cell references from this sheet** to populate your other formulas with bid/ask data as needed.

You can use the **noheaders** option when you want to group multiple quotes in a single table, usually using cell references. This allows you to put all your option symbols in a single column and the **STOCKDATA** formula will generate detailed level 1 quotes next to them. Add the first row normally with headers and then on each each subsequent row use the **noheaders** option to make a table populated with level 1 quotes.

This is especially useful for users who are using Market Data’s Free Forever Plan. Since you only get 100 prices per day, **you can build a real-time quote table and then use a VLOOKUP formula** to lookup the price in this table and populate other cells in the same spreadsheet with quotes from this table, rather than making multiple API calls to Market Data’s servers.

## Real-Time Stock Prices Formula Guide

Use this quick guide to copy and paste these examples into your own Google Sheet to quickly begin building your formulas.

-   Real-Time Midpoint Stock Quote
    -   `=STOCKDATA("AAPL")`
-   Real-Time Full Level 1 Stock Quote
    -   `=STOCKDATA("AAPL","all")`
-   Real-Time Full Level 1 Stock Quote With No Header Rows
    -   `=STOCKDATA("AAPL","all,noheaders")`