Custom Stock Tracker In Google Sheets
📈 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/
In this video, I will walk you through how to make a custom stock analysis tool in Google Sheets. This tool can be completely customizable to your preferences! This stock tracker or analyzer or whatever you want to call it will save you so much time and help you pick the stocks you want to trade with your custom criteria!
To make this possible we need to pull real-time stock data. We will pull that data from google finance and finviz.com. Below you will find all the codes I used in this tutorial. Don't worry, I also go over how the code works in the video as well so it won't just be a copy and paste tutorial.
The cool part comes later on in the video where we will dabble in some simple coding with IF and IFS statements to make the actual "Trade Signal" part work. So make sure to stick around for the entire video!
I'm giving you all this great information for free so all I ask is that you SMASH that like button and subscribe!!!
***Finviz code update*** In the video my I'm pulling from table 9, but now it is from Table 8.
- The codes below have been updated so you shouldn't have a problem
- for company name you need to pull from Google Finance now.
- The code for the company name is also updated below!
🔸Price: =GOOGLEFINANCE(B2,"price")
🔸Company Name: =GOOGLEFINANCE(B2,"Name")
🔸Marketcap: =GOOGLEFINANCE(B2,"marketcap")
🔸Earnings: =(substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&B2,"table", 8),11,6),"*",""))
🔸PE =(substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&B2,"table", 8),1,4),"*","")*1)
🔸Current Ratio: =(substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&B2,"table", 8),9,4),"*",""))*1
🔸RSI: =(substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&B2,"table", 8),9,10),"*",""))*1
🔸Debt to Equity: =(substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&B2,"table", 8),10,4),"*",""))*1
🔸Price to Book: =(substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&B2,"table", 8),5,4),"*",""))*1
🔸Trade Signal: =IFs(C12=5,"Strong Buy",C12=4,"Buy",C12=3,"Hold",C12=2,"Hold",C12=1,"Sell",C12=0,"Strong Sell")
Disclaimer: This is not financial advice. I am not a financial advisor. This video is meant for education and entertainment. Do not use this video as investing advice and consult with a professional advisor before buying or selling securities.
Video Chapters:
0:00 Introduction
1:20 Building The Tracker
3:50 Google Finance Codes
5:33 Finviz Codes
13:37 Building The Trade Signal
19:57 Conditional Formating
25:25 Data Validation
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.
#googlsheets #stockanalysistool #stocktracker #tradesignalgooglesheets #codingingooglesheets #realtimedata