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!
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?
=smfGetOptionQuotes
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).
On Sun, Jan 31, 2016 at 5:08 PM, 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
>
"3" is not a valid source code. It's the value you would use as a
"datacode"
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
...gets me:
Last Price Ticker Symbol Time/Theo Value Vega Theta Rho Gamma Delta
6.45 SPY^^^160304C001890
You can get the data from multiple sources at the same time with something
like:
=smfGetOptionQuotes
...which gets me:
Last Price Ticker Symbol Time/Theo Value Vega Theta Rho Gamma Delta Implied
Volatility
6.45 SPY^^^160304C001890
...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
When I enter:
=smfGetOptionQuotes
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
>
>
>
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 = 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:
Posting Komentar