Feedback by UserVoice

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

The STOCK data type

The STOCK data type gives inaccurate data for ETP/PRD and for EPD.
Also transposed SFIX and SCHW. See attached Workbook.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ron DelPorto shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        I have the same problem with other preferred shares. Morningstar and MSN money have the correct symbols but the stock quote data selector within excel is unable to retrieve preferred shares.

      • Ron DelPorto commented  ·   ·  Flag as inappropriate

        Update! They apparently fixed EPD! It now gives the correct name.. Unfortunately as of today, ETP/PRD (a preferred stock) still reports as "FT Global Risk Managed Income ETF Com". That is incorrect. It should be "Energy Transport Operating Company"

      • Ron DelPorto commented  ·   ·  Flag as inappropriate

        My bad, I think the transposition of Stitch Fix and Schwab was my error. The only problem here is that It is giving the wrong company and therefore the wrong price for ETP/PRD and EPD. Does Microsoft monitor this site? It seems there would be a so=imple fix for this.

      Feedback and Knowledge Base