2 New Messages
Digest #2584
Messages
Sat Apr 13, 2013 10:12 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
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 askplease refer to this
picturehttp://i48.tinypic.com/1pwd4k.jpg
as you can see, with reference to
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
<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-482\
8/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?
thanks
)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> This works fine:
>
> =RCHGetTableCell("
>
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/ ",1,"\
(DPS
> / Price)")
>
> As do these:
>
> =RCHGetTableCell("
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/ ",
> 1,"Finances - Leverage",">Leverage")
>
> =RCHGetTableCell("
>
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/ ",1,"\
Financial
> Ratios","Capitalization")
>
> On Fri, Apr 12, 2013 at 11:11 PM, weekeewawa weekeewawa@... wrote:
>
> >
> > i have tested used the code you have told me
> >
> > with the smfGetTagContent-Quick-Webpage-Examination.xls and also
> > implementing it on my excel as well
> >
> > 1)
> > =RCHGetTableCell("
> >
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/consensus/ ",1,">\
Mean
> > Consensus")
> >
> > with this code, it has solved at least 75% of the VALUE errors in
> > http://www.4-traders.com/ "&A1&"/financials/ BUT a new problem occur.
On
> > the smfGetTagContent-Quick-Webpage-Examination.xls, when i tested
the
> > following cell reference, it gave me a blank result. On my excel
template,
> > it gave me ERROR
> >
> > the following specific cells reference problems are
> > in sections (problematic cell reference)
> > Annual Income Statement Data (Yield)
> >
> > Finances - Leverage (Finance)
> >
> > Size (Size, Capitalization, Company Value)
> >
> > Valuation (Valuation, PER (Price / EPS), Capitalization / Revenue,
EV /
> > Revenue, EV / EBITDA, Yield (DPS / Price))
> >
> > and
> >
> > Profitability (operating laverage (Delta EBIT / Delta Sales),
> >
> > no matter which code i used the o substitute one or rchgettablecell
and on
> > the examination.xls, it just wouldn't work
> >
>
the guide have been perfect and somehow, it inspires me to experiment
with the examination.
bulbs! haha
but there is one more question i need to askplease refer to this
picturehttp:
as you can see, with reference to
http://www.4-
<http://www.4-
in the financial ratios section under ''SIZE&#
it is not so straightforward as
=RCHGetTableCell(
8/financials/
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?
thanks
)
--- In smf_addin@yahoogrou
wrote:
>
> This works fine:
>
> =RCHGetTableCell(
>
http://www.4-
(DPS
> / Price)"
>
> As do these:
>
> =RCHGetTableCell(
> http://www.4-
> 1,"Finances - Leverage"
>
> =RCHGetTableCell(
>
http://www.4-
Financial
> Ratios"
>
> On Fri, Apr 12, 2013 at 11:11 PM, weekeewawa weekeewawa@.
>
> >
> > i have tested used the code you have told me
> >
> > with the smfGetTagContent-
> > implementing it on my excel as well
> >
> > 1)
> > =RCHGetTableCell(
> >
http://www.4-
Mean
> > Consensus"
> >
> > with this code, it has solved at least 75% of the VALUE errors in
> > http://www.4-
On
> > the smfGetTagContent-
the
> > following cell reference, it gave me a blank result. On my excel
template,
> > it gave me ERROR
> >
> > the following specific cells reference problems are
> > in sections (problematic cell reference)
> > Annual Income Statement Data (Yield)
> >
> > Finances - Leverage (Finance)
> >
> > Size (Size, Capitalization, Company Value)
> >
> > Valuation (Valuation, PER (Price / EPS), Capitalization / Revenue,
EV /
> > Revenue, EV / EBITDA, Yield (DPS / Price))
> >
> > and
> >
> > Profitability (operating laverage (Delta EBIT / Delta Sales),
> >
> > no matter which code i used the o substitute one or rchgettablecell
and on
> > the examination.
> >
>
Sat Apr 13, 2013 11:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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@yahoo.com > 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?
>
>
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@yahoo.
>
> the guide have been perfect and somehow, it inspires me to experiment with
> the examination.
> haha
>
> but there is one more question i need to ask
> please refer to this picture
> http://i48.tinypic.
>
> as you can see, with reference to
> http://www.4-
>
> in the financial ratios section under ''SIZE&#
>
> it is not so straightforward as =RCHGetTableCell(
> http://www.4-
> Ratios"
>
> 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?
>
>
Tidak ada komentar:
Posting Komentar