5 New Messages

Digest #2430

Re: Changes in Earnings Estimates for S&P500 by "Randy Harmelink" rharmelink

StockCharts Tables by "sewuzy" sewuzy

Re: StockCharts Tables by "sewuzy" sewuzy

Re: StockCharts Tables by "Randy Harmelink" rharmelink

Messages

1a

Re: Changes in Earnings Estimates for S&P500

Mon Dec 10, 2012 7:05 am (PST) . Posted by:

"Randy Harmelink" rharmelink

There is no such template. I'm not even aware of a data source...

On Mon, Dec 10, 2012 at 3:00 AM, andrewhills97 <andrewhills97@yahoo.com>wrote:

> In Files, there is a template Excel file which retrieves changes in
> Analyst Estimates for specific companies by typing in the company ticker
> (SMF_Template_Yahoo_Analyst_Estimates.xls).
>
> Can anyone help me find a template which retrieves changes in earnings
> estimates for the S&P500 index?
>

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

2a

StockCharts Tables

Mon Dec 10, 2012 12:12 pm (PST) . Posted by:

"sewuzy" sewuzy

Hi Randy,

I'd like to capture data from the tables in pages below onto Excel:

http://stockcharts.com/freecharts/sctr.html?&V=E&I=N

http://stockcharts.com/freecharts/sctr.html?&V=L&I=N

http://stockcharts.com/freecharts/sctr.html?&V=M&I=N

http://stockcharts.com/freecharts/sctr.html?&V=S&I=N

Can you please help with the appropriate codings ?

Thank you so much.
Seth

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

2b

Re: StockCharts Tables

Mon Dec 10, 2012 12:15 pm (PST) . Posted by:

"sewuzy" sewuzy

Please also include coding for data in table on this page:

http://www.barchart.com/stocks/sectors/-TOP?_dts1=weighted_alpha

Thanks so much again,
Seth

--- In smf_addin@yahoogroups.com, "sewuzy" <sewuzy@...> wrote:
>
> Hi Randy,
>
> I'd like to capture data from the tables in pages below onto Excel:
>
> http://stockcharts.com/freecharts/sctr.html?&V=E&I=N
>
> http://stockcharts.com/freecharts/sctr.html?&V=L&I=N
>
> http://stockcharts.com/freecharts/sctr.html?&V=M&I=N
>
> http://stockcharts.com/freecharts/sctr.html?&V=S&I=N
>
> Can you please help with the appropriate codings ?
>
> Thank you so much.
> Seth
>

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

2c

Re: StockCharts Tables

Mon Dec 10, 2012 12:41 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but all of those web pages are dynamically generated...

On Mon, Dec 10, 2012 at 1:12 PM, sewuzy <sewuzy@gmail.com> wrote:

>
> I'd like to capture data from the tables in pages below onto Excel:
>
> http://stockcharts.com/freecharts/sctr.html?&V=E&I=N
>
> http://stockcharts.com/freecharts/sctr.html?&V=L&I=N
>
> http://stockcharts.com/freecharts/sctr.html?&V=M&I=N
>
> http://stockcharts.com/freecharts/sctr.html?&V=S&I=N
>
> Can you please help with the appropriate codings ?
>

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

2d

Re: StockCharts Tables

Mon Dec 10, 2012 12:43 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("
http://www.barchart.com/stocks/sectors/-TOP?_dts1=weighted_alpha
",">Links",-1,"",1)

On Mon, Dec 10, 2012 at 1:15 PM, sewuzy <sewuzy@gmail.com> wrote:

> Please also include coding for data in table on this page:
>
> http://www.barchart.com/stocks/sectors/-TOP?_dts1=weighted_alpha
>
>