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
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

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

4 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • rros commented  ·   ·  Flag as inappropriate

    Same issue with other preferred shares: fnmas, fmckj, mtl.pr (mechel preferred shares), not retrieving the data.

  • 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