Images are reused AI-generated editorial illustrations, not documentary photographs or verified product screenshots.
GOOGLEFINANCE in Sheets retrieves supported current or historical securities information, but coverage, timing and permitted use have limits. Treat it as a documented data source, not a guaranteed trading feed or investment recommendation. Check the actual symbol, attribute and restrictions before building a workbook around returned values.
Identify the security and attribute precisely
Use the documented ticker format, including an exchange where appropriate, and the attribute that answers the question. Similar symbols can represent different instruments. Not every attribute is available for every security or date range. Review the source definition rather than assuming a displayed number is the measure your report requires.
Respect delays and usage restrictions
Google documents that price quotes can be delayed by up to 20 minutes and describes limitations on professional use. Review the current terms for the intended use. Do not promise real-time execution decisions or imply that a spreadsheet calculation removes licensing obligations. Availability in a cell is not permission for every downstream application.
Test historical shape and missing values
Current attributes and historical requests can return different result shapes. Allow space and inspect headers, dates and supported values. Verify important information with a source suitable for the actual decision. Handle unavailable results visibly; replacing an error with zero can turn missing market data into a misleading price or return calculation.
A practical checklist
- Identify exchange, symbol and attribute.
- Review supported coverage and date behavior.
- Check data delays and permitted use.
- Inspect returned headers and missing values.
- Use an appropriate source for consequential decisions.
Worked example
Illustrative example: a learning workbook requests a supported historical price series and checks its date and price columns. An unavailable symbol is labeled unavailable rather than assigned a zero. The workbook is used to understand data handling, not to recommend a security or claim that all returned prices can support professional trading work.
Common questions
Is the function a guaranteed real-time feed? No. Does every security support every attribute? No. Should an unavailable price become zero? No; keep missing data distinct from a valid value.
What to do next
Document the source and intended use alongside the formula. Market-data limitations should remain visible even when the workbook’s calculations are mathematically correct.