DividendPerShare() not working

Discussion in 'General Questions' started by eLake, Nov 2, 2017.

DividendPerShare() not working

  1. eLake

    eLake New Member

    Joined:
    Mar 4, 2016
    Messages:
    9
    Likes Received:
    0
    Hello,
    This function is not working.
    Will it be corrected in this upcoming update?
    Thanks.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    yes, almost fixed. Working on it.

    Kind regards
    Ankur
     
  3. eLake

    eLake New Member

    Joined:
    Mar 4, 2016
    Messages:
    9
    Likes Received:
    0
    I applied the new version 8.0.0.7 and it still does not work.
    All dividends are returned as 1.00
     
  4. XLS

    XLS New Member

    Joined:
    Jun 7, 2016
    Messages:
    6
    Likes Received:
    0
    Hello,

    Still the same here as well, getting #Value! on both DividendPerShare and DividendPayDate functions; please advise with an estmated time on the fix. Thanks very much.
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Please can you check again? May I ask is it for any specific symbol? I am getting 0.39 for the one below, this is what they paid last time.
    =DividendPerShare("MSFT")
     
  6. m_cope

    m_cope New Member

    Joined:
    Jul 9, 2016
    Messages:
    9
    Likes Received:
    1
    I believe =DividendPerShare previously returned the annualized amount per share but now it looks like it is now returning the interval dividend amount per share (quarterly in the MSFT example). The old annualized amount was easier to deal with in my opinion; but, nevertheless, I'm still getting inconsistent results with the =DividendPerShare function in my spreadsheet today. I really don't have any spare time to throw at this at the moment so I'll just continue hoping that it gets fixed sooner rather than later. By the way, "Refresh All" is still painfully slow with your new server apparently up and running this morning. Thanks and I'm still waiting patiently, although with a fair amount of frustration.
     
  7. eLake

    eLake New Member

    Joined:
    Mar 4, 2016
    Messages:
    9
    Likes Received:
    0
    Yes, in the past it returned the annual amount.
    The return for MSFT should be 1.68
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,123
    Likes Received:
    10
    Ok, thanks for your feedback. We are working on the group model for the speed. It will be different architecture in the new version.We will work on dividend per share.

    Kind regards
    Ankur
     
  9. m_cope

    m_cope New Member

    Joined:
    Jul 9, 2016
    Messages:
    9
    Likes Received:
    1
    =DividendPerShare appears to be working this morning and it's again returning the annualized amount. Thanks!
     
  10. eLake

    eLake New Member

    Joined:
    Mar 4, 2016
    Messages:
    9
    Likes Received:
    0
    It's better but still different than before the "issues".

    MSFT should return 1.68 as its annualized dividend payout
    It now returns 1.56

    CSCO should return 1.16
    It now returns 1.10

    Why?
     

Share This Page