Those appear to return bad data.

<http://www.stockscores.com/quickreport.asp?ticker=SIRI> /=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,"Moving Average/Vol")

<http://www.stockscores.com/quickreport.asp?ticker=SIRI> Error

<http://www.stockscores.com/quickreport.asp?ticker=SIRI> /=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,"Moving Average/")

<http://www.stockscores.com/quickreport.asp?ticker=SIRI> Error

<http://www.stockscores.com/quickreport.asp?ticker=SIRI> /=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,">sector")

<http://www.stockscores.com/quickreport.asp?ticker=SIRI> .yui-skin-sam .yui-navset .yui-nav a em {height: 28px;} tradingsectorchartprice
relativityvolume/
momentummov. avg
/volatilityLast Trade: 3/7/2013

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, March 07, 2013 7:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] I NEED HELP - this is driving me nuts

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 ...

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

1b

Re: I NEED HELP - this is driving me nuts

Fri Mar 8, 2013 7:38 am (PST) . Posted by:

Well, that explains it. The content of your web page is different than
mine. All three of those formulas return the same thing for me:

tradingsectorchartprice relativityvolume/momentummoving
average/volatilityLast Trade: 3/7/2013

Note that I have "moving average/volatility" and you have
"mov.avg/volatility".

Since the string on mine is the search string for elements #811-#813, it
doesn't find it on yours.

On Fri, Mar 8, 2013 at 6:57 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

> ** **
>
> Those appear to return bad data.****
>
> ** **
>
> ****
>
> ****
>
> ****
>
> */=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,"Moving
> Average/Vol") <http://www.stockscores.com/quickreport.asp?ticker=SIRI>*
>
> ****
>
> *Error <http://www.stockscores.com/quickreport.asp?ticker=SIRI>*
>
> */=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,"Moving
> Average/") <http://www.stockscores.com/quickreport.asp?ticker=SIRI>*
>
> ****
>
> *Error <http://www.stockscores.com/quickreport.asp?ticker=SIRI>*
>
> *
> /=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,">sector")<http://www.stockscores.com/quickreport.asp?ticker=SIRI>
> *
>
> ****
>
> *.yui-skin-sam .yui-navset .yui-nav a em {height: 28px;}
> tradingsectorchartprice
> relativityvolume/
> momentummov. avg
> /volatilityLast Trade: 3/7/2013<http://www.stockscores.com/quickreport.asp?ticker=SIRI>
> *
>
> ** **
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

1c

Re: I NEED HELP - this is driving me nuts

Fri Mar 8, 2013 11:50 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

That confuses me even more. How can I be getting a different page than you?

Viewing the webpage source, as of 3/8/12 2:47 pm, I find this code starting at line 555 thru 575.
I don't understand why the SMF addin would be picking up that value since it does not have the >sector anywhere close.
Sector is several lines down.

<br />
<table cellpadding="0" cellspacing="0" border="0" width="368" align="center">
<tr>
<td valign="top">

<style type="text/css">
.yui-skin-sam .yui-navset .yui-nav a em {height: 28px;}
</style>

<div class="yui-skin-sam">
<div id="demo" class="yui-navset">
<ul class="yui-nav">
<li class="selected"><a href="#tab1"><em style="width: 45px; text-align:center;">trading</em></a></li>
<li><a href="#tab2"><em style="width: 42px; text-align:center;">sector</em></a></li>
<li><a href="#tab3"><em style="width: 40px; text-align:center;">chart</em></a></li>
<li><a href="#tab4"><em style="width: 54px; text-align:center;">price<br>relativity</em></a></li>
<li><a href="#tab5"><em style="width: 68px; text-align:center;">volume/<br>momentum</em></a></li>
<li><a href="#tab6"><em style="width: 60px; text-align:center;">mov. avg<br>/volatility</em></a></li>
</ul>
<div class="yui-content";>
<div id="tab1">

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, March 08, 2013 10:39 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] I NEED HELP - this is driving me nuts

Well, that explains it. The content of your web page is different than mine. All three of those formulas return the same thing for me:

tradingsectorchartprice relativityvolume/momentummoving average/volatilityLast Trade: 3/7/2013

Note that I have "moving average/volatility" and you have "mov.avg/volatility".

Since the string on mine is the search string for elements #811-#813, it doesn't find it on yours.
On Fri, Mar 8, 2013 at 6:57 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

Those appear to return bad data.

/=RCHGetTableCell( <http://www.stockscores.com/quickreport.asp?ticker=SIRI http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,"Moving Average/Vol")

Error <http://www.stockscores.com/quickreport.asp?ticker=SIRI>

/=RCHGetTableCell( <http://www.stockscores.com/quickreport.asp?ticker=SIRI http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,"Moving Average/")

Error <http://www.stockscores.com/quickreport.asp?ticker=SIRI>

/=RCHGetTableCell( <http://www.stockscores.com/quickreport.asp?ticker=SIRI http://www.stockscores.com/quickreport.asp?ticker=SIRI",0,">sector")

.yui-skin-sam .yui-navset .yui-nav a em {height: 28px;} <http://www.stockscores.com/quickreport.asp?ticker=SIRI> tradingsectorchartprice
relativityvolume/
momentummov. avg
/volatilityLast Trade: 3/7/2013

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

1d

Re: I NEED HELP - this is driving me nuts

Fri Mar 8, 2013 12:02 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Because the RCHGetTableCell() function retrieves ALL of the contents of the
table cell, and then it removes everything that is between pairs of "<" and
">" (i.e. HTML tags). Note that all of your content below is within a
single table cell (and is also incomplete, since there is no ending table
cell tag in your listing).

I also don't understand why your source code is different than mine.
However, since the elements WERE working the other day, you must have been
getting the same source code then as I currently am.

On Fri, Mar 8, 2013 at 12:50 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> That confuses me even more. How can I be getting a different page than you?
> ****
>
> ** **
>
> Viewing the webpage source, as of 3/8/12 2:47 pm, I find this code
> starting at line 555 thru 575. ****
>
> I don't understand why the SMF addin would be picking up that value since
> it does not have the >sector anywhere close. ****
>
> Sector is several lines down.****
>
> ** **
>
> ** **
>
> <br />****
>
> <table cellpadding="0" cellspacing="0" border
> ="0" width="368" align="center"> ****
>
> <tr> ****
>
> <td valign="top">****
>
> ****
>
> <style type="text/
> css">****
>
> .yui-skin-sam.
> yui-navset .yui-nav a em {height: 28px;}
> ****
>
> </style>****
>
> ****
>
> <div class="yui-skin-sam"> ****
>
> <div id="demo" class="yui-navset">****
>
> <ul class
> ="yui-nav";>****
>
> <li
> class="selected"><a href="#tab1"><em style="width: 45px; text-align:center
> ;">trading</em></a></li>****
>
> <li><a
> href="#tab2"><em style="width: 42px; text-align:center;">sector</em></a></
> li>****
>
> <li><a
> href="#tab3"><em style="width: 40px; text-align:center;">chart</em></a></
> li>****
>
> <
> li><a href="#tab4"><em style="width: 54px; text-align:center;">price<br>
> relativity</em></a></li>****
>
> <li><a
> href="#tab5"><em style="width: 68px; text-align:center;">volume/<br>
> momentum</em></a></li>****
>
> <li><a
> href="#tab6"><em style="width: 60px; text-align:center;">mov. avg<br>
> /volatility</em></a></li>****
>
> </ul> ***
> *
>
> <div class="yui-content";>****
>
> <div id="tab1">
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

2a

RCHGetTableCell-Template-IBD-Stock-Checkup??

Fri Mar 8, 2013 9:01 am (PST) . Posted by:

"andyha8" andyha8

I don't understand how to use this sheet.
I have an account with IBD.
I go to the web query in excel and sign into IBD.
On the bottom of the window there is an import button, I click it
and it asks me where I want to put the data

This is what I don't get. Where should I tell it to save the data?
Thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2b

Re: RCHGetTableCell-Template-IBD-Stock-Checkup??

Fri Mar 8, 2013 11:44 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You don't want to actually import anything. Once you log in, you can just
cancel out the Web Query session. Logging in creates a security cookie that
EXCEL and the add-in use when it retrieves web pages from the IBD site.

Once you've logged in and created that security cookie, the add-in
functions should be able to retrieve the web pages and extract the
requested data items.

On Fri, Mar 8, 2013 at 10:01 AM, andyha8 <andyha8@gmail.com> wrote:

> I don't understand how to use this sheet.
> I have an account with IBD.
> I go to the web query in excel and sign into IBD.
> On the bottom of the window there is an import button, I click it
> and it asks me where I want to put the data
>
> This is what I don't get. Where should I tell it to save the data?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2c

Re: RCHGetTableCell-Template-IBD-Stock-Checkup??

Fri Mar 8, 2013 6:37 pm (PST) . Posted by:

"andyha8" andyha8

I see, now I've got it!! Man that is awesome. To be able to get all these different data scources in the same worksheet is just unreal man. It saves SO much time it's crazy.

It's weird though, because certain tickers always come back with errors. If you have a minute try these tickers out and see if you get data back from them:
GMCR
CELG
HTZ
AWAY
XXIA
EVR
MPC
VRX
OPEN
TRIP

Is there any kind of syntax needed for these? I know that I struggled with some of the stockscores indicaters, and I discovered that if I put a spce at the end like "signal stockscore " they worked perfect, but without the space nothing.

Thanks for all you do for the group(s)Randy

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You don't want to actually import anything. Once you log in, you can just
> cancel out the Web Query session. Logging in creates a security cookie that
> EXCEL and the add-in use when it retrieves web pages from the IBD site.
>
> Once you've logged in and created that security cookie, the add-in
> functions should be able to retrieve the web pages and extract the
> requested data items.
>
> On Fri, Mar 8, 2013 at 10:01 AM, andyha8 <andyha8@...> wrote:
>
> > I don't understand how to use this sheet.
> > I have an account with IBD.
> > I go to the web query in excel and sign into IBD.
> > On the bottom of the window there is an import button, I click it
> > and it asks me where I want to put the data
> >
> > This is what I don't get. Where should I tell it to save the data?
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2d

Re: RCHGetTableCell-Template-IBD-Stock-Checkup??

Fri Mar 8, 2013 8:22 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

All of those tickers worked fine for me...

If you put a space at the end of the ticker symbol, it would have retrieved
a new copy of the web page, using the new ticker symbol.

Sounds like you are having issues retrieving web pages...?

The add-in saves a copy of any web page it retrieves, and extracts all data
needed from that page from the saved copy of the web page. So if that
retrieved web page has an issue, it will always be an issue until a fresh
copy of the web page can be retrieved. See the writeup on the
smfForceRecalculation macro in the LINKS area of the Yahoo Group.

On Fri, Mar 8, 2013 at 7:37 PM, andyha8 <andyha8@gmail.com> wrote:

>
> It's weird though, because certain tickers always come back with errors.
> If you have a minute try these tickers out and see if you get data back
> from them:
> GMCR
> CELG
> HTZ
> AWAY
> XXIA
> EVR
> MPC
> VRX
> OPEN
> TRIP
>
> Is there any kind of syntax needed for these? I know that I struggled with
> some of the stockscores indicaters, and I discovered that if I put a spce
> at the end like "signal stockscore " they worked perfect, but without the
> space nothing.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3a

Current News

Fri Mar 8, 2013 11:39 am (PST) . Posted by:

"ufdn16" ufdn16

Thanks to smf I have a great spreadsheet that analyzes individual stocks for me. I'd like to have a section that delivers current news to the spreadsheet. Is this possible?
Thanks, David

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3b

Re: Current News

Fri Mar 8, 2013 11:47 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Check out the most recent messages on this thread:

http://finance.groups.yahoo.com/group/smf_addin/messages/15586?threaded=1&m=e&var=1&tidx=1

On Fri, Mar 8, 2013 at 12:39 PM, ufdn16 <ufdn16@yahoo.com> wrote:

> Thanks to smf I have a great spreadsheet that analyzes individual stocks
> for me. I'd like to have a section that delivers current news to the
> spreadsheet. Is this possible?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4a

Average Daily Volume

Fri Mar 8, 2013 2:03 pm (PST) . Posted by:

"iamruf" iamruf

Hi Randy,
Is there a way to grab Average Daily Volume from Yahoo and/or MSN?
E.G. similar to the formulas below:
=MSNStockQuote(B2,"Market Cap","US")
=RCHGetYahooQuotes(B2, "d")
Thanks

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

4b

Re: Average Daily Volume

Fri Mar 8, 2013 2:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Is there something wrong with?

=RCHGetYahooQuotes(B2, "a2")

On Fri, Mar 8, 2013 at 3:02 PM, iamruf <iamruf@yahoo.com> wrote:

>
> Is there a way to grab Average Daily Volume from Yahoo and/or MSN?
> E.G. similar to the formulas below:
> =MSNStockQuote(B2,"Market Cap","US")
> =RCHGetYahooQuotes(B2, "d")
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

4c

Re: Average Daily Volume

Fri Mar 8, 2013 7:07 pm (PST) . Posted by:

"Undisclosed" iamruf

NOPE! Working fine, thanks.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Friday, March 8, 2013 5:07 PM
Subject: Re: [smf_addin] Average Daily Volume

Is there something wrong with?

=RCHGetYahooQuotes(B2, "a2")

On Fri, Mar 8, 2013 at 3:02 PM, iamruf <iamruf@yahoo.com> wrote:

>Is there a way to grab Average Daily Volume from Yahoo and/or MSN?
>E.G. similar to the formulas below:
>=MSNStockQuote(B2,"Market Cap","US")
>=RCHGetYahooQuotes(B2, "d")
>