Dear all,
I have a question: I am working on an event study in STATA but have my source files in Excel (returns, dates, etc) = every column contains 360 dates, stock and market returns of 1 security/observation. STATA requires all the information on one row rather than one column. How can I do this with a couple of commands or formulas? Since I have 260 securities, I do not want to copy and paste every input 260 times :s
Hope you can help me out.
Thanks,
Mel
I have a question: I am working on an event study in STATA but have my source files in Excel (returns, dates, etc) = every column contains 360 dates, stock and market returns of 1 security/observation. STATA requires all the information on one row rather than one column. How can I do this with a couple of commands or formulas? Since I have 260 securities, I do not want to copy and paste every input 260 times :s
Hope you can help me out.
Thanks,
Mel