Problem Receiving an Option Quote

Discussion in 'Troubleshooting' started by wbunn, Jun 29, 2016.

Problem Receiving an Option Quote

  1. wbunn

    wbunn New Member

    Joined:
    Mar 16, 2016
    Messages:
    9
    Likes Received:
    0
    I am trying to get a Marketxls stock option quote using the Option article in the Knowledge Base showing the May 2010 format. Following the article format,  I setup up an option symbol that looks like this:  (JNJ161021C00120000) representing:

    JNJ Oct 21,2016 Call, 120 Strike.  Unfortunately, all I get back is "N/A".  Does anyone see an error in this option symbol - the parenthesis were shown in the examples and the long symbol spilled over into more than one Excel cells.  Any suggestions or working examples would be greatly appreciated.

    William

    wbunn@comcast.net
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    Hi William,

    It looks like you are using =Last function to get option price. But I would recommend you use =Option_Last_Price(H7) instead. When I have JNJ161021C00120000 in cell H7 with this formula I get 2.89 as the result.

    Let me know if this solves it.

    Kind regards

    Ankur
     

Share This Page