Portfolio optimization in Python involves using libraries like NumPy and CVXPY to maximize returns and minimize risks by adjusting asset weights based on the covariance matrix and expected returns, ensuring the sum of weights equals one and all weights are non-negative.<\/em><\/p>\n<\/blockquote>\n\n\n\n Recommended: How to Scrape Yahoo Finance Data in Python using Scrapy<\/a><\/em><\/strong><\/p>\n\n\n\n Recommended: The Future of REITs: Harnessing AI for Smarter Investments<\/a><\/em><\/strong><\/p>\n\n\n\n A portfolio is essentially a collection of assets with different or the same weights. It is usually constructed using the Capital Asset Pricing Model(CAPM) and utility theory, and as mentioned before, it is done to maximize returns and minimize risks. Let us now look at the formula for how a portfolio is constructed.<\/p>\n\n\n\n In the above formula, Wi<\/sub><\/em><\/strong> and Ri<\/sub><\/em><\/strong> represent each asset’s weights and historical returns. The summation of all the assets is our portfolio return. Let us now look at how a portfolio is optimized.<\/p>\n\n\n\n We use Operations Research concepts to maximize our portfolios. Our objective function is the expected return on the portfolio. Sometimes, instead of maximizing returns, we have target returns. After that, we calculate and minimize the portfolio variance and define constraints. <\/p>\n\n\n\n The sum of weights of all assets should be equal to 1, and they should be non-negative. It becomes an optimization problem in Operations, and then a Simple Greedy or Brute Force approach may be applied. Let us now look at the code and understand it step by step.<\/p>\n\n\n We have imported two Python libraries, which will be used in further calculations. The Cvxpy library, our portfolio, is generally used for optimization problems.<\/p>\n\n\n In the above block, we have declared variables, expected returns, a covariance matrix, and our targeted return. We have also created an objective function, the portfolio return. Additionally, we have added constraints, like the sum of all assets should be 100% and the weights should be non-negative.<\/p>\n\n\n In the above block, we have used the called modules to optimize our objective function value. We have used the field of operations research in finance.<\/p>\n\n\n Finally, we have randomly created asset returns, which, by performing matrix operations, gives us a covariance matrix. Finally, we print the results of our optimized value.<\/p>\n\n\n\n Let us now look at the output of the code above.<\/p>\n\n\n\n Therefore, the assets with returns of 8%, 12%, and 10% should be constructed with weights of 45%, 45%, and 10% to maximize returns and minimize variance. Let us look at the code used to get data from Yahoo Finance and determine the weights for the optimized portfolio.<\/p>\n\n\n\n We can download data from Yahoo Finance and calculate the mean, variance, and covariance matrix of the assets. The process remains the same after that.<\/p>\n\n\n\n Portfolio optimization is crucial to investment management, enabling investors to achieve their desired returns while minimizing risk exposure. Python’s versatility and robust optimization libraries make it an ideal tool for implementing advanced portfolio optimization techniques, leveraging real-world data from sources like Yahoo Finance. How could you extend this approach to incorporate additional constraints or objectives specific to your investment goals?<\/p>\n\n\n\n Recommended: Understanding Capital Asset Pricing Model (CAPM)<\/a><\/em><\/strong><\/p>\n\n\n\nUnderstanding Portfolios<\/h2>\n\n\n\n
![\"Portfolio](\"https:\/\/www.askpython.com\/wp-content\/uploads\/2024\/04\/Portfolio-Return-Formula.webp\")
Optimizing Portfolios with Python<\/h2>\n\n\n\n
\nimport numpy as np\nimport cvxpy as cp\n<\/pre><\/div>\n\n\n
\ndef portfolio_optimization(expected_returns, cov_matrix, target_return):\n num_assets = len(expected_returns)\n \n # Define the variables\n weights = cp.Variable(num_assets)\n \n # Define the objective function (minimize portfolio variance)\n portfolio_variance = cp.quad_form(weights, cov_matrix)\n objective = cp.Minimize(portfolio_variance)\n \n # Define the constraints\n constraints = [\n cp.sum(weights) == 1, # Sum of weights equals 1\n weights >= 0, # Non-negativity constraint on weights\n weights.T @ expected_returns == target_return # Target return constraint\n ]\n<\/pre><\/div>\n\n\n
\n # Formulate and solve the optimization problem\n problem = cp.Problem(objective, constraints)\n problem.solve()\n \n # Retrieve the optimal portfolio weights\n optimal_weights = weights.value\n \n return optimal_weights\n\n<\/pre><\/div>\n\n\n
\n# Example usage\nif __name__ == "__main__":\n # Example data\n expected_returns = np.array([0.08, 0.12, 0.1]) # Expected returns of assets\n cov_matrix = np.array([[0.1, 0.03, 0.05], [0.03, 0.12, 0.07], [0.05, 0.07, 0.15]]) # Covariance matrix\n target_return = 0.1 # Target return\n \n # Perform portfolio optimization\n optimal_weights = portfolio_optimization(expected_returns, cov_matrix, target_return)\n print("Optimal weights:", optimal_weights)\n<\/pre><\/div>\n\n\n![\"Portfolio](\"https:\/\/www.askpython.com\/wp-content\/uploads\/2024\/04\/Portfolio-optimization-output.png\")
Putting It All Together<\/h2>\n\n\n
\nimport pandas as pd\nimport numpy as np\nimport cvxpy as cp\n\ndef portfolio_optimization_from_excel(file_path, target_return):\n # Read returns data from Excel file into DataFrame\n returns_data = pd.read_excel(file_path, index_col=0)\n \n # Calculate expected returns\n expected_returns = returns_data.mean()\n \n # Calculate covariance matrix\n cov_matrix = returns_data.cov()\n \n # Number of assets\n num_assets = len(expected_returns)\n \n # Define the variables\n weights = cp.Variable(num_assets)\n \n # Define the objective function (minimize portfolio variance)\n portfolio_variance = cp.quad_form(weights, cov_matrix.values)\n objective = cp.Minimize(portfolio_variance)\n \n # Define the constraints\n constraints = [\n cp.sum(weights) == 1, # Sum of weights equals 1\n weights >= 0, # Non-negativity constraint on weights\n weights.T @ expected_returns.values == target_return # Target return constraint\n ]\n \n # Formulate and solve the optimization problem\n problem = cp.Problem(objective, constraints)\n problem.solve()\n \n # Retrieve the optimal portfolio weights\n optimal_weights = weights.value\n \n return optimal_weights\n\n# Example usage\nif __name__ == "__main__":\n # Path to the Excel file containing returns data\n file_path = "returns_data.xlsx"\n \n # Target return\n target_return = 0.1 # Adjust as needed\n \n # Perform portfolio optimization\n optimal_weights = portfolio_optimization_from_excel(file_path, target_return)\n print("Optimal weights:", optimal_weights)\n\n<\/pre><\/div>\n\n\nConclusion<\/h2>\n\n\n\n