Publication number: ELQ-74300-1
View all versions & Certificate
Portfolio Optimization for Asset Allocation and Rebalancing
The Excel portfolio optimization model combines asset allocation and technical analysis to maximize investment returns.
Acquire business license for $26.00
Add to cart
Add to bookmarks
The Excel portfolio optimization model combines asset allocation and technical analysis constant optimization to maximize returns on financial investment portfolios. Portfolio rebalancing incorporates advanced options including risk assessment under Sharpe, Sortino and Omega ratios. Optimal trading strategies are established through back testing of optimized technical indicator constant parameters.
Optimizing portfolios of investments or assets where time series data is available
Portfolios where periodic investment prices or returns are not available.
People using this Best Practice also downloaded
Multivariate Regression Analysis Excel Model with ForecastingThe Excel multivariate regression analysis performs multiple linear regression analysis for forecasting and prediction.285$19.00 by Business Spreadsheets
Project Management with Automated Schedule OptimizationThe Excel project management solution facilitates the creation of project plans and automated monitoring of progress.313
Business Valuation Excel Model with Pro-Forma Financial StatementsThe business valuation model provides an accurate and robust financial reporting structure to value proposed investments442
Customer Invoicing and Inventory Management Excel ModelA complete business invoicing system with product/service, customer and inventory management.459
Real Options Valuation and Analysis Excel ModelThe Excel real options valuation and analysis provides quantification of embedded value in investment strategies.221
Financial Portfolio Tracking and Valuation Excel Model TemplateExcel portfolio tracking and valuation allows the ongoing tracking of the performance of financial investment portfolios461$22.00 by Business Spreadsheets
Business Valuation Excel Model with Economic Value AddedBusiness and investment valuation model with economic value added (EVA) calculations.1,593
Technical Analysis Excel Template with Trading Strategy Back TestingThe technical analysis template provides analysis for SMA, ROC, MACD, RSI and Bollinger Band indicators2,494
Project Planning and Management Excel ModelProject management and planning model with Gantt chart scheduling and Earned Value Analysis443
Customer Invoicing System Excel ModelCustomer Invoicing and Inventory Management solution with management of customer information and product details.868
Optimal Hedging Calculation Excel ModelThe Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.726
Bond Yield Calculator Excel ModelAutomatic generation of scheduled bond payments and the calculation of resulting yield to maturity.185
Any questions on Portfolio Optimization For Asset Allocation And Rebalancing?
The user community and author are here to help. Go ahead!