This problem can be very complex. Monte Carlo predictions is based on a
model. You have to build that model using the VBA. You have to set up some
rules before you start. You have to determine how long you plan to keep each
stock. Is this length of time going to be random Distribution, Normal
distribution, or is the buying and selling going to be based other criteria.

What you really need to do is run some experiments. I would build a model
and test it over theh last 5 years to see how well the model behaves compare
to actual results. Then when you perfect the model use it as a prediction
for future investments.

" wrote:

Hi,
Does any body have any idea or examples that you can show me on wrting
a program in Excel that does the Monte Carlo Simulation for Long /
Short Equity?
I would have all the stocks in the Russell 3000 and the beta of each
stock. I would also have the price for each stock at the beginning
and at the end of the month. I am constraining my maximum long to be
50 positions, equally weighted. The Shorts can be flexible, but let's
say I want 50 shorts that make the beta neutral on a portfolio level.
I guess I should use a random generator function that labels 50 stocks
long and 50 stocks short and see how the returns at the end of the
month turn out. But I really have no clue where to start. Do I need
any other variables or specify distributions? Can someone show me
some examples or code?

Thanks so much in advance.