A Dynamic Spreadsheet Model for Determining the Portfolio Frontier for BSE30 Stocks

Main Article Content

Dr. Anupam Mitra
Mr. Punneet Khanna


Introductory investments courses revolve around Harry Markowitz’s modern portfolio theory and William Sharpe’s Index for the performance measurement of those portfolios. This paper presents a simplified perspective of Markowitz’s contributions to Modern Portfolio Theory. It is to see the effect of duration of historical data on the risk and return of the portfolio and to see the applicability of risk-reward logic. The empirical results also show that short selling may increase the risk of the portfolio when the investor is instability preferred.


Download data is not yet available.


Metrics Loading ...

Article Details



BODIE, Z.; MARCUS, A. J.; KANE, A. (1995) Investments. Mc-Graw Hill International Edition.

CADSBY, C. B. (1986) Performance Hypothesis Testing with the Sharpe and Treynor Measures. The Journal of Finance. v. 41, n. 5, p. 1175-1176.

COWDELL, J.; BILLINGS, M. (2001) Investment Management. Financial World Publishing.

KAPLAN, P. D.; SAVAGE, S. (2009) The New Efficient Frontier Asset Allocation for the 21st Century. Morningstar Direct.

MANGRAM, M. E. (2013) A Simplified Perspective of the Markowitz Portfolio Theory. Global Journal of Business Research. v. 7, n. 1, p. 59-70.

MARKOWITZ, H. (1952) Portfolio Selection. The Journal of Finance. v. 7, n. 1, p. 77-91.

Mohanty, P. (2009) A Dynamic Spreadsheet Model for Determining the Portfolio Frontier.

REILY, F. K.; BROWN, K. C. (2005) Investment analysis and Portfolio Management. Cengage Learning.

ROSS, S. A.; WESTERFIELD, R. W.; JAFFE, J. (2009) Corporate Finance. Mc-Graw Hill.

ZAKAMULIN, V. (2011) Sharpe (Ratio) Thinking about the Investment opportunity Set and CAPM Relationship. Economics Research International.