Hi All
Finally we come to the actual procedure to setup the sectors and Industries for Amibroker.
We require 2 Amibroker files, One text file containing the industry details for the stocks and finally one afl to load the data into Amibroker. Following are the files
1. Broker.sectors - Ami file
2. Broker.Industries - Ami File
3. Stockindustry.txt - text file containg the industry details for the stocks
4. loaddata.afl - Afl for lading the sector and Industry data.
Following is the procedure
1,Backup file c:\Program Files\Amibroker\data\Broker.Workspace ( or d:\... wherever you AB is loaded)
2. Delete Broker.Workspace
(Or you can just rename the existing Broker.Workspace into something convenient to remember)
3. Backup and Delete broker.industries and broker.sectors from
c:\program files\Amibroker.
(Or just rename as mentioned before)
4. Copy the files new broker.sectors and broker.industries file to this dir.
5. Copy LoadData.afl into c:\programfiles\Amibroker\formulas\custom ( or d:\... wherever you AB is loaded)
6. Modify LoadData.afl file to point to where the StockIndustry.txt file. Is located. The Default location is the root directory of D:\. If you are apprehensive in changing the Loaddata.afl , just save the txt file in the root directory in partition D.
7. Now open Amibroker.
8. By default, all the stocks will be in the 1st industry, Agro - Others. Move them to Industry 255 using menu item Symbol -> Organize assignments..
9. Open LoadData.afl for analysis. In the Analysis window, choose the following
Apply to: All stocks
Range : Last 200 quotes.
And then run the scan. This may take a few minutes depending on your computer speed.
10. Once the Scan is complete, check it your sector and Industry allocation.
The necessary files enclosed.
Please do let us know if you face any problem..
warm regards
karthik
Finally we come to the actual procedure to setup the sectors and Industries for Amibroker.
We require 2 Amibroker files, One text file containing the industry details for the stocks and finally one afl to load the data into Amibroker. Following are the files
1. Broker.sectors - Ami file
2. Broker.Industries - Ami File
3. Stockindustry.txt - text file containg the industry details for the stocks
4. loaddata.afl - Afl for lading the sector and Industry data.
Following is the procedure
1,Backup file c:\Program Files\Amibroker\data\Broker.Workspace ( or d:\... wherever you AB is loaded)
2. Delete Broker.Workspace
(Or you can just rename the existing Broker.Workspace into something convenient to remember)
3. Backup and Delete broker.industries and broker.sectors from
c:\program files\Amibroker.
(Or just rename as mentioned before)
4. Copy the files new broker.sectors and broker.industries file to this dir.
5. Copy LoadData.afl into c:\programfiles\Amibroker\formulas\custom ( or d:\... wherever you AB is loaded)
6. Modify LoadData.afl file to point to where the StockIndustry.txt file. Is located. The Default location is the root directory of D:\. If you are apprehensive in changing the Loaddata.afl , just save the txt file in the root directory in partition D.
7. Now open Amibroker.
8. By default, all the stocks will be in the 1st industry, Agro - Others. Move them to Industry 255 using menu item Symbol -> Organize assignments..
9. Open LoadData.afl for analysis. In the Analysis window, choose the following
Apply to: All stocks
Range : Last 200 quotes.
And then run the scan. This may take a few minutes depending on your computer speed.
10. Once the Scan is complete, check it your sector and Industry allocation.
The necessary files enclosed.
Please do let us know if you face any problem..
warm regards
karthik
I am new to amibroker and was implementing the steps mentioned in this useful post.but i am not able to see anything in my sector.By default all companies are in sectors/services/advertising.My amibroker version is 5.20.As i hve recently setup database,didnot implemented the steps to cleanup database.please guide me whats wrong?
Thanks,
Arti