Build Your Own Portfolio Dashboard Tracker in 20 Minutes! (Portfolio Tracker in Google Sheets)

Video Description

Download my Spreadsheets: https://tickerdata.com/ Get 50% off of Seeking Alpha Premium! https://www.sahg6dtr.com/9D5QH2/R74QP/ In this video, I take you step by step on how to build an automated portfolio dashboard tracker. Let me know if you have any questions! *Formulas Below 1 Yr Trend Line: =if(A5="","",sparkline(GOOGLEFINANCE(A5,"Price",today()-364,today()))) Here is the updated formula to pull dividends and industry: Dividends: =(SUBSTITUTE(index(importhtml("http://finviz.com/quote.ashx?t="&I2,"table",10),7,2),"*","")) Industry: =if(I2="","",IFERROR(substitute(Index(IMPORTHTML("https://finviz.com/quote.ashx?t="&I2,"Table",8),3,1),"*",""),"-")) =if(I2="","",Left(Q2, Search(" |",Q2))) *Be sure to adjust I2 to where your ticker is located Be sure to adjust these cells to refer to where your stock are listed. Follow me on Twitter: https://twitter.com/dividendology Join my Discord! https://www.patreon.com/dividendology I am not a Financial advisor or licensed professional. Nothing I say or produce on YouTube, or anywhere else, should be considered as advice. All content is for educational purposes only. I am not responsible for any financial losses or gains. Invest and trade at your own risk.