Help get this topic noticed by sharing it on Twitter, Facebook, or email.

auto Dividends reinvestment of imported portfolio

Hi,
Recently discovered your web site. Absolutely love it. It is amazingly intuitive, and so informative. I am DIY investor and have used many web sites, spreadsheets to keep track of my portfolio over the past 20 years, so far nothing compares to sharesight.

I imported my portfolio using csv bulk import with all of the trades. Sharesight seems to record all information correctly. Two(2) questions:
1. is there a way to turn auto dividend reinvestment for Canadian and US ETFs, primarily vanguard etfs?
2. After bulk importing, is there a way to automate the dividend reinvestment or does this have to be done one by one for each dividend? I bought number of vanguard etfs some back in 2012, some of them pay dividends monthly , some quarterly. I prefer not to click through 100's to record reinvestment. I also tried to add "Dividend Reinvestment" as transaction type during import for each of the distribution however sharesight did not accept it.

Thanks
OP
1 person has
this question
+1
Reply
  • Hi OP,

    It's great to hear your experience of Sharesight has been a positive one so far.

    Regarding your two questions;

    1. We don't currently provide the ability to enable auto dividend reinvestments in Canadian portfolios. We can provide this feature in Australia and New Zealand because we receive the strike price for each dividend reinvestment from the Australian and New Zealand stock exchanges.

    We have not been able to find a source for the equivalent data point for our Canadian stocks.

    Without an accurate strike price any auto reinvestment would have to rely on the current trading price and this is always go to result in discrepancies.

    2. Because of the issues I mention above, we don't provide the ability to turn on dividend reinvestments in bulk. Each reinvestment needs to have the strike price entered manually.

    We'd love to find a way to improve on this manual entry of reinvestments for our Canadian market.

    We are looking at a couple of options to add automation into this area. Even without being able to access the correct data points we have a couple of promising ideas we will be exploring over the coming months.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • Ben, Thank you for the response.
    I am with Scotia iTrade, I downloaded all transactions that includes dividend payments, and dividend reinvestment. The way I can identify dividend reinvestment vs regular buy is that the price is 0.
    Before uploading to sharesight, I reversed engineer the price(in csv file)= settlement amount/quantity; in the example below, it comes to $23.92. which matches the price listed in the description. The only issue is that when uploading to sharesight, Transaction type can only be buy/sell, would be nice to upload with "dividend reinvestment" type since I can already identity dividends buys.

    Description Symbol Transaction Date Settlement Date Account Currency Type Quantity Currency of Price Price Settlement Amount

    VANGUARD CDN SHORT TERM BD INDEX ETF TR UNIT DPP-Divd Pur Plan REINV @ 23.92C$ VSB 8-May-19 8-May-19 CAD BUY 11 CAD 0 -263.12

    I understand the accuracy dilemma for on-going case; I used morningstar and they use ex-dividend date's closing price which is in-accurate. Maybe use the close price of paid date, probably still not accurate, might not match the strike price.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited