How To Use Google Finance Portfolios
📈 Link to download all my Portfolio Trackers: https://www.patreon.com/thinkstocks
🌎 Follow me on Twitter: https://twitter.com/KeithFrislid
🎥 Here is the camera I use for my videos: https://amzn.to/2PB865Q
🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
https://www.sahg6dtr.com/28KL61/R74QP/
DISCLAIMER: I am not a financial advisor, and this content is not financial advice. These videos are for entertainment and educational purposes only.
AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.
**** Suggestions: set the playing speed to 0.75 or 1.25 depends on your prefered speed. Pause the video and press the period key to forward one frame at a time. Please buy me a coffee if you like my video: https://www.buymeacoffee.com/stanleysuen 🙂
With GoogleFinance() and a few other functions within Google Sheets, we can build a highly intelligent and informative stock monitoring stock list that shows:
– daily price change
– daily trading volume vs average trading volume.
– price performance in 5, 10 or whatever trading days user prefer.
– calculate moving averages price value based on 5, 10 or whatever user selected number of trading days.
– create a mini price chart with user selected number of days.
– setup as auto filter to let user sort and filter stocks from the list.
– the spreadsheet is fuzzily formatted and demonstrate creative use of Number Format codes in making the sheet highly readable and easy on the eyes.
This is an advance Google Sheets demonstration that requires reader to have a foundation of Google Sheets or Excel skill.
Video Rating: / 5
