| Home > Forum Home > Excel Portfolio Optimization Template > How do you input short positions? > Negative weights cannot be calculated | Share |
Negative weights cannot be calculated
Excel Help for Negative Weights Cannot Be Calculated in Excel Portfolio Optimization Template
| Forum Topic | Login |
Negative Weights Cannot Be Calculated | Rate this: (3/5 from 1 vote) |
 | The program does not allow negative values for units. Entering negative price data to force the current portfolio weighting (unit multiplied by the final price) to produce a negative weighting in the portfolio will not produce valid results as the optimization process assumes only positive prices for assets ignoring observations that do not comply. Therefore, the program cannot account for negative (short) positions. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Negative weights cannot be calculated in the Excel Business Solutions Directory |