Getting Stock Price using GoogleFinance formula in Google Sheet

Hello friends japanesising, on this occasion the admin wants to share an article entitled Getting Stock Price using GoogleFinance formula in Google Sheet, we have made good, quality and useful articles for you to read and take information in. hopefully the post content is about which we write you can understand. Alright, happy reading.
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:

That's the article: Getting Stock Price using GoogleFinance formula in Google Sheet

Thank you for visiting my blog, hopefully it can be useful for all of you. Don't forget to share this article with your friends so they also know the interesting info, see you in other article posts.

You are now reading the article Getting Stock Price using GoogleFinance formula in Google Sheet with link address https://japanesising.blogspot.com/2019/11/getting-stock-price-using-googlefinance.html