Sabtu, 13 April 2013

[smf_addin] Digest Number 2583

4 New Messages

Digest #2583

Messages

Fri Apr 12, 2013 1:32 pm (PDT) . Posted by:

"rr76012" rr76012

I fell like an idiot, your answer was spot on to just use the RCHGetYahooQuotes() function?

Question: I have only used it with your sample array file you posted.

Just now, I tried several times with different stock symbols etc...and the results were the same nothing happened, example with =rchgetyahooquotes(B7, L1) for a current price and nothing happened, can it be only be used in an array? I must be doing something wrong.

Thanks,

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Both work fine for me. But if you got "Error" with one, you will get
> "Error" with the other -- they are both extracting data from the same saved
> web page.
>
> I always use RCHGetYahooQuotes() for current prices. It also has codes for
> dividend and EPS, although it is a trailing dividend. Most people desire a
> forward dividend.
>
> On Fri, Apr 12, 2013 at 1:06 PM, rr76012 <rr76012@...> wrote:
>
> > Randy would you try using the symbol for Excelon "EXC" with these 2
> > methods. I keep getting an error?
> >
> > =RCHGetElementNumber("exc";,25) give me "Error"
> >
> > B7 = EXC,
> > =RCHGetElementNumber(B7, 25), gives me "Error"
> >
> > Randy thanks, do you recommend other rchgetelementnumber numbers for
> > current: price, dividend, and eps?
> >
>

Fri Apr 12, 2013 2:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The second parameter needs to be a literal -- "l1". When you use -- L1 --
it is a cell reference. So:

=RCHGetYahooQuotes(B7,"l1")

Of course you could put the string with the Yahoo code(s) *in* cell L1, if
you prefer. :)

On Fri, Apr 12, 2013 at 1:31 PM, rr76012 <rr76012@yahoo.com> wrote:

> I fell like an idiot, your answer was spot on to just use the
> RCHGetYahooQuotes() function?
>
> Question: I have only used it with your sample array file you posted.
>
> Just now, I tried several times with different stock symbols etc...and the
> results were the same nothing happened, example with =rchgetyahooquotes(B7,
> L1) for a current price and nothing happened, can it be only be used in an
> array? I must be doing something wrong.
>

Fri Apr 12, 2013 11:11 pm (PDT) . Posted by:

"weekeewawa" weekeewawa

hello randy,

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

for 2) and 3), works like a clock. perfect!

would like to ask you on the issues in 1)

thanks!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> This works fine for me:
>
> =RCHGetTableCell("
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/consensus/",
> 1,">Mean Consensus")
>
> For news, I would use:
>
> =RCHGetHTMLTable("
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/news-history/",
> ">Latest News on",1,"",2)
>
> For sales, I would use:
>
> =RCHGetHTMLTable("
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes-ticks/",
> ">Quantity&quot;,-1,"",1)
>
> Are you trying these on the template I suggested?
>
> On Fri, Apr 12, 2013 at 4:59 AM, weekeewawa <weekeewawa@...> wrote:
>
> > haha,
> >
> > i guess programming is taxing me till i made all sort of silly errors.
> >
> > i was testing on the codes at 4 traders and i ran into some problems
> >
> > 1) i keep getting the #VALUE error for certain rows but it works fine for
> > other rows. the codes work fine but when i input the row reference name for
> > example
> >
> > ''Mean consensus'' in
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/consensus/
> >
> > ''Yield&#39;', ''Announcement Date'', ''PER (Price / EPS)'',''Capitalization /
> > Revenue'', ''EV / Revenue'', ''operating laverage (Delta EBIT / Delta
> > Sales)'&#39;,Capital Intensity (Assets / Sales). ''Company Value'&#39;
> >
> > in the size, valuation, profitability and balance sheeet analysis of
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/financials/
> > but examples like EBITDA, ROA, ROE works well!
> >
> > Annual publications in
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/calendar/ gives
> > the #VALUE Error
> >
> > although the code is as simple as
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&A1&"/calendar/",1,"Sales";),"
> > ","")
> >
> > in which i just replace ''Annual Results'' with the relevant row
> > reference. It shouldnt have any problem logically but the #VALUE Error
> > shows in the above example rows
> >
> > 2) i was also testing this code
> > =smfGetTagContent("http://http://www.4-traders.com/
> > "&D$125&"/news-history/"",1,""LatestNews")
> >
> > on
> >
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/news-history/
> > as the extraction in specific news site are based on this code. But also,
> > it gives a VALUE Error. Am i close to getting it right?
> >
> > 3) in
> > http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes-ticks/
> >
> > i understand that the row reference is not horizontal but instead is
> > vertical down.
> >
> > So what should be tweaked in
> > =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/"&A1&"/calendar/",1,"Sales";),"
> > ","")
> >
> > for the case of the vertical column reference?
> >
>

Fri Apr 12, 2013 11:34 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

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@yahoo.com> 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
>
Diposting oleh EXCEL FEED LEARNING di 02.09

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)