Minggu, 16 April 2017

[smf_addin] Digest Number 3966

4 Messages

Digest #3966

Messages

Sun Apr 16, 2017 4:48 am (PDT) . Posted by:

alankc_mok

Randy,

If I want to use Barchart as source, what should be the data code ? Currently, I am using this =smfGetOptionQuotes(X5:X1074,Y4,,"Y") to get option quote from Yahoo.


Thanks


Alan

Sun Apr 16, 2017 10:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "data codes" parameter won't change, other than what might be
available, but the "source" parameter would use a "B" instead of a "Y"...

On Sun, Apr 16, 2017 at 4:48 AM, alankc_mok@
​...wrote:

>
> If I want to use Barchart as source, what should be the data code ?
> Currently, I am using this =smfGetOptionQuotes(X5:X1074,Y4,,"Y") to get
> option quote from Yahoo.
>
>
>

Sun Apr 16, 2017 4:13 pm (PDT) . Posted by:

alankc_mok

Randy,

Thanks for your prompt reply.


When I changed the source from "Y" to "B", the cell is blank. And I am using the latest smf add in.


Regards


Alan

Sun Apr 16, 2017 4:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Can you give me an example? This works for me:

=smfGetOptionQuotes("MMM 5/19 2017 $180 Call","b",,"B")

How about you?

On Sun, Apr 16, 2017 at 4:13 PM, alankc_mok@ wrote:

>
> When I changed the source from "Y" to "B", the cell is blank. And I am
> using the latest smf add in.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.05

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)