Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

Add Dividend Data to Stock Data Type

It would be helpful to include the dividend amount per share and ex-dividend date with the stock data type.

100 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

27 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Pete commented  ·   ·  Flag as inappropriate

    There are several fields relating to dividends that would be extemely useful to us.
    NEXT DIVIDEND PAYOUT AMOUNT
    UPCOMING PAYOUT DATE
    EX-DIVIDEND DATE
    DIVIDEND PAYOUT FREQUENCY
    To name a few...

    I know I currently have to look this information up regularly from a variety of sources sometimes. Would be nice to just hit Refresh all and have it at my fingertips.

  • John Alsdorf commented  ·   ·  Flag as inappropriate

    absolutely, this is the set of data that is necessary for any full data extract of Stock data. Dividend, Ex-Div date at a minimum.

  • Charles ARNESTAD commented  ·   ·  Flag as inappropriate

    Looking forward to this functionality (Dividend Yield, Monthly / Annual Dividend, etc...) being added as a function please. By the way, I LOVE this functionality of bringing in stock data to my Excel files -- thanks for this.

  • Quentin Schmierer commented  ·   ·  Flag as inappropriate

    Adding all the available information for a stock quote and making it accessible would be a great improvement. Also adding support for stock options trading would be very good including fields for:

    Symbol Stock Symbol
    ExpDate yymmdd
    Type C | P (Call/Put)
    Strike
    OptionCode <Option Symbol><Expiration Date><Option Type Char><Strike>
    Bid
    Ask
    Last
    Change
    PercentChange
    Volume
    OpenInt
    Delta
    Gamma
    Theta
    TimeValue
    IntrinisicValue
    ExtrinsicValue
    ImpliedVolatility
    HistoricVolatility

  • Anonymous commented  ·   ·  Flag as inappropriate

    This feature is critical. Should provide data to include - dividend yield %, annualized dividend payout amount $, payout ratio %, dividend frequency (e.g. monthly/quarterly, etc), dividend growth %, next dividend payout date, ex-dividend date. Should provide for stocks, etfs as well as funds. Yahoo finance, Google docs, etc have this data. Much found via aggregate sites like dividend.com too.

  • Anonymous commented  ·   ·  Flag as inappropriate

    perosnally without at least the dividend amount - this functionality is worthless. I have to attach to yahoo or google sheets somehow - mso why bother with Office. ex date, yield, maturity date, annual yield, next ex, are all valuable

  • Marc Schare commented  ·   ·  Flag as inappropriate

    Confirming Google Sheets provides this function and a lot more. For income investors, the stock prie alone is fairly useless without this information.

← Previous 1

Excel for Windows (Desktop Application): Data Import

Categories

Feedback and Knowledge Base

(thinking…)