preferred share

Discussion in 'General Questions' started by holmespoint, May 28, 2016.

preferred share

  1. holmespoint

    holmespoint New Member

    Joined:
    May 28, 2016
    Messages:
    6
    Likes Received:
    0
    what syntax for Preferred shares? also are preferred data available in Canada
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,087
    Likes Received:
    10
    Hi Kevin,

    There is no specific syntax for preferred shares. The normal functions should work, what changes is just the symbol. Is there any one which is not working for you?

    Thanks
    Ankur for MarketXLS Support
     
  3. holmespoint

    holmespoint New Member

    Joined:
    May 28, 2016
    Messages:
    6
    Likes Received:
    0
    DF.PR.A  is an example it is a Canadian
     
  4. bbrewer1972

    bbrewer1972 New Member

    Joined:
    Jun 4, 2016
    Messages:
    1
    Likes Received:
    0
    Also WFCPRJ

    Well Fargo Preferred Series J.  When I simply use WFCPRJ in lieu of another symbol it brings back N/A, I have added WFCPRJ to my stock list.

    I am a new user, thank  you for the help.

     

     
     
  5. holmespoint

    holmespoint New Member

    Joined:
    May 28, 2016
    Messages:
    6
    Likes Received:
    0
    hi Admin, is the an answer to the canadian preferred question above?
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,087
    Likes Received:
    10
    Hi Kevin,

    Sorry for the delay. I will get a resolution in this latest release around 1st of July

    Kind regards

    Ankur
     
  7. bcheung

    bcheung New Member

    Joined:
    Apr 28, 2016
    Messages:
    3
    Likes Received:
    0
    Hello,

    I purchased Marketxls April 24, 2016 and requested a refund May 18, 2016 and again May 20th, 2016. The request was made before the 30 day trial period ended, but as of today (June26, 2016), I'm still waiting for my refund to process.

    Bill
     
  8. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,087
    Likes Received:
    10
    Hi Bill,

    Your refund is processed.

    Kind regards

    Ankur for MarketXLS
     
  9. graovsko

    graovsko New Member

    Joined:
    Jun 9, 2016
    Messages:
    7
    Likes Received:
    1
    You have to use the preferred format supported by Yahoo finance.  For WFC J-series preferred it is WFC-PJ.  This is a common Yahoo syntax: stock ticker followed by a "-P" followed by the series letter ("J" in this case).  You may need to go to Yahoo Finance and search in some cases.  Morningstar uses WFCPRJ, Fidelity WFC/PJ and Quantum online WFC-J.
     
  10. dfraser

    dfraser New Member

    Joined:
    May 10, 2016
    Messages:
    20
    Likes Received:
    2
    Excellent - thank you. Works perfectly for preferreds.
     

Share This Page