Then we use the MIN formula to select the product net value at the lowest point in the current time.
The formula is as follows (B2 minutes (B2:93 Brunei dollars)) /B2.
3 drop-down, we can get the interval retracement rate of all dates.
Finally, we use the MAX function to find the maximum withdrawal rate.
The formula for calculating the maximum withdrawal rate of funds is: (maximum net value of funds-minimum net value of funds)/maximum net value of funds * 100%. For example, if the highest net worth of a fund is 2. 14 and the lowest net worth is 0.99, then the maximum withdrawal rate of this fund can be calculated as: (2. 14-0.99)/2.
Maximum withdrawal refers to the maximum risk value of the fund in the past, which is directly proportional to the fund risk. The smaller the maximum withdrawal means the smaller the risk, and the larger the maximum withdrawal means the greater the risk.