---------------------------------------------------
The GoogleFinance function now has the ability to show historical data. This provides an easy way to track the performance of any stock over a certain time period.
See instructions on how to get historical stock data.
Use this function:
Syntax: =GoogleFinance("symbol", "attribute", "start_date", "num_days|end_date", "interval") where:
"symbol" - stock symbol
"attribute" - high, low, open, close, vol, or all (quote also works, and defaults to close).
"start_date" - the date for the historical data. When only the start_date is specified, the historical data is just for that day.
Note: The remaining parameters are optional.
"num_days" | "end_date" - can be either the end date for the time period over which you want to see historical data, or the number of days from the start date. Any number less than 50 is considered to be num_days. Otherwise it is considered an end_date.
"interval" - this specifies the interval "DAILY" or "WEEKLY," or 1 and 7 can also be used. This is the granularity at which the stock data is shown at daily or weekly intervals. Please note that queries for recent dates may not have information, as historical data may not be available for a day or two.
Stock quotes and other data may be delayed up to 20 minutes. Information is provided "as is" and solely for informational purposes, not for trading purposes or advice. For more information, please read our Stock Quotes Disclaimer.
You can enter 250 GoogleFinance functions in a single spreadsheet; two functions in the same cell count as two.
---------------------------------------------------
The GoogleFinance function now has the ability to show historical data. This provides an easy way to track the performance of any stock over a certain time period.
See instructions on how to get historical stock data.
Use this function:
Syntax: =GoogleFinance("symbol", "attribute", "start_date", "num_days|end_date", "interval") where:
"symbol" - stock symbol
"attribute" - high, low, open, close, vol, or all (quote also works, and defaults to close).
"start_date" - the date for the historical data. When only the start_date is specified, the historical data is just for that day.
Note: The remaining parameters are optional.
"num_days" | "end_date" - can be either the end date for the time period over which you want to see historical data, or the number of days from the start date. Any number less than 50 is considered to be num_days. Otherwise it is considered an end_date.
"interval" - this specifies the interval "DAILY" or "WEEKLY," or 1 and 7 can also be used. This is the granularity at which the stock data is shown at daily or weekly intervals. Please note that queries for recent dates may not have information, as historical data may not be available for a day or two.
Stock quotes and other data may be delayed up to 20 minutes. Information is provided "as is" and solely for informational purposes, not for trading purposes or advice. For more information, please read our Stock Quotes Disclaimer.
You can enter 250 GoogleFinance functions in a single spreadsheet; two functions in the same cell count as two.