It is very important to have clean database before we start allocating the Sector and Industry to the stocks.

So first we have to clean up our databases before we proceed. The basic things to do will be as follows
  • Correct for all symbol changes and delete the old symbols from the database.
  • Correct for all splits and bonus.
  • Verify that our stock list match with the NSE lists.