Minggu, 15 Mei 2016

[smf_addin] Digest Number 3699

15 Messages

Digest #3699
2a
Re: Macintosh by pdyson10
2b
Re: Macintosh by "Randy Harmelink" rharmelink
2c
Re: Macintosh by pdyson10
2d
Re: Macintosh by "Randy Harmelink" rharmelink
3b
Re: IBD industry subgroup rankings by "Randy Harmelink" rharmelink
4a
Investing.com by bushpilote
4b
Re: Investing.com by "Randy Harmelink" rharmelink

Messages

Sun May 15, 2016 2:08 am (PDT) . Posted by:

perseuslim11

Just wondering, is it possible to use smfgettagcontent to extract single pieces of data from morningstar?

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

perseuslim11

I see, thanks for your clarification Randy :) Will get the csv instead ^^


---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

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 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 ...








Sun May 15, 2016 6:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's a very difficult extraction, because it has to come out of JSON
Javascript code. That's why I recommend the CSV file.

On Sun, May 15, 2016 at 2:08 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Just wondering, is it possible to use smfgettagcontent to extract single
> pieces of data from morningstar?
>
>

Sun May 15, 2016 6:24 am (PDT) . Posted by:

perseuslim11

Ok, understood ^^ by the way, I've just noticed that reuters uses Reuters Instrument Codes (RIC) for each stocks in KLSE market


Hence, to use data from reuters, I would definitely need all those RICs, I know how to get them one by one, but it is very time consuming, as I am building a full coverage on all 900+ companies in KLSE


is there any where I could get the RICs list for companies in KLSE?
I've tried searching online to no avail as well..


Please let me know if there is such a list or faster way to get RICs, as I am currently manually finding them out one by one, which is super slow haha..
Thanks! :)

Sun May 15, 2016 6:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry. I've never even heard of RIC before, so I know nothing about them.

All I can suggest is doing a series of Google searches to see if you can
find a good source to map them.

On Sun, May 15, 2016 at 6:24 AM, perseuslim11@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> by the way, I've just noticed that reuters uses Reuters Instrument Codes
> (RIC) for each stocks in KLSE market
>
> Hence, to use data from reuters, I would definitely need all those RICs, I
> know how to get them one by one, but it is very time consuming, as I am
> building a full coverage on all 900+ companies in KLSE
>
> is there any where I could get the RICs list for companies in KLSE?
> I've tried searching online to no avail as well..
>
> Please let me know if there is such a list or faster way to get RICs, as I
> am currently manually finding them out one by one, which is super slow
> haha..
> Thanks! :)
>
>
>

Sun May 15, 2016 6:40 am (PDT) . Posted by:

perseuslim11

Alright, thanks for your clarification ^^ then I will just continue the manual seach haha :)

Sun May 15, 2016 5:33 am (PDT) . Posted by:

pdyson10

Randy

I have adapted your add-in to run natively on a Mac and would be happy to work with you to provide an add-in to run on either operating system. Please let me know if you would be interested in doing this.


Regards


Paul





Sun May 15, 2016 6:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I've no interest in doing anything with the Mac...

I'm just sharing something that I developed for my own use.

I still can't believe there isn't a commercial, universal tool that does
the job better.

On Sun, May 15, 2016 at 5:33 AM, pdysonuk@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have adapted your add-in to run natively on a Mac and would be happy to
> work with you to provide an add-in to run on either operating system.
> Please let me know if you would be interested in doing this.
>
>
>

Sun May 15, 2016 6:46 am (PDT) . Posted by:

pdyson10

All that would be required is for your code to include a function to test which operating system the add-in is running on and if it is a Mac, run a different function to retrieve the data from the internet. I have written the code and it would just need to be added to your add-in so that users on any system could you use it. I would be happy to maintain the Mac function calls. We could give it a try - if it turned out that there was additional work for you that we hadn't considered, you could always revert to your original code.

Let me know if that is something that you would consider.


Regards


Paul





Sun May 15, 2016 4:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you can give me a module with all the Mac-related code, and the switch
in the regular code to direct it there instead of the normal route, that
would be acceptable to me.

On Sun, May 15, 2016 at 6:45 AM, pdysonuk@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> All that would be required is for your code to include a function to test
> which operating system the add-in is running on and if it is a Mac, run a
> different function to retrieve the data from the internet. I have written
> the code and it would just need to be added to your add-in so that users on
> any system could you use it. I would be happy to maintain the Mac function
> calls. We could give it a try - if it turned out that there was additional
> work for you that we hadn't considered, you could always revert to your
> original code.
>
> Let me know if that is something that you would consider.
>
>
>

Sun May 15, 2016 12:36 pm (PDT) . Posted by:

mff2805

Hi,
Is there a way to pull the data from this page
http://www.investors.com/data-tables/industry-sub-group-rankings-may-13-2016/ http://www.investors.com/data-tables/industry-sub-group-rankings-may-13-2016/ into a spreadsheet? or, better yet, can you provide an example?
thanks much,
Mike





Sun May 15, 2016 1:06 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I can't determine where the data is coming from. Looks like a
JSON call of some type, which is then loaded onto the web page.

On Sun, May 15, 2016 at 12:36 PM, mff3429@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there a way to pull the data from this page
>
> http://www.investors.com/data-tables/industry-sub-group-rankings-may-13-2016/
>
> into a spreadsheet? or, better yet, can you provide an example?
>
>

Sun May 15, 2016 1:24 pm (PDT) . Posted by:

"Bryan" ilmostro

Just highlight the data in the table, copy, then "paste special" "text"
into a blank spreadsheet.

Bryan

On Sun, May 15, 2016 at 3:06 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Sorry, but I can't determine where the data is coming from. Looks like a
> JSON call of some type, which is then loaded onto the web page.
>
> On Sun, May 15, 2016 at 12:36 PM, mff3429@comcast.net [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Is there a way to pull the data from this page
>>
>> http://www.investors.com/data-tables/industry-sub-group-rankings-may-13-2016/
>>
>> into a spreadsheet? or, better yet, can you provide an example?
>>
>>
>
>

Sun May 15, 2016 1:50 pm (PDT) . Posted by:

bushpilote

Hi Randy,
hope all is well with you.

I use your add-in to pick up closing prices for a bunch of commodities from investing.com.

I can get all the visible historical closing prices http://www.investing.com/commodities/crude-oil-historical-datafrom the following link:(http://www.investing.com/commodities/crude-oil-historical-data) http://www.investing.com/commodities/crude-oil-historical-data, which at the time of writing this email is from April 15-2016 to May 13, 2016, but nothing prior to April 15 2016. http://www.investing.com/commodities/crude-oil-historical-data

Expanding the visible historical data range with the online date picker doesn't change the original url (http://www.investing.com/commodities/crude-oil-historical-data http://www.investing.com/commodities/crude-oil-historical-data), which means the RCHGetTableCell
formula won't work on closing prices prior to April 15 2016.
Any suggestions on how I can resolve this problem?

Thanks and Regards

Sun May 15, 2016 4:32 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't see a way. I tried various URLs that look like they
should pass the parameters, but they had no affect.

You should be able to get more history from barchart.com

On Sun, May 15, 2016 at 1:50 PM, bushpilote@
​...wrote:

>
> Hi Randy,
> hope all is well with you.
>
> I use your add-in to pick up closing prices for a bunch of commodities
> from investing.com.
>
> I can get all the visible historical closing prices
> <http://www.investing.com/commodities/crude-oil-historical-data>from the
> following link:(
> http://www.investing.com/commodities/crude-oil-historical-data)
> <http://www.investing.com/commodities/crude-oil-historical-data>, which
> at the time of writing this email is from April 15-2016 to May 13, 2016,
> but nothing prior to April 15 2016.
> <http://www.investing.com/commodities/crude-oil-historical-data>
>
> Expanding the visible historical data range with the online date picker
> doesn't change the original url (
> http://www.investing.com/commodities/crude-oil-historical-data), which
> means the RCHGetTableCell
> formula won't work on closing prices prior to April 15 2016.
> Any suggestions on how I can resolve this problem?
>
> Thanks and Regards
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar