Selasa, 25 Agustus 2015

[smf_addin] Digest Number 3495

2 Messages

Digest #3495


Mon Aug 24, 2015 11:44 pm (PDT) . Posted by:


Hello Randy,

I'm trying to get the following smfGetOptionQuotes function to work:

=smfGetOptionQuotes(A6&" "&C1&" "&C6&" "&"Call","b",0,C3)

Where cell a6 is the symbol
cell C1 is the expiration date
cell C3 is source I'm trying to use G
cell C6 is the strike

This might not even be possible to use direct cell references like this, but if it is could you tell me how to format this to work?

Thanks in advance, Mark

Tue Aug 25, 2015 12:09 am (PDT) . Posted by:


Hi Randy,

I am having troubles with the correct stockmarket symbol for ADVFN data.

If i search "IBM" in my sheet ADVFN will be empty as on there website it returns to "lse:ibm". Before i could enter "NYSE:IBM"; in my sheet and then it would receive data from IBM but it seems not to work anymore, i tried other symbols as: &, \, /, %3A

But nothing works.

How can i point my sheet to the correct data from ADVFN?

For the Add-in, Documentation, Templates, Tips and FAQs, visit

Tidak ada komentar:

Poskan Komentar