Friday, November 30, 2012

Problems in Research in M&A in India

This article I have written out of my own experience

* The CMIE prowess database is considered most reliable database. But this database need some modifications. This do not keep data on the country of acquirer and target firm.
* M&A as such is few in India compared to other countries. So performance evaluation studies specifically financial pre and post m&A is difficult since nonavailability of continuous data.
*In Prowess , it is not mentioned about the method of payment of deal in detail. So whether a particular deal is  cash deal or stock deal, is difficult to know, specifically when there is combination of both the methods. we have search in individual deal in google search engine.
*There is no mention if with merger, the acquirer company name exist, or target company name exist or a new name is present. It would help to know which type of merger deals are done.
*There should be another section of demerger list in prowess. However, ACE database have such data. But again ACE database, data when stored in excel, it is unable to be copied for data analysis.
*Sometimes some deals are completed, which are not updated in prowess, quickly.
*The company names changes within few months, so researchers have to track each time which company name has changed to what. The solution to this is save the company name along with the company BSE script code or ISIN code, so that it would be used for different database. different database have different way of writing the company name. The same company name would appear in different ways in prowess database, Capitoline database and ACE database.
*In merger cases, since the target company ceases to exist, so there financial data is unavailable  so there is a need to know after merger, which company exist.
*Sometimes questionnaire method also do not help fully, since the respondents take time to reply and if they reply it would be a copy and paste matter. so the researcher have to check if the respondent have given  reply from own experience or not.

Written as on 30th November 2012

Tuesday, November 20, 2012

Kuch aapke naam

Dedicated to a friend who left hostel after completing studies 

Jane kaisa hai yeh dosti hamari
Kuch adhe adhure se mulakat hamari
Duriyan kabhi lagi nehi zindegi
Par tum dur jane ki baat ki toh
Yaad aye sal do sal ki haar baat hamari
Yeh zindegi se tha jo mulakat hamari

Dedicated to a friend who had recently fall in love

Tu Isqh na karna
Ismen lakho taklifen hain
Yeh jamana bataye hame
Isqh na karke jeena bhi koi jeena hai
Ishe behetar hum mar jayen so baar
Hum jamane ko samjhaye

Saturday, November 17, 2012

Aaap se yun juda hokar

Yaseen Anwer , a friend in poetry group in facebook wrote the two lines below which touched my heart

Ek Muddat ho gai hai khud se khafa hokar
Kaha tum chale gai mujh se juda hokar 

Then i felt to complete it and wrote my shayeri which came spontaneously from my heart
you can read them below

Zindegi toh ji liya apne hame bhool kar;
Par aap toh zindegi the hamare ,
Hum jiyen kaise aaap se juda hokar

Jahan rehete the aap in palko par
Aab panha milgayi wahan ashkon ko
Apki yaadein kahan muskarne deti hai
Khafa toh men bhi hoon khud se
Aaap se yun juda hokar

Aap toh sayar ban gaye
Muhje apki dil ki sayari bana kar
Taliyon ki goonz men; logon ki bid men
Aap ke din gujar gaye honge
Hum toh tanha hi kate din aur raten
Aap se yun juda hokar


Thursday, November 1, 2012

Yeh mukadar men kahin kho gaye

Yeh mukadar men kahin kho gaye
Wo mahek tumhara jo apna banaye
Wo akarsan chehera jo chahat jagaye
Wo ankhon se baat sabhi
Wo honson se raat kabhi
Wo dil lagana mera
Wo dil todna tera
Wo sison ka mahal
Wo kalam se gazal
Wo duriyon ki tadap
Wo nazdiyon ki kasak
Wo pedon ki chaon
Wo anjaan gaon
Wo subhe ki dhoop
Wo khilta hua roop
Wo hardam apka satana
Wo pyar se fir manana
Wo goonz hasi ki 
Wo madhosi baaton ki
Wo umeed men men subhe jagna
Wo khwahison men shaam katna
Yeh galion men kahin rehe gaye 
Yeh mukadar men kahin kho gaye
Jise apna takdir banana tha
Wo takdir ka naam leke dur ho gaye

1st November 2012
HIT a LIKE at if you like the poem

Bash Tum....

Bash Tum...

Tum jo aye, muskuraye yeh dharti asman
Tum jo aye toh, yeh muskurahat yeh hasi ka silsila
Kho jao na men kahin
Kho jaaun na men yahan
Never ever go, keep me within you
Like your reflections, I can go through

Tum jo pass ho, sambhalne lage hum yahan
Tum jo pass ho, khilkhiyale chehera yahan
Kho jao na mujhme kahin rehjao na
Dhundu toh milo dil men esse rehe jao na
Be with me, my love my life
Hug me so that I can hug my life

Tum jo sath ho, tabiyat khilne lagi
Tum jo sath ho, gham sab bhulne lagi
Muhje bhi tumhare sath le jao
Dil ki duniya men ghar banayun, esa pyar de jao
Make me your love, your destiny lines
Your life partner, your dream divine

Tum jo thame mere hath, sath jane ki rah khulgaye
Tum jo thame mere hath, jeene ki chah milgaye
Embrace my feelings and hold my hand
Rule my heart, until I merge in sand

1st November 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

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?...