Present Dividend Data

Discussion in 'Feature Ideas' started by mddickmeyer, Mar 28, 2016.

Present Dividend Data

  1. mddickmeyer

    mddickmeyer New Member

    Joined:
    Feb 18, 2016
    Messages:
    5
    Likes Received:
    0
    It would be more beneficial for present dividend information to come in as "0.00" rather than "N/A." In Excel strings such as N/A case errors within functions, so any company that doesn't pay a dividend breaks down the formulas in my sheets. Since the purpose of MarketXLS is to bring data into Excel it would make more sense for the data formats to work together.

    I wasn't sure if this was something that only I am concerned with, so I put it out here to see what other people thought.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
    Hi Max,

    Releasing a new version 4.0.0.0 in an hour or so, this one has a new function that works like below...

    =DividendBetweenTwoDates("MSFT", TODAY()-365,TODAY())

    This will get sum of last 1 year dividends of a stock. In the next release we will add a button to download all historical dividends, we have this data.

    We are sending an email about all changes in v4.

    Kind regards
    Ankur for MarketXLS Support
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
    Hi Max,

    I see your point, yes, will return 0 instead of N/A in next release.

    Thanks for the suggestion.

    Kind regards
    Ankur
     
  4. mddickmeyer

    mddickmeyer New Member

    Joined:
    Feb 18, 2016
    Messages:
    5
    Likes Received:
    0
    Hi Ankur,

    I noticed dividends are still reporting as N/A. I realize there might be a good reason it is reported that way instead of as a zero. You need not explain the details of your decision, but I was curious if a change to zero was still expected?

     

    Regards,

    Max
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
    Hi Max,

    Ok, sure. Answer is no.

    Kind regards

    Ankur for MarketXLS
     

Share This Page