Google Sheets Dividend Tracker / ScreenerThis is a custom Google Sheets Dividend Tracker that I made to track my Canadian Dividend Stock Portfolio. It can accommodate USD and CAD transactions, and supports stocks in the Toronto Stock Exchange (TSE), Toronto Venture Stock Exchange (CVE), New York Stock Exchange (NYSE), and NASDAQ. The Sheet has several tabs for portfolio summaries, sector breakdowns, dividend charts, sparkline screeners, transaction & dividend history, watch list, etc. It's a great compliment to your regular trading app, as it shows / visualizes some more information than most apps, such as the portfolio average yield, or annual estimated dividend income.
I made this sheet for my self a few months ago, but over 100 people are already happily using it too. So this video just runs the basics on how to use it if you want to try as well. If you do download it and have any questions at all, just send me an email (it's in the "welcome" tab) and I'll help you through whatever issue you're having. Because I also use this sheet, I'm always trying to improve it for myself and also from the feedback & suggestions of all other users, and if you download it you'll get free access to future improved versions 👌. You can watch any of my other "dividend portfolio update" videos too to see more examples of me using the sheet.
0 Comments
Rebalancing my TFSAIn today's update of my Canadian dividend investing portfolio, I use Wealthsimple Trade to sell out of an industrial company that I am up 35% on, and reinvest the money into a few different REITS. I am banking on more recovery from the Canadian REITs in the next few months, hopefully that actually happens. Either way though, by doing the trade, my average portfolio yield increased, and hence, my annual passive income which is what I am mostly after. I will be reinvesting the monthly REIT distributions in the future to continue my compounding / dividend snowball effect. You can get the Dividend Tracker Google Sheet that I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW Rebalancing a TFSAI'm cashing out of Shaw Communications (SJR.B) today. I'm up 45%, due to the buyout announcement from Rogers, and I've decided that's good enough. I was dollar cost averaging into them as their stock price was falling over the last few months, and this boost has far surpassed my short term goals, so I'm selling before the deal potentially does not go through. I also close two other industrial positions that I hold, for similar reasons. Take all the money from these sales, and reinvest into several of my positions that are currently in the red, and open two new positions. Just by shifting the money around today, my annual dividend income rose by $10/year too.
You can get the Dividend Tracker Google Sheet that I use in the video here. If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW Buying a new Canadian monthly dividend stock now that Shaw's monthly dividend may disappear3/19/2021 Canadian Monthly Dividend StocksIn today's update of my Canadian Dividend Investing Portfolio, I buy more into two utility companies, and also a REIT. I was always averaging into Shaw Communications SJR.B but with the recent news that Rogers intends to buy them out, their monthly dividend will possible become a thing of the past. I'm not complaining though! That was a big surprise boost to my portfolio, considering that their stock price just kept falling before. So I'll be looking for monthly dividends to eventually replace them, and Northland Power NPI is a great choice, as well as several REITs for their monthly distributions. You can get the Dividend Tracker Google Sheet that I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW My Top Canadian Dividend Stocks TodayAnother day, another dividend! In today's update, I spend about $300 on more Canadian Dividend Stocks. I buy a utility stock, a consumer staple stock, and a REIT. The first two I'm buying in the red, but the REIT I buy while it's 50% above my average buy price! My personal preference is to always buy in the red, but sometimes the best dividend stocks are those that are just performing well. It looks like it's going to keep climbing, so for me personally, it looks like a good pick for a recovery stock to buy today. You can get the Google Sheets Dividend Screener that I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW =googlefinance() Is Broken! Adding More to 3 of my Canadian Dividend Stocks in Wealthsimple Trade3/12/2021 The =googlefinance() function in Google SheetsThe =googlefinance() function is broken. It's an issue being reported by users all around the world in the last few days. Hopefully it is resolved soon. It doesn't stop us from still buying good dividend stocks though. Today I am on the lookout for the best Canadian dividend stocks in my portfolio to add to, and decided on two utility stocks, and one consumer staple stock. Two of the stocks that I pick today are dividend aristocrats, and the other has a monthly dividend.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW You can get the Dividend Screener Google Sheet that I usually use in the videos here. Buying Canadian Utility Stocks and REITs for Income GenerationHello friends. Back again with another update of my Canadian Dividend Investing Portfolio. Today, the dip just keeps dipping, so I keep buying. Utility stocks seem to be the hardest hit this week, so that's where I'm putting my money. I add to three Canadian Utility Stocks, and also one REIT in this video. I am mostly interested in buying the discounted utilities in this little crash, but still try to buy at least one stock from a company in a different sector. You can get the Dividend Tracker Google Sheet that I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use the link above, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW Canadian Renewable Energy StocksStock market is red so I'm buying! Picking up several different Canadian Dividend Stocks today. I'm using Wealthsimple Trade to buy the stocks in Canada, and I track my dividends in a google sheet that I made. In the video, I take a look at some renewable energy stocks that I probably should have sold, when they peaked a few weeks ago, but missed the boat. However, I'm turning this frown upside down and taking the opportunity to buy some different stocks that are now quite far below my average price. You can get the Dividend Tracker Google Sheet that I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW Chasing the Best Dividend Stocks in Canada for my RetirementGreat prices on Canadian dividend stocks right now! In today's update of my Canadian Dividend Portfolio, I add to 4 of my positions, at a discount of several % on each compared to my own personal average buy price. Tracking my portfolio in Google Sheets and buying dips is my form of dollar cost averaging (sort of) that is helping me to realize when I can get the same dividend, but at a lower cost than before. I'm trying to keep the portfolio balanced, by still spreading out my purchases, and as you can see in the video, it's going alright. Thanks for checking out my investing portfolio with Canadian dividend stocks. You can get the Dividend Tracker Google Sheet that I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! Canadian Monthly Dividend StocksIn today's update of my Dividend Portfolio, I buy three monthly dividend paying stocks. I also buy three others too. All stocks that I buy are Canadian Dividend Stocks listed on the TSX. Some of the stonks have high dividend yield, and the others are for their dividend growth, and although I'm slightly cringing to add to my positions at a price thats 20% above my average buy, I'm happy to boost some of those monthly dividends. You can get the Dividend Tracker Google Sheet that I use in the video here.
If you are Canadian and want to start buying dividend stocks, Wealthsimple Trade is a really easy and convenient way to start putting aside some money. You can even buy one stock at a time for just a few dollars. If you have $100 to invest, you can use this link, and they’ll add $10 your account as a bonus. Immediate 10% ROI... not bad! If you already signed up for Wealthsimple Trade, you can still claim the $10 with this code: BL5OIW |
Alpine DividendsI'm documenting the growth of a Canadian dividend investing portfolio and make videos about dividend investing, Canadian stocks, Wealthsimple Trade, Google Sheets, personal finance, and passive income.
Categories
All
|