Spreadsheet: 152864d1335556205-how-to-find-out-result-by-array-formula-mdd
Sheet: 工作表1

Date | Equit | DD1 | DD2 | DD3 | DD4 | DD(n) |  | case | result | start date | end date | remark
1999-01-28 00:00:00 | 198642.464 |  |  |  |  |  |  | [NAME] |  |  |  | full period
1999-01-29 00:00:00 | 197048.192 |  |  |  |  |  |  | MDD2 |  |  |  | custom/random selected
1999-02-01 00:00:00 | 199439.6 |  |  |  |  |  |  | MDD3 |  |  |  | custom/random selected
1999-02-02 00:00:00 | 194656.784 |  |  |  |  |  |  | [NAME] |  |  |  | custom/random selected
1999-02-03 00:00:00 | 193062.512 |  |  |  |  |  |  | …. |  |  |  | custom/random selected
1999-02-04 00:00:00 | 193062.512 |  |  |  |  |  |  | MDD(n) | ??% | dd/mmm/yyyy | dd/mmm/yyyy | custom/random selected
1999-02-05 00:00:00 | 189873.968
1999-02-08 00:00:00 | 191468.24 |  |  |  |  |  |  | How to find out each result on MDD(n) on one cell by array formula? (say I have over 1000 case)
1999-02-09 00:00:00 | 190671.104
1999-02-10 00:00:00 | 193859.648
1999-02-11 00:00:00 | 194656.784
1999-02-12 00:00:00 | 196251.056
1999-02-15 00:00:00 | 199439.6
1999-02-19 00:00:00 | 203425.28
1999-02-22 00:00:00 | 202628.144
1999-02-23 00:00:00 | 203425.28
1999-02-24 00:00:00 | 201033.872
1999-02-25 00:00:00 | 200236.736
1999-02-26 00:00:00 | 199439.6
1999-03-01 00:00:00 | 201831.008
1999-03-02 00:00:00 | 201831.008
1999-03-03 00:00:00 | 201831.008
1999-03-04 00:00:00 | 201033.872
1999-03-05 00:00:00 | 199439.6
1999-03-08 00:00:00 | 201033.872
1999-03-09 00:00:00 | 201831.008
1999-03-10 00:00:00 | 201831.008
1999-03-11 00:00:00 | 200236.736
1999-03-12 00:00:00 | 198642.464
1999-03-15 00:00:00 | 199439.6
1999-03-16 00:00:00 | 197048.192
1999-03-17 00:00:00 | 195725.024
1999-03-18 00:00:00 | 193333.616
1999-03-19 00:00:00 | 194130.752
1999-03-22 00:00:00 | 208479.2
1999-03-23 00:00:00 | 212464.8799999999
1999-03-24 00:00:00 | 214059.1519999999
1999-03-25 00:00:00 | 214856.288
1999-03-26 00:00:00 | 216450.56
1999-03-29 00:00:00 | 216450.56
1999-03-30 00:00:00 | 216450.56
1999-03-31 00:00:00 | 214059.1519999999
1999-04-01 00:00:00 | 212464.8799999999
1999-04-07 00:00:00 | 216450.56
1999-04-08 00:00:00 | 222030.512
1999-04-09 00:00:00 | 228407.6
1999-04-12 00:00:00 | 227610.4639999999
1999-04-13 00:00:00 | 231994.712
1999-04-14 00:00:00 | 231994.712
1999-04-15 00:00:00 | 231197.576
1999-04-16 00:00:00 | 235183.256
1999-04-19 00:00:00 | 237176.096
1999-04-20 00:00:00 | 234386.12
1999-04-21 00:00:00 | 235581.824
1999-04-22 00:00:00 | 233588.984
1999-04-23 00:00:00 | 235183.256
1999-04-26 00:00:00 | 233588.984
1999-04-27 00:00:00 | 232393.28
1999-04-28 00:00:00 | 233190.4159999999
1999-04-29 00:00:00 | 236777.528
1999-04-30 00:00:00 | 233987.552
1999-05-03 00:00:00 | 233588.984
1999-05-04 00:00:00 | 233987.552
1999-05-05 00:00:00 | 230001.872
1999-05-06 00:00:00 | 228407.6
1999-05-07 00:00:00 | 231994.712
1999-05-11 00:00:00 | 230001.872
1999-05-12 00:00:00 | 222827.648
1999-05-13 00:00:00 | 221346.388
1999-05-14 00:00:00 | 216892.498
1999-05-17 00:00:00 | 219383.548
1999-05-18 00:00:00 | 218387.128
1999-05-19 00:00:00 | 218387.128
1999-05-20 00:00:00 | 220878.178
1999-05-21 00:00:00 | 224863.858
1999-05-24 00:00:00 | 216892.498
1999-05-25 00:00:00 | 213903.238
1999-05-26 00:00:00 | 219383.548
1999-05-27 00:00:00 | 217390.708
1999-05-28 00:00:00 | 218387.128
1999-05-31 00:00:00 | 217888.918
1999-06-01 00:00:00 | 220878.178
1999-06-02 00:00:00 | 216394.288
1999-06-03 00:00:00 | 215896.078
1999-06-04 00:00:00 | 216394.288
1999-06-07 00:00:00 | 221376.388
1999-06-08 00:00:00 | 217390.708
1999-06-09 00:00:00 | 221376.388
1999-06-10 00:00:00 | 222871.018
1999-06-11 00:00:00 | 221874.598
1999-06-14 00:00:00 | 222372.808
1999-06-15 00:00:00 | 222372.808
1999-06-16 00:00:00 | 220878.178
1999-06-17 00:00:00 | 219383.548
1999-06-21 00:00:00 | 217888.918
1999-06-22 00:00:00 | 215896.078
1999-06-23 00:00:00 | 214514.198
1999-06-24 00:00:00 | 214015.988
1999-06-25 00:00:00 | 212023.148