Senin, 01 Februari 2016

[smf_addin] Digest Number 3622

5 Messages

Digest #3622

Messages

Sun Jan 31, 2016 4:25 am (PST) . Posted by:

sirons1962

Randy,

You are correct, it does not show on the Stock Checkup.


I followed your advise to grab it from another source.


Thanks!

Sun Jan 31, 2016 4:08 pm (PST) . Posted by:

dtrynoski

Hi, I'm trying to retrieve the greeks and the last trade price for options, codes lzyz123456. I enter the following as an array:




=smfGetOptionQuotes(C7,C9,1,3)



C7 Cell: SPY 3/3 12016 $189 Call
C9 Cell: lzyz123456



The headers correctly display but the cell each header it displays "Bad Source Code: 3




Is the data still able to be queried?




Sun Jan 31, 2016 4:41 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

There are several problems with your formula -- see below.

On Sun, Jan 31, 2016 at 5:08 PM, dtrynoski@... wrote:

> Hi, I'm trying to retrieve the greeks and the last trade price for
> options, codes lzyz123456. I enter the following as an array:
>
> =smfGetOptionQuotes(C7,C9,1,3)
>

"3" is not a valid source code. It's the value you would use as a
"datacode"; suffix if you were getting your data items from multiple data
sources. Plus that last parameter needs to be a string value.

I suspect you want "OX" instead.

> C7 Cell: SPY 3/3 12016 $189 Call
>

"3/3" is not a valid expiration date and "12016" is not a valid year. I
suspect you want:

SPY 3/4 2016 $189 Call

> C9 Cell: lzyz123456
>

That's OK, except that "z" is in there twice and "6" is not valid for data
source "OX".

The headers correctly display but the cell each header it displays "Bad
> Source Code: 3
>

Yup. See above.

> Is the data still able to be queried?
>

=smfGetOptionQuotes("SPY 3/4 2016 $189 Call","lzy12345",1,"OX")

...gets me:

Last Price Ticker Symbol Time/Theo Value Vega Theta Rho Gamma Delta
6.45 SPY^^^160304C00189000 7.034 0.2058 -0.0624 0.1143 0.0343 0.6922
You can get the data from multiple sources at the same time with something
like:

=smfGetOptionQuotes("SPY 3/4 2016 $189 Call","3l3z3y313233343556",1,"2")

...which gets me:

Last Price Ticker Symbol Time/Theo Value Vega Theta Rho Gamma Delta Implied
Volatility
6.45 SPY^^^160304C00189000 7.034 0.2058 -0.0624 0.1143 0.0343 0.6922 19.3
...but sometimes it's just easier to do individual formulas. Array-entering
this function doesn't really gain you anything, since it is scraping web
pages instead of parsing a returned CSV file (like RCHGetYahooQuotes()
does).

Sun Jan 31, 2016 5:18 pm (PST) . Posted by:

dtrynoski

Okay, I corrected those errors and was able to get the expected data. My next question is, how would I enter the following put option as an individual formula.

When I enter:
=smfGetOptionQuotes(C28,"l",,"OX")

C28 = SPY 2/26 2016 $189 Call
I get the last price returned 6.88


when I change C28 to: SPY 2/26 2016 $189 Put


I get:
Invalid Put/Call indicator (must be a C): P


Sun Jan 31, 2016 5:37 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

As noted in the documentation, the "OX" data source is for calls only. I
wasn't able to find a bookmarkable web page on OptionsXpress that had
Greeks for the puts.

On Sun, Jan 31, 2016 at 6:18 PM, dtrynoski@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Okay, I corrected those errors and was able to get the expected data. My
> next question is, how would I enter the following put option as an
> individual formula.
>
> When I enter:
> =smfGetOptionQuotes(C28,"l",,"OX")
> C28 = SPY 2/26 2016 $189 Call
> I get the last price returned 6.88
>
> when I change C28 to: SPY 2/26 2016 $189 Put
>
> I get:
> Invalid Put/Call indicator (must be a C): P
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar