Getting Stock Price using GoogleFinance formula in Google Sheet

Do you know that you can actually pull all the historical stock price data using GoogleFinance formula in Google Sheet?
This is a powerful tool where you can analyze the stock price and many more info as well.

It can check for:

Stock Price
The Current Day's High Price
The Current Day's Low Price
PE Ratio
Volume
Beta
EPS
The 52-week high price
The 52-week low price

The number of outstanding shares

Refer here for the complete list: https://support.google.com/docs/answer/3093281?hl=en

Sample Usage

GOOGLEFINANCE("GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY")

GOOGLEFINANCE("GOOG","price",TODAY()-30,TODAY())

GOOGLEFINANCE(A2,A3)

Syntax

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

• ticker - The ticker symbol for the security to consider.
• Note: Reuters Instrument Codes are no longer supported. For example, ticker 123.TO or XYZ.AX would not work. Instead, use TSE:123 or ASX:XYZ.
• Recommended: Add an exchange to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG." If an exchange is not specified, GOOGLEFINANCE will use its best judgement to choose one for you.

I have created a sample here for Google Stock:

https://docs.google.com/spreadsheets/d/1uFWr9bkjLIFpISNXc12tbUfsFxfSTvi29RF3MKhPFpA/edit?usp=sharing


Let's say I want to check the stock price from 2 Jan 2018 to 16 Jan 2018, I can just use a formula:

=GOOGLEFINANCE("GOOG", "all","1/1/2018","1/16/2018","daily")

Date	Open	High	Low	Close	Volume
1/2/2018 16:00:00	1048.34	1066.94	1045.23	1065	1237564
1/3/2018 16:00:00	1064.31	1086.29	1063.21	1082.48	1430170
1/4/2018 16:00:00	1088	1093.57	1084	1086.4	1004605
1/5/2018 16:00:00	1094	1104.25	1092	1102.23	1279123
1/8/2018 16:00:00	1102.23	1111.27	1101.62	1106.94	1047603
1/9/2018 16:00:00	1109.4	1110.57	1101.23	1106.26	902541
1/10/2018 16:00:00	1097.1	1104.6	1096.11	1102.61	1042793
1/11/2018 16:00:00	1106.3	1106.53	1099.59	1105.52	978292
1/12/2018 16:00:00	1102.41	1124.29	1101.15	1122.26	1720533
1/16/2018 16:00:00	1132.51	1139.91	1117.83	1121.76	1575261

And here is a sample of Google Share Price chart that I plotted in Google Sheet from 1 Jan 2018 to 21 Nov 2019.

Check the price data from Investing.com do see similar data:




This is the chart for the past 30 days: