ETF Portfolio Tracker in Google Sheets! (Create a Tracker Step by Step)
Автор: Dividendology
Загружено: 2021-11-14
Просмотров: 14424
Описание:
Access Tickerdata and my Spreadsheets: https://tickerdata.com/
In this video, I take you step by step how to make an interactive ETF portfolio tracker in google sheets. This ETF tracker will help automate the tracking of your investments, will help you understand your diversification by country and sector, and will help you to screen for other ETF investments. Feel free to slow down or rewind the video if needed. If you enjoy this video, be sure to check out my other portfolio trackers on my channel.
Get 50% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/
1 Year trendline formula:
=(SPARKLINE(index(GOOGLEFINANCE(R16,"Price",today()-364,today()),,2),{"Charttype","column";"color","purple"}))
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 listed in my code, you may need to adjust it to refer to your data. (Ex: B7)
Get one free stock when you sign up for robinhood at this link: https://join.robinhood.com/elib190
Get $10 of bitcoin for free when you sign up for coinbase at my affiliate link: https://www.coinbase.com/join/breece_ie
The microphone I use: https://amzn.to/3ngqbVz
Some of the links above may be affiliate links.
#ETFtracker #PortfolioTracker #GoogleSheets
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: