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 [email protected], "brian_z111" <brian_z...@...> wrote:
>
> http://finance.groups.yahoo.com/group/amibroker/message/133496
>
>
> --- In [email protected], "murthysuresh" <money@> wrote:
> >
> > anyone has a list or know where to get one?
> >
>
