How to Build a Daily Dividend Calendar in Google Sheets (Track your Dividend Income!)
ฝัง
- เผยแพร่เมื่อ 29 ก.ย. 2024
- Access Tickerdata and my Spreadsheets: tickerdata.com/
Get up to 12 free stocks now using my link for Webull! (Free Money!!): a.webull.com/i...
Get 50% off of Seeking Alpha Premium!
www.sahg6dtr.c...
In this video, I take you step by step on how to build a daily dividend calendar in google sheets. This is great way to track dividend income over time. Let me know if you have any questions in the comments down below!
Social Media (and other fun stuff): linktr.ee/divi...
I am not a Financial advisor or licensed professional. Nothing I say or produce on TH-cam, 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.
March 1-2 dividends are double counted on February "29-30"
This is amazing! I tried to ad the ticker from which company i got my dividens from as well, but google sheets says that would be more than 3 arguments for the sumif function. Do u know a way around this? Thank u so much for this video. And a happy new dividend year :) Greetings from Norway.
Instead of using sumif, use sumifs. This allow multiple arguments.
@@Dividendology I tried that now. My formula lookes like this: =SUMIFS(Data!$E:$E,date($C$6,$B7,D$6),Data!$D:$D,Data!$C:$C), and google sheets now says: SUMIFS expect all arguments after position 3 to be in pairs. I tried to move the C colon before date argument as well. If i do that, it only returns 0.
Thank you for sharing these videos.
You are welcome!
Great video
Love the dividends on February 29th and 30th 😂
Lol, typo on my end. Nice catch.
@@Dividendology I have just added conditional formatting to grey out the illegal dates, with the following custom formula:🙃
"=IF(NOT(ISERROR(DATEVALUE(D$6 & "/" & $B7 & "/" & $C$6))),FALSE(),TRUE())"
Awesome!
My cell references are different, but I blocked the incorrect dates with:
"=if(ISERROR(datevalue($B7 & "/" & D$6 & "/" & $C$6))," ",sumif('Raw data'!$D:$D,DATE($C$6,$B7,D$6),'Raw data'!$C:$C))"
'Raw data' is 'sheet2' in the video. This will leave a blank cell if there is no date for that year. It will have 29 Feb on leap years, but not on the others.
This is very interesting! I do have 1 question. Is it possible to add a total to each month and then have it add a overall total of all dividends received automatically? I think thatd be cool to add to this setup
Yes! Thats a very easy adjustment. I actually do have that feature on my dividend calendar.
Easy and lean, but fantastic sheet!
It really is! Thanks!
Ciao 😁
Hi, just wondering, where can I get the ex-dates data, or where did you get it from in such a nice format?
Hello, thanks for the video. in minute 5:33 for "O" show a dividend on 2/15/2022 of $5.85 but "O" pays monthly dividends, it should be 0.2465 instead, isn't it? Best
It’s just example data :)
What if it will change the pay date?
And how do you know all pay date for a company?
For example (2023) if a company pay quartely, how do you know each date?
Just plug in the dividend payouts as they are paid out.
Newbie here, if you own a mutual fund that does a capital gain distribution, would you include that in a dividend tracker such as this?
It’s personal preference, but I would.
I'm a noob with Excel /sheets.Way over my head, but I was wondering.. is there a way to use maybe APIs to have it automatically insert values daily vs. Manually which are pulled from various sources or probably not easy ?
I'll look into this.
@@Dividendology thanks brother.
Will you paste that formula, have been trying to get it right for a few hours and just can’t seem to figure it out. But thanks for the help
Hope this helps!
=sumif(Sheet2!$E:$E,date($C$6,$B7,D$6),Sheet2!$D:$D)
@@Dividendology got it figured out thanks so much keep up the great content!!!!