10 New Messages
Digest #2902
Messages
Sat Dec 21, 2013 9:40 am (PST) . Posted by:
"Randy Harmelink" rharmelink
"Obsolete"; sounds like something RCHGetElementNumber() would return, not
RCHGetYahooQuotes(). If it is RCHGetYahooQuotes(), I'd like to see the
exact function invocation. Off-hand, I can't think of a way for
RCHGetYahooQuotes() to return "Obsolete"; unless Yahoo is sending such data
-- but I could be wrong.
But I suspect you are using element #25 of RCHGetElementNumber() to get the
"Last Price" from MSN.
When MSN changed their web pages early last year, they started posting the
previous day's closing price as the "Last Price". So I decided to obsolete
the element when I was updating various MSN data elements this year.
On Sat, Dec 21, 2013 at 9:54 AM, lucas_scanlon <lucas_scanlon@yahoo.com>wrote:
> Hi Guys, I'm seeing an error not yet mentioned, so I wanted to add for
> triage.
>
> I'm running a virtual machine on a mac, using Windows 8 and Excel 2013. Up
> until last week getYahooQuote was solid, but now I will simple get the
> ticket back or "obsolete";. usually not even error.
>
> any ideas? I've removed and added the SMF add in and the files in my SMF
> folder a couple of times (using both the 2012 standard and the 2013 beta
> version in Working Files), and same experience with both.
>
> Any ideas?
>
RCHGetYahooQuotes(
exact function invocation. Off-hand, I can't think of a way for
RCHGetYahooQuotes(
-- but I could be wrong.
But I suspect you are using element #25 of RCHGetElementNumber
"Last Price" from MSN.
When MSN changed their web pages early last year, they started posting the
previous day's closing price as the "Last Price". So I decided to obsolete
the element when I was updating various MSN data elements this year.
On Sat, Dec 21, 2013 at 9:54 AM, lucas_scanlon <lucas_scanlon@
> Hi Guys, I'm seeing an error not yet mentioned, so I wanted to add for
> triage.
>
> I'm running a virtual machine on a mac, using Windows 8 and Excel 2013. Up
> until last week getYahooQuote was solid, but now I will simple get the
> ticket back or "obsolete"
>
> any ideas? I've removed and added the SMF add in and the files in my SMF
> folder a couple of times (using both the 2012 standard and the 2013 beta
> version in Working Files), and same experience with both.
>
> Any ideas?
>
Sat Dec 21, 2013 9:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Can you still visit the Zacks web page with IE and see the data? We had
someone a while back that was getting empty pages from Zacks for a while. I
thought it might be related to overuse of their website. Where you getting
Zacks ranks for a lot of stocks?
But there could be an issue on the IE side. If so, clearing the cached
files might help. Or deleting the cookies related to Zacks.
Did you try smfForceRecalculation (see LINKS area of group for info on it)?
But just exiting and restarting EXCEL would reload the add-in from scratch.
On Sat, Dec 21, 2013 at 10:37 AM, <mb0329@msn.com> wrote:
>
> I pasted your equation in an Excel spreadsheet and still get an error
> message. I am using Excel 2013 . It was working a few days ago so something
> has changed somewhere. Would it help for me to delete the smf software and
> reload it?
>
someone a while back that was getting empty pages from Zacks for a while. I
thought it might be related to overuse of their website. Where you getting
Zacks ranks for a lot of stocks?
But there could be an issue on the IE side. If so, clearing the cached
files might help. Or deleting the cookies related to Zacks.
Did you try smfForceRecalculati
But just exiting and restarting EXCEL would reload the add-in from scratch.
On Sat, Dec 21, 2013 at 10:37 AM, <mb0329@msn.com> wrote:
>
> I pasted your equation in an Excel spreadsheet and still get an error
> message. I am using Excel 2013 . It was working a few days ago so something
> has changed somewhere. Would it help for me to delete the smf software and
> reload it?
>
Sat Dec 21, 2013 10:00 am (PST) . Posted by:
zbgb952
Yes, I can still get to the zacks website and see the data with both IE and Firefox (I use Firefox mostly).
Using the smfforcerecalculation function didn't fix the problem either. I haven't tried erasing my cache as that causes other problems sometimes...
I just get error message for zacks. I tried a few other element numbers and they worked .
Using the smfforcerecalculati
I just get error message for zacks. I tried a few other element numbers and they worked .
Sat Dec 21, 2013 10:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
OK. Let's do some diagnostics then. Exit and restart EXCEL, and then tell
me what you get for:
=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM";,848)
=smfGetAParms(848)
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank
:"),": ","-"))
=RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks
Rank :",50)
=RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates
",1,50)
On Sat, Dec 21, 2013 at 11:00 AM, <mb0329@msn.com> wrote:
>
> Yes, I can still get to the zacks website and see the data with both IE
> and Firefox (I use Firefox mostly).
> Using the smfforcerecalculation function didn't fix the problem either. I
> haven't tried erasing my cache as that causes other problems sometimes...
>
> I just get error message for zacks. I tried a few other element numbers
> and they worked .
>
me what you get for:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=smfConvertData(
http://www.zacks.
:"),"
=RCHGetWebData(
Rank :",50)
=RCHGetWebData(
",1,50)
On Sat, Dec 21, 2013 at 11:00 AM, <mb0329@msn.com> wrote:
>
> Yes, I can still get to the zacks website and see the data with both IE
> and Firefox (I use Firefox mostly).
> Using the smfforcerecalculati
> haven't tried erasing my cache as that causes other problems sometimes...
>
> I just get error message for zacks. I tried a few other element numbers
> and they worked .
>
Sat Dec 21, 2013 12:59 pm (PST) . Posted by:
zbgb952
OK..
1. for =RCHGetElementNumber("Version"), I get,
Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-In; 1)
2. For =RCHGetElementNumber("MMM";,848) , I get
Error
3. For =smfGetAParms(848) , I get
Zacks;Zacks Rank;=0+smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/~~~~~/detailed-estimates","p",-1,"Zacks Rank:"),": ","-")
4. for
=smfConvertData(smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks Rank :"),": ","-")) , I get
3
5. For =RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks Rank :",50) , I get
Zacks Rank : 3-Hold <sup class="help_text" title="
6. and for
=RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates http://www.zacks.com/stock/quote/MMM/detailed-estimates",1,50), I get
<!DOCTYPE html><html lang="en"><!-- Faster page lo
******
All your examples seem to return a response except then 2nd one, which returns 'error'.
Thanks for your help.
1. for =RCHGetElementNumbe
Stock Market Functions add-in, Version 2.1.2012.12.
2. For =RCHGetElementNumbe
Error
3. For =smfGetAParms(
Zacks;Zacks Rank;=0+smfStrExtr(
4. for
=smfConvertData(
3
5. For =RCHGetWebData(
Zacks Rank : 3-Hold <sup class="
6. and for
=RCHGetWebData(
<!DOCTYPE html><
******
All your examples seem to return a response except then 2nd one, which returns 'error&#
Thanks for your help.
Sat Dec 21, 2013 1:41 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You need to get the updated element definitions for Zacks from the "Works
in Progress" folder.
See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/24294
The formula in item #4 is the current definition of the element.
On Sat, Dec 21, 2013 at 1:59 PM, <mb0329@msn.com> wrote:
> OK..
>
> 1. for =RCHGetElementNumber("Version"), I get,
>
>
> Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program
> Files\SMF Add-In; 1)
> 2. For =RCHGetElementNumber("MMM";,848) , I get
> Error
>
> 3. For =smfGetAParms(848) , I get
> Zacks;Zacks Rank;=0+smfStrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/~~~~~/detailed-estimates","p",-1,"Zacks
> Rank:"),": ","-")
> 4. for
> =smfConvertData(smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/quote/MMM/detailed-estimates","p",-1,"Zacks
> Rank :"),": ","-")) , I get
>
> 3
>
> 5. For =RCHGetWebData("
> http://www.zacks.com/stock/quote/MMM/detailed-estimates","Zacks Rank
> :",50) , I get
> Zacks Rank : 3-Hold <sup class="help_text" title="<http://www.zacks.com/stock/quote/MMM/detailed-estimates>
>
> 6. and for
> =RCHGetWebData("http://www.zacks.com/stock/quote/MMM/detailed-estimates",1,50),
> I get
>
> <!DOCTYPE html><html lang="en"><!-- Faster page lo
> ******
>
> All your examples seem to return a response except then 2nd one, which
> returns 'error'.
>
> Thanks for your help.
>
in Progress" folder.
See:
http://groups.
The formula in item #4 is the current definition of the element.
On Sat, Dec 21, 2013 at 1:59 PM, <mb0329@msn.com> wrote:
> OK..
>
> 1. for =RCHGetElementNumbe
>
>
> Stock Market Functions add-in, Version 2.1.2012.12.
> Files\SMF Add-In; 1)
> 2. For =RCHGetElementNumbe
> Error
>
> 3. For =smfGetAParms(
> Zacks;Zacks Rank;=0+smfStrExtr(
> http://www.zacks.
> Rank:")
> 4. for
> =smfConvertData(
> http://www.zacks.
> Rank :"),"
>
> 3
>
> 5. For =RCHGetWebData(
> http://www.zacks.
> :",50) , I get
> Zacks Rank : 3-Hold <sup class="
>
> 6. and for
> =RCHGetWebData(
> I get
>
> <!DOCTYPE html><
> ******
>
> All your examples seem to return a response except then 2nd one, which
> returns 'error&#
>
> Thanks for your help.
>
Sat Dec 21, 2013 7:42 pm (PST) . Posted by:
zbgb952
Seems to have worked! thx.
Sat Dec 21, 2013 8:44 pm (PST) . Posted by:
amitc@ymail.com
Hello,
Trying yahoo & 888 options are returning "Error". I rechecked & did not find anything wrong
The formula I am trying,
=smfGetYahooOptionQuote("XRT","Put",DATE(2015,1,1),85,"l")
=smfGet888OptionQuote("XRT","Put","1/1/2015",85,"l")
The options are there on their webpage
http://finance.yahoo.com/q/op?s=XRT&m=2015-01-17
http://www.optionseducation.org/quotes.html?quote=xrt
Excel is configured with RCH_Stock_Market_Functions-2.1.2013.10.17.zip
Any suggestions would be welcome.
Regards
Amit
Trying yahoo & 888 options are returning "Error"
The formula I am trying,
=smfGetYahooOptionQ
=smfGet888OptionQuo
The options are there on their webpage
http://finance.
http://www.optionse
Excel is configured with RCH_Stock_Market_
Any suggestions would be welcome.
Regards
Amit
Sat Dec 21, 2013 9:06 pm (PST) . Posted by:
amitc@ymail.com
Hi Randy
Ok, with more testing shows following
With 2.1.2012.12.29,
=smfGetYahooOptionQuote("XRT","P",DATE(2015,1,1),85,"l")
note "P" instead of "Put"
=smfGet888OptionQuote("XRT","P",DATE(2015,1,1),85,"l")
still does not work.
I am going back to the older version. Have many xls using smf-addin, so have forgotten why I moved to this one.
Also, will be good to have =smfGet888OptionQuote() working, they have many good info about a specific option.
Regards
Amit
Ok, with more testing shows following
With 2.1.2012.12.
=smfGetYahooOptionQ
note "P" instead of "Put"
=smfGet888OptionQuo
still does not work.
I am going back to the older version. Have many xls using smf-addin, so have forgotten why I moved to this one.
Also, will be good to have =smfGet888OptionQuo
Regards
Amit
Sat Dec 21, 2013 10:09 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
All of these work for me:
=smfGetYahooOptionQuote("XRT","P",DATE(2015,1,17),85,"l")
=smfGet888OptionQuote("XRT","P",DATE(2015,1,17),85,"l")
=smfGet888OptionQuote("XRT","Put",DATE(2015,1,17),85,"l")
=smfGetYahooOptionQuote("XRT","P",smfGetOptionExpiry(2015,1,"M"),85,"l")
However, note:
- The current version of the add-in no longer allows you to use the 1st
day of the month in a passed date to get the monthly option. I had to
remove that processing because weekly options can fall on the 1st day of
the month. So now you need to use the exact date or the
smfGetOptionExpiry() function (see last example above). Note that there may
be an issue with smfGetOptionExpiry() for 2016 and beyond -- I've been told
they've changed the expiration dates in option ticker symbols from
Saturdays to Fridays. So far that is true for LEAPS. At the moment,
however, exact dates do work.
- If you want to use the smfGet888OptionQuote() function, you do need to
manually create the security cookie first. That means going to get one
actual option quote web page at 888options.com. So, for example, the two
invocations above gave me "Error" at first. But I used the EXCEL Web Query
dialog (keyboard shortcut alt+d+d+w) to get a quote from their web page,
cancelled out, ran the smfForceRecalculation macro to tell the add-in to
get a fresh copy of the web page to extract data from, and they both
worked. However, I do see different values between Yahoo and
888options.com. But Yahoo is matching OptionsXPress. No clue what that
is about.
I changed the smfGetYahooOptionQuote() function to allow "Put" or "Call" to
be used. My error, sorry. So this works for me right now, with my version
of the add-in:
=smfGetYahooOptionQuote("XRT","Put",DATE(2015,1,17),85,"l")
There is a change log in the "Works in Progress" folder, so you can check
to see what changes have been made going forward from the last official
release of the add-in. For example, the two items I mention here are:
*Date* *Routine* *Description* 2013-01-04 smfGetMSNOptionQuote
smfGetOXOptionQuote
smfGetYahooOptionQuote
Remove day 1, 30, and 31 assumptions for option expiration date (because
weekly options can fall on those days) 2013-12-21 smfGetMSNOptionQuote
smfGetYahooOptionQuote
Fixed so that "Put" and "Call" strings can be passed as parameters instead
of just "P" and "C".
If you moved back to the 2012.12.29 version, make sure you have the updated
element definition files.
On Sat, Dec 21, 2013 at 9:44 PM, <ac11@rajgad.com> wrote:
>
> Trying yahoo & 888 options are returning "Error". I rechecked & did not
> find anything wrong
>
> The formula I am trying,
> =smfGetYahooOptionQuote("XRT","Put",DATE(2015,1,1),85,"l")
> =smfGet888OptionQuote("XRT","Put","1/1/2015",85,"l")
>
> The options are there on their webpage
> http://finance.yahoo.com/q/op?s=XRT&m=2015-01-17
> http://www.optionseducation.org/quotes.html?quote=xrt
>
> Excel is configured with RCH_Stock_Market_Functions-2.1.2013.10.17.zip
>
> Any suggestions would be welcome.
>
On Sat, Dec 21, 2013 at 10:06 PM, <ac11@rajgad.com> wrote:
>
> Ok, with more testing shows following
>
> With 2.1.2012.12.29,
>
> =smfGetYahooOptionQuote("XRT","P",DATE(2015,1,1),85,"l")
>
> note "P" instead of "Put"
>
> =smfGet888OptionQuote("XRT","P",DATE(2015,1,1),85,"l")
>
> still does not work.
>
> I am going back to the older version. Have many xls using smf-addin, so
> have forgotten why I moved to this one.
>
> Also, will be good to have =smfGet888OptionQuote() working, they have
> many good info about a specific option.
>
=smfGetYahooOptionQ
=smfGet888OptionQuo
=smfGet888OptionQuo
=smfGetYahooOptionQ
However, note:
- The current version of the add-in no longer allows you to use the 1st
day of the month in a passed date to get the monthly option. I had to
remove that processing because weekly options can fall on the 1st day of
the month. So now you need to use the exact date or the
smfGetOptionExpiry(
be an issue with smfGetOptionExpiry(
they've changed the expiration dates in option ticker symbols from
Saturdays to Fridays. So far that is true for LEAPS. At the moment,
however, exact dates do work.
- If you want to use the smfGet888OptionQuot
manually create the security cookie first. That means going to get one
actual option quote web page at 888options.com. So, for example, the two
invocations above gave me "Error" at first. But I used the EXCEL Web Query
dialog (keyboard shortcut alt+d+d+w) to get a quote from their web page,
cancelled out, ran the smfForceRecalculati
get a fresh copy of the web page to extract data from, and they both
worked. However, I do see different values between Yahoo and
888options.com. But Yahoo is matching OptionsXPress. No clue what that
is about.
I changed the smfGetYahooOptionQu
be used. My error, sorry. So this works for me right now, with my version
of the add-in:
=smfGetYahooOptionQ
There is a change log in the "Works in Progress" folder, so you can check
to see what changes have been made going forward from the last official
release of the add-in. For example, the two items I mention here are:
*Date* *Routine* *Description* 2013-01-04 smfGetMSNOptionQuot
smfGetOXOptionQuote
smfGetYahooOptionQu
Remove day 1, 30, and 31 assumptions for option expiration date (because
weekly options can fall on those days) 2013-12-21 smfGetMSNOptionQuot
smfGetYahooOptionQu
Fixed so that "Put" and "Call" strings can be passed as parameters instead
of just "P" and "C"
If you moved back to the 2012.12.29 version, make sure you have the updated
element definition files.
On Sat, Dec 21, 2013 at 9:44 PM, <ac11@rajgad.
>
> Trying yahoo & 888 options are returning "Error"
> find anything wrong
>
> The formula I am trying,
> =smfGetYahooOptionQ
> =smfGet888OptionQuo
>
> The options are there on their webpage
> http://finance.
> http://www.optionse
>
> Excel is configured with RCH_Stock_Market_
>
> Any suggestions would be welcome.
>
On Sat, Dec 21, 2013 at 10:06 PM, <ac11@rajgad.
>
> Ok, with more testing shows following
>
> With 2.1.2012.12.
>
> =smfGetYahooOptionQ
>
> note "P" instead of "Put"
>
> =smfGet888OptionQuo
>
> still does not work.
>
> I am going back to the older version. Have many xls using smf-addin, so
> have forgotten why I moved to this one.
>
> Also, will be good to have =smfGet888OptionQuo
> many good info about a specific option.
>
Tidak ada komentar:
Posting Komentar