Dividend Income Tracker in Google Sheets! (Best Way to Track Your Dividends!)
HTML-код
- Опубликовано: 1 апр 2022
- Access Tickerdata and my Spreadsheets: tickerdata.com/
Get 50% off of Seeking Alpha Premium!
www.sahg6dtr.com/9D5QH2/R74QP/
In this video, I show you how to make a dividend income tracker in google sheets. This is an updated version to my original dividend tracker in google sheets. You can find the original tutorial here:
• Portfolio Tracker in G...
Let me know if you have any questions!
Follow me on Twitter: / dividendology
Join my Discord! / dividendology
I am not a Financial advisor or licensed professional. Nothing I say or produce on RUclips, 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.
Thank you for all the work you do. I noticed that on the daily dividend calendar, the formala will blindly treat a date such as Feb 29 as Mar 1st, which is why you have data for February 30.. or April 31 (which is then repeated on May 1 cell). I am guessing the fix for this is to blank out those cells, but I wanted to mention this just in case people are following along.
I got this entire thing done this morning. ThanksL
That’s awesome!!
Another great tutorial. Hope you’re doing well
Great tracker! You should be able to pull in all dividend data, payments etc. by using formulas. Just a tip. Keep up the good work!
Thank you and thanks for the tip!
@@Dividendology You're welcome, if you need any assistance, I'd be happy to help! Have a great day!
How to make the Divident/ portfolio recording?
Very interesting
Can you automate the dividend payments vs having to enter manually? Also what about a session in importing transactions from the brokerage account using a csv format
I will look into making a video on this!
is it possible dividend payment date/ month extracted automatically with a formula? in your example you are making a database and make manual input for each dividend payment.
Yes that is fairly easy to do! I did it to simply the learning process for the tutorial.
@@Dividendology do you think you can make a video on how to automate this process?
I will look into this.
Thanks for your wonderful video. Any idea how I can retrieve the "Ex-Dividend Date" from the internet ?
Yes! I have a video coming out soon where you can see how to do that.
Hey, amazing videos. I was wondering can you help me with my dividend tracker?
I'm planning on creating a discord server soon where we can discuss things like this. Be on the look out!
am i able to add funds to this please? great video
Most funds should work!
Why was there a 22 listed next to all the months?
I’ve been tracking over multiple years, so I put the 22 to stand for 2022.