11 Messages
Digest #4037
Messages
Fri May 26, 2017 7:42 pm (PDT) . Posted by:
sjagers
Is anyone else having trouble getting info from Zacks website? GetElementNumbers 848, 850, 13885, 13888 quit working for me last week. I'm using the most current Elements text files and the new Beta version of the add-in. Any ideas or suggestions? Thanks.
Fri May 26, 2017 8:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried them with tickers MMM, IBM, and ED, and all four are working
here...
Was the Zacks website unavailable for a short while?
On Fri, May 26, 2017 at 7:42 PM, sjagers@
...wrote:
>
> Is anyone else having trouble getting info from Zacks website?
> GetElementNumbers 848, 850, 13885, 13888 quit working for me last week.
> I'm using the most current Elements text files and the new Beta version of
> the add-in. Any ideas or suggestions? Thanks.
>
here...
Was the Zacks website unavailable for a short while?
On Fri, May 26, 2017 at 7:42 PM, sjagers@
...wrote:
>
> Is anyone else having trouble getting info from Zacks website?
> GetElementNumbers 848, 850, 13885, 13888 quit working for me last week.
> I'm using the most current Elements text files and the new Beta version of
> the add-in. Any ideas or suggestions? Thanks.
>
Sat May 27, 2017 11:09 am (PDT) . Posted by:
sjagers
This is very puzzling, now.
I just installed the SMF Add-In on my wife's laptop (Windows 7 with Internet Explorer 11) and those Zacks element numbers work just fine.
But on my laptop (Windows Vista, Internet Explorer 9 and Firefox 52) they still don't work. And even more puzzling..... my Vista laptop can only view Zack's website when I use my Firefox browser. If I try to access their site with Internet Explorer 9, I get an error message: "Internet Explorer cannot display the webpage."
Does the SMF Add-In use a browser's settings/web access protocol by default? Zacks.com will open with IE11 and Firefox, but not IE9. Would this oddity be causing my problem.... something to do with IE9 on my Vista laptop? (IE9 is the last browser version for Vista)
Any ideas?
-Thanks
I just installed the SMF Add-In on my wife's laptop (Windows 7 with Internet Explorer 11) and those Zacks element numbers work just fine.
But on my laptop (Windows Vista, Internet Explorer 9 and Firefox 52) they still don't work. And even more puzzling....
Does the SMF Add-In use a browser'
Any ideas?
-Thanks
Sat May 27, 2017 12:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in uses Microsoft's XMLHTTP routine to grab source code of web
pages from the Internet, which is more or less the same engine they use for
IE. That's why the "Internet Options" need to be tweaked on a few items,
and why cookies need to be created using IE for websites that require a
login.
I was using Vista on my old machine, and had an older version of IE. I
don't recall having an issue with Zacks.
I wonder if you have a cookie problem, or cache problem, with IE9, on that
machine. You could try deleting cookies for Zacks and removing cached
pages. One item I sometimes do is a Ctrl+F5 on a web page -- it refreshes
all web page content from scratch.
On Sat, May 27, 2017 at 11:09 AM, sjagers@
...wrote:
>
> This is very puzzling, now.
>
> I just installed the SMF Add-In on my wife's laptop (Windows 7 with
> Internet Explorer 11) and those Zacks element numbers work just fine.
>
> But on my laptop (Windows Vista, Internet Explorer 9 and Firefox 52) they
> still don't work. And even more puzzling..... my Vista laptop can only
> view Zack's website when I use my Firefox browser. If I try to access
> their site with Internet Explorer 9, I get an error message: "Internet
> Explorer cannot display the webpage."
>
> Does the SMF Add-In use a browser's settings/web access protocol by
> default? Zacks.com will open with IE11 and Firefox, but not IE9. Would
> this oddity be causing my problem.... something to do with IE9 on my Vista
> laptop? (IE9 is the last browser version for Vista)
>
> Any ideas?
>
pages from the Internet, which is more or less the same engine they use for
IE. That's why the "Internet Options" need to be tweaked on a few items,
and why cookies need to be created using IE for websites that require a
login.
I was using Vista on my old machine, and had an older version of IE. I
don't recall having an issue with Zacks.
I wonder if you have a cookie problem, or cache problem, with IE9, on that
machine. You could try deleting cookies for Zacks and removing cached
pages. One item I sometimes do is a Ctrl+F5 on a web page -- it refreshes
all web page content from scratch.
On Sat, May 27, 2017 at 11:09 AM, sjagers@
...wrote:
>
> This is very puzzling, now.
>
> I just installed the SMF Add-In on my wife's laptop (Windows 7 with
> Internet Explorer 11) and those Zacks element numbers work just fine.
>
> But on my laptop (Windows Vista, Internet Explorer 9 and Firefox 52) they
> still don't work. And even more puzzling....
> view Zack's website when I use my Firefox browser. If I try to access
> their site with Internet Explorer 9, I get an error message: "Internet
> Explorer cannot display the webpage."
>
> Does the SMF Add-In use a browser'
> default? Zacks.com will open with IE11 and Firefox, but not IE9. Would
> this oddity be causing my problem.... something to do with IE9 on my Vista
> laptop? (IE9 is the last browser version for Vista)
>
> Any ideas?
>
Sat May 27, 2017 12:31 pm (PDT) . Posted by:
"Brad Reel" reeldeal9090
It's entirely possible that IE 9 renders the page differently than IE 11.
Having said that, I don't know if the IE that Excel uses to make a web call
is the "standard" version on the computer or if it is something embedded in
Excel. Hope that makes sense.
Having said all that, I suspect the Excel versions between the two
computers or the IE versions between the two computers are more likely the
culprit than Vista vs. Windows 7.
On Sat, May 27, 2017 at 2:07 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The add-in uses Microsoft's XMLHTTP routine to grab source code of web
> pages from the Internet, which is more or less the same engine they use for
> IE. That's why the "Internet Options" need to be tweaked on a few items,
> and why cookies need to be created using IE for websites that require a
> login.
>
> I was using Vista on my old machine, and had an older version of IE. I
> don't recall having an issue with Zacks.
>
> I wonder if you have a cookie problem, or cache problem, with IE9, on that
> machine. You could try deleting cookies for Zacks and removing cached
> pages. One item I sometimes do is a Ctrl+F5 on a web page -- it refreshes
> all web page content from scratch.
>
> On Sat, May 27, 2017 at 11:09 AM, sjagers@
> ...wrote:
>
>>
>> This is very puzzling, now.
>>
>> I just installed the SMF Add-In on my wife's laptop (Windows 7 with
>> Internet Explorer 11) and those Zacks element numbers work just fine.
>>
>> But on my laptop (Windows Vista, Internet Explorer 9 and Firefox 52) they
>> still don't work. And even more puzzling..... my Vista laptop can only
>> view Zack's website when I use my Firefox browser. If I try to access
>> their site with Internet Explorer 9, I get an error message: "Internet
>> Explorer cannot display the webpage."
>>
>> Does the SMF Add-In use a browser's settings/web access protocol by
>> default? Zacks.com will open with IE11 and Firefox, but not IE9. Would
>> this oddity be causing my problem.... something to do with IE9 on my Vista
>> laptop? (IE9 is the last browser version for Vista)
>>
>> Any ideas?
>>
>
>
>
Having said that, I don't know if the IE that Excel uses to make a web call
is the "standard" version on the computer or if it is something embedded in
Excel. Hope that makes sense.
Having said all that, I suspect the Excel versions between the two
computers or the IE versions between the two computers are more likely the
culprit than Vista vs. Windows 7.
On Sat, May 27, 2017 at 2:07 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The add-in uses Microsoft'
> pages from the Internet, which is more or less the same engine they use for
> IE. That's why the "Internet Options" need to be tweaked on a few items,
> and why cookies need to be created using IE for websites that require a
> login.
>
> I was using Vista on my old machine, and had an older version of IE. I
> don't recall having an issue with Zacks.
>
> I wonder if you have a cookie problem, or cache problem, with IE9, on that
> machine. You could try deleting cookies for Zacks and removing cached
> pages. One item I sometimes do is a Ctrl+F5 on a web page -- it refreshes
> all web page content from scratch.
>
> On Sat, May 27, 2017 at 11:09 AM, sjagers@
> ...wrote:
>
>>
>> This is very puzzling, now.
>>
>> I just installed the SMF Add-In on my wife's laptop (Windows 7 with
>> Internet Explorer 11) and those Zacks element numbers work just fine.
>>
>> But on my laptop (Windows Vista, Internet Explorer 9 and Firefox 52) they
>> still don't work. And even more puzzling....
>> view Zack's website when I use my Firefox browser. If I try to access
>> their site with Internet Explorer 9, I get an error message: "Internet
>> Explorer cannot display the webpage."
>>
>> Does the SMF Add-In use a browser'
>> default? Zacks.com will open with IE11 and Firefox, but not IE9. Would
>> this oddity be causing my problem.... something to do with IE9 on my Vista
>> laptop? (IE9 is the last browser version for Vista)
>>
>> Any ideas?
>>
>
>
>
Sat May 27, 2017 12:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is a difference between IE and the IE object used by EXCEL, at least
for me. I used this tool:
http://www.pinlady.net/PluginDetect/IE/
When I use IE, I get:
Your browser is IE: true
Your IE browser version: 11
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): null
IE browser version (derived from navigator.userAgent): 11
IE browser document mode: 11
When I use the IE object from EXCEL (keyboard shortcut alt+d+d+w), I get:
Your browser is IE: true
Your IE browser version: 11.296
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): 11.296.15063.0
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7
My login from IE is not reflected by the IE object in EXCEL. I can't even
visit the Yahoo historical quotes web page from the EXCEL IE object. It
tells me it can't find the web page.
On Sat, May 27, 2017 at 12:30 PM, Brad Reel brad.reel90@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> It's entirely possible that IE 9 renders the page differently than IE 11.
> Having said that, I don't know if the IE that Excel uses to make a web call
> is the "standard"; version on the computer or if it is something embedded in
> Excel. Hope that makes sense.
>
> Having said all that, I suspect the Excel versions between the two
> computers or the IE versions between the two computers are more likely the
> culprit than Vista vs. Windows 7.
>
>
for me. I used this tool:
http://www.pinlady.net/PluginDetect/IE/
When I use IE, I get:
Your browser is IE: true
Your IE browser version: 11
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): null
IE browser version (derived from navigator.userAgent): 11
IE browser document mode: 11
When I use the IE object from EXCEL (keyboard shortcut alt+d+d+w), I get:
Your browser is IE: true
Your IE browser version: 11.296
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or
browser mode): 11.296.15063.0
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7
My login from IE is not reflected by the IE object in EXCEL. I can't even
visit the Yahoo historical quotes web page from the EXCEL IE object. It
tells me it can't find the web page.
On Sat, May 27, 2017 at 12:30 PM, Brad Reel brad.reel90@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> It's entirely possible that IE 9 renders the page differently than IE 11.
> Having said that, I don't know if the IE that Excel uses to make a web call
> is the "standard"
> Excel. Hope that makes sense.
>
> Having said all that, I suspect the Excel versions between the two
> computers or the IE versions between the two computers are more likely the
> culprit than Vista vs. Windows 7.
>
>
Sat May 27, 2017 9:42 am (PDT) . Posted by:
sonofhercules
Randy -
Thanks, the beta version is working for me.
By the way, do you have an email address where I can reach you personally? No worries if you don't want to disclose, but I wanted to ask.
Regards,
Alex.
Thanks, the beta version is working for me.
By the way, do you have an email address where I can reach you personally? No worries if you don't want to disclose, but I wanted to ask.
Regards,
Alex.
Sat May 27, 2017 10:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's on every email I post to the group...but my filtering is very strict.
If it doesn't go into a folder, it often ends up in spam. Which is why I
ask people to send questions to the group. If they get set to me
personally, they often end up in the spam folder and I may not see them.
On Sat, May 27, 2017 at 9:42 AM, sonofhercules@
...wrote:
>
> Thanks, the beta version is working for me.
>
> By the way, do you have an email address where I can reach you
> personally? No worries if you don't want to disclose, but I wanted to ask.
>
>
If it doesn't go into a folder, it often ends up in spam. Which is why I
ask people to send questions to the group. If they get set to me
personally, they often end up in the spam folder and I may not see them.
On Sat, May 27, 2017 at 9:42 AM, sonofhercules@
...wrote:
>
> Thanks, the beta version is working for me.
>
> By the way, do you have an email address where I can reach you
> personally? No worries if you don't want to disclose, but I wanted to ask.
>
>
Sat May 27, 2017 11:05 am (PDT) . Posted by:
sonofhercules
Understood. I just wanted to contact you personally, in regards to a non-group question.
Sat May 27, 2017 5:47 pm (PDT) . Posted by:
lewglenn
When I issue the vba command:
Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", , 1)
I get correctly the serial dates in column 1 and adjusted close in column 2. The last row today (5/27/2017) is row number 3735.
However, when I look down my worksheet I see, beginning in row 17317, #N/A appearing in columns 1 and 2 and extending to row 20000.
Randy, Can you tell me why this is happening and what I might need to do to eliminate?
Thanks.
Range("
I get correctly the serial dates in column 1 and adjusted close in column 2. The last row today (5/27/2017) is row number 3735.
However, when I look down my worksheet I see, beginning in row 17317, #N/A appearing in columns 1 and 2 and extending to row 20000.
Randy, Can you tell me why this is happening and what I might need to do to eliminate?
Thanks.
Sat May 27, 2017 7:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just pass the pRows and pCols parameters as 20000,2. The function was only
filling up as much of the range as it had data to fill and left the rest
alone (causing the #N/A). If you tell it to return a 20000x2 range, it will
blank fill the unused portion of the range.
On Sat, May 27, 2017 at 5:47 PM, lewglenn@
...wrote:
> When I issue the vba command:
>
> Range("A1:B20000") = smfGetYahooHistory("IEF", , , "d", "dc", , 1)
>
> I get correctly the serial dates in column 1 and adjusted close in column
> 2. The last row today (5/27/2017) is row number 3735.
>
> However, when I look down my worksheet I see, beginning in row 17317, #N/A
> appearing in columns 1 and 2 and extending to row 20000.
>
> Randy, Can you tell me why this is happening and what I might need to do
> to eliminate?
>
>
filling up as much of the range as it had data to fill and left the rest
alone (causing the #N/A). If you tell it to return a 20000x2 range, it will
blank fill the unused portion of the range.
On Sat, May 27, 2017 at 5:47 PM, lewglenn@
...wrote:
> When I issue the vba command:
>
> Range("
>
> I get correctly the serial dates in column 1 and adjusted close in column
> 2. The last row today (5/27/2017) is row number 3735.
>
> However, when I look down my worksheet I see, beginning in row 17317, #N/A
> appearing in columns 1 and 2 and extending to row 20000.
>
> Randy, Can you tell me why this is happening and what I might need to do
> to eliminate?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar