Kamis, 24 Desember 2015

[smf_addin] Digest Number 3590[1 Attachment]

8 Messages

Digest #3590

Messages

Thu Dec 24, 2015 1:26 am (PST) . Posted by:

perseuslim11

Hi, I've added the RCH add-in to a new workbook and tried this function: =smfGetCSVFile("http://financials.morningstar.com/ajax/exportKR2CSV.html?t=5053®ion=MYS&culture=en_US http://financials.morningstar.com/ajax/exportKR2CSV.html?t=5053®ion=MYS&culture=en_US")



but nothing happened, it just became like this:
(refer photo attached)


what should I do?




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

Thu Dec 24, 2015 1:28 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That's what the function does. It loads the CSV file into your EXCEL
workbook. You array-enter the function over a range, and it will place the
data into that range.

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

>
> instead of getting cvs file, could I get the data displayed inside one of
> the sheets of my excel?
>
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=5053®ion=MYS&culture=en_US
> ")
>
>
>

Thu Dec 24, 2015 1:34 am (PST) . Posted by:

"Randy Harmelink" rharmelink

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

>
> ok, thanks! Am I allowed to use the morningstar link you gave above to
> retrieve data for diff companies?
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=5053®ion=MYS&culture=en_US
> ")
>

You just need to change the t= and region= parameters to what's appropriate
for your needs.

> and abt the morningstar data, all are in millions rite?
>

Size may vary by company and by currency.

> and how abt the missing gross margin data?
>

No idea. You'd need to ask MorningStar.

> As for
> =RCHGetHTMLTable("
> http://www.klse.my/stock/result/financial/quarterAnalysis/3107.jsp","Revenue
> (",-1,"",16)
> what does -1 represent? and what does 16 represent?
>

You should check the function documentation for that kind of information.
However, the function says to:

1. Grab the source code from that web page.
2. Search for a string of "Revenue (" within the source code.
3. Go backwards to the first previous HTML "<table&quot; tag. That is the
beginning of the data extraction.
4. The "" parameter says to again Search for a string of "Revenue (" within
the source code.
5. Go forward to the 16th HTML "</table&quot; tag. That is the end of the data
extraction.

Then it parses the tables into rows and columns of data, and plops it into
the range you entered the formula over.

Thu Dec 24, 2015 1:39 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Looks like you entered the formula into a single worksheet cell instead of
array-entering the formula over a range. The function can only place data
into worksheet cells that's it been given permission to use. By entering it
into a single cell, you just get the single value from the first row and
first column of the CSV file.

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

> [Attachment(s) <#151d34fe3dcae067_TopText> from perseuslim11@yahoo.com
> [smf_addin] included below]
>
> Hi, I've added the RCH add-in to a new workbook and tried this function:
> =smfGetCSVFile("
> http://financials.morningstar.com/ajax/exportKR2CSV.html?t=5053®ion=MYS&culture=en_US
> ")
>
> but nothing happened, it just became like this:
> (refer photo attached)
>
> what should I do?
>

Thu Dec 24, 2015 1:39 am (PST) . Posted by:

perseuslim11

Hi, i've tried array entering into 111x12 range, but initially didnt work because i forgot to ctrl+shift+enter, only pressed enter, thanks!! It works now

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

perseuslim11

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-Function.html http://ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetHTMLTable-Function.html > SMF add-in Top-Level Directory > Documentation > RCHGetHTMLTable-Function.html



View on ogres-crypt.com http://ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetHTMLTable-Function.html
Preview by Yahoo



=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 http://www.klse.my/stock/result/financial/quarterAnalysis/3107.jsp","Revenue (",-1,"",16)





why is it so?


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

perseuslim11

this is the url that I need to extract from: http://www.klse.my/stock/result/financial/quarterAnalysis/5053.jsp#stockDetailDiv http://www.klse.my/stock/result/financial/quarterAnalysis/5053.jsp#stockDetailDiv



For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar