8 Messages
Digest #3590
1b
Re: Hi,I'm a newbie here, I've read the faq page, but I still have n by "Randy Harmelink" rharmelink
1c
Re: Hi,I'm a newbie here, I've read the faq page, but I still have n by "Randy Harmelink" rharmelink
1d
Re: Hi,I'm a newbie here, I've read the faq page, but I still have n by "Randy Harmelink" rharmelink
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?
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
> ")
>
>
>
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" 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" 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.
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","
> (",-1,"
> 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&quo
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&qu
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?
>
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?
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","
why is it so?
Thu Dec 24, 2015 2:04 am (PST) . Posted by:
perseuslim11
it just returns blank with the formula I've entered @.@
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:
Posting Komentar