Selasa, 25 Agustus 2015

[smf_addin] Digest Number 3495

2 Messages

Digest #3495
1
2

Messages

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

markknutson2005

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:

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?




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar