Current location - Trademark Inquiry Complete Network - Tian Tian Fund - How to calculate the maximum drawdown of a stock or index in excel
How to calculate the maximum drawdown of a stock or index in excel

Suppose you want to calculate the maximum retracement of column A data. Enter B1: 0B2 input: =IF(MAX($A$1:A2)-A2

The maximum retracement corresponding to each point can be calculated

Related articles
  • Is it safe for Ping An Bank to grow for one year?
  • What does Publicity Department of the Communist Party of China Public Opinion Bureau do?
  • 20 17 is it difficult to apply for sending international students from the country?
  • Is the quality of Mulinsen's mask guaranteed?
  • How does Guangfa Dow Jones Oil Index Fund view the rise and fall of the day?
  • Fund Practitioner Examination several times a year
  • Private equity fund registration guide
  • General situation of Dublin University in Ireland
  • The difference between first-class social security and second-class social security
  • How to redeem a fund that has been held regularly for one year?

    • copyright 2024 Trademark Inquiry Complete Network All rights reserved