Senin, 18 Juli 2016

[smf_addin] Digest Number 3748

13 Messages

Digest #3748
2a
Re: 888OptionQuote by chrishervochon
2b
Re: 888OptionQuote by "Randy Harmelink" rharmelink
2c
Re: 888OptionQuote by chrishervochon
2d
Re: 888OptionQuote by "Randy Harmelink" rharmelink

Messages

Sun Jul 17, 2016 7:31 am (PDT) . Posted by:

dleeper47

On or about July 12 or 13, RCHGetYahooQuotes suddenly stopped working in Excel2010/Windows10. I get only #NAME? for every entry.


Apparently(?) an Excel security update now inhibits the add-in from working, but only on initial launch of Excel, such as when double-clicking on the file icon.


A workaround is to go to File/Options/Add-Ins/Go. Then uncheck "Stock Market Functions Add-In" off, update the spreadsheet, and then check the same box to "on". That has worked every time.


I've recorded the above steps in a macro and added it to the ribbon at the top of the window. It's one extra click when I start Excel, but that's not so bad. And as long as I leave the Excel program window open, RCHGetYahooQuotes keeps working. The security bug (?) only raises its ugly head when Excel is initially launched.

Sun Jul 17, 2016 8:29 am (PDT) . Posted by:

"Dennis Ringler" daringler

dleeper, I have the same setup, Windows 10 with Office Pro 2010 with Windows updates on Automatic. Not getting any errors. Running StockMarketFunctions Add in Version 2.1.2014.01.30. Been watching others having problems since MS Update on 7/12/2016, and expecting an issue, but nothing has shown up. Is it a version issue??? Dennis

From: mailto:smf_addin@yahoogroups.com
Sent: Sunday, July 17, 2016 10:31 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] RCHGetYahooQuotes stops working - here's a workaround



On or about July 12 or 13, RCHGetYahooQuotes suddenly stopped working in Excel2010/Windows10. I get only #NAME? for every entry.




Apparently(?) an Excel security update now inhibits the add-in from working, but only on initial launch of Excel, such as when double-clicking on the file icon.




A workaround is to go to File/Options/Add-Ins/Go. Then uncheck "Stock Market Functions Add-In" off, update the spreadsheet, and then check the same box to "on". That has worked every time.




I've recorded the above steps in a macro and added it to the ribbon at the top of the window. It's one extra click when I start Excel, but that's not so bad. And as long as I leave the Excel program window open, RCHGetYahooQuotes keeps working. The security bug (?) only raises its ugly head when Excel is initially launched.

Sun Jul 17, 2016 11:42 am (PDT) . Posted by:

dleeper47

Hi, Dennis --

Thanks for the note. I have the latest RCH add-in. And auto-updates to Windows 10 and Excel 2010 correspond exactly to when the bug showed up. You may be luckier than I -- stay tuned!


Maybe the problem will go away with the next MS updates.


And maybe my hair will grow back overnight! :)


Dave

Sun Jul 17, 2016 11:49 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

​One thought I had was that having the add-in located in the "Program
Files" directory may be an issue.

I know when I converted to Vista from Windows XP, it would no longer allow
me to save updates to the VBA code of the add-in. That's why I moved my
location to "C:\SMF Add-in" instead.​

Sun Jul 17, 2016 1:39 pm (PDT) . Posted by:

daringler

I also have the add-in located in "C:\SMF Add-in" and not in "Program Files". My set up would be similar to Randy and I have had no issues all week. This would be easy to check out. Someone could try the add-in, in both places and see if there is a difference.

Sun Jul 17, 2016 1:42 pm (PDT) . Posted by:

dleeper47

Thanks, Randy!

I will check into that ... in fact I do have the add-in in "Program Files". Perhaps I could get around the security bug in Windows 10 (if that's indeed the cause) by locating the add-in elsewhere (like C:\).


I'm new to this Yahoo Group ... I believe you are the "RCH" in RCHGetYahooQuotes ... correct? If so, my thanks and compliments! I've been using this great add-in for years -- it's lightning-fast and free. I track over 100 issues with it in an Excel spreadsheet with an Excel array ... I'm an Excel novice, so it was tricky to get it working right, but well worth the effort!


Regards,


David

Sun Jul 17, 2016 2:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup. I'm the RCH. Initially, I wrote a few functions and shared them via
the "XL Traders" Yahoo group. So I just put my initials on the front of the
functions to identify them.

Eventually, I combined them into the add-in and named it "Stock Market
Functions" and the file got too large for that Yahoo group, so I started my
own. After that, all new functions started with smf. I would like to
convert them all to the smf prefix, but then it creates a headache for
anyone using them as the current RCH prefix. Backward compatibility can be
a sticky wicket. :(

When it comes down to it, I'm just sharing something I originally wrote for
my own use, because EXCEL 2003 kept crashing with the numerous queries I
used to run.

After more than a decade, I'm surprised there isn't a commercial service
that does a far better job of it. MSN used to have something similar to
RCHGetElementNumber(), but on a very limited number of items. GuruFocus is
close, with their downloadable workbooks.

On Sun, Jul 17, 2016 at 1:42 PM, dleeper@mail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks, Randy!
>
> I will check into that ... in fact I do have the add-in in "Program
> Files". Perhaps I could get around the security bug in Windows 10 (if
> that's indeed the cause) by locating the add-in elsewhere (like C:\).
>
> I'm new to this Yahoo Group ... I believe you are the "RCH" in
> RCHGetYahooQuotes ... correct? If so, my thanks and compliments! I've been
> using this great add-in for years -- it's lightning-fast and free. I track
> over 100 issues with it in an Excel spreadsheet with an Excel array ... I'm
> an Excel novice, so it was tricky to get it working right, but well worth
> the effort!
>
>
>

Sun Jul 17, 2016 3:12 pm (PDT) . Posted by:

dleeper47

Again, my compliments!

I may get deluged with hate mail, but you seem to keep the add-in up to date -- have you thought about at least accepting donations?


I've tried a couple commercial solutions, but none has been as fast (let alone as inexpensive) for an individual investor and Excel novice like me.

Sun Jul 17, 2016 3:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks, but I always ask people to "Pay it Forward" and give the donation
to a worthy charity.

On Sun, Jul 17, 2016 at 3:12 PM, dleeper@mail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> have you thought about at least accepting donations?
>
>
>

Sun Jul 17, 2016 11:53 am (PDT) . Posted by:

chrishervochon

Thanks, Randy. I went to the iVolatility website, logged in, and pulled up a quote for AAPL, then tried the formula again and it still didn't work. Do you think it has anything to do with the fact that I am on Windows 10, or using Excel 2016?

Sun Jul 17, 2016 1:50 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

A quick test to see if you have the security setup OK is to try and bring
up this web page in the EXCEL Web Query dialog (alt+d+d+w):

http://oic.ivolatility.com/oic_adv_options.j?exp_date=-1&ticker=IWM

It isn't necessarily the iVolatility website you need to go to. You need to
bring up the quotes page on 888options.com. They have a "partner" security
cookie that is being used. When I tried going to iVolatility directly (long
ago), their security was of a different nature and more difficult to
implement.

When you get to a quotes page like this via 888options:

http://www.optionseducation.org/quotes.html?quote=MMM

...what happens is that the iVolatility display on that web page is within
a frame. But the security is now in place to get the data within the frame.
The URL contained in that frame is something like the first URL I cited
above. THAT is where the add-in is extracting the data from. But it takes
the partner security cookie to get to it.

PS: You can't just "try the formula" again. If you already tried to
retrieve it with your exiting instance of EXCEL, the add-in has saved a
copy of that previous attempt, and will be extracting data from the same
web page it saved earlier. You'd either need to exit and restart EXCEL, or
run the smfForceRecalculation macro -- to clear out all of the saved web
pages and force them to be retrieved again. This time, with the security
cookie in place.

Ramble, ramble. I hope something of that is useful...?

On Sun, Jul 17, 2016 at 11:53 AM, chervochon@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks, Randy. I went to the iVolatility website, logged in, and pulled
> up a quote for AAPL, then tried the formula again and it still didn't
> work. Do you think it has anything to do with the fact that I am on
> Windows 10, or using Excel 2016?
>
>

Sun Jul 17, 2016 2:33 pm (PDT) . Posted by:

chrishervochon

Randy, Thanks for your time and the explanation. As always, very helpful.


After going through your note, I was able to successfully extract data using the function. However, it seems like I will need to open a new web query before using the function each time I start a new instance of Excel. Is there any way to work around that? In other words, if I save and close the file, then reopen it, I get "Error".


Thanks again!

Sun Jul 17, 2016 2:45 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I get "Error" as well. When I tried the "test" URL, I get the message that
the session had expired. So apparently the security cookie is only valid
for the current session.

I never noticed it before because EXCEL is one of the programs I ALWAYS
have open. :)

I'm not sure of a work-around. Seems like the IE session and Web Query
session might even be different ones. Not sure, since I don't use IE, and
it's actually an OLD, OLD version on my machine. Many sites tell me they
won't operate with it.

On Sun, Jul 17, 2016 at 2:33 PM, chervochon@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> However, it seems like I will need to open a new web query before using
> the function each time I start a new instance of Excel. Is there any way to
> work around that? In other words, if I save and close the file, then
> reopen it, I get "Error".
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar