Hi,

I would like to read updated stock option quotes into Sheet.

I recall that this used to be possible. However, recently a new format has been instituted for stock option quotes.

For example, the symbol for the Apple April 200 Call is now: APV100417C00200000.

I tried entering:  =STOCK("APV100417C00200000") but it didn't work. It sent the message "Unable to Fetch".

Please advise if this is possible, and how to do it.

Thanks ...