In Excel, I have the monthly stock price data for the past few years for Asset A and Asset B. I have calculated the monthly returns, mean returns, variances, and standard deviations for both stocks as well as the covariance and correlation.

Then I calculated the weighted portfolios of Asset A and Asset B calculating the return and standard deviation for each portfolio, this let me draw the mean-variance frontier (MVF).

Then I solved the optimisation problem to find the smallest variance portfolio.

Then I found the portfolio with the highest Sharpe Ratio. I used a short-term government bond as a risk-free asset. Then I drew a new efficient frontier.

I am now tasked with: finding the market price of mkt portfolio according to No Arbitrage condition. How do I do this?


1 Answer 1


To find the current market price of the market portfolio, you need to multiply the current/latest market price of each asset by its respective weight in the tangent portfolio and then sum them up. This will give you the market price of the market portfolio (tangent portfolio) according to the No Arbitrage condition.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.