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.
@@DougHExcel Google Sheets is big and complex like Excel. Your expertise in finance can be an asset in creating finance videos that use Google Sheets. Most investment classes use Excel, but many students prefer Google Sheets because of its mobility where they can share collaborate on assignments. With Chrome computers being popular in schools, it makes sense to use Sheets over Excel.
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.
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 =googlefinance(concatenate("IDX:";"TLKM");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY") The result is different with this function : =googlefinance(concatenate("NYSE:";"UNVR");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")
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.-
Sparkline feature is amazing! I used it for NSE Stocks in India and its working. Thank you, Doug!
You're welcome!
Thank you soooo much I have spent days trying to figure out how to get prices from different exchanges into sheets.
You’re welcome!!
first time learning about sparkline function. Thank you.
You’re welcome!
thanks for the upload!
Hi CaioComC, you're welcome!
Thanks Doug. Interesting functions from Google Sheets. Thanks for sharing :)) Thumbs up!!
My pleasure!
Thank you for this video, Doug. Now that you have established some of the basics, I can try my hand it :)
You’re welcome!
Sir, if we nee intraday chart for 5 minutes then what would be the sparline formulae ?
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.
Glad you like them! I do have a few google sheets vids see playlist
th-cam.com/video/1icIPh2O6Bw/w-d-xo.html
@@DougHExcel Google Sheets is big and complex like Excel. Your expertise in finance can be an asset in creating finance videos that use Google Sheets. Most investment classes use Excel, but many students prefer Google Sheets because of its mobility where they can share collaborate on assignments. With Chrome computers being popular in schools, it makes sense to use Sheets over Excel.
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.
Hi TV V, thanks for the comment! I do have other Goog sheets vid here
th-cam.com/video/1icIPh2O6Bw/w-d-xo.html
Ive seen the google finance function being used for fx price also
Hi David Shamiri, thanks for the comment and adding more info to the thread!
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
=googlefinance(concatenate("IDX:";"TLKM");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")
The result is different with this function :
=googlefinance(concatenate("NYSE:";"UNVR");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")
Great video thank you
Thanks for the comment
Thank you
You're welcome
dear brother, You use formula with any company but i want to know that there is any formula for track stock index , indices
Have you tried using the carat sign? (i.e., ^DJI)
@@DougHExcel Sorry I am not understand
my bad...carat won't work try a period like this ➡ =googlefinance(".DJI")
@@DougHExcel Thanks Brother
My Google Finance portfolio sheets all-
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.-