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. =googlefinance() for dividends? A workaround for getting dividends into Google SheetsThe =googlefinance() function in Google Sheets does not yet have an automatic way to bring in the dividend yield, so it must be done manually. In this video I show a very quick way to update dozens of dividends in just a few clicks. While it is possible to write a script / macro to pull in the information automatically, this is a very simple, no-code way. I spend 7 minutes discussing the method, but in reality, you could apply it in just 1 minute. This isn't something that needs to be done all the time, generally every few months is good enough. The extra benefit of keeping a list of all of your positions in Yahoo Finance, is that you can also skim through the other information that they provide, such as ex dividend, and payment dates. You can get the dividend stock screener 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 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 Top Canadian Utility Stocks for Dividend InvestingThe stock prices keep falling this week, so I'm buying! Today I add to two of my Canadian Utility Stocks for their strong dividends, at a discounted price. I also pick up one share of a REIT with my left over cash for the day. My Canadian dividend portfolio's biggest sector is actually utilities. A lot of Canadian Utility Stocks pay some of the best dividends out there, and are well positioned for growth and stability in the long term. Canada is cold, and we're all still going to be paying for heat for decades to come. You can get the Dividend Tracker Google Sheet that I use in the video here.
f 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 Digital Nomad FinancesIf I told you that I earn less than minimum wage, but travel full time, would you believe me? I've been what most people would call a digital nomad for the last two and a half years, and since October 2018, I've visited 20 countries, mostly on motorcycles that I bought abroad, while earning less than Canada's minimum wage. And After 2.5 years on the road, I have more money than when I started. This video shows how I broke the system.
|
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
|
RSS Feed
Disclaimer: I am not a financial professional or advisor. Nothing on this website or the associated social media accounts constitutes financial advice. I'm just documenting my own investing journey and don't suggest that you do the same. Investing is risky, so make your own decisions or hire a qualified professional make them for you.
© COPYRIGHT 2021. ALL RIGHTS RESERVED.