# Stocks in Google Sheets: Quotes & Earnings

> 6 articles on Stocks in Google Sheets, part of Sheets. Tutorials, explainers and worked examples from Market Data for traders and developers.

Source: https://www.marketdata.app/topics/sheets/stocks/

---

# Stocks in Google Sheets

The Stocks in Google Sheets subcategory focuses on tutorials and guides for utilizing stock-related formulas within our Google Sheets add-on, such as STOCKDATA, EARNINGS, and more. This resource is crafted to empower users with the knowledge to effectively pull and analyze stock market data directly in their spreadsheets, enhancing their investment research and decision-making processes. From setting up real-time stock quotes to conducting earnings analysis and portfolio tracking, this subcategory provides step-by-step instructions and practical examples to maximize the utility of our Google Sheets integration for stock market enthusiasts, investors, and financial analysts.

Filter:

API[Google Sheets](?tag=sheets)[Show All](?tag=)

No articles on this page match that filter.

[

(image: Rows of green and magenta prices beside six-figure volumes on an angled market quote board.)

How To Bulk Download Stock Data in Google Sheets

Learn how to perform bulk stock data downloads using Market Data's Google Sheets Add-on.

](/sheets/stocks/bulk-download-stock-data/)[

(image: The word EARNINGS across a wireframe globe, ringed by bar charts, pie charts, line graphs and spreadsheet panels on a green background.)

How To Get An Earnings Calendar For Any Stock In Google Sheets

Add an earnings calendar to Google Sheets using Market Data's EARNINGS formula. Find what Wall Street Analysts are projecting for next quarter.

](/sheets/stocks/earnings-calendar/)[

(image: A pencil on a blue-tinted calendar page, crossed by a red band lettered MARKET HOLIDAYS.)

How To Get Stock Market Holidays In Your Spreadsheet

Get past, present, and future stock market holidays for the United States directly into your spreadsheet with the MARKETSTATUS formula.

](/sheets/stocks/stock-market-holidays/)[

(image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.)

Candles vs Quotes, What’s The Difference?

Candles or quotes? STOCKDATA returns both, and picking the wrong one skews your spreadsheet. Here is what each one holds and when to use it.

](/sheets/stocks/candles-vs-quotes/)[

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

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.

](/sheets/stocks/how-to-get-real-time-stock-prices/)[

(image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.)

How To Get Intraday Stock Prices in Google Sheets

Learn how to get intraday stock prices in Google Sheets (with prices down to the minute) using a simple formula that works the same way as GoogleFinance.

](/sheets/stocks/intraday-stock-prices/)