5 Messages

Digest #3896

Re: Anyone please help me on getting this table? Tried RCHgethtmltab by "Randy Randall" randyr_cds

Re: Anyone please help me on getting this table? Tried RCHgethtmltab by perseuslim11

2.1

Re: I'm back! by loukurrelmeyer

Elements with Errors by loukurrelmeyer

Re: Option Chains by jamesbparker999

Messages

1a

Re: Anyone please help me on getting this table? Tried RCHgethtmltab

Fri Jan 20, 2017 2:38 am (PST) . Posted by:

"Randy Randall" randyr_cds

I don't know what part you are trying to get, but try something like:
=RCHGetHTMLTable("
http://klse.i3investor.com/servlets/stk/fin/7087.jsp?type=last10fy","Last
10 FY",1)

This needs to be array-entered over the size of the table...

On Fri, Jan 20, 2017 at 4:30 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> [Attachment(s) <#m_6422990186587663781_TopText> from
> perseuslim11@yahoo.com [smf_addin] included below]
>
> Hi guys, can anyone teach me how to get table from this link?
>
> http://klse.i3investor.com/servlets/stk/fin/7087.jsp?type=last10fy
>
>
>
> I was using the RCHgetHTMLtable function to pull the data however its not
> working even though I've tried numerous alterations to the formula..
>
>
> Formula I've used is
>
> =RCHGetHTMLTable("http://klse.i3investor.com/servlets/stk/fin/
> "&$E$1&".jsp?type=last10fy","Revenue
>
> ",-1,"",1)
>
>
>
> My table in excel appears blank like this: (attachment)
>
>
>
> I think the problem lies with the "?type=last10fy" part
>
> any way to get around this problem?
>
>
> Many thanks in advance to thise kind souls who'd help me on this =)
>
>
>
> and to Randy, hope that you'd recover to the pink of health soon!! A nice
> person like you would definitely be blessed by the Almighty God :)
>
>
>

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

1b

Re: Anyone please help me on getting this table? Tried RCHgethtmltab

Fri Jan 20, 2017 3:58 am (PST) . Posted by:

perseuslim11

Thanks Randy, that did the trick!

Hope you're feeling better now :)

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

2.1 Re: I'm back!

Fri Jan 20, 2017 11:42 am (PST) . Posted by:

loukurrelmeyer

Randy,

I hope you're doing better. Do you need some help? Someone to hand this off to?

Lou

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

3 Elements with Errors

Fri Jan 20, 2017 11:43 am (PST) . Posted by:

loukurrelmeyer

It has been several years since I works with the RCHGetElementNumber formulas. I downloaded the RCH_Stock_Market_Functions-2.1.2016.12.03 version. I am finding a large number of elements not working.

I see 12,358 total elements.
I see 184 elements marked as obsolete.
I find 10,686 return "ERROR" with any of several stocks, funds, or ETFs.

Is it possible that most of the web pages are no longer usable? Or am I doing something wrong? I find I can use 1,407 of the element numbers, so I know I have installed correctly.