Dividend per Share Values incorrect for CAD stocks

Discussion in 'General Questions' started by ksarai, May 28, 2017.

Dividend per Share Values incorrect for CAD stocks

  1. ksarai

    ksarai New Member

    Joined:
    Aug 31, 2016
    Messages:
    21
    Likes Received:
    1
    Hi Ankur,

    There is a serious problem here with the accuracy of dividends per share for Canadian companies (trading on the Toronto Stock Exchange "TSX") using MarketXLS.

    I track 55 Canadian stocks and out of those 29 stocks had incorrect dividend per share values.

    Here's small sample of what I'm talking about:

    Annual Dividends per share obtained from MarketXLS, for example using =DividendPerShare("RY.TO"):
    AGU $4.72
    ACO.X $1.23
    BMO $3.52
    BNS $2.27
    CU $1.07
    CWB $0.69
    CM $3.72
    ECA $0.06
    ESI $0.36
    IFC $1.87
    PJC.A $0.38
    POW $1.00
    REI.UN $1.04
    SAP $0.45
    SU $0.93

    Annual Dividends per share obtained from TSX.COM:
    AGU $4.79
    ACO.X $1.31
    BMO $3.60
    BNS $3.04
    CU $1.43
    CWB $0.92
    CM $5.08
    ECA $0.08
    ESI $0.48
    IFC $2.56
    PJC.A $0.52
    POW $1.43
    REI.UN $1.41
    SAP $0.60
    SU $1.28

    As you can see from the list above that the values do not match.

    Ankur, please contact your financial data service provider to rectify this situation.

    Are you using Yahoo Finance, because they also have the incorrect values.

    thanks,
    Kanwal
     
  2. Stephen Vetter

    Stephen Vetter New Member

    Joined:
    Jun 24, 2017
    Messages:
    11
    Likes Received:
    2
    Hi,

    Dividends for Canadian listed stocks seem not to be working properly. Following table includes some Canadian dividend-paying stocks:

    MarketXLS Function DividendYield(symbol) only returns #VALUE
    MarketXLS Function DividendPerShare(symbol) doesn't return a value that is even close to dividend vale reported by my brokerage
    other MarketXLS Functions, e.g. RelativeStrengthIndex(symbol) seem to be working OK

    Please note that reported dividend payouts have different frequencies.

    upload_2018-2-11_19-53-21.png

    Greatly appreciate if you can check into this.

    Stephen Vetter
     

    Attached Files:

  3. joe__cunningham

    joe__cunningham New Member

    Joined:
    Feb 9, 2017
    Messages:
    5
    Likes Received:
    0
    Hello - I may have a similar issue.
    Seems like the Dividend functions are failing for my .AX (Australia) stocks at the moment. e.g. =DividendPerShare("CBA.AX") is returning 0 and =DividendPayDate("CBA.AX") returning NA. Swap in "V" (NYSE Visa) and these both work fine.
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10

    I am checking these.

    Kind regards
    Ankur
     
  5. Allan

    Allan New Member

    Joined:
    Jan 30, 2018
    Messages:
    4
    Likes Received:
    0
    Good morning Ankur

    As per our earlier on line chat, I am still unable to get any Cdn dividend info. There are also a number of other functions that do not work for Cdn stocks.

    Hopefully a solution cn be found for this.
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Allan,

    We are working on a solution for this. We are calculating this field and we do have the data. We are trying to work it out. I see some issues. It will be working soon, this week. I think its about currency as we looked in the past. But we are still working to figure this out for a long term and solidify this.

    Thank You
    Ankur
     
    joe__cunningham likes this.
  7. Stephen Vetter

    Stephen Vetter New Member

    Joined:
    Jun 24, 2017
    Messages:
    11
    Likes Received:
    2
    Hi Ankur - Thanks for this update.
     
    joe__cunningham likes this.
  8. Allan

    Allan New Member

    Joined:
    Jan 30, 2018
    Messages:
    4
    Likes Received:
    0
    Ankur, have you made any progress on this?
     

Share This Page