6 Messages
Digest #3150
Messages
Thu Aug 14, 2014 11:27 am (PDT) . Posted by:
"Douglas Ohlman" jurisdoctor74
I have a brief question ...
I use most of the various option commands on a daily basis,
including the following one which downloads all of the available option expiration
dates:
=smfGetOptionExpirations("IBM","Y")
Today, Aug. 14, 2014, the above command simply
stopped working for no reason I can think of. When I remove the optional "Y"
reference, it functions normally.
Did Yahoo changes its coding or implement some
other change that would invalidate this command? Any ideas?
Doug
I use most of the various option commands on a daily basis,
including the following one which downloads all of the available option expiration
dates:
=smfGetOptionExpira
Today, Aug. 14, 2014, the above command simply
stopped working for no reason I can think of. When I remove the optional "Y"
reference, it functions normally.
Did Yahoo changes its coding or implement some
other change that would invalidate this command? Any ideas?
Doug
Thu Aug 14, 2014 1:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It appears the Yahoo API for options is not returning any data. I don't
know if that is a temporary glitch or a permanent one. It tells me there
are results, but then it doesn't return them.
Removing the "Y" parameter just sends you to the default source, Google.
For now, I guess using another data source is the workaround. If the API
stays down, I'll have to do it some other way.
On Thu, Aug 14, 2014 at 11:24 AM, Douglas Ohlman jurisdoctor74@... wrote:
>
> I have a brief question ...
>
> I use most of the various option commands on a daily basis, including the
> following one which downloads all of the available option expiration dates:
>
> =smfGetOptionExpirations("IBM","Y")
>
> Today, Aug. 14, 2014, the above command simply stopped working for no
> reason I can think of. When I remove the optional "Y" reference, it
> functions normally.
>
> Did Yahoo changes its coding or implement some other change that would
> invalidate this command? Any ideas?
>
>
know if that is a temporary glitch or a permanent one. It tells me there
are results, but then it doesn't return them.
Removing the "Y" parameter just sends you to the default source, Google.
For now, I guess using another data source is the workaround. If the API
stays down, I'll have to do it some other way.
On Thu, Aug 14, 2014 at 11:24 AM, Douglas Ohlman jurisdoctor74@
>
> I have a brief question ...
>
> I use most of the various option commands on a daily basis, including the
> following one which downloads all of the available option expiration dates:
>
> =smfGetOptionExpira
>
> Today, Aug. 14, 2014, the above command simply stopped working for no
> reason I can think of. When I remove the optional "Y" reference, it
> functions normally.
>
> Did Yahoo changes its coding or implement some other change that would
> invalidate this command? Any ideas?
>
>
Thu Aug 14, 2014 5:25 pm (PDT) . Posted by:
jurisdoctor74
Thanks, Randy, for lookinng into this problem. As you pointed out, Google is a viable alternative.
Regarding other useful sources for options information, the smfGetOptionQuotes command appears to work with Google, Options Express (limited function), and Yahoo. Your documentation also listed MSN and MarketWatch but I am unable to get these last two to work, e.g.,
smfGetOptionQuotes("IBM Sep 2014 $185 Call","v",0,"MSN")
smfGetOptionQuotes("IBM Sep 2014 $185 Call","v",0,"MW")
both yield "Error". Am I doing something wrong or are these no longer supported.
Thanks,
Doug
Regarding other useful sources for options information, the smfGetOptionQuotes command appears to work with Google, Options Express (limited function), and Yahoo. Your documentation also listed MSN and MarketWatch but I am unable to get these last two to work, e.g.,
smfGetOptionQuotes(
smfGetOptionQuotes(
both yield "Error"
Thanks,
Doug
Thu Aug 14, 2014 5:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
MSN and MarketWatch changed their web pages after I wrote the function.
I've not been able to figure out how to get either to work consistently.
MSN is using ticker symbols for options that I can't decipher, and
MarketWatch has been giving unreliable web pages (different listings at
different times).
At least last time I looked. I've checked them several times in the past.
Maybe it's time to try again...or to remove them from the documentation.
Sigh.
Personally, I tend to use OptionsXPress, as Yahoo and Google have also had
sporadic problems. Sometimes missing entire chains. Other times missing
expiration dates. Although OptionsXpress is a bit slower, I figure they'll
have more reliable data since they need to be used by actual traders...
On Thu, Aug 14, 2014 at 5:24 PM, jurisdoctor74@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks, Randy, for lookinng into this problem. As you pointed out, Google
> is a viable alternative.
> Regarding other useful sources for options information, the
> smfGetOptionQuotes command appears to work with Google, Options Express
> (limited function), and Yahoo. Your documentation also listed MSN and
> MarketWatch but I am unable to get these last two to work, e.g.,
> smfGetOptionQuotes("IBM Sep 2014 $185 Call","v",0,"MSN")
> smfGetOptionQuotes("IBM Sep 2014 $185 Call","v",0,"MW")
> both yield "Error". Am I doing something wrong or are these no longer
> supported.
>
>
I've not been able to figure out how to get either to work consistently.
MSN is using ticker symbols for options that I can't decipher, and
MarketWatch has been giving unreliable web pages (different listings at
different times).
At least last time I looked. I've checked them several times in the past.
Maybe it's time to try again...or to remove them from the documentation.
Sigh.
Personally, I tend to use OptionsXPress, as Yahoo and Google have also had
sporadic problems. Sometimes missing entire chains. Other times missing
expiration dates. Although OptionsXpress is a bit slower, I figure they'll
have more reliable data since they need to be used by actual traders...
On Thu, Aug 14, 2014 at 5:24 PM, jurisdoctor74@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Thanks, Randy, for lookinng into this problem. As you pointed out, Google
> is a viable alternative.
> Regarding other useful sources for options information, the
> smfGetOptionQuotes command appears to work with Google, Options Express
> (limited function), and Yahoo. Your documentation also listed MSN and
> MarketWatch but I am unable to get these last two to work, e.g.,
> smfGetOptionQuotes(
> smfGetOptionQuotes(
> both yield "Error"
> supported.
>
>
Thu Aug 14, 2014 6:45 pm (PDT) . Posted by:
digsupply
Thank you for your answer
I used FinViz to get the data I needed. But I came across two problems, field #68, Earnings Date, returns the value of the last earnings date, not the next, which is what I need.
The other problem is that the data returned is not in the same row as the tickers on my worksheet, apparently it sorts them alphabetically by company name.
As regards to your question, about why I am placing formulas into the cells, all my worksheets run macros, and then I use Range(xx)=Range(xx).value, therefore all the worksheets show only values.
I have uploaded some of my worksheets to folder:
Files - Uploads by forum members - Money making worksheets
1000 input tickers with RCHGetYahooQuotes function-2.xlsm
Barchart What Not and What Hot .xlsm
(https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/Money%20making%20worksheets/)
The data I want, which is the Next Earnings Date will be included in a workshhet like the ones I uploaded, which is already sorted out .
Best regards, Robert
I used FinViz to get the data I needed. But I came across two problems, field #68, Earnings Date, returns the value of the last earnings date, not the next, which is what I need.
The other problem is that the data returned is not in the same row as the tickers on my worksheet, apparently it sorts them alphabetically by company name.
As regards to your question, about why I am placing formulas into the cells, all my worksheets run macros, and then I use Range(xx)=Range(xx).value, therefore all the worksheets show only values.
I have uploaded some of my worksheets to folder:
Files - Uploads by forum members - Money making worksheets
1000 input tickers with RCHGetYahooQuotes function-2.xlsm
Barchart What Not and What Hot .xlsm
(https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/Money%20making%20worksheets/)
The data I want, which is the Next Earnings Date will be included in a workshhet like the ones I uploaded, which is already sorted out .
Best regards, Robert
Thu Aug 14, 2014 7:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Thu, Aug 14, 2014 at 6:45 PM, picsound@... wrote:
>
> I used FinViz to get the data I needed. But I came across two problems,
> field #68, Earnings Date, returns the value of the last earnings date, not
> the next, which is what I need.
>
Oops. I just saw they had an earnings date, and didn't look at it closely.
Sorry.
> The other problem is that the data returned is not in the same row as the
> tickers on my worksheet, apparently it sorts them alphabetically by company
> name.
>
Yeah. I don't know of any way to sort it, or leave it unsorted. They do
that automatically.
> As regards to your question, about why I am placing formulas into the
> cells, all my worksheets run macros, and then I use
> Range(xx)=Range(xx).value, therefore all the worksheets show only values.
>
Hmm. Sounds like you could just use the smfUpdateDownloadTable macro? The
beta version of the add-in has the ability to highlight a range in the
table (or rows, or columns), and just have the macro update that portion of
the table.
>
> I used FinViz to get the data I needed. But I came across two problems,
> field #68, Earnings Date, returns the value of the last earnings date, not
> the next, which is what I need.
>
Oops. I just saw they had an earnings date, and didn't look at it closely.
Sorry.
> The other problem is that the data returned is not in the same row as the
> tickers on my worksheet, apparently it sorts them alphabetically by company
> name.
>
Yeah. I don't know of any way to sort it, or leave it unsorted. They do
that automatically.
> As regards to your question, about why I am placing formulas into the
> cells, all my worksheets run macros, and then I use
> Range(xx)=Range(
>
Hmm. Sounds like you could just use the smfUpdateDownloadTa
beta version of the add-in has the ability to highlight a range in the
table (or rows, or columns), and just have the macro update that portion of
the table.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar