1 New Message

Digest #2880

IBD Current Group Rank Query Question by "hjreed@swbell.net" hjreed@swbell.net

Message

1 IBD Current Group Rank Query Question

Sat Nov 30, 2013 11:17 pm (PST) . Posted by:

"hjreed@swbell.net" hjreed@swbell.net

I used to be able to query the Ranking of the groups from IBD. For some
reason I get an Error for that data retrieval now.

I am logged into IDB using Web Query.

Here's a snapshot of the xls.

y T2.x IBD 50 Sector Pull Sector Industry
Subgroup Current Group Rank Top 5 Composite Rating in Group # Stocks in
Group URL one stock in the group 1 AEROSPACE AEROSPACE/DEFENSE Error
BEAV HEI HEIA PCP ATRO 56
http://research.investors.com/stockcheckup/nyse-transdigm-group-inc-tdg.\
aspx TDG 2 AGRICULTRE AGRICULTURAL OPRTIONS Error ANDE LMNR GAGA POPE
MON 20
http://research.investors.com/stockcheckup/nasdaq-andersons-inc-ande.asp\
x ANDE

D3 contains the following: =IF($A$1="y",IF(M3="","",
RCHGetTableCell("http://research.investors.com/stockcheckup/"&smfStrExtr\
(RCHGetWebData("http://www.investors.com/search/searchresults.aspx?Ntt="\
&M3,"/quotes/"),"/quotes/","'"),1,">Industry
<http://research.investors.com/stockcheckup/"&smfStrExtr(RCHGetWebData("\
http://www.investors.com/search/searchresults.aspx?Ntt="&M3,"/quotes/"),\
"/quotes/","'"),1,">Industry> Group Rank")),"")

This used to return the value of the IBD Group Rank

E3/F3/G3/H3/I3 contain:
=IF($A$1="y",smfStrExtr(smfGetTagContent(L3,"dt",-1,"Group
Leaders","_rptComposite"),"Symbol=",""""),"")

They work correctly and return the values of the top 5 tickers

J3 contains:

=IF($A$1="y",smfStrExtr(smfGetTagContent(L3,"p",-1,"RANK WITHIN
THE"),"("," STOCK"),"")

It works correctly and returns the number of stocks within the industry.

Two questions:

1) Do you see what is causing the Industry Group Rank not to be
returned? I have tried several changes, but none seem to do the trick.
Does it work for you?

2) I want to confirm this is pulling from the same query as E3-J3 or am
I using two of the 300 hits IBD will let you have within a day? (or has
that changed that you know of?)

Thank you in advance for taking a look at this.