Video Description

Access Tickerdata and my Spreadsheets: https://tickerdata.com/ In this video, I show you how to build an automated stock screener in google sheets. Google sheets is a very powerful tool when it comes to building financial and investment spreadsheets. Get 50% off of Seeking Alpha Premium! https://www.sahg6dtr.com/9D5QH2/R74QP/ Formulas: *note - some formulas will be posted in comments below Finviz formula: 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 Chart: =(SPARKLINE(index(GOOGLEFINANCE(I2,"price",today()-I18,today()),,2),{"Charttype","column";"color","purple"})) 1 Yr return: =(GOOGLEFINANCE(I2,"price") / index(GOOGLEFINANCE(I2,"price", datevalue(today()-365) ) , 2,2) - 1 ) 2 Yr return: =(GOOGLEFINANCE(I2,"price") / index(GOOGLEFINANCE(I2,"price", datevalue(today()-730) ) , 2,2) - 1 ) Videos: How to get a stock's industry into google sheets: https://www.youtube.com/watch?v=192O2foouGo How to webscrape in google sheets: https://www.youtube.com/watch?v=kn1JonQIvdI&t=183s _____________________________________________________ Get one free stock when you sign up for robinhood at this link: https://join.robinhood.com/elib190 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. Some of the links in the description may be affiliate links.