MATLAB Answers

Sort stocks into portfolios based on two characteristics

8 views (last 30 days)
FC93
FC93 on 7 Mar 2017
Answered: Prateek Khandelwal on 14 Mar 2017
I have 3 matrix with the dimension 235x7690. The 235 represent months, the first month is june 1995, and 7690 are the number of firms. The first matrix represents returns, the second and third matrix represent characteristics of the firms (market equity and the third book-to-market equity). Now I wand to sort all 7690 firms in portfolios. I want to create 6 portfolio (high and low market equity and high middle and low book-to-markt equity). So with the 2nd matrix I want to separete them in high and low and the third matrix in high medium and low (the borders are the 30th percentil and the 70th percentil). The porfoliosort shoud be done every June. The I want to calculate the return of the six porfolios.
Could someone help me? Thank you
  2 Comments
FC93
FC93 on 8 Mar 2017
I don't know if it would be possible. I don't even know how you would do it for 1 "period".

Sign in to comment.

Answers (1)

Prateek Khandelwal
Prateek Khandelwal on 14 Mar 2017
Hi, To me, it appears you merely want to filter the data into 6 separate buckets and not sort it.
Once you've identified the values distinguishing high vs low market equity value and high vs medium vs low book to market equity values, you can use these to create another table with 'high','low','medium' acting as categorical values. This will be followed by filtering the data out based on these categories.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!