When you extract data from a web page for something like RCHGetTableCell(),
it saves a copy of the web page first, and then extracts the data from that
saved copy of the web page. The whole point of that is to reduce the number
of Internet accesses that need to be done. For more details on that
process, check out the smfForceRecalculation item in the LINKS area of the
group.

You could also retrieve the table with one array-entered formula:

=RCHGetHTMLTable("
http://research.investors.com/etables/NewAmericaXSL.aspx?tabView=IBD85&columnsort1=Name&columnsorttype1=ASC&columnsort2=&columnsorttype2=DESC
","",1,"",1)

It may be slightly faster, because its only a single function parsing the
whole table at once, instead of having a number of individual
RCHGetTableCell() functions parsing the web page one piece at a time.

But using RCHGetTableCell() allows you to sort and manipulate the returned
data, and only get selected columns of data, while RCHGetHTMLTable() does
not. It really depends on how you want to use the retrieved data.

I use the RCHGetTableCell() functions because I sometimes use a "scoring"
method on the data, and want to be able to sort by the resultant values.

On Wed, Jan 16, 2013 at 11:06 PM, mff2805 mff3429@comcast.net> wrote:

>
> question: if i grab all 50 stocks and all the columns for each stock by
> varying pRows andd pCells, is that just one grab of the data table or
> multiple grabs, i.e. is it inefficient? If so, would there be a more
> efficient way?
> just wondering.
>

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

2a

Error getting MSN STOCK RATING

Wed Jan 16, 2013 10:41 pm (PST) . Posted by:

"kimhock78" kimhock78

1. The specific function(s) or template(s) you are having problems with.
RCHGetElementNumber

2. The parameter(s) you are using with the function(s).
=RCHGetElementNumber("APPL", 543)

3.The version of EXCEL you use.
Microsoft Excel 2010

4. The operating system you're running EXCEL under.
Windows 7 Home Premium

5. The steps you took to try to resolve the problem.
Re-install add-in.

6. The ticker symbols or URLs that are being used.
http://investing.money.msn.com/investments/stock-ratings/?symbol=APPL

-- The results you expect to get and what you actually get.
"7"

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

2b

Re: Error getting MSN STOCK RATING

Wed Jan 16, 2013 10:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I get a value of "NA" with your function, which is what I see on the print
report for the stock.

The web page you cited, which is not where the data is extracted from for
the RCHGetElementNumber() function, says "No information available". There
is no StockScouter rating on that page, so I'm not sure why you expect to
see a value of 7.

Hmmm. I note that Apple, ticker symbol AAPL does have a value of 7 -- did
you type in the wrong ticker symbol for the function?

On Wed, Jan 16, 2013 at 11:31 PM, kimhock78 kimhock78@yahoo.com> wrote:

> 1. The specific function(s) or template(s) you are having problems with.
> RCHGetElementNumber
>
> 2. The parameter(s) you are using with the function(s).
> =RCHGetElementNumber("APPL", 543)
>
> 3.The version of EXCEL you use.
> Microsoft Excel 2010
>
> 4. The operating system you're running EXCEL under.
> Windows 7 Home Premium
>
> 5. The steps you took to try to resolve the problem.
> Re-install add-in.
>
> 6. The ticker symbols or URLs that are being used.
> http://investing.money.msn.com/investments/stock-ratings/?symbol=APPL
>
> -- The results you expect to get and what you actually get.
> "7"
>

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

2c

Re: Error getting MSN STOCK RATING

Wed Jan 16, 2013 11:06 pm (PST) . Posted by:

"Melvin Chua" kimhock78

Sorry, my typo error. Should be AAPL instead of APPL. I still get "Error" on my spreadsheet even if i put in the correct value.

How do i extract the stockscouter ratings from http://investing.money.msn.com/investments/stock-ratings/?symbol=AAPL ? I need to display "7" on my spreadsheet. Thanks.

>________________________________
> From: Randy Harmelink rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, 17 January 2013, 14:46
>Subject: Re: [smf_addin] Error getting MSN STOCK RATING
>
>
>
>
>I get a value of "NA" with your function, which is what I see on the print report for the stock.
>
>The web page you cited, which is not where the data is extracted from for the RCHGetElementNumber() function, says "No information available". There is no StockScouter rating on that page, so I'm not sure why you expect to see a value of 7.
>
>Hmmm. I note that Apple, ticker symbol AAPL does have a value of 7 -- did you type in the wrong ticker symbol for the function?
>
>
>On Wed, Jan 16, 2013 at 11:31 PM, kimhock78 kimhock78@yahoo.com> wrote:
>1. The specific function(s) or template(s) you are having problems with.
>>RCHGetElementNumber
>>
>>2. The parameter(s) you are using with the function(s).
>>=RCHGetElementNumber("APPL", 543)
>>
>>3.The version of EXCEL you use.
>>Microsoft Excel 2010
>>
>>4. The operating system you're running EXCEL under.
>>Windows 7 Home Premium
>>
>>5. The steps you took to try to resolve the problem.
>>Re-install add-in.
>>
>>6. The ticker symbols or URLs that are being used.
>>http://investing.money.msn.com/investments/stock-ratings/?symbol=APPL
>>
>>-- The results you expect to get and what you actually get.
>>"7"
>>
>

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

2d

Re: Error getting MSN STOCK RATING

Wed Jan 16, 2013 11:20 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Are you using an older version of the add-in? The element definitions had
to be updated last year, because MSN changed their web page structure. That
could be the reason you are getting "Error" returned. To check which
version you're using:

=RCHGetElementNumber("Version")

For the cited web page:

=0+smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings/?symbol=AAPL
","div",-2,">Scouter";)

On Thu, Jan 17, 2013 at 12:05 AM, Melvin Chua kimhock78@yahoo.com> wrote:

>
> Sorry, my typo error. Should be AAPL instead of APPL. I still get "Error"
> on my spreadsheet even if i put in the correct value.
>
> How do i extract the stockscouter ratings from
> http://investing.money.msn.com/investments/stock-ratings/?symbol=AAPL ? I
> need to display "7" on my spreadsheet. Thanks.
>

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

2e

Re: Error getting MSN STOCK RATING

Wed Jan 16, 2013 11:25 pm (PST) . Posted by:

"Melvin Chua" kimhock78

It stated 2.1.2012.02.02.

I tried installing the latest but it still state this version. How do i uninstall completely and reinstall the new add in? Thanks.

>________________________________
> From: Randy Harmelink rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, 17 January 2013, 15:20
>Subject: Re: [smf_addin] Error getting MSN STOCK RATING
>
>
>
>
>Are you using an older version of the add-in? The element definitions had to be updated last year, because MSN changed their web page structure. That could be the reason you are getting "Error" returned. To check which version you're using:
>
>=RCHGetElementNumber("Version")
>
>For the cited web page:
>
>=0+smfGetTagContent("http://investing.money.msn.com/investments/stock-ratings/?symbol=AAPL","div",-2,">Scouter";)
>
>
>On Thu, Jan 17, 2013 at 12:05 AM, Melvin Chua kimhock78@yahoo.com> wrote:
>
>>
>>Sorry, my typo error. Should be AAPL instead of APPL. I still get "Error" on my spreadsheet even if i put in the correct value.
>>
>>How do i extract the stockscouter ratings from http://investing.money.msn.com/investments/stock-ratings/?symbol=AAPL ? I need to display "7" on my spreadsheet. Thanks.
>>
>

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

2f

Re: Error getting MSN STOCK RATING

Wed Jan 16, 2013 11:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You need to exit and restart EXCEL for it to load the new version of the
add-in. Add-ins are loaded at start-up time.

On Thu, Jan 17, 2013 at 12:25 AM, Melvin Chua kimhock78@yahoo.com> wrote:

>
> It stated 2.1.2012.02.02.
>
> I tried installing the latest but it still state this version. How do i
> uninstall completely and reinstall the new add in? Thanks.
>

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

2g

Re: Error getting MSN STOCK RATING

Thu Jan 17, 2013 12:09 am (PST) . Posted by:

"Melvin Chua" kimhock78

i managed to remove the existing addins and re-installed the new one. Its working now. Thanks.

>________________________________
> From: Randy Harmelink rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Thursday, 17 January 2013, 15:46
>Subject: Re: [smf_addin] Error getting MSN STOCK RATING
>
>
>
>
>You need to exit and restart EXCEL for it to load the new version of the add-in. Add-ins are loaded at start-up time.
>
>
>On Thu, Jan 17, 2013 at 12:25 AM, Melvin Chua kimhock78@yahoo.com> wrote:
>
>>
>>It stated 2.1.2012.02.02.
>>
>>I tried installing the latest but it still state this version. How do i uninstall completely and reinstall the new add in? Thanks.
>>
>

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

3a

Re: RCHGetYahooQuotes() - Array - Prevent Update

Wed Jan 16, 2013 10:44 pm (PST) . Posted by:

"bobc94595" bobc94595

Thanks, Randy. I have inserted the formula, designated "n" in the worksheet, and saved it. I look forward to opening it tomorrow to see what happens.

Thanks for the late night effort.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> Only two ways to prevent the recalculation and preserve what is displayed
> -- turn of automatic calculation, or convert everything to values. If you
> wanted to preserve the values infrequently, as in the year-end case, I
> would first create another worksheet, then copy the original worksheet and
> paste special both values and formats into the new empty workbook, and then
> name the tab appropriately.
>
> As far as a trigger cell, it would be something like:
>
> =IF($B$2<>"Y","--",RCHGetYahooQuotes(A4:A106,B3:E3))
>
> ...so when you save the workbook, you set cell B2 to "N", and everything
> will be set to "--". When you next open the workbook, no Internet access
> would be performed, because the RCHGetYahooQuotes() function would not be
> executed.
>
> Typically, I do that when it would take some time to open a workbook,
> because of the number of Internet accesses that need to be done. And I may
> not want the current formulas to update until after I've made some changes
> to the workbook.
>
> On Wed, Jan 16, 2013 at 11:00 PM, bobc94595 wrote:
>
> > Is there a formula modification which can be made to the array formula
> > "RCHGetYahooQuotes(A4:A106,B3:E3)" which will prevent automatic
> > recalculation or update of the worksheet upon its next opening? I would
> > like to preserve the sheet as of a particular date (e.g. year end
> > 12/31/12,) and not have it recalculated automatically if I open it
> > thereafter. How do I preserve the sheet as of a specific date?
> >
> > How does one establish a trigger cell for recalculation?
> >
>

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

4a

Re: advfn-financial statements

Thu Jan 17, 2013 2:55 am (PST) . Posted by:

"lawrence.leesh" lawrence.leesh

I realized I could download from my 32-bit OS computers but not in my newer 64-bit OS ones even though I pointed the addin correctly to Program Files (x86) and did not have this problem in the past. Maybe it is memory problem.

I got Error and "--" for those two formulas below. I was not redirected to another URL in IE.

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I just retrieved the file from the Yahoo group, used ticker symbol MMM, and
> it worked fine for me.
>
> What do you get with:
>
> =smfGetADVFNElement("MMM","A",999)
> =smfGetADVFNElement("MMM","A",1,">year end date<",,"--")
>
> If you plug this URL into IE:
>
> http://www.advfn.com/p.php?pid=financials&symbol=MMM
>
> ...do you get redirected to a different URL?
>
> On Wed, Jan 16, 2013 at 3:41 PM, lawrence.leesh wrote:
>
> >
> > The file you mentioned below
> > smfGetAdvFNElement-Template-All-Line-Items.xls could not retrieve advfn
> > data and it returns blank. Did advfn make some changes to their website?
> >
>

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

4b

Re: advfn-financial statements

Thu Jan 17, 2013 3:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Check out the AdvFN item in the LINKS area of the Yahoo group. You may have
different Windows Updates on the two machines (or fixed the issue on the
one that works).

On Thu, Jan 17, 2013 at 3:55 AM, lawrence.leesh lawrence.leesh@yahoo.com>wrote:

> I realized I could download from my 32-bit OS computers but not in my
> newer 64-bit OS ones even though I pointed the addin correctly to Program
> Files (x86) and did not have this problem in the past. Maybe it is memory
> problem.
>
> I got Error and "--" for those two formulas below. I was not redirected to
> another URL in IE.
>

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

4c

Re: advfn-financial statements

Thu Jan 17, 2013 3:22 am (PST) . Posted by:

"lawrence.leesh" lawrence.leesh

Randy, it worked like magic. Thanks again!

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> Check out the AdvFN item in the LINKS area of the Yahoo group. You may have
> different Windows Updates on the two machines (or fixed the issue on the
> one that works).
>
> On Thu, Jan 17, 2013 at 3:55 AM, lawrence.leesh wrote:
>
> > I realized I could download from my 32-bit OS computers but not in my
> > newer 64-bit OS ones even though I pointed the addin correctly to Program
> > Files (x86) and did not have this problem in the past. Maybe it is memory
> > problem.
> >
> > I got Error and "--" for those two formulas below. I was not redirected to
> > another URL in IE.
> >
>

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

5a

Re: Bloomberg Data - Brazil

Thu Jan 17, 2013 5:22 am (PST) . Posted by:

"cesarcrivelli" cesarcrivelli

Randy,

Thanks for the reply.

I think that the first option you pointed may be the case, but as I far away from be an expert, below is the URL for on stock that is listed at Bovespa.

I would like to retrieve most of the fields that are below the chart, as P/E ratio, Mkt Cap, Shares Outstanding, etc.

http://www.bloomberg.com/quote/PETR4:BZ

Do you think the AddIn can get this data?

Best,

Cesar

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> It all depends on how the data is placed on the web page. The add-in
> extracts data from the source code of the web page, so if the data is
> placed on the web page dynamically, there may be nothing in the source code
> for the add-in to extract. A sample URL, along with an item you want to
> extract, would help.
>
> On Wed, Jan 16, 2013 at 4:36 PM, cesarcrivelli wrote:
>
> >
> > I am from Brasil, and just few days ago I found this amazing solution
> > regarding stock market data.
> >
> > The issue here is that most of the web content its not related to
> > Brazilian Stock Market.
> >
> > Bloomberg as a WorldWide data provider has at their web site some info
> > that I would like to retrieve.
> >
> > The bottom line is... Can this add-in retrieve data from bloomberg
> > website? Does anybody get data of Brazilian Stock Market: Would be nice to
> > have some color about this!
> >
>