Access Tickerdata and my Spreadsheets: https://tickerdata.com/
In this video, I am going to show you the power and scalability of the google financial function within google sheets. Google financial provides you with the ability to create amazing financial spreadsheets full of meaningful data that can be used to drive funding decisions. This will be a quick tutorial on some of the different functions and metrics that can be pulled using the google financial formula in google sheets. If you want to take your google sheets skills a step further, then you should check out these videos below:
Get 50% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/
How to create a Stock Watchlist in Google Sheets: https://www.youtube.com/watch?v=AzOh4aEidLM
How to create a Stock collection of investments Tracker in Google Sheets:
https://www.youtube.com/watch?v=Mw52fJHL7lU&t=60s
How to create a Dividend revenue Tracker in Google Sheets:
https://www.youtube.com/watch?v=wFVz1bgczwE&t=413s
How to create a Crypto Tracker in Google Sheets:
https://www.youtube.com/watch?v=6sCpfmkgNsI
How to create a collection of investments dashboard in Google Sheets: https://youtu.be/YOOJxPKp3g8
Formula to create a one year price chart:
=sparkline(GOOGLEFINANCE(A3,”price”,today()-364,today()))
Formula for price change as a percentage:
=GOOGLEFINANCE(A3,”changepct”)/100
If you are having trouble with the formula or have any questions, then be sure to leave a comment and I’ll get back to you as quick as I can.
The microphone I use: https://amzn.to/3ngqbVz
#GoogleFinance #StockData #GoogleSheets
Disclaimer:
If you own the YouTube channel related to this video and do not want it to be featured here, you can contact us through our contact page. We will gladly remove it without questioning your reasons.