2 Messages

Digest #3181

smfGetOptionQuotes - Can't figure out why this doesn't work by bobobfd

Re: smfGetOptionQuotes - Can't figure out why this doesn't work by "Randy Harmelink" rharmelink

Messages

1a

smfGetOptionQuotes - Can't figure out why this doesn't work

Mon Sep 15, 2014 1:15 pm (PDT) . Posted by:

bobobfd

=smfGetOptionQuotes("NILE FEB 2015 30 Put","b")

This formula comes back with "error" whether I use Yahoo or Google. It returns valid values if I use a date prior to Feb. 2015. Anyone know why this doesn't work - I'm stumped.

Thanks
Bob
(using Excel 2010)

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

1b

Re: smfGetOptionQuotes - Can't figure out why this doesn't work

Mon Sep 15, 2014 1:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That's because all monthly expirations after 2015-02-01 will be on Fridays
instead of Saturdays in order to align to the weekly option expiration
dates. My version of the add-in has been fixed for that change, but it
hasn't been released yet. For now, as a work-around, you'll need to use:

=smfGetOptionQuotes("NILE 2/20 2015 30 Put","b")

On Mon, Sep 15, 2014 at 1:01 PM, bobobfd@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> =smfGetOptionQuotes("NILE FEB 2015 30 Put","b")
>
> This formula comes back with "error" whether I use Yahoo or Google. It
> returns valid values if I use a date prior to Feb. 2015. Anyone know why
> this doesn't work - I'm stumped.
>
>