Google Finace取得歷史資料

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.