Import DTNIQ symbols

howto
Tags: #<Tag:0x00007f2d7abb14b8>

#1

DTNIQ now shares the symbols in the following format @ http://www.dtniq.com/product/mktsymbols_v2.zip
How can we import this into AMIBROKER database preserving the symbol/LISTED MARKET /sic/ etc.

SYMBOL	DESCRIPTION	EXCHANGE	LISTED MARKET	SECURITY TYPE	SIC	FRONTMONTH	NAICS
&QCL&12	CRUDE OIL 12 MONTH STRIP AVERAGE	NYMEX	NYMEX_GBX	STRIP			
&QCL&18	CRUDE OIL 18 MONTH STRIP AVERAGE	NYMEX	NYMEX_GBX	STRIP			
&QCL&24	CRUDE OIL 24 MONTH STRIP AVERAGE	NYMEX	NYMEX_GBX	STRIP