Thursday, November 1, 2012

Prowess database..basic steps to use

Prowess is the reliable database in india to get company information. I thought to share the basic steps so that it would help the beginners.
I will show some basic steps that would help beginners to use the prowess for data collection. any more queries , you can post in comment, i will update the article as per your queries.
step 1click on prowess database and run the program to open prowess
 step-2 It would ask for username and password.
 step3 The figure shows the prowess window when it open up
 step 4 The option in left hand corner SELECT COMPANIES IN PRE-DEFINED SETS. help you to classify set as per your requirement. It classifies companies into non financial and financial companies. you can choose the companies as per your need. There is sub classifications of the companies in different industries too like in non and beverage industry companies.

The red arrow shows the list of industries. you can click on the left side rectangle box for the industry you want to select and then run. To run you have three otions which have been marked in ricght hand corner of the figure below in blue(add to current), green ( send to new osc), orange.(replace current osc). 
(a)If you already have a company set and you want to add few more companies in it-use BLUE arrow option(add to current)
(b)If you want a new set of companies, use GREEN arrow option.( send to new osc)
(c)If you want to replace the existing set of companies with new lsit of companies . use ORANGE arrow option (replace current osc). 
then it would give an a output sheet like below in figure . say i have run for food and beverage companies and i found 1660 food and beverage companies. see the blue arrow. the sheet is indicated with a blue circle market which represent this is the "active output sheet/current sheet" on which you can work now. see the red arrow, it shows the OUTPUT SHEET option. This option you can use whenever you wnat to look into the output sheet.

now you can save the file in prowess, so that next time you open your prowess, you wont have to run the program again for same kind of set. you can ust open the saved output sheet as you have worked earlier. to save the file use the option indicated in green arrow. It will ask for a file name as indicated in red arrow. after gving a file name you click on SAVE option as indicated in blue arrow. The yellow arrow shows a yellow box which if clicked will help you in making a new folder to save your files as per your customized needs.

now the file is saved. This file is saved in prowess program userset folder. you can see it by folowing way-
Go START menu
so you can copy those files and can save in other computer in same process in same place and can use in other computers too. you don't have to run program again if you change your computer system or laptop. from this place also you can send your datasets to other persons doing work on same data sets.

or you can simply save in excel by copy and paste the companies list.

always use the cross symbol (CLEAR ALL option) indicated by red arrow to clear any list from the predefined industry that you clicked earlier in the rectangle box, so that running the program, it wont take both the clicked item

next, suppose from those food and beverage companies-i want it to filter for more criteria.for example listed food and beverage companies, then use LISTED AND PERMITTED COMPANIES option as indicated on red arrow below one. then clcik on COMPANIES IN CURRENT OSC as indicated in green arrow. then click on RETAIN MATCHED COMPANIES IN OSC option as indicated in blue arrow. , you will get listed food and beverage companies. 

see i have used CLEAR ALL OPTION (x) before i clicked on LISTED AND PERMITTED COMPANIES option , so there is so click on FOOD AND BEVERAGE industry option. thus it would not again take same companies again, rather reduce to only listed food and beverage companies.

you can also use REMOVE FROM OSC OPTION as given in right hand corner below, so that it would removed listed food companies from your food and beverage companies set.

you can use your usersets, which would look like the figure below as indicated by the red arrow. you can create so many sets as per your needs , name name and use as many times you need. Just click on the rectabgle box near the set which u need and run SEND TO NEED OSC  as discussed earlier. 

The more you explore yourself , the more you would know. So keep exploring .

you can also get clarifications on prowess from
Any queries, you can post comment, i would do my best to help you


  1. i want to take balance sheet and profit loss account of some companies.please tell me the procedure

  2. You can take them from the ANNUAL FINANCIAL STATEMENTS. OR you can select the companies list first by making a output sheet, then select them all, go to report viewer option -then for each company just copy paste the financial data which would be available there. Hope i have clarified .

  3. i want to find financial statements of non IT companies with no debt for 10 years with turnover of abve Rs 100 crores

  4. for any query on prowess database, pls log in to and put forth your queries in seek clarifications.

  5. i have a user set that sum1 mailed me. how do i open that in prowess. it is saved wid .psu extension.


  6. from where can i download setup file


Note: Only a member of this blog may post a comment.

About Leepsa...writer by chance but write by choice

My photo
Chandler, Arizona, India
N. M. Leepsa is a young writer, teacher researcher, painter. She was born in 1985 in Bhubaneswar, India’s eastern state of Odisha. Her parents Nabaghan Jena(Father ) and Madhabika Jena(Mother) raised her with utmost care to give her higher education and support her achieve whatever academic credentials. She did her schooling at the Children’s Centre of Integral Education, Bhubaneswar, Odisha. She attended Ramadevi Women’s College (B.Com), Utkal University (M.Com);Ravenshaw University (M.Phil) for her college studies. After this, she was inspired to pursue her PhD from Vinod Gupta School of Management, Indian Institute of Technology Kharagpur. Completing her studies, she joined as faculty of finance in LMT School of Management, Thapar University, Patiala, Punjab and then worked at School of Management, National Institute of Technology, Rourkela, Odisha. She is currently pursuing her professional courses at Grand Canyon University, USA. She can be reached at • Email:, • Facebook Page: • Blog:

Featured Post

Capstone Project: The 5 W's and the H

■ WHAT makes capstone project ? ■ WHY it matters ? ■ WHO will win? ■ WHEN to start preparation? ■ WHERE is the source of idea?...