Creation of this database

BANKS

Companies/Persons
Data on defaulting companies/persons is captured from advertisements issued by various banks in various newspapers. The key information is entered in a database format. Cleaning of names standardization is done.

Since the source is newpapers only, this database is not comprehensive.

BOMBAY STOCK EXCHANGE LTD.

Companies Delisted
Data on companies that have been delisted by BSE is obtained from BSE. This is in Excel format. The key information is converted into a database format. Cleaning of names of the entities is done.

CENTRAL BOARD OF EXCISE & CUSTOMS

Companies/Persons
Data on companies/directors/proprietors is downloaded from CBEC’s website, which is in html format. The key information - name of entity/person, regulatory action taken etc. is entered into a database format. Cleaning of names of the entities is done.

CENTRAL BUREAU OF INVESTIGATION

Companies/Persons
All press releases available on CBI’s website are first downloaded. The press releases which are of relevance to watchoutinvestors are segregated. The key information-name of entity/person, date of order, defaults committed, regulatory action taken etc. is entered into a database format. In the process, a large degree of standardization is done. For example, the same regulatory action or regulatory charge which is worded in several different ways in CBI’s press releases is standardized. Cleaning of names of both the entities and persons is done.

CENTRAL DEPOSITORY SERVICES (INDIA) LTD.

Companies With High Demat Requests
Data on companies that have high demat requests is downloaded from the CDSL website. This is in html format. The key information is converted into a database format. Cleaning of names of the entities is done.

DEBT RECOVERY TRIBUNALS

Companies/Persons
Data on companies/persons is captured from advertisements issued by various DRTs in various newspapers. The key information is entered in a database format. Cleaning of names standardization is done.

Since the source is newpapers only, this database is not comprehensive.

Moreover, the appeals filed by the respondents with DRAT are not being covered presently.

EMPLOYEES' PROVIDENT FUND ORGANISATION

Companies
Data on companies is downloaded from EPFO’s website, which is in PDF format. The data is then converted to Excel format. The default amounts of a company across various locations are aggregated. The key information - name of entity, amount in default etc. is entered into a database format. Cleaning of names of the entities is done.

INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA

Companies/Persons
Only one record has been created from IRDA Press Release. No data has been forthcoming from ICAI.

INSURANCE REGULATORY & DEVELOPMENT AUTHORITY

Companies
All press releases available on IRDA’s website are first downloaded. The press releases which relate to watchoutinvestors are segregated. The key information-name of entity/person, date of order, defaults committed, regulatory action taken etc. are entered into a database format. In the process, a large degree of standardization is done. For example, the same regulatory action or regulatory charge which is worded in several different ways in IRDA’s press releases is standardized. Cleaning of names of both the entities and persons is done.

MINISTRY OF CORPORATE AFFAIRS

Registrar Of Companies
Data is requested from all – Registrars of Companies. The data is received in typed/word format. The key information-name of entity/person, date of order, defaults committed, regulatory action taken etc. is entered into a database format. In the process, a large degree of standardization is done. For example, the same regulatory action which is worded in several different ways in RoC’s data is standardized. Cleaning of names of both the entities and persons is done.

Company Law Board
Data is requested from all offices of Company Law Board. The data is received from some of them in typed format. The key information-name of entity/person, date of order, defaults committed, regulatory action taken etc. is entered into a database format. In the process, a large degree of standardization is done. For example, the same regulatory action which is worded in several different ways in CLB’s data is standardized. Cleaning of names both the entities and persons is done.

In addition, orders are downloaded from CLB’s website, which is in html format. The key information - name of entity, regulatory action taken etc. is entered into a database format. Cleaning of names of the entities is done.

Official Liquidator
Data is requested from all offices of Official Liquidators. The data is received from some of them in typed format. The key information-name of entity/person, date of order, defaults committed, regulatory action taken etc. is entered into a database format. In the process, a large degree of standardization is done. For example, the same regulatory action which is worded in several different ways in Official Liquidators’ data is standardized. Cleaning of names of both the entities and persons is done.

Simplified Exit Scheme
Data is requested from all Registrars of Companies. The data received is in typed/excel format. The key information-name of entity/person, exit status etc. is entered into a database format. In the process, a large degree of standardization is done. Cleaning of names of both the entities and persons is done.

NATIONAL HOUSING BANK

Housing Finance Companies
Data on housing finance companies is downloaded from NHB’s website, which is in html/word format. The key information - name of entity, regulatory action taken etc. is entered into a database format. Cleaning of names of the entities is done.

In addition, advertisements issued regularly by the NHB in various newspapers are being used as source for creating additional database. In this case also, the data is entered in database format, names are cleaned and standardization is done.

NATIONAL SECURITIES DEPOSITORY LTD.

Companies With High and Long Pending Demat Requests
Data on companies that have high demat requests is downloaded from the NSDL website. This is in html format. The key information is converted into a database format. Cleaning of names of the entities is done.

NATIONAL STOCK EXCHANGE OF INDIA LTD.

Companies Delisted/Suspended
Data on companies that have been delisted/suspended is obtained from NSE. This is in word format. The key information – name of entity, regulatory action etc. is entered into a database format. Cleaning of names of the entities is done.

In addition, advertisements issued regularly by the NSE in various newspapers are being used as source for creating additional database. In this case also, the data is entered in database format, names are cleaned and standardization is done.

Brokers Derecognised
Data on brokers that have been derecognised by the NSE is obtained from NSE. This is in word format. The key information – Name of entity, regulatory action etc. is entered into a database format. Cleaning of names of the entities is done.

In addition, advertisements issued regularly by the NSE in various newspapers are being used as source for creating additional database. In this case also, the data is entered in database format, names are cleaned and standardization is done.

RESERVE BANK OF INDIA

NBFCs
Data on NBFCs is downloaded from RBI’s website, which is in html/word format. The key information - name of entity etc. is entered into a database format. Cleaning of names of entities is done.

In addition, advertisements issued regularly by the RBI in various newspapers are being used as source for creating additional database. In this case also, the data is entered in database format, names are cleaned and standardization is done.

Co-operative Banks
Data on Co-operative Banks is regularly downloaded from RBI’s website, which is in html/word format. The key information - name of entity etc. is entered into a database format. Cleaning of names of entities is done.

In addition, advertisements issued regularly by the RBI in various newspapers are being used as source for creating additional database. In this case also, the data is entered in database format, names are cleaned and standardization is done.

SECURITIES AND EXCHANGE BOARD OF INDIA

Companies/Directors/Intermediaries
All press releases, Chairman’s orders, Member’s orders, Adjudicating Officers orders and SAT orders available on SEBI’s website are first downloaded. The documents which relate to watchoutinvestors are segregated. The key information-name of entity/person, date of order, defaults committed, regulatory action taken etc. is entered into a database format. In the process, a large degree of standardization is done. For example, the same regulatory action or regulatory charge which is worded in several different ways in SEBI’s orders is standardized. Cleaning of names of both the entities and persons is done.

Each press release is linked to Chairman’s/Member’s orders. In the process, it was discovered that there are several press releases for which no Chairman’s/Member’s orders are available on SEBI’s website. Moreover, there are several Chairman’s/Member’s orders for which no press release is hosted on SEBI’s website. Subsequently, the records are linked to SAT’s orders. Again, it was discovered that there are many missing SAT orders.

Sub-Brokers
Since the source is newpapers only, this database is not comprehensive.

SECURITIES APPELLATE TRIBUNAL

Most of the orders of Securities Appellate Tribunal are posted on SEBI’s website. The available SAT orders have been linked to the appropriate SEBI Chairman’s/Member’s orders.