Jumat, 25 Desember 2015

[smf_addin] Digest Number 3591[2 Attachments]

15 Messages

Digest #3591

Messages

Thu Dec 24, 2015 2:22 am (PST) . Posted by:

perseuslim11

and is it possible to get tables from this link as well? https://secure8.itradecimb.com.my/gcCIMB/tcplus/index.jsp https://secure8.itradecimb.com.my/gcCIMB/tcplus/index.jsp?t=1450944092697



Thu Dec 24, 2015 7:00 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Because you can't use the website positioning portion of the URL (the "#"
sign and everything following it).

On Thu, Dec 24, 2015 at 3:02 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi Randy, I tried this function myself but it doesnt work: (I referred to
> this page RCHGetHTMLTable-Function.html
> <http://ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetHTMLTable-Function.html>
>
> =RCHGetHTMLTable("
> http://www.klse.my/stock/result/financial/quarterAnalysis/5053.jsp#stockDetailDiv","Revenue
> ('000)",-1,"",16)
>
> but your function works
> =RCHGetHTMLTable("
> http://www.klse.my/stock/result/financial/quarterAnalysis/3107.jsp","Revenue
> (",-1,"",16)
>
> why is it so?
>

Thu Dec 24, 2015 7:03 am (PST) . Posted by:

perseuslim11

I see, ook noted ^^

btw, is it possible to get tables from this link as well?
https://secure8.itradecimb.com.my/gcCIMB/tcplus/index.jsp https://secure8.itradecimb.com.my/gcCIMB/tcplus/index.jsp?t=1450944092697




Thu Dec 24, 2015 7:09 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I can't tell, because it requires a login.

Typically, to grab data from a web page with security, you first need to
create an IE security cookie by logging in with either the EXCEL Web Query
dialog (preferred) or with IE.

On Thu, Dec 24, 2015 at 8:03 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I see, ook noted ^^
>
> btw, is it possible to get tables from this link as well?
> https://secure8.itradecimb.com.my/gcCIMB/tcplus/index.jsp
> <https://secure8.itradecimb.com.my/gcCIMB/tcplus/index.jsp?t=1450944092697>
>

Thu Dec 24, 2015 7:14 am (PST) . Posted by:

perseuslim11

but i think it wont work, because the income statement, balance sheet,cash flow statement and ratios are on different tabs of the platform, same url, so i think the smf couldn't be used to retrieve it..

see attached photo :)


do you think its possible?
Attachment(s) from
1 of 1 Photo(s)

Thu Dec 24, 2015 7:20 am (PST) . Posted by:

perseuslim11

cannot load the web query properly also , says unsupported version hmm..

(attached photo)
Attachment(s) from
1 of 1 Photo(s)

Thu Dec 24, 2015 7:32 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Depends on how they do the web page. Google has tabs like that and all the
tabs do is hide and unhide sections of the web page. So all of the data is
on the web page. It's just the browser is only showing one section at a
time. Another option is for the "tab" to actually go to a new web page.

It's impossible to tell without looking at the how the web page operates,
and checking the source code of the web page.

On Thu, Dec 24, 2015 at 8:14 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> [Attachment(s) <#151d48e4104cab27_TopText> from perseuslim11@yahoo.com
> [smf_addin] included below]
>
> but i think it wont work, because the income statement, balance sheet,cash
> flow statement and ratios are on different tabs of the platform, same url,
> so i think the smf couldn't be used to retrieve it..
>
> see attached photo :)
>
> do you think its possible?
>

Thu Dec 24, 2015 7:44 am (PST) . Posted by:

perseuslim11

ok, do you know of any other websites with at least 5 yr data? and no subscription needed?

gurufocus i think cant even get 5 year data without subscription rite?

Thu Dec 24, 2015 8:27 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Like I said, I don't do non-US stocks, so I'm not aware of the various
sources...

On Thu, Dec 24, 2015 at 8:44 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> ok, do you know of any other websites with at least 5 yr data? and no
> subscription needed?
>
> gurufocus i think cant even get 5 year data without subscription rite?
>
>

Thu Dec 24, 2015 8:44 am (PST) . Posted by:

perseuslim11

oh ya, how about http://www.unclestock.com/ http://www.unclestock.com/, how do I extract data from the website?

Thu Dec 24, 2015 9:17 am (PST) . Posted by:

perseuslim11

ok, but can you teach me how to extract data from unclestock.com? the free version still can access the financial data section (my country's stock is available at this website as well)

thanks :)

Thu Dec 24, 2015 9:51 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Specific URL example for a data page from which you want to extract
please...

On Thu, Dec 24, 2015 at 9:44 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> oh ya, how about http://www.unclestock.com/, how do I extract data from
> the website?
>
>

Thu Dec 24, 2015 8:38 pm (PST) . Posted by:

perseuslim11

http://www.unclestock.com/?email=perseuslim@gmail.com&code=-1401172332 http://www.unclestock.com/?email=perseuslim@gmail.com&code=-1401172332

actually there's no specific url, because in the url, it just contain my email behind the main url..
hmm..?

Thu Dec 24, 2015 11:55 pm (PST) . Posted by:

perseuslim11

and can i import the table without the Horiz% option? (untick horizontal)

KLSE - FIMACOR(3107): FIMA CORPORATION BHD http://www.klse.my/stock/result/financial/last10fy/3107.jsp#stockDetailDiv

http://www.klse.my/stock/result/financial/last10fy/3107.jsp#stockDetailDiv

KLSE - FIMACOR(3107): FIMA CORPORATION BHD http://www.klse.my/stock/result/financial/last10fy/3107.jsp#stockDetailDiv FIMA CORPORATION BHD



View on www.klse.my http://www.klse.my/stock/result/financial/last10fy/3107.jsp#stockDetailDiv
Preview by Yahoo







Fri Dec 25, 2015 12:11 am (PST) . Posted by:

perseuslim11

and i tried this formula =RCHGetHTMLTable("http://klse.i3investor.com/servlets/stk/fin/=stockno.jsp","Annual Result:",-1,"",1)
and the smfgetcvs function


but both returns nothing , why?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 00.11

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)