2 New Messages

Digest #2585

Re: Consensus estimates for EBITDA and Capital Expenditure by "weekeewawa" weekeewawa

Re: Consensus estimates for EBITDA and Capital Expenditure by "Randy Harmelink" rharmelink

Messages

1a

Re: Consensus estimates for EBITDA and Capital Expenditure

Sun Apr 14, 2013 3:56 am (PDT) . Posted by:

"weekeewawa" weekeewawa

hello randy,

works perfectly! everything seems to be working now.

got to say that 4 trader is the most complex extraction so far for me

i was actually having this thought and also a couple of question

1) is it possible to extract news from http://finviz.com/news.ashx?
tried
=RCHGetHTMLTable("http://finviz.com/news.ashx",">News",1,"",1) but completely blank and so on for other permutations

any codes for it?

2) is it even remotely possible that for news extraction such as
=smfGetTagContent("http://www.reuters.com/finance/stocks/companyNews?symbol="&$A$1,"a",1,"select another date") where A1 points to for example IBM in which the headlines is actually a hyperlink which links me to the news article?

thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The problem is that you've got tables within tables there. Plus, "size" is
> a VERY common string in an HTML web page. On the template, just use the
> ">Financial Ratios" as your "Find 1" string and remove the "End" string.
>
> You should see everything you need.
>
> On Sat, Apr 13, 2013 at 10:12 PM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > the guide have been perfect and somehow, it inspires me to experiment with
> > the examination.xls and somehow, it just lights up a lot of light bulbs!
> > haha
> >
> > but there is one more question i need to ask
> > please refer to this picture
> > http://i48.tinypic.com/1pwd4k.jpg
> >
> > as you can see, with reference to
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
> >
> > in the financial ratios section under ''SIZE''
> >
> > it is not so straightforward as =RCHGetTableCell("
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/",1,"Financial
> > Ratios","Balance Sheet"
> >
> > where 2013 is on row 0 and column 0 and 2014 is on row 0 and column 1
> >
> > instead, for size, it is on row 1 and 2 and column 1
> >
> > what will be the modified code for it?
> >
> >
>

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

1b

Re: Consensus estimates for EBITDA and Capital Expenditure

Sun Apr 14, 2013 6:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Sun, Apr 14, 2013 at 3:56 AM, weekeewawa <weekeewawa@yahoo.com> wrote:

> 1) is it possible to extract news from http://finviz.com/news.ashx?
> tried
> =RCHGetHTMLTable("http://finviz.com/news.ashx",">News",1,"",1) but
> completely blank and so on for other permutations
>
> any codes for it?
>

Possible, but extremely tedious. It's tables within tables within tables.
So you'd have to determine their coding pattern for the web page before
decided how to extract each bit.

> 2) is it even remotely possible that for news extraction such as
> =smfGetTagContent("
> http://www.reuters.com/finance/stocks/companyNews?symbol="&$A$1,"a",1,"select
> another date") where A1 points to for example IBM in which the headlines is
> actually a hyperlink which links me to the news article?
>

Not quite sure what you're asking? Is it this:

=HYPERLINK("http://www.reuters.com/"&smfStrExtr(smfGetTagContent("
http://www.reuters.com/finance/stocks/companyNews?symbol="&$A$1,"h2",1,"select
another date"),"""",""""),smfGetTagContent("
http://www.reuters.com/finance/stocks/companyNews?symbol="&$A$1,"a",1,"select
another date"))