7 Messages
Digest #3813
1b
Re: No Yahoo Earnings Estimates Available on any stock for a couple by "Randy Harmelink" rharmelink
Messages
Thu Oct 6, 2016 5:10 am (PDT) . Posted by:
ghart21
N/A appears everywhere. I have tried both IE11 and Chrome. Any idea why this is occurring?
Thu Oct 6, 2016 10:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hopefully just a glitch on end-of-month updates?
On Thu, Oct 6, 2016 at 5:10 AM, ghart23@
...wrote:
> N/A appears everywhere. I have tried both IE11 and Chrome. Any idea why
> this is occurring?
>
>
On Thu, Oct 6, 2016 at 5:10 AM, ghart23@
...wrote:
> N/A appears everywhere. I have tried both IE11 and Chrome. Any idea why
> this is occurring?
>
>
Thu Oct 6, 2016 2:12 pm (PDT) . Posted by:
bob_15861586
Randy,
I do not see any valid quotes for SPX options on Yahoo. Having said that, the following macro call does appear to work. At the moment, it might be off by 5 cents.
=smfGetOptionQuotes("SPX 1/20 2017 $1500 Put","A",,"OX2")
I do not know why. Could it be luck?
I did notice the following site gives SPX option calls:
http://www.marketwatch.com/investing/index/spx/options http://www.marketwatch.com/investing/index/spx/options
I do not think it would be easy to extract prices from this website.
Bob
I do not see any valid quotes for SPX options on Yahoo. Having said that, the following macro call does appear to work. At the moment, it might be off by 5 cents.
=smfGetOptionQuotes("SPX 1/20 2017 $1500 Put","A",,"OX2")
I do not know why. Could it be luck?
I did notice the following site gives SPX option calls:
http://www.marketwatch.com/investing/index/spx/options http://www.marketwatch.com/investing/index/spx/options
I do not think it would be easy to extract prices from this website.
Bob
Thu Oct 6, 2016 3:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't think it's luck that OX has the data and Yahoo does not.
OptionsXPress is a trading platform. Yahoo is not. Yahoo is missing a lot
of option quotes. I currently have a limit order on an option that isn't
listed on Yahoo.
MarketWatch used to be a source the add-in used. Until they changed their
option ticker symbols. They have characters in their option ticker symbol
that I've not figured out how to generate. It used to be a good source
before that, because ALL options are on a single page. So for example, this:
=RCHGetTableCell("
http://www.marketwatch.com/investing/index/SPX/options?showAll=True
",5,"SPXWM31172150000")
...would retrieve the "SPX 1/31 2017 $1500 Put". I don't see a Jan 20 put
option on their page though, so that would be a problem.
But I can't break that ticker symbol up into pieces that are all
meaningful, at least to me. For example, "SPXWM31172150000":
SPX = the ticker symbol
W = no idea what this is
M = Put with January expiration date
31 = day of expiration date
17 = year of expiration date
2 = I suspect it has to do with the magnitude of the strike price, since
normal rules can't apply, but haven't pursued it
150000 = $1500 strike price
On Thu, Oct 6, 2016 at 2:12 PM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I do not see any valid quotes for SPX options on Yahoo. Having said that,
> the following macro call does appear to work. At the moment, it might be
> off by 5 cents.
> =
>
> smfGetOptionQuotes(
>
> "
>
> SPX 1/20 2017 $1500 Put","A",,"OX2")
>
> I do not know why. Could it be luck?
>
> I did notice the following site gives SPX option calls:
>
> http://www.marketwatch.com/investing/index/spx/options
>
> I do not think it would be easy to extract prices from this website.
>
>
>
OptionsXPress is a trading platform. Yahoo is not. Yahoo is missing a lot
of option quotes. I currently have a limit order on an option that isn't
listed on Yahoo.
MarketWatch used to be a source the add-in used. Until they changed their
option ticker symbols. They have characters in their option ticker symbol
that I've not figured out how to generate. It used to be a good source
before that, because ALL options are on a single page. So for example, this:
=RCHGetTableCell("
http://www.marketwatch.com/investing/index/SPX/options?showAll=True
",5,"SPXWM31172150000")
...would retrieve the "SPX 1/31 2017 $1500 Put". I don't see a Jan 20 put
option on their page though, so that would be a problem.
But I can't break that ticker symbol up into pieces that are all
meaningful, at least to me. For example, "SPXWM31172150000":
SPX = the ticker symbol
W = no idea what this is
M = Put with January expiration date
31 = day of expiration date
17 = year of expiration date
2 = I suspect it has to do with the magnitude of the strike price, since
normal rules can't apply, but haven't pursued it
150000 = $1500 strike price
On Thu, Oct 6, 2016 at 2:12 PM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I do not see any valid quotes for SPX options on Yahoo. Having said that,
> the following macro call does appear to work. At the moment, it might be
> off by 5 cents.
> =
>
> smfGetOptionQuotes(
>
> "
>
> SPX 1/20 2017 $1500 Put","A",,"OX2")
>
> I do not know why. Could it be luck?
>
> I did notice the following site gives SPX option calls:
>
> http://www.marketwatch.com/investing/index/spx/options
>
> I do not think it would be easy to extract prices from this website.
>
>
>
Thu Oct 6, 2016 3:36 pm (PDT) . Posted by:
bob_15861586
Randy,
One thing about index calls is that they do not settle in stock but instead they settle in cash. The W means that it is a weekly option. By the way, this option is out of the money and it is very likely to expire worthless.
Do you have a desire to support these index options? I know that it would help me but I am not sure how many other users it would help.
Bob
One thing about index calls is that they do not settle in stock but instead they settle in cash. The W means that it is a weekly option. By the way, this option is out of the money and it is very likely to expire worthless.
Do you have a desire to support these index options? I know that it would help me but I am not sure how many other users it would help.
Bob
Thu Oct 6, 2016 3:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I was doing my testing today, I was finding response times from
OptionsXpress running between 59 and 193 seconds apiece.
It may be more of a matter of finding a good source of index options and
utilizing it, rather than trying to force fit it into the current data
sources.
So I guess it's more of a convenience issue than anything else. For the
most part, the smfGetOptionQuotes() function just uses a common ticker
symbol defined by me, a more readable one, to communicate with the various
sources. It then calls other add-in functions to get the actual data. The
other functions could be used directly by anyone, similar to the
RCHGetTableCell() one I just gave you in the other message.
On Thu, Oct 6, 2016 at 3:36 PM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Do you have a desire to support these index options? I know that it would
> help me but I am not sure how many other users it would help.
>
>
>
OptionsXpress running between 59 and 193 seconds apiece.
It may be more of a matter of finding a good source of index options and
utilizing it, rather than trying to force fit it into the current data
sources.
So I guess it's more of a convenience issue than anything else. For the
most part, the smfGetOptionQuotes() function just uses a common ticker
symbol defined by me, a more readable one, to communicate with the various
sources. It then calls other add-in functions to get the actual data. The
other functions could be used directly by anyone, similar to the
RCHGetTableCell() one I just gave you in the other message.
On Thu, Oct 6, 2016 at 3:36 PM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Do you have a desire to support these index options? I know that it would
> help me but I am not sure how many other users it would help.
>
>
>
Thu Oct 6, 2016 5:34 pm (PDT) . Posted by:
"Tim Young" timy2matoe
Randy,
Here is some info on the "W" after SPX... Appreciate what you do, thx.Tim
The Chicago Board Options Exchange (CBOE) trades options on the S&P 500 Index (SPX) with two types of expirations and settlements.
SPX options ordinarily cease trading on the business day (usually a Thursday) preceding the day on which the exercise-settlement value is calculated. The exercise-settlement value is calculated using the opening sales price in the primary market of each component stock on the last business day (usually a Friday) before the expiration date. This is called "AM settlement." SPXW options are weekly options that generally start trading on Thursdays and expire on Fridays, except in some circumstances.1 SPXW options trade until 4:00 p.m. ET on expiration day. Unlike SPX options, SPXW options are "PM-settled," meaning the exercise-settlement value is calculated using the last (closing) reported sales price in the primary market of each component stock on the expiration date. 1 Weekly options are not listed if they would expire on the third Friday of the month or if a quarterly option is set to expire on the same day.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, October 6, 2016 5:53 PM
Subject: Re: [smf_addin] Re: Index Calls
When I was doing my testing today, I was finding response times from OptionsXpress running between 59 and 193 seconds apiece.
It may be more of a matter of finding a good source of index options and utilizing it, rather than trying to force fit it into the current data sources.
So I guess it's more of a convenience issue than anything else. For the most part, the smfGetOptionQuotes() function just uses a common ticker symbol defined by me, a more readable one, to communicate with the various sources. It then calls other add-in functions to get the actual data. The other functions could be used directly by anyone, similar to the RCHGetTableCell() one I just gave you in the other message.
On Thu, Oct 6, 2016 at 3:36 PM, bob_15861586@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Do you have a desire to support these index options? I know that it would help me but I am not sure how many other users it would help.
#yiv1252408896 #yiv1252408896 -- #yiv1252408896ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1252408896 #yiv1252408896ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1252408896 #yiv1252408896ygrp-mkp #yiv1252408896hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1252408896 #yiv1252408896ygrp-mkp #yiv1252408896ads {margin-bottom:10px;}#yiv1252408896 #yiv1252408896ygrp-mkp .yiv1252408896ad {padding:0 0;}#yiv1252408896 #yiv1252408896ygrp-mkp .yiv1252408896ad p {margin:0;}#yiv1252408896 #yiv1252408896ygrp-mkp .yiv1252408896ad a {color:#0000ff;text-decoration:none;}#yiv1252408896 #yiv1252408896ygrp-sponsor #yiv1252408896ygrp-lc {font-family:Arial;}#yiv1252408896 #yiv1252408896ygrp-sponsor #yiv1252408896ygrp-lc #yiv1252408896hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1252408896 #yiv1252408896ygrp-sponsor #yiv1252408896ygrp-lc .yiv1252408896ad {margin-bottom:10px;padding:0 0;}#yiv1252408896 #yiv1252408896actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1252408896 #yiv1252408896activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1252408896 #yiv1252408896activity span {font-weight:700;}#yiv1252408896 #yiv1252408896activity span:first-child {text-transform:uppercase;}#yiv1252408896 #yiv1252408896activity span a {color:#5085b6;text-decoration:none;}#yiv1252408896 #yiv1252408896activity span span {color:#ff7900;}#yiv1252408896 #yiv1252408896activity span .yiv1252408896underline {text-decoration:underline;}#yiv1252408896 .yiv1252408896attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1252408896 .yiv1252408896attach div a {text-decoration:none;}#yiv1252408896 .yiv1252408896attach img {border:none;padding-right:5px;}#yiv1252408896 .yiv1252408896attach label {display:block;margin-bottom:5px;}#yiv1252408896 .yiv1252408896attach label a {text-decoration:none;}#yiv1252408896 blockquote {margin:0 0 0 4px;}#yiv1252408896 .yiv1252408896bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1252408896 .yiv1252408896bold a {text-decoration:none;}#yiv1252408896 dd.yiv1252408896last p a {font-family:Verdana;font-weight:700;}#yiv1252408896 dd.yiv1252408896last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1252408896 dd.yiv1252408896last p span.yiv1252408896yshortcuts {margin-right:0;}#yiv1252408896 div.yiv1252408896attach-table div div a {text-decoration:none;}#yiv1252408896 div.yiv1252408896attach-table {width:400px;}#yiv1252408896 div.yiv1252408896file-title a, #yiv1252408896 div.yiv1252408896file-title a:active, #yiv1252408896 div.yiv1252408896file-title a:hover, #yiv1252408896 div.yiv1252408896file-title a:visited {text-decoration:none;}#yiv1252408896 div.yiv1252408896photo-title a, #yiv1252408896 div.yiv1252408896photo-title a:active, #yiv1252408896 div.yiv1252408896photo-title a:hover, #yiv1252408896 div.yiv1252408896photo-title a:visited {text-decoration:none;}#yiv1252408896 div#yiv1252408896ygrp-mlmsg #yiv1252408896ygrp-msg p a span.yiv1252408896yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1252408896 .yiv1252408896green {color:#628c2a;}#yiv1252408896 .yiv1252408896MsoNormal {margin:0 0 0 0;}#yiv1252408896 o {font-size:0;}#yiv1252408896 #yiv1252408896photos div {float:left;width:72px;}#yiv1252408896 #yiv1252408896photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1252408896 #yiv1252408896photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1252408896 #yiv1252408896reco-category {font-size:77%;}#yiv1252408896 #yiv1252408896reco-desc {font-size:77%;}#yiv1252408896 .yiv1252408896replbq {margin:4px;}#yiv1252408896 #yiv1252408896ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1252408896 #yiv1252408896ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1252408896 #yiv1252408896ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1252408896 #yiv1252408896ygrp-mlmsg select, #yiv1252408896 input, #yiv1252408896 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1252408896 #yiv1252408896ygrp-mlmsg pre, #yiv1252408896 code {font:115% monospace;}#yiv1252408896 #yiv1252408896ygrp-mlmsg * {line-height:1.22em;}#yiv1252408896 #yiv1252408896ygrp-mlmsg #yiv1252408896logo {padding-bottom:10px;}#yiv1252408896 #yiv1252408896ygrp-msg p a {font-family:Verdana;}#yiv1252408896 #yiv1252408896ygrp-msg p#yiv1252408896attach-count span {color:#1E66AE;font-weight:700;}#yiv1252408896 #yiv1252408896ygrp-reco #yiv1252408896reco-head {color:#ff7900;font-weight:700;}#yiv1252408896 #yiv1252408896ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1252408896 #yiv1252408896ygrp-sponsor #yiv1252408896ov li a {font-size:130%;text-decoration:none;}#yiv1252408896 #yiv1252408896ygrp-sponsor #yiv1252408896ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1252408896 #yiv1252408896ygrp-sponsor #yiv1252408896ov ul {margin:0;padding:0 0 0 8px;}#yiv1252408896 #yiv1252408896ygrp-text {font-family:Georgia;}#yiv1252408896 #yiv1252408896ygrp-text p {margin:0 0 1em 0;}#yiv1252408896 #yiv1252408896ygrp-text tt {font-size:120%;}#yiv1252408896 #yiv1252408896ygrp-vital ul li:last-child {border-right:none !important;}#yiv1252408896
Here is some info on the "W" after SPX... Appreciate what you do, thx.Tim
The Chicago Board Options Exchange (CBOE) trades options on the S&P 500 Index (SPX) with two types of expirations and settlements.
SPX options ordinarily cease trading on the business day (usually a Thursday) preceding the day on which the exercise-settlement value is calculated. The exercise-settlement value is calculated using the opening sales price in the primary market of each component stock on the last business day (usually a Friday) before the expiration date. This is called "AM settlement." SPXW options are weekly options that generally start trading on Thursdays and expire on Fridays, except in some circumstances.1 SPXW options trade until 4:00 p.m. ET on expiration day. Unlike SPX options, SPXW options are "PM-settled," meaning the exercise-settlement value is calculated using the last (closing) reported sales price in the primary market of each component stock on the expiration date. 1 Weekly options are not listed if they would expire on the third Friday of the month or if a quarterly option is set to expire on the same day.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, October 6, 2016 5:53 PM
Subject: Re: [smf_addin] Re: Index Calls
When I was doing my testing today, I was finding response times from OptionsXpress running between 59 and 193 seconds apiece.
It may be more of a matter of finding a good source of index options and utilizing it, rather than trying to force fit it into the current data sources.
So I guess it's more of a convenience issue than anything else. For the most part, the smfGetOptionQuotes() function just uses a common ticker symbol defined by me, a more readable one, to communicate with the various sources. It then calls other add-in functions to get the actual data. The other functions could be used directly by anyone, similar to the RCHGetTableCell() one I just gave you in the other message.
On Thu, Oct 6, 2016 at 3:36 PM, bob_15861586@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Do you have a desire to support these index options? I know that it would help me but I am not sure how many other users it would help.
#yiv1252408896 #yiv1252408896 -- #yiv1252408896ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar