The light grey cells can be automated through a formula or a lookup into another tab.The following columns are up to you to define but I track at a minimum the following columns:Following that, you can decide on the information you want on this tab. A portfolio & dividend tracker can help assess the income gap in your retirement and allow you to take appropriate action.You also need to know what’s in your portfolio and what it means to your performance such as your exposure to the different sectors or the dividend income your investments bring in.
Our system makes it easy to securely track the performance of your dividend portfolio, your total weighted yield, and yield on cost. When I set up my portfolio of dividend-paying stocks, I want to my dividends to double in the next 7 years. That’s the goal. Free for life. The dividend income should grow and you can then forecast how much to save and invest to reach your goals. Diesen Wert können Sie direkt mit Performance-Indices wie z.B. Portfolio overview & performance. Do a first pass and review it every quarter or year to see if it matches your investment philosophy.After this step, you should have a third tab summing up your holding value per sector if that’s of interest.This is where the magic happens for my portfolio. You just need to track the money going in and out of the account versus the total value set up in summary tab of Step 2 above. At a minimum, you have the current market value of your investment. The target per sector is for you to identify based on your investment goals. [ Performance as of 5/15/2020] *The AAII Dividend Investing portfolio is an actual portfolio started on January 3, 2012. I know exactly what the performance of my portfolio is and better yet, with Google Sheet, I compare it to indexes and I have a benchmark.As I have explained a number of times, the performance of your portfolio is a factor of your contributions to your accounts and your overall portfolio value. This spreadsheet contains my entire dividend stock portfolio and excludes any mutual funds I've yet to sell. Tracking your portfolio performance is a really important step to successful investing. Additions and deletions to the portfolio are made during the week following the portfolio alert. Features.
It’s free to have an account and you can use your own email address to sign up. Either way, it’s going to take time on your part to track the BUY, SELL and DRIP.As seen above, all of the ‘light grey’ shaded cells are computed and white cells require information from your accounts. The following table shows all of the positions for my portfolio, and so far, the portfolio return for June was 0.135%. Get started today. The goal would be to ensure (note: not target) that it is always better than this index ETF performance. SharesMaster will help track the stock investment performance and dividends in your portfolio without the need for cumbersome spreadsheets. It’s really up to you to track what you want. You can track more information if you want such as the industry, international exposure, growth vs income investment. I spent over 5 years getting to this stage and refining my process for tracking all the details I need to make informed decisions. With that information, you just have to apply the XIRR Excel function and you will have the ROR for your portfolio.After this step, you should have your 4th tab tracking all the money going in and out of each account. Google Sheets can give you the same Excel tracker since many of the formula exists for lookups and the finance functions are excellent. If you don’t know how your portfolio is doing, you won’t know if you are making the right decisions. The results can provide a comprehensive Below are two dividend tracker examples with Google Sheets using GoogleFinance that can get you started.They are the basic introduction to tracking capital gains and dividend income but it’s a good start depending on what you need.One key point to be aware of is that Canadians will usually deal with both USD and CAD dollars whereas Americans will usually only have USD. Now you might ask what kind of investment returns can be expected from this Vanguard three-fund portfolio.