Markowitz Eff Frontier on 18 mos 30 stock of the DJ
Budget: ₹1,500 – ₹12,500 INR
I'm looking for someone to perform a Markowitz Efficient Frontier analysis on a selection of 30 stocks from the Dow Jones Industrial Average over a period of 18 months. I have a specific list of stocks (30 of the DJ) in mind for the project and I would like the results presented in graph form. This analysis should provide insight into how different combinations of assets can be optimized for maximum return while minimizing risk. The job includes data collection. The Markowitz Efficient Frontier can be used to calculate the optimal portfolio given a set of financial data, so I'm looking for a professional with a strong background in finance and portfolio optimization to get the job done. o calculate the Markowitz Efficient Frontier for the Dow Jones stocks over the past 18 months, you would need the following data:
Historical daily prices for each of the Dow Jones stocks: You need the daily closing prices for each stock in the Dow Jones Industrial Average (DJIA) for the past 18 months. These prices will be used to calculate the stock returns and estimate their statistical properties.
Risk-free rate of return: You would need the risk-free rate of return for the same period. Typically, the risk-free rate is represented by the yield on a government bond, such as the U.S. Treasury bills or bonds with a similar maturity to your investment horizon.
Historical returns for each Dow Jones stock: From the daily prices, you would calculate the historical returns for each stock. The returns are usually calculated as the percentage change in price from one day to the next.
Covariance matrix of returns: With the historical returns for each stock, you can calculate the covariance matrix. The covariance matrix represents the interdependencies or relationships between the returns of different stocks. It is a key input for the Markowitz portfolio optimization.
Expected returns for each Dow Jones stock: You need to estimate the expected returns for each stock. These estimates can be based on historical returns, analysts' forecasts, or other relevant information.
By utilizing these data sets, you can construct the Markowitz Efficient Frontier by considering different combinations of stocks in your portfolio and finding the optimal allocation that maximizes return for a given level of risk or minimizes risk for a given level of return. The efficient frontier is determined by solving the mathematical optimization problem based on the covariance matrix, expected returns, and risk-free rate.
Historical daily prices for each of the Dow Jones stocks: You need the daily closing prices for each stock in the Dow Jones Industrial Average (DJIA) for the past 18 months. These prices will be used to calculate the stock returns and estimate their statistical properties.
Risk-free rate of return: You would need the risk-free rate of return for the same period. Typically, the risk-free rate is represented by the yield on a government bond, such as the U.S. Treasury bills or bonds with a similar maturity to your investment horizon.
Historical returns for each Dow Jones stock: From the daily prices, you would calculate the historical returns for each stock. The returns are usually calculated as the percentage change in price from one day to the next.
Covariance matrix of returns: With the historical returns for each stock, you can calculate the covariance matrix. The covariance matrix represents the interdependencies or relationships between the returns of different stocks. It is a key input for the Markowitz portfolio optimization.
Expected returns for each Dow Jones stock: You need to estimate the expected returns for each stock. These estimates can be based on historical returns, analysts' forecasts, or other relevant information.
By utilizing these data sets, you can construct the Markowitz Efficient Frontier by considering different combinations of stocks in your portfolio and finding the optimal allocation that maximizes return for a given level of risk or minimizes risk for a given level of return. The efficient frontier is determined by solving the mathematical optimization problem based on the covariance matrix, expected returns, and risk-free rate.