Divide group of stocks into quintiles

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

Sima77
Posts: 23
Joined: Sat May 01, 2021 10:07 am

Divide group of stocks into quintiles

Postby Sima77 » Tue Aug 16, 2022 4:19 pm

I have a group of 46 series/stocks that shows the monthly betas of the stocks and It looks like this:

......... stock1...stock 2 .......stock 46
2010m01...1.8...0.34............ 0.98
2010m02...0.55...0.20............0.43
.
.
2021m1... 0.11...0.65............ 0.79

I need to divide the stocks into quintiles based on beta values EVERY month, but I need the output to show me which stocks (stocks1, stock5, stock31...) are in each quintile (not only the beta values). Any programming suggestions?

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 20 guests