9 New Messages
Digest #2536
Messages
Thu Mar 7, 2013 4:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
But did you do an import of the web page after it was loaded, and see the
data you're looking for?
I think the "Roaming" folder is where EXCEL copies the add-ins it is using?
Re-booting shouldn't fix anything on add-in usage. Just exiting and
re-starting EXCEL should reset any add-in environment.
It doesn't make sense to me that 811-813 wouldn't work, but other
StockScores elements would. All of those elements are coming from the same
web page.
What do you get with the following functions:
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI
","title")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",1,">Momentum
Indicators")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",2,">Momentum
Indicators")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",3,">Momentum
Indicators")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",4,">Momentum
Indicators")
=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving
Average/Vol","100 Day Trend")
=RCHGetWebData("http://www.stockscores.com/quickreport.asp?ticker=SIRI
",1,200)
On Thu, Mar 7, 2013 at 2:56 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> To answer your questions:****
>
> ** **
>
> I am using IE version 9.0.13 (KB2792100) on both machines. I try to keep
> my machines up-to-date with Microsoft updates. ****
>
> ** **
>
> When I click yes and continue the web page loads with every field correct.
> The webpage looks the same if I reply Y or N****
>
> ** **
>
> Well, I have good news and Bad news. ****
>
> ** **
>
> I discovered an old copy of the Addin in the appData/Roaming/Microsoft/Addin
> folder. I had deleted it twice. But I guess I must have done something
> between the delete and the reboot to cause it to reappear. ****
>
> ** **
>
> For the third time I remove every reference to the Addin from my Vista
> machine. I did the same thing I had done previously deleting, rebooting,
> re-downloading, and re-installing.****
>
> ** **
>
> *Good news is all MSN elements now work.*
>
> * *
>
> *Good news now all Stockscores elements except 811-813 work but then they
> worked before*
>
> ** **
>
> *Bad news 811 -813 now fails for all symbols. I can live with not having
> that information but it would be nice to know why it fails.*
>
data you're looking for?
I think the "Roaming" folder is where EXCEL copies the add-ins it is using?
Re-booting shouldn'
re-starting EXCEL should reset any add-in environment.
It doesn't make sense to me that 811-813 wouldn't work, but other
StockScores elements would. All of those elements are coming from the same
web page.
What do you get with the following functions:
=smfGetTagContent(
","
=smfGetTagContent(
Indicators"
=smfGetTagContent(
Indicators"
=smfGetTagContent(
Indicators"
=smfGetTagContent(
Indicators"
=RCHGetTableCell(
Average/Vol"
=RCHGetWebData(
",1,200)
On Thu, Mar 7, 2013 at 2:56 PM, Kermit W. Prather
<kermitp@tampabay.
>
> To answer your questions:**
>
> ** **
>
> I am using IE version 9.0.13 (KB2792100) on both machines. I try to keep
> my machines up-to-date with Microsoft updates. ****
>
> ** **
>
> When I click yes and continue the web page loads with every field correct.
> The webpage looks the same if I reply Y or N****
>
> ** **
>
> Well, I have good news and Bad news. ****
>
> ** **
>
> I discovered an old copy of the Addin in the appData/Roaming/
> folder. I had deleted it twice. But I guess I must have done something
> between the delete and the reboot to cause it to reappear. ****
>
> ** **
>
> For the third time I remove every reference to the Addin from my Vista
> machine. I did the same thing I had done previously deleting, rebooting,
> re-downloading, and re-installing.
>
> ** **
>
> *Good news is all MSN elements now work.*
>
> * *
>
> *Good news now all Stockscores elements except 811-813 work but then they
> worked before*
>
> ** **
>
> *Bad news 811 -813 now fails for all symbols. I can live with not having
> that information but it would be nice to know why it fails.*
>
Thu Mar 7, 2013 4:27 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
Yes, I imported it and all the data was there.
Excel does not copy the addin it uses it where it is I'm pretty sure.
Rebooting was more to clean up the temp files
The addin is now in a folder C:SMFADDIN and working for the most part.
I get this for the
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","title")
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > Stockscores Quick Report - SIRI
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",1,">Momentum Indicators")
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > <td class=table-content1>10 Day Trend </td> <td class=table-content1><img src="images/bullish_small.gif" border=0 alt="Bullish"> bullish</td>
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",2,">Momentum Indicators")
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > <td class=table-content2>40 Day Trend </td> <td class=table-content2><img src="images/bullish_small.gif" border=0 alt="Bullish"> bullish</td>
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",3,">Momentum Indicators")
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > <td class=table-content1>100 Day Trend </td> <td class=table-content1><img src="images/bullish_small.gif" border=0 alt="Bullish"> bullish</td>
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",4,">Momentum Indicators")
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > <td class=table-content2>Stochastics </td> <td class=table-content2><img src="images/neutral_small.gif" border=0 alt="Neutral"> neutral </td>
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving Average/Vol","100 Day Trend")
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > Error
<http://www.stockscores.com/quickreport.asp?ticker=SIRI > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>Stockscores Quick Report - SIRI</title><meta http-equiv=Content-Type content="text/html; charset=UTF-8"><meta name="g
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, March 07, 2013 7:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] I NEED HELP - this is driving me nuts
But did you do an import of the web page after it was loaded, and see the data you're looking for?
I think the "Roaming" folder is where EXCEL copies the add-ins it is using?
Re-booting shouldn't fix anything on add-in usage. Just exiting and re-starting EXCEL should reset any add-in environment.
It doesn't make sense to me that 811-813 wouldn't work, but other StockScores elements would. All of those elements are coming from the same web page.
What do you get with the following functions:
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","title")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",1,">Momentum Indicators")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",2,">Momentum Indicators")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",3,">Momentum Indicators")
=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker=SIRI ","tr",4,">Momentum Indicators")
=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving Average/Vol","100 Day Trend")
=RCHGetWebData("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,200)
On Thu, Mar 7, 2013 at 2:56 PM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
To answer your questions:
I am using IE version 9.0.13 (KB2792100) on both machines. I try to keep my machines up-to-date with Microsoft updates.
When I click yes and continue the web page loads with every field correct. The webpage looks the same if I reply Y or N
Well, I have good news and Bad news.
I discovered an old copy of the Addin in the appData/Roaming/Microsoft/Addin folder. I had deleted it twice. But I guess I must have done something between the delete and the reboot to cause it to reappear.
For the third time I remove every reference to the Addin from my Vista machine. I did the same thing I had done previously deleting, rebooting, re-downloading, and re-installing.
Good news is all MSN elements now work.
Good news now all Stockscores elements except 811-813 work but then they worked before
Bad news 811 -813 now fails for all symbols. I can live with not having that information but it would be nice to know why it fails.
Excel does not copy the addin it uses it where it is I'm pretty sure.
Rebooting was more to clean up the temp files
The addin is now in a folder C:SMFADDIN and working for the most part.
I get this for the
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
<http://www.stocksco
From: smf_addin@yahoogrou
Sent: Thursday, March 07, 2013 7:16 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] I NEED HELP - this is driving me nuts
But did you do an import of the web page after it was loaded, and see the data you're looking for?
I think the "Roaming" folder is where EXCEL copies the add-ins it is using?
Re-booting shouldn'
It doesn't make sense to me that 811-813 wouldn't work, but other StockScores elements would. All of those elements are coming from the same web page.
What do you get with the following functions:
=smfGetTagContent(
=smfGetTagContent(
=smfGetTagContent(
=smfGetTagContent(
=smfGetTagContent(
=RCHGetTableCell(
=RCHGetWebData(
On Thu, Mar 7, 2013 at 2:56 PM, Kermit W. Prather <kermitp@tampabay.
To answer your questions:
I am using IE version 9.0.13 (KB2792100) on both machines. I try to keep my machines up-to-date with Microsoft updates.
When I click yes and continue the web page loads with every field correct. The webpage looks the same if I reply Y or N
Well, I have good news and Bad news.
I discovered an old copy of the Addin in the appData/Roaming/
For the third time I remove every reference to the Addin from my Vista machine. I did the same thing I had done previously deleting, rebooting, re-downloading, and re-installing.
Good news is all MSN elements now work.
Good news now all Stockscores elements except 811-813 work but then they worked before
Bad news 811 -813 now fails for all symbols. I can live with not having that information but it would be nice to know why it fails.
Thu Mar 7, 2013 4:34 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Looks like the element should work, based on the results you showed. Sigh.
How about:
=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",0,"Moving
Average/Vol")
=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",0,"Moving
Average/")
=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI
",0,">sector")
On Thu, Mar 7, 2013 at 5:26 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> Yes, I imported it and all the data was there.****
>
> ** **
>
> Excel does not copy the addin it uses it where it is I'm pretty sure.****
>
> ** **
>
> Rebooting was more to clean up the temp files****
>
> ** **
>
> The addin is now in a folder C:SMFADDIN and working for the most part. ***
> *
>
> ** **
>
> I get this for the ...
>
How about:
=RCHGetTableCell(
Average/Vol"
=RCHGetTableCell(
Average/"
=RCHGetTableCell(
",0,"
On Thu, Mar 7, 2013 at 5:26 PM, Kermit W. Prather
<kermitp@tampabay.
>
> Yes, I imported it and all the data was there.****
>
> ** **
>
> Excel does not copy the addin it uses it where it is I'm pretty sure.****
>
> ** **
>
> Rebooting was more to clean up the temp files****
>
> ** **
>
> The addin is now in a folder C:SMFADDIN and working for the most part. ***
> *
>
> ** **
>
> I get this for the ...
>
Thu Mar 7, 2013 5:53 pm (PST) . Posted by:
"B Roberts" broberts1745
Thu Mar 7, 2013 6:27 pm (PST) . Posted by:
"ilmostro" ilmostro
I was using the smf addin to get some data from IBD's stock checkup and quote pages and it was only getting some of the data. I logged out of IBD using my normal browser and used excel to log back into IBD and that didn't fix it as it normally does. For some reason I typed in a stock symbol in lower caps and it got all the data I wanted. I tried some other symbols capitalized and it got all the data and some other symbols that are capitalized doesn't get all the data, but it always gets all the data when the symbols are lowercase. Anybody else notice this?
Thanks,
Bryan
Thanks,
Bryan
Thu Mar 7, 2013 6:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Using lower case versus upper case would get you a different web page,
using the add-in, because it saves a copy of the URL address.
So, if you get an error using upper case because of some temporary error,
doing it again with lower case will attempt to get a fresh copy of the web
page. But if the web page retrieved with the upper case ticker symbol had
some type of retrieval error, then all functions attempting to retrieve
data from that URL will probably have error as well, since they are all
attempting to extract data from the saved copy of the web page.
You're not exceeding IBD's limits, are you? Their terms of service limit
how many checkups you can do within a 24-hour period.
On Thu, Mar 7, 2013 at 7:27 PM, ilmostro <ilmostrobtw@gmail.com > wrote:
> I was using the smf addin to get some data from IBD's stock checkup and
> quote pages and it was only getting some of the data. I logged out of IBD
> using my normal browser and used excel to log back into IBD and that didn't
> fix it as it normally does. For some reason I typed in a stock symbol in
> lower caps and it got all the data I wanted. I tried some other symbols
> capitalized and it got all the data and some other symbols that are
> capitalized doesn't get all the data, but it always gets all the data when
> the symbols are lowercase. Anybody else notice this?
>
using the add-in, because it saves a copy of the URL address.
So, if you get an error using upper case because of some temporary error,
doing it again with lower case will attempt to get a fresh copy of the web
page. But if the web page retrieved with the upper case ticker symbol had
some type of retrieval error, then all functions attempting to retrieve
data from that URL will probably have error as well, since they are all
attempting to extract data from the saved copy of the web page.
You're not exceeding IBD's limits, are you? Their terms of service limit
how many checkups you can do within a 24-hour period.
On Thu, Mar 7, 2013 at 7:27 PM, ilmostro <ilmostrobtw@
> I was using the smf addin to get some data from IBD's stock checkup and
> quote pages and it was only getting some of the data. I logged out of IBD
> using my normal browser and used excel to log back into IBD and that didn't
> fix it as it normally does. For some reason I typed in a stock symbol in
> lower caps and it got all the data I wanted. I tried some other symbols
> capitalized and it got all the data and some other symbols that are
> capitalized doesn't get all the data, but it always gets all the data when
> the symbols are lowercase. Anybody else notice this?
>
Thu Mar 7, 2013 6:45 pm (PST) . Posted by:
"Bryan" ilmostro
Nope not exceeding IBD's limits. Just grabbed data for about 15
symbols. I can type a symbol in upper case and it only gets a few of
the data elements. Then I can type the same symbol lowercase and it
gets all the data elements. Very strange indeed.
Some symbols it doesn't matter upper or lowercase. Some symbols it
will only grab all the data if in lowercase.
Thanks,
Bryan
On 3/7/13, Randy Harmelink <rharmelink@gmail.com > wrote:
> Using lower case versus upper case would get you a different web page,
> using the add-in, because it saves a copy of the URL address.
>
> So, if you get an error using upper case because of some temporary error,
> doing it again with lower case will attempt to get a fresh copy of the web
> page. But if the web page retrieved with the upper case ticker symbol had
> some type of retrieval error, then all functions attempting to retrieve
> data from that URL will probably have error as well, since they are all
> attempting to extract data from the saved copy of the web page.
>
> You're not exceeding IBD's limits, are you? Their terms of service limit
> how many checkups you can do within a 24-hour period.
>
> On Thu, Mar 7, 2013 at 7:27 PM, ilmostro <ilmostrobtw@gmail.com > wrote:
>
>> I was using the smf addin to get some data from IBD's stock checkup and
>> quote pages and it was only getting some of the data. I logged out of
>> IBD
>> using my normal browser and used excel to log back into IBD and that
>> didn't
>> fix it as it normally does. For some reason I typed in a stock symbol in
>> lower caps and it got all the data I wanted. I tried some other symbols
>> capitalized and it got all the data and some other symbols that are
>> capitalized doesn't get all the data, but it always gets all the data
>> when
>> the symbols are lowercase. Anybody else notice this?
>>
>
symbols. I can type a symbol in upper case and it only gets a few of
the data elements. Then I can type the same symbol lowercase and it
gets all the data elements. Very strange indeed.
Some symbols it doesn't matter upper or lowercase. Some symbols it
will only grab all the data if in lowercase.
Thanks,
Bryan
On 3/7/13, Randy Harmelink <rharmelink@gmail.
> Using lower case versus upper case would get you a different web page,
> using the add-in, because it saves a copy of the URL address.
>
> So, if you get an error using upper case because of some temporary error,
> doing it again with lower case will attempt to get a fresh copy of the web
> page. But if the web page retrieved with the upper case ticker symbol had
> some type of retrieval error, then all functions attempting to retrieve
> data from that URL will probably have error as well, since they are all
> attempting to extract data from the saved copy of the web page.
>
> You're not exceeding IBD's limits, are you? Their terms of service limit
> how many checkups you can do within a 24-hour period.
>
> On Thu, Mar 7, 2013 at 7:27 PM, ilmostro <ilmostrobtw@
>
>> I was using the smf addin to get some data from IBD's stock checkup and
>> quote pages and it was only getting some of the data. I logged out of
>> IBD
>> using my normal browser and used excel to log back into IBD and that
>> didn't
>> fix it as it normally does. For some reason I typed in a stock symbol in
>> lower caps and it got all the data I wanted. I tried some other symbols
>> capitalized and it got all the data and some other symbols that are
>> capitalized doesn't get all the data, but it always gets all the data
>> when
>> the symbols are lowercase. Anybody else notice this?
>>
>
Thu Mar 7, 2013 7:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It doesn't make sense to be that it would only get a few of the data
elements, since all elements are extracted from a saved copy of the web
page. That would imply that the retrieved web page got truncated somehow.
I remember one person had problems on another service when he tried to
access a number of their web pages. After about 10 or so, it started
returning errors for everything. It turned out it was because the website
was returning a web page saying something like, "It appears an automated
process is accessing the website instead of an individual". So, obviously,
nothing to extract from those web pages.
On Thu, Mar 7, 2013 at 7:45 PM, Bryan <ilmostrobtw@gmail.com > wrote:
> Nope not exceeding IBD's limits. Just grabbed data for about 15
> symbols. I can type a symbol in upper case and it only gets a few of
> the data elements. Then I can type the same symbol lowercase and it
> gets all the data elements. Very strange indeed.
> Some symbols it doesn't matter upper or lowercase. Some symbols it
> will only grab all the data if in lowercase.
>
elements, since all elements are extracted from a saved copy of the web
page. That would imply that the retrieved web page got truncated somehow.
I remember one person had problems on another service when he tried to
access a number of their web pages. After about 10 or so, it started
returning errors for everything. It turned out it was because the website
was returning a web page saying something like, "It appears an automated
process is accessing the website instead of an individual"
nothing to extract from those web pages.
On Thu, Mar 7, 2013 at 7:45 PM, Bryan <ilmostrobtw@
> Nope not exceeding IBD's limits. Just grabbed data for about 15
> symbols. I can type a symbol in upper case and it only gets a few of
> the data elements. Then I can type the same symbol lowercase and it
> gets all the data elements. Very strange indeed.
> Some symbols it doesn't matter upper or lowercase. Some symbols it
> will only grab all the data if in lowercase.
>
Thu Mar 7, 2013 7:40 pm (PST) . Posted by:
"Bryan" ilmostro
yeah I know it doesn't make sense. just tried it again and now it is
working as it should.
Thanks,
Bryan
On 3/7/13, Randy Harmelink <rharmelink@gmail.com > wrote:
> It doesn't make sense to be that it would only get a few of the data
> elements, since all elements are extracted from a saved copy of the web
> page. That would imply that the retrieved web page got truncated somehow.
>
> I remember one person had problems on another service when he tried to
> access a number of their web pages. After about 10 or so, it started
> returning errors for everything. It turned out it was because the website
> was returning a web page saying something like, "It appears an automated
> process is accessing the website instead of an individual". So, obviously,
> nothing to extract from those web pages.
>
> On Thu, Mar 7, 2013 at 7:45 PM, Bryan <ilmostrobtw@gmail.com > wrote:
>
>> Nope not exceeding IBD's limits. Just grabbed data for about 15
>> symbols. I can type a symbol in upper case and it only gets a few of
>> the data elements. Then I can type the same symbol lowercase and it
>> gets all the data elements. Very strange indeed.
>> Some symbols it doesn't matter upper or lowercase. Some symbols it
>> will only grab all the data if in lowercase.
>>
>
working as it should.
Thanks,
Bryan
On 3/7/13, Randy Harmelink <rharmelink@gmail.
> It doesn't make sense to be that it would only get a few of the data
> elements, since all elements are extracted from a saved copy of the web
> page. That would imply that the retrieved web page got truncated somehow.
>
> I remember one person had problems on another service when he tried to
> access a number of their web pages. After about 10 or so, it started
> returning errors for everything. It turned out it was because the website
> was returning a web page saying something like, "It appears an automated
> process is accessing the website instead of an individual"
> nothing to extract from those web pages.
>
> On Thu, Mar 7, 2013 at 7:45 PM, Bryan <ilmostrobtw@
>
>> Nope not exceeding IBD's limits. Just grabbed data for about 15
>> symbols. I can type a symbol in upper case and it only gets a few of
>> the data elements. Then I can type the same symbol lowercase and it
>> gets all the data elements. Very strange indeed.
>> Some symbols it doesn't matter upper or lowercase. Some symbols it
>> will only grab all the data if in lowercase.
>>
>
Tidak ada komentar:
Posting Komentar