|
PureBytes Links
Trading Reference Links
|
Brian
I was looking for a list that trades only on both Nasdaq and TSE.
if you need just TSE tickers, the best one is from DTNIQ which has
tickers for all the data they provide.
http://www.dtniq.com/product/mktsymbols.zip
here is a bit of a ruby script that will import it into amibroker.
require 'fastercsv'
require 'win32ole'
class ImportSymbols
TSE=4
def loadSymbols(databaselocation)
# downlload symbols from http://www.dtniq.com/product/mktsymbols.zip
rows=FasterCSV.open("c:\\temp\\mktsymbols.txt",{:headers=>:first_row,:col_sep=>"\t"
,:skip_blanks=>true})
importStocks=Array.new
rows.each{|r|
case r['EXCHANGE']
when 'TSE'
importStocks<<r
end
}
puts importStocks.length
amibroker = WIN32OLE.new("Broker.Application")
amibroker.loadDatabase(databaselocation) #load the database
stocks=amibroker.stocks
importStocks.each{|stk|
begin
stock=stocks.add(stk["SYMBOL"])
stock.FullName=stk["DESCRIPTION"]
stock.MarketID =TSE
rescue => detail
print detail.backtrace.join("\n")
puts stk.to_s
end
}
amibroker.SaveDatabase()
amibroker.quit()
end
end
test=ImportSymbols.new
test.loadSymbols("E:\\Data\\Stocks")
--- In amibroker@xxxxxxxxxxxxxxx, "brian_z111" <brian_z111@xxx> wrote:
>
> http://finance.groups.yahoo.com/group/amibroker/message/133496
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "murthysuresh" <money@> wrote:
> >
> > anyone has a list or know where to get one?
> >
>
------------------------------------
**** 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/
|