Amibroker Database for NSE stocks

karthikmarar

karthikmarar

Well-Known Member
#51
#51
ragh_ash said:
Hi karthik, murthysir,
i loaded the sector dta and my observation would be
a)Kalp power, ptc kec should be in Power/Others rather than in Textiles
B) emkay AND gEOJIT SHOULD be in Financial/Others(presently in Pharma and diversified resp)
if yes pl tell me how to make corrections in my database
regards
Click to expand...

ragh_ash

Thanks for the feedback. We were looking forward to feedbacks like this. This helps us having a good allocaation of Industries and sectors.

1. kalp power, ptc, KEC etc are in Power/ others. Please check. I am enclosing the complete list of sector allocation (latest correction not incorporated) for your reference.

2. Fully agree with you on Emkay and Geojit. These can be moved to Financial service / Investment.

Also please note another mistake which was pointed out by another member.

Kothari poduct now apperaring under sugar industry. This could be moved to Consumer goods/Cigrettes as this company is related to tobacco products.

We look forward to more such comments.

warm regards

karthik
 
Last edited:
karthikmarar

karthikmarar

Well-Known Member
#52
#52
ragh_ash

oops .. forgot the explanation for moving the stocks from one industry to another.

In the Symbol menu ontop select Organize Assignments..

organize assignments window opens.. select the Industry radio button

on the left pane select the industry where the stock you want to move resides. On the right pane select the new industry where you want to move the stock to. Click the > button... as simpla as that.. The screen image enclosed...

warm regards

karthik
 
Last edited:
M

murthymsr

Well-Known Member
#53
#53
karthikmarar said:
ragh_ash

oops .. forgot the explanation for moving the stocks from one industry to another.

In the Symbol menu ontop select Organize Assignments..

organize assignments window opens.. select the Industry radio button

on the left pane select the industry where the stock you want to move resides. On the right pane select the new industry where you want to move the stock to. Click the > button... as simpla as that.. The screen image enclosed...

warm regards

karthik
Click to expand...
thanks karthik for detailing the procedure.

additionally, one may incorporate such chnges in his stockindustry.txt file also, so that in the unfortunate event of rerunning the sector-industry asignment program, the new assignments will be up-to-date.

hope i am clear.
murthymsr
 
karthikmarar

karthikmarar

Well-Known Member
#54
#54
Hi all

Stock / Industry Allocation for new listing - NSE.

Company: Development Credit Bank Ltd.
Symbol : DCB
Line of Business : Banking
Sector : Banking
Industry : Private

regards

Karthik
 
karthikmarar

karthikmarar

Well-Known Member
#55
#55
Hi all

Stock / Industry Allocation for new listing - NSE.

Company: Global Vectra Helicorp Ltd.
Symbol : GLOBALVECT
Line of Business : Air Transport
Sector : Service
Industry : Aviation

regards

karthik
 
karthikmarar

karthikmarar

Well-Known Member
#56
#56
Hi All

Stock / Industry Allocation for new listing - NSE.

Company: Accel Frontline Ltd.
Symbol : AFL
Line of Business : IT Solutions
Sector : IT
Industry : Software Small

regards

karthik
 
M

mdv10002000

New Member
#57
#57
karthikmarar said:
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
Click to expand...




very good work and new concept of alloting sector but i have done one correction
var filename = "d:/stockindustry.txt";
instead of
var filename = "d://stockindustry.txt";

than it's work

otherwise it's give error

ones again thanks for great idea
 
M

murthymsr

Well-Known Member
#58
#58
hi all,

i hope you have by this time incorporated the sectors and industries on your AB database, including the additions being posted by him from time to time.

exporting all the currently set industries and secors against a stock. may be helpful for your record and to review/modify them on your own.

i am attaching an AFL, which will display the list of stocks with their industry and sectors. as usual, you may change the extention to AFL and scan for all symbols and all days.

all the best.
murthymsr
 
Last edited:
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
rinku4142 NSE EOD Database for Amibroker Data Feeds 3
OneThatGotAway NSE Amibroker Database 5 yrs with self update End of Day 107
B AmiBroker database nse stocks AmiBroker 0
V Help needed in setting-up Up to date NSE Database in Amibroker AmiBroker 1
Q nse eod database 4 amibroker. End of Day 0

Similar threads