Hi All,
In order to conduct an event study, I have to sort company’s data in specific manner.
Excel file consists of 9 sheets, each sheet has data of same companies, but for different years. The data is in rows and is related to company’s symbol, date and price on specific date. The following table shows the data for 3 of 921 company’s from the sample, which is derived from the sheet related to the year 2002.
ZOT SM Equity
Date 1/3/2002 1/4/2002
PX_LAST 4.8717 4.7875
ZON PL Equity
Date 1/3/2002 1/4/2002
PX_LAST 4.0601 4.0212
ZIL2 GR Equity
Date 1/3/2002 1/4/2002
PX_LAST 1.75 1.676
I have to gather all data from 9 sheets (year 2002-2010) in one sheet and sort it into columns. This means data of one company for all years, then second company data for all years etc. For example:
Symbol Date PX_LAST
ZOT SM Equity 1/2/2002 4.7565
ZOT SM Equity 1/3/2002 4.8717
ZOT SM Equity 1/4/2003 4.7875
ZOT SM Equity 1/5/2003 4.7875
ZOT SM Equity 1/6/2004 4.7875
ZOT SM Equity 1/7/2004 4.7875
ZOT SM Equity 1/8/2005 4.7875
ZOT SM Equity 1/9/2005 4.7875
ZON PL Equity 1/2/2002 3.8996
ZON PL Equity 1/3/2002 4.0601
ZON PL Equity 1/4/2003 4.0212
ZON PL Equity 1/5/2003 3.9726
ZON PL Equity 1/6/2004 3.9385
ZON PL Equity 1/7/2004 3.8996
ZON PL Equity 1/8/2005 3.8899
ZON PL Equity 1/9/2005 3.8899
ZIL2 GR Equity 1/2/2002 1.833
ZIL2 GR Equity 1/3/2002 1.75
ZIL2 GR Equity 1/4/2003 1.676
ZIL2 GR Equity 1/5/2003 1.692
ZIL2 GR Equity 1/6/2004 1.692
ZIL2 GR Equity 1/7/2004 1.717
ZIL2 GR Equity 1/8/2005 1.717
ZIL2 GR Equity 1/9/2005 1.717
Is this possible? I would appreciate your help, thank you all for your time and consideration.
All the best,
Ana
Bookmarks