Ami Database - sector classification

#11
Please Give Step by Step I am not able to configure sector wise in AMI
Steps:
1. go to your ambroker install directory: In my case it is c:\ProgramFiles\Amibroker
2. go to formats folder in the amibroker directory.
3. open a text file, write the above code, and save it in the format directory, with 'format' extention. I saved it as 'sector.format'
4. find 'import.types' file in same folder, open it with notepad and add following lines :
Code:
Sector format(*.csv)|*.csv|sector.format
5. Save this https://drive.google.com/file/d/0B2HDkZSTrj09Y3lkY0RYTnU1Z0k/edit?usp=sharing file in your hard drive, extract it
6. Open amibroker, go to file -> import ascii.
7. In 'files of types' you will find 'Sector format(*.csv)', select it.
8. point to the extracted file 'I_s.csv'
9. click import..

post your doubts
regards
Srivastava
 
Last edited:

cloudTrader

Well-Known Member
#12
Steps:
1. go to your ambroker install directory: In my case it is c:\ProgramFiles\Amibroker
2. go to formats folder in the amibroker directory.
3. open a text file, write the above code, and save it in the format directory, with 'format' extention. I saved it as 'sector.format'
4. find 'import.types' file in same folder, open it with notepad and add following lines :
Code:
Sector format(*.csv)|*.csv|sector.format
5. Save this https://drive.google.com/file/d/0B2HDkZSTrj09Y3lkY0RYTnU1Z0k/edit?usp=sharing file in your hard drive, extract it
6. Open amibroker, go to file -> import ascii.
7. In 'files of types' you will find 'Sector format(*.csv)', select it.
8. point to the extracted file 'I_s.csv'
9. click import..

post your doubts
regards
Srivastava

Got the allocation of companies sectorwise perfectly . Thanks a ton. :clap: :clapping:
 

Iron_Man

Active Member
#15
Any way this EOD data can be classified as per the Indices in Amibroker ?
Like CNX100,CNXAuto,CNXPharma,etc ?
Will have to be done manually.. this way..

Go to Symbol - Categories - Name few of them as your ur need (CNX100, CNXAUTO etc)

Then go to Organize asignment - and just select the scripts all that you want to put under the categories
 

amitrandive

Well-Known Member
#16
Will have to be done manually.. this way..

Go to Symbol - Categories - Name few of them as your ur need (CNX100, CNXAUTO etc)

Then go to Organize asignment - and just select the scripts all that you want to put under the categories
Thanks Ironman
Any faster way to do this?
:D
 

amitrandive

Well-Known Member
#17
Steps:
1. go to your ambroker install directory: In my case it is c:\ProgramFiles\Amibroker
2. go to formats folder in the amibroker directory.
3. open a text file, write the above code, and save it in the format directory, with 'format' extention. I saved it as 'sector.format'
4. find 'import.types' file in same folder, open it with notepad and add following lines :
Code:
Sector format(*.csv)|*.csv|sector.format
5. Save this https://drive.google.com/file/d/0B2HDkZSTrj09Y3lkY0RYTnU1Z0k/edit?usp=sharing file in your hard drive, extract it
6. Open amibroker, go to file -> import ascii.
7. In 'files of types' you will find 'Sector format(*.csv)', select it.
8. point to the extracted file 'I_s.csv'
9. click import..

post your doubts
regards
Srivastava
Am unable to get the sector classification,all I get is the full name of the stock.
Please advise.
 

amitrandive

Well-Known Member
#18
Any way this EOD data can be classified as per the Indices in Amibroker ?
Like CNX100,CNXAuto,CNXPharma,etc ?
Thanks Ironman
Any faster way to do this?
:D
Will have to be done manually.. this way..

Go to Symbol - Categories - Name few of them as your ur need (CNX100, CNXAUTO etc)

Then go to Organize asignment - and just select the scripts all that you want to put under the categories
Am unable to get the sector classification,all I get is the full name of the stock.
Please advise.
Bumping requests
 

casoni

Well-Known Member
#19
create watchlist like shown in below image ,
then do as iron -man said

 
Last edited:

casoni

Well-Known Member
#20
Am unable to get the sector classification,all I get is the full name of the stock.
Please advise.
Hello ,

first download csv file from this link

https://drive.google.com/file/d/0B2H...it?usp=sharing

https://drive.google.com/file/d/0B2HDkZSTrj09Y3lkY0RYTnU1Z0k/edit?pli=1

you will get I_s .csv

then create a dummy format , save that format [ give whatever name you like e.g - I_s.format]

then edit that forma t file and copy-paste these lines

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


save the changes ... now import I_s .csv with I_s format ...
your all stocks will get classified > Full Name / industry / Sector

Hope this helps
 

Similar threads