Track Stocks with GOOGLEFINANCE - Google Sheets

If you like to track your stock investments, Google Sheets has a function called GOOGLEFINANCE that helps you get delayed (~20 minute) stock price (or volume) information on numerous stocks in your portfolio. It can event track mutual funds and currency. You also have the option of getting historical information on those various stocks so you can do some anaylsis or comparisons of your portfolio. In this video I'll show you how to use the many ways of GOOGLEFINANCE to get this information and even show you how to create a small in cell chart to visualize the stock prices from 30 days or even 365 days to the current date.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[davidponraj]

Sparkline feature is amazing! I used it for NSE Stocks in India and its working. Thank you, Doug!

[Franny]

Thank you soooo much I have spent days trying to figure out how to get prices from different exchanges into sheets.

[AM-ubnh]

first time learning about sparkline function. Thank you.

[madhushreebhangle]

Sir, if we nee intraday chart for 5 minutes then what would be the sparline formulae ?

[wayneedmondson]

Thanks Doug. Interesting functions from Google Sheets. Thanks for sharing :)) Thumbs up!!

[Rahul.Quotient]

Thank you for this video, Doug. Now that you have established some of the basics, I can try my hand it :)

[al.istitsmaar]

Good Day, Sir.
May i ask you a question?
🙏

List of Stock Prices (Monthly/Daily/Weekly Closing Price) on Google Finance Indonesia, the last one is only until July 1, 2022, right?
How come today (September 18, 2022) does not appear?
Thank you




The result is different with this function :

[jasonluong]

Great video. I don't see more videos on using Google Sheets to track stocks on your channel, presumably it's an Excel channel, but your ways of explaining is easy to follow so if you can make more Google Sheets videos, it would be great. Again, how to use the power of Google and Google Sheets to research the stock market.

[jamesharris]

Ive seen the google finance function being used for fx price also

[sendnojunkmailtome]

Sparkline feature is great to have. Noticed it first time. Appreciate the explanation.
Do you plan to have videos about the various capabilities of Google Finance (and Google Sheets) also added to your website? Will be glad to get enlightened with the functionalities. Thank you.

[ShadanFamily]

dear brother, You use formula with any company but i want to know that there is any formula for track stock index, indices

[DaivoHelloworld]

My Google Finance portfolio sheets all-

[DaivoHelloworld]

revisits, SatellitesObservationsolutions, imageryTouch and hold a clip to pin it. Unpinned clips will be deleted after 1 hour.Welcome to Gboard clipboard, any text you copy will be saved here.Use the edit icon to pin, add or delete clips.Tap on a clip to paste it in the text box.-