Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Creating portfolios based on rankings in excel

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
We are going to construct the fama and french factors based on a dataset of 800 companies over 75 months.

What we want to do for each of the 75 months is to divide the companies in 3 portfolios based om value weighted market to book value (30% highest, 40% mid and 30% lowest). When the portfolios are created we need to calculate the return of each portfolio.

Or main issue is to rank the companies and assign them to a portfolio without having to do it manually per month.

All help would be appreciated!
  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP