2 Messages

Digest #3495

smfGetOptionQuotes question by markknutson2005

ADVFN Stockechange selection by antonvanas1989

Messages

1

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2 ADVFN Stockechange selection

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

antonvanas1989

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?