2 Messages

Digest #3910

GetOptionQuotes "u" Underlying function by e_bartsch

Re: GetOptionQuotes "u" Underlying function by "Randy Harmelink" rharmelink

Messages

1a

GetOptionQuotes "u" Underlying function

Sun Feb 5, 2017 8:18 am (PST) . Posted by:

e_bartsch

Randy:

I use the =smfGetOptionQuotes function (normally in an array with the operators "lsu").

Recently, the "u" has been returning an invalid value for the Underlying price of the security. I have experimented with different data sources ("OX," "OX2", etc.), which either return no value or an invalid value (for example, I get the same value, 216.83, when using LOX or OX2, regardless of the security).

I updated my Add-In to the latest release.

Any ideas?

Thanks.

Eric Bartsch

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

1b

Re: GetOptionQuotes "u" Underlying function

Sun Feb 5, 2017 10:18 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. Strange -- they added an undisplayed quote for
LNKD in the page's source code before the underlying equity. So it was
picking up that price instead of the underlying equity price. I hope I
don't have to undo this change later...

The code has been changed, so the fix will be in the next release of the
add-in.

On Sun, Feb 5, 2017 at 9:18 AM, eabartsch@
...wrote:

> I use the =smfGetOptionQuotes function (normally in an array with the
> operators "lsu").
>
> Recently, the "u" has been returning an invalid value for the Underlying
> price of the security. I have experimented with different data sources
> ("OX," "OX2", etc.), which either return no value or an invalid value (for
> example, I get the same value, 216.83, when using LOX or OX2, regardless of
> the security).
>
> I updated my Add-In to the latest release.
>
> Any ideas?
>
>