Quick answer: Google Sheets added two stock-chart types on October 5, 2026: High-Low-Close (HLC) and Open-High-Low-Close (OHLC). To try them, place dates and price fields in labeled columns, select the range, choose Insert → Chart, then pick the matching stock chart in the Chart editor. Rapid Release rollout began October 5; Scheduled Release rollout begins October 22, so the option may take up to 15 days to appear. [1]
Copy-paste setup: build an OHLC chart with GOOGLEFINANCE
Open a blank Google Sheet and paste this formula into cell A1:
=CHOOSECOLS(GOOGLEFINANCE("NASDAQ:GOOG","all",TODAY()-90,TODAY(),"DAILY"),1,2,3,4,5)This produces a chart-ready table containing Date, Open, High, Low and Close while leaving out Volume. Replace NASDAQ:GOOG with the exchange and ticker you need. Google recommends including both parts—for example, NASDAQ:GOOG rather than only GOOG—to reduce ambiguity. [2]
- Wait for the historical rows to load.
- Select the full table, including the header row.
- Choose Insert → Chart.
- In Setup → Chart type, choose the Open-High-Low-Close stock chart.
- Confirm the date field is the horizontal axis and the four price fields map to Open, High, Low and Close.
- Open Customize to set the title, axis labels, colors and gridlines.
If the new chart type is not listed yet, jump to the rollout checks below instead of rebuilding the sheet.
Copy-paste HLC formula
For the simpler High-Low-Close chart, paste:
=CHOOSECOLS(GOOGLEFINANCE("NASDAQ:GOOG","all",TODAY()-90,TODAY(),"DAILY"),1,3,4,5)The selected columns are Date, High, Low and Close. After the data loads, select the table and choose the HLC stock-chart type. Google describes HLC as the period’s high-to-low trading range plus its closing point; OHLC adds the opening price so a single marker can show whether that period finished up or down. [1]
HLC vs OHLC: which should you use?
| Chart | Required price fields | Best for |
|---|---|---|
| HLC | High, Low, Close | A compact range-and-close view when the opening price is not important |
| OHLC | Open, High, Low, Close | Seeing the full period range and whether the close finished above or below the open |
Use OHLC for the more complete session view. Use HLC when you want fewer fields or your source does not provide an opening value. These charts can also work with non-market interval data if each row has the required maximum, minimum, initial and final values.
Important GOOGLEFINANCE limits
- Quotes may be delayed: Google says market quotes may be delayed by up to 20 minutes.
- Not all exchanges are supported: the function does not support most international exchanges.
- Not every field works for every symbol: some attributes may return no result.
- Historical data spills into nearby cells: keep the cells below and to the right of the formula empty.
- API limitation: Google says historical GOOGLEFINANCE data cannot be downloaded through the Sheets API or Apps Script.
- Usage restriction: Google warns that the data is informational, not trading advice, and may have professional-use licensing limits.
Those limitations come from Google’s current GOOGLEFINANCE documentation. [2]
If the new stock chart is missing
- Check the date and account: Rapid Release rollout started October 5, 2026, while Scheduled Release begins October 22.
- Allow for staged rollout: Google says visibility can take up to 15 days from the applicable start date.
- Do not search for an admin switch: Google says there is no admin control for the feature.
- Try a personal account: the feature is available to personal Google accounts as well as all Google Workspace customers.
- Refresh the chart editor: reload the spreadsheet, select the range again and reopen Insert → Chart.
The account availability and rollout dates above are from Google’s launch notice. [1]
Fallback: use the existing candlestick chart
If your account has not received HLC or OHLC yet, Sheets’ existing candlestick chart can display a similar range view. Its documented input order is label, high, open, close, low. Google’s help page explains that each row becomes one marker and provides editable chart examples. [4]
Use this formula to put GOOGLEFINANCE output into that documented candlestick order:
=CHOOSECOLS(GOOGLEFINANCE("NASDAQ:GOOG","all",TODAY()-90,TODAY(),"DAILY"),1,3,2,5,4)Select the result, choose Insert → Chart, then select Candlestick chart. Google’s general chart workflow uses a selected cell range as the chart’s data range, and customization options vary by chart type. [3]
Five-minute quality checklist
- Use
EXCHANGE:TICKER, not an ambiguous ticker alone. - Keep one date/period per row.
- Make sure High is not below Low.
- Remove blank or error rows before charting.
- Verify the date range and daily/weekly interval.
- Label the chart and vertical axis clearly.
- State that market data may be delayed.
- Do not treat the chart as investment advice.
Frequently asked questions
Does Google Sheets now support OHLC stock charts?
Yes. Google announced new High-Low-Close and Open-High-Low-Close stock-chart types on October 5, 2026. The launch is gradual, so not every account will see them immediately.
Is the stock-chart feature free?
Google says it is available to users with personal Google accounts and to all Google Workspace customers.
Why can’t I see HLC or OHLC in the Chart editor?
Your account may still be in the staged rollout. Rapid Release began October 5, Scheduled Release begins October 22, and either rollout can take up to 15 days.
Can GOOGLEFINANCE create the source table automatically?
Yes. The historical "all" attribute returns open, close, high, low and volume data. The formulas above select and reorder those fields for the relevant chart.
Are Google Finance prices real time?
Not necessarily. Google says quotes may be delayed by up to 20 minutes and are provided for informational purposes, not for trading.
Sources
- Google Workspace Updates — Use stock charts in Sheets to better visualize price movements
- Google Docs Editors Help — GOOGLEFINANCE
- Google Docs Editors Help — Add and edit a chart or graph
- Google Docs Editors Help — Candlestick charts
Last checked: October 6, 2026. Feature availability can vary during rollout. This guide is for spreadsheet organization and education, not investment advice.