EPS data mis-behaving

Discussion in 'Troubleshooting' started by jerry262, May 10, 2016.

EPS data mis-behaving

  1. jerry262

    jerry262 New Member

    Joined:
    May 10, 2016
    Messages:
    3
    Likes Received:
    0
    I have the new version in Excel 2016 and 2013 there are a few problems with EarningsPerShare data.

    2 issues.  First some of the data comes back as AVG Volume instead of EPS  See the 2 pictures.

    The other problem seems to only happen when there is a large amount of data.  I started with  a full list of NYSE stock symbols added EarningsPerShare then sorted the data.  A few times it worked but most of the time it kills the API or something and one by one every value in the EPS cells turns to #VALUE and the only way to get it back is to reboot the PC.  Other data seems ok but anything related to EPS comes back as #VALUE

    Restarting Excel doesn't work.  Had the same problem with Excel 2013 and 2016

    [​IMG]<b></b><i></i><u></u>

    mostl[​IMG]
     
  2. marketxls

    marketxls Administrator
    Staff Member

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

    Ok, sure. Thanks for your post. We are checking on this and will update asap. If its a bug we will fix in coming release.

    Kind regards
    Ankur for MarketXLS.
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Its definitely not about your implementation, seems like a bug. We are checking on this.
     
  4. jerry262

    jerry262 New Member

    Joined:
    May 10, 2016
    Messages:
    3
    Likes Received:
    0
    Thanks for your rapid attention to this issue.

    Update: Last night (after posting this)  I tried sorting with a smaller data set and this time it crashed the name function.  Also after the reboot this time, MarketXls no longer appeared as a menu item and I had to uninstall and re-install.
     
  5. jerry262

    jerry262 New Member

    Joined:
    May 10, 2016
    Messages:
    3
    Likes Received:
    0
    Anything happening with this?
     
  6. marketxls

    marketxls Administrator
    Staff Member

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

    New release coming on Monday 23rd, it will be fixed.

    Kind regards
    Ankur
     
  7. marketxls

    marketxls Administrator
    Staff Member

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

    I tested EPS functions but they seem to be working fine... see below...

    [​IMG]

    What did you have in the Column D? Can you try again like =EarningsPerShare("AAON"), without the cell reference to double check?

    Thanks

    Ankur
     
  8. marketxls

    marketxls Administrator
    Staff Member

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

    Nevermind, my previous post, it is fixed now and will be available in on Monday on a new release..

    Kind Regards

    Ankur  for MarketXLS
     
  9. marketxls

    marketxls Administrator
    Staff Member

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

    Please use the latest version this should now be okay.

    Let me know if you face further issues.

    Thanks
    Ankur
     

Share This Page