GOOGLEFINANCE “Formula parse error”?
A parse error is never the market — it means Sheets can't read your formula. It's almost always a quote, a comma, or a typo. Here's every cause and its fix.
Free · no sign-up needed · real-time on every plan.
September 12, 2026 · 5 min read
| A | B | C | D | |
|---|---|---|---|---|
| 1 | SYMBOL | NAME | PRICE | Δ% |
| 2 | Apple Inc. | … | ||
| 3 | Bitcoin | … | ||
| 4 |
Those are real, live prices — no formula, no sign-up. Edit any ticker, or type one in the empty row (stocks or for crypto).
Open the full sheet →1. Smart (curly) quotes instead of straight quotes
The most common cause. If you copied a formula from a web page, doc, or chat, the quotes may be “curly” (“AAPL”) instead of straight ("AAPL"). Sheets only accepts straight quotes — retype them directly in the cell and the error clears.
2. The wrong argument separator for your locale
In many non-US locales, Google Sheets uses a semicolon as the argument separator, not a comma. So =GOOGLEFINANCE("AAPL","price") has to be =GOOGLEFINANCE("AAPL";"price"). A comma in a semicolon locale is an instant parse error. (Check File → Settings → Locale.)
3. A misspelled or unquoted attribute
The attribute must be a quoted string from GOOGLEFINANCE's fixed list — "price", "priceopen", "marketcap", and so on. price without quotes, or a typo like "prices", won't parse. (If it parses but returns #N/A, that's a different problem — see the #N/A guide.)
4. Mismatched parentheses or a stray reference
A missing closing ), an extra argument, or a reference to a cell you later deleted (which shows as #REF!) will all break parsing. Click the cell and read the formula left to right — Sheets highlights matching parentheses to help you spot the gap.
The pattern behind every one of these
Notice what they have in common: none is about stocks. They're all about getting a string of syntax exactly right— quotes, separators, spelling, brackets. That's the tax of doing market data with formulas.
The way to never see a parse error is to not write a formula. Stealth Quotes is a spreadsheet where you just type a ticker in a cell — no function, no arguments, no quotes — and the live price appears next to it. There's no syntax to get wrong.
Skip the syntax entirely — type a ticker in a cell, get a live price. No quotes, no separators, no parse errors. Free, no sign-up.
Try it free →Keep reading
Frequently asked questions
What causes a GOOGLEFINANCE formula parse error?
A small syntax slip, not a data problem: smart/curly quotes instead of straight quotes, the wrong argument separator for your locale (a comma where your Sheets expects a semicolon), a misspelled attribute, mismatched parentheses, or a missing quote around the ticker.
Why does my formula need semicolons instead of commas?
In some regional locales (many European ones), Google Sheets uses a semicolon as the argument separator instead of a comma. =GOOGLEFINANCE("AAPL","price") then has to be =GOOGLEFINANCE("AAPL";"price"). A comma in a semicolon locale throws a parse error.
What's the difference between a parse error and #N/A?
A parse error means Sheets can't even read the formula — the syntax is wrong, so it never runs. #N/A means the formula ran fine but there's no data for what you asked (bad ticker, unsupported attribute, most crypto).
How do I avoid formula errors entirely?
Don't use a formula. A no-formula tool like Stealth Quotes has no syntax to get wrong — you type a ticker in a cell and the price appears, so there's no parse error, no separator locale trap, and no attribute to misspell.
No formula, no parse error.
Type a ticker in a cell and get a real-time price — no quotes, no separators, nothing to misspell. Stocks and crypto. Free, no sign-up.