Syntax or pattern
Pull financial market data into a spreadsheet.
=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date])5 practical examples
Import a source table
Bring a table from another spreadsheet into the current file.
=IMPORTRANGE(A1, "Data!A:E")Adjust the ranges, criteria and sheet names to match your workbook.
Import and filter rows
Clean imported data before it reaches the dashboard.
=QUERY(IMPORTRANGE(A1, "Data!A:E"), "select Col1, Col2 where Col5 > 0", 1)Adjust the ranges, criteria and sheet names to match your workbook.
Import a web table
Pull a table from a public web page.
=IMPORTHTML(A1, "table", 1)Adjust the ranges, criteria and sheet names to match your workbook.
Import CSV data
Bring CSV data from a URL into a sheet.
=IMPORTDATA(A1)Adjust the ranges, criteria and sheet names to match your workbook.
Import market data
Pull a current market attribute into a model or tracker.
=GOOGLEFINANCE("NASDAQ:GOOG", "price")Adjust the ranges, criteria and sheet names to match your workbook.
Common mistakes to avoid
- Changing source sheet permissions or range names after building formulas.
- Importing entire sheets when only a few columns are needed.
- Depending on web imports that may change structure.
FAQ
What is this Google Sheets page for?
This page gives copy-ready examples for googlefinance examples so you can understand the pattern and adapt it to real spreadsheet work.
Can I copy these formulas directly?
Yes. Use the copy buttons, then adjust sheet names, ranges, criteria and column references for your own file.
Why does my formula return an error?
The most common causes are mismatched ranges, missing quotes around text criteria, blank source data, or references that do not match your sheet layout.