Download my Spreadsheets: [ Ссылка ]
Get 50% off of Seeking Alpha Premium!
[ Ссылка ]
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("[ Ссылка ]),7,2),"*",""))
Industry:
=if(I2="","",IFERROR(substitute(Index(IMPORTHTML("[ Ссылка ]),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: [ Ссылка ]
Join my Discord! [ Ссылка ]
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.
