Separate names with a comma.
Discussion in 'General Questions' started by eLake, Nov 2, 2017.
This function is not working.
Will it be corrected in this upcoming update?
yes, almost fixed. Working on it.
I applied the new version 22.214.171.124 and it still does not work.
All dividends are returned as 1.00
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.
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.
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.
Yes, in the past it returned the annual amount.
The return for MSFT should be 1.68
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.
=DividendPerShare appears to be working this morning and it's again returning the annualized amount. Thanks!
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