The 0.1% is, in fact, 0.08% but the cell formatting is set at one decimal place. If you unprotect the sheet and increase the number of decimal places, you will see the 0.08%.
i think am getting there. Please clarify in specific to my data than general explaination. I entered my tatrget return of 0.08% and all my prices data are "DAILY"; Why it is not showing the proability of achieving target return of 0.08%. i am confused where this 0.1% came from.
The target return is entered in the Input sheet and represents a target return corresponding to the periodicity of the data. If data is monthly, then 0.1% represents 1.2% annual return for the portfolio.
Monte Carlo simulation is run to calculate the probability of achieving this return based on the normal distribution of portfolio returns given the mean and standard deviation (volatility). More information on this can be found in the user guide.
