Minggu, 15 Mei 2016

[smf_addin] Digest Number 3698

2 Messages

Digest #3698

Messages

Sun May 15, 2016 12:27 am (PDT) . Posted by:

"joo zhi" perseuslim11

I've tried looking at documentation of rchgetelementnumber as well as smf template morningstar key ratios.xls but still unable to find ways to get any morningstar key ratios working....
Company example is Magnitech, ticker symbol "Magni" ,7087 ticker number  (from klse market)
I've tried using rchgetelementnumber("7087";,14387)
Also tried using these in the ticker:"Xkls:"&7087&"""7087.kl"
Please help... Been trying for half a day to no avail on this ...
Sent from Yahoo Mail on Android

Sun May 15, 2016 1:59 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The correct ticker symbol to use on Morningstar would be XKLS:7087.
However, the filings pages for foreign companies are carried differently on
Morningstar, so that extraction can't work since the web page doesn't exist
for that ticker symbol.

However, you could grab their CSV file and extract from those results:

=smfGetCSVFile("
http://financials.morningstar.com/ajax/exportKR2CSV.html?t=XKLS:7087")

On Sun, May 15, 2016 at 12:27 AM, joo zhi perseuslim11@
​... wrote:

>
> I've tried looking at documentation of rchgetelementnumber as well as smf
> template morningstar key ratios.xls but still unable to find ways to get
> any morningstar key ratios working....
>
> Company example is Magnitech, ticker symbol "Magni" ,7087 ticker number
> (from klse market)
>
> I've tried using rchgetelementnumber("7087";,14387)
> Also tried using these in the ticker:
> "Xkls:"&7087&""
> "7087.kl"
>
> Please help...
> Been trying for half a day to no avail on this ...
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar