Ami Database - sector classification

sr114

Well-Known Member
#1
Hello

required info/resources in classifying or rearranging the amibroker database according to NSE classification.

either afl or jscript/vbscript for classyfing the ami database according to NSE sector/industry definition.

any 1 have this resource/info?

rgds
subroto
 

sudris

Well-Known Member
#2
Hello

required info/resources in classifying or rearranging the amibroker database according to NSE classification.

either afl or jscript/vbscript for classyfing the ami database according to NSE sector/industry definition.

any 1 have this resource/info?

rgds
subroto
hi sr
how you doing?

could you come up with the list of stocks and their respective sectors in csv format?
have something in mind that may work but will need the list first. ;)

regards
 

sr114

Well-Known Member
#3
hi sr
how you doing?

could you come up with the list of stocks and their respective sectors in csv format?
have something in mind that may work but will need the list first. ;)

regards
Hello Sudris

here's the link for the files u require
1. 1st link (contains the list in shortened form)
http://www.ziddu.com/download/21557692/IndustrySectorStockList.csv.html

2. 2nd link (more extensive)
http://www.ziddu.com/download/21557705/IndustrySectorStockList1.csv.html


rgds
subroto
 

sudris

Well-Known Member
#4
Hi sr

what is the source for those lists?
can we have the industry classification as per what is provided in CNX-500?
CNX-500 because it is the only index with huge amount of stocks and should cover majority of the industries. have listed them below :

ABRASIVES
AIRCONDITIONERS
ALUMINIUM
AUTO ANCILLARIES
AUTOMOBILES - 2 AND 3 WHEELERS
AUTOMOBILES - 4 WHEELERS
BANKS
BEARINGS
BREW/DISTILLERIES
CABLES - POWER
CASTINGS/FORGINGS
CEMENT AND CEMENT PRODUCTS
CERAMICS AND SANITARYWARE
CHEMICALS - INORGANIC
CHEMICALS - ORGANIC
CHEMICALS - SPECIALITY
CIGARETTES
COMPRESSORS / PUMPS
COMPUTERS - HARDWARE
COMPUTERS - SOFTWARE
CONSTRUCTION
CONSUMER DURABLES
CYCLES
DIESEL ENGINES
DIVERSIFIED
DYES AND PIGMENTS
ELECTRICAL EQUIPMENT
ELECTRODES
ELECTRONICS - INDUSTRIAL
ENGINEERING
FASTNERS
FERTILISERS
FINANCE
FINANCE - HOUSING
FINANCIAL INSTITUTION
FOOD AND FOOD PROCESSING
GAS
GEMS JEWELLERY AND WATCHES
HOTELS
LEATHER AND LEATHER PRODUCTS
MEDIA & ENTERTAINMENT
METALS
MINING
MISCELLANEOUS
OIL EXPLORATION/PRODUCTION
PACKAGING
PAINTS
PAPER AND PAPER PRODUCTS
PERSONAL CARE
PESTICIDES AND AGROCHEMICALS
PETROCHEMICALS
PHARMACEUTICALS
PLASTIC AND PLASTIC PRODUCTS
POWER
PRINTING AND PUBLISHING
REFINERIES
REFRACTORIES
SHIPPING
SOLVENT EXTRACTION
STEEL AND STEEL PRODUCTS
SUGAR
TEA AND COFFEE
TELECOMMUNICATION - EQUIPMENT
TELECOMMUNICATION - SERVICES
TEXTILE MACHINERY
TEXTILE PRODUCTS
TEXTILES - COTTON
TEXTILES - SYNTHETIC
TRADING
TRANSMISSION TOWERS
TRAVEL AND TRANSPORT
TYRES
 

casoni

Well-Known Member
#5

casoni

Well-Known Member
#6
Hello everyone,
Posting after long time
here's the sector and industry classification of NSE , import format

$FORMAT Ticker, FullName,IndustryName,SectorName
$SEPARATOR ,
$AUTOADD 1
$NOQUOTES 1
$OVERWRITE 1
$CLEANSECTORS 1
$SORTSECTORS 1

please check , and let me know if there is any mistake in assign the stock to its Ind / sec

*Requires AB 5.60 or above



Link to download csv

https://drive.google.com/file/d/0B2HDkZSTrj09Y3lkY0RYTnU1Z0k/edit?usp=sharing

Hope this will be useful
Thank you
 

cloudTrader

Well-Known Member
#7
Hello everyone,
Posting after long time
here's the sector and industry classification of NSE , import format

$FORMAT Ticker, FullName,IndustryName,SectorName
$SEPARATOR ,
$AUTOADD 1
$NOQUOTES 1
$OVERWRITE 1
$CLEANSECTORS 1
$SORTSECTORS 1

please check , and let me know if there is any mistake in assign the stock to its Ind / sec

*Requires AB 5.60 or above



Link to download csv

https://drive.google.com/file/d/0B2HDkZSTrj09Y3lkY0RYTnU1Z0k/edit?usp=sharing

Hope this will be useful
Thank you
Thanks so much. This will be really a great help .

Another link for segregation of Companies sector wise.

http://www.traderji.com/trading-resources/95455-list-securities-traded-nse-fno.html#post1002476

PS: I noticed afterwards that the excel file which you have provided is for import purpose. The link which I mentioned is just a list.

Thanks for the Excel File.

Regards.
 
Last edited:

TradeOptions

Well-Known Member
#9
Thanks for sharing the links casoni and Leonid :thumb:

from Amibroker Guide - https://www.amibroker.com/guide/d_ascii.html

Importing Sector/Industry structure

Let's assume we have a text file with Stock tickers, Full names, Sector name and industry name listed line by line, as follows:

"DDD","3D Systems Corporation","Technology","Computer Software: Prepackaged Software"
"MMM","3M Company","Health Care","Medical/Dental Instruments"
"SVN","7 Days Group Holdings Limited","Consumer Services","Hotels/Resorts"
"AHC","A.H. Belo Corporation","Consumer Services","Newspapers/Magazines"
"AIR","AAR Corp.","Capital Goods","Aerospace"
"AAN","Aaron's, Inc.","Technology","Diversified Commercial Services"
"ABB","ABB Ltd","Consumer Durables","Electrical Products"

To import such file we use the following format definition:

$FORMAT Ticker, FullName,SectorName,IndustryName
$SEPARATOR ,
$AUTOADD 1
$NOQUOTES 1
$OVERWRITE 1
$CLEANSECTORS 1
$SORTSECTORS 1

$NOQUOTES 1 tells the importer that we will be importing non-quotation data. $AUTOADD 1/$OVERWRITE 1 is required to automatically add new symbols and overwrite existing symbol information. $CLEANSECTORS 1 wipes existing stock/industry structure prior to importing and $SORTSECTORS 1 - sorts sectors/industries after importing so they will be listed in alphabetical order in the Symbol window. $FORMAT command just specifies the order and types of field to import

AmiBroker will read such ASCII file one-by one, then it will check whenever given sector name/industry name already exists, if not - it will create new sector/industry. Then it will assign given symbol to specified sector/industry.

The result will be a database with new sector/industry structure being set up and symbols assigned to proper sectors and industries.

Described functionality is used to implement Tools->Update US symbol list and categories tool.
Regards
 

Similar threads