Скачать с ютуб Investment Tracker in Google Sheets! (Track Stocks, Crypto, ETFs, and Dividends) в хорошем качестве

Investment Tracker in Google Sheets! (Track Stocks, Crypto, ETFs, and Dividends)

Access Tickerdata and my Spreadsheets: https://tickerdata.com/ In this video, I take you step by step on how to create an interactive investment tracker in google sheets that tracks stocks, crypto, ETFs, and dividends. Get 50% off of Seeking Alpha Premium! https://www.sahg6dtr.com/9D5QH2/R74QP/ Formulas posted below: Stock trend line: =sparkline(GOOGLEFINANCE(A23,"Price",today()-364,today())) Dividend: It seems finviz has changed the way to pull dividends from their website. I have corrected the spreadsheet and it now works. Here is the updated formula: =substitute(SUBSTITUTE(index(importhtml("http://finviz.com/quote.ashx?t="&A23,"table",9),7,2),"*",""),"-","0.00") Industry: =if(isblank(A23),"",index(importxml("https://eresearch.fidelity.com/eresea..."&A23&"","//div[@class='sub-heading']//span[@class='right']"),1)) Crypto current price: =if(isblank(A20),iferror(0/0),value(index(importhtml(concat("https://coinmarketcap.com/currencies/",A20),"table",1),1,2))) Note - the cryptos have to be all lowercase to work. Note - These formulas are based off of where my prior data is located. You may have to change what cells the data is pulling from based off of where you put your prior data. For example, If A4 is in my code for pulling dividends from Fidelity, you may have to change it to B4 or B5 depending on how you set up your spreadsheet. If you are having trouble, be sure to ask a question in the comments or head to my page and download this spreadsheet for your own use! The microphone I use: https://amzn.to/3ngqbVz Thanks for watching and don't forget to like and subscribe! #InvestmentTracker #GoogleSheets #PortfolioTracker