| Home > Forum Home > Excel Portfolio Optimization Template > Help Required from Administrator | Share |
Help Required from Administrator
Excel Help for Help Required From Administrator in Excel Portfolio Optimization Template
| Forum Topic | Post Reply Login |
Help Required From Administrator | Rate this: (3/5 from 1 vote) |
 |
Hello, I have few questions, please answer Q1- I have entered daily data of 5 months of 24 stocks. Can you please guide me about the rate what to input in Risk Free Rate & Target Rate. (Annual Intered Rate is 10%) I dont want to specify the target, I want to see how maximum i can take irrespective of specified target. Q2- The result section shows the Avg period return while the target is already given. What does it means.. will appreciate if your interpret the result for me breifly. https://onedrive.live.com/redir?resid=763898090EAA00D6!124&authkey=!AH9UgWIaTwbCYGY&ithint=folder%2c.JPG Thanks alot. | |
| Posted by Rain on | ||
| Replies - Displaying 1 to 1 of 1 | Order Replies By: Most Recent | Chronological | Highest Rated |
 | Rate this: (4.3/5 from 3 votes) Q1. The target rate is used for when using semi-deviation below this rate and probability of achieving it in the results. It has no impact on optimization otherwise so can be set freely such as 0%. The risk free rate should be what can be earned for the time period used, so if months, the 1 year government note rate divided by 12 is a good proxy. Q2. The results show the optimized average monthly return and then the target is used under Monte Carlo simulation to calculate the probability of achieving it under the current and optimized portfolios. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Help Required from Administrator in the Excel Business Solutions Directory |