|
Title: Re: [amibroker] Re: Need some help setting up DTN folders
Yes, Excel couldn't take it. I think I will split the file into two parts and then/sort import the tls.
I was hoping there was an official way to do this and place the tickers into categories, like N100, SP500, etc.
Thanks for the suggestions m,
have a great day!
herman
Saturday, March 28, 2009, 10:09:42 AM, you wrote:
> i filtered it to only import TSE tickers. but it can be modified to add any set of tickers.
> pl note that there are thousands of symbols in that list. it is just a plain
> csv file. you can probably import it in excel and review it. it is possible
> that excel could truncate the file as there seems to be a line length
> limitation in excel but i can be mistaken.
> pl let me know which ones that you want to add, and i can modify the list to
> add those exchagnes or send you a template that you can play with.
>
> for this script to work on your machine, you need to install ruby from www.ruby-lang.org/en/downloads/
> you also need to install the fastercsv library that i use.
> this can be done from your command prompt.
> gem install fastercsv
> in ruby, the # means it is a commented line.
> change the importsymbols.rb to configure amibroker exchange id and location
> of the mktsymbols.txt file and the databse that you intend to use.
> then just goto the command prompt and
> execute ruby importsymbols.rb
> ------------------------------------
> **** IMPORTANT PLEASE READ ****
> This group is for the discussion between users only.
> This is *NOT* technical support channel.
> TO GET TECHNICAL SUPPORT send an e-mail directly to
> SUPPORT {at} amibroker.com
> TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
> http://www.amibroker.com/feedback/
> (submissions sent via other channels won't be considered)
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroker.com/devlog/
> Yahoo! Groups Links
> <*> To visit your group on the web, go to:
> http://groups.yahoo.com/group/amibroker/
> <*> Your email settings:
> Individual Email | Traditional
> <*> To change settings online go to:
> http://groups.yahoo.com/group/amibroker/join
> (Yahoo! ID required)
> <*> To change settings via email:
> mailto:amibroker-digest@xxxxxxxxxxxxxxx
> mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx
> <*> To unsubscribe from this group, send an email to:
> amibroker-unsubscribe@xxxxxxxxxxxxxxx
> <*> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
__._,_.___
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
![]()
__,_._,___
|