Question: CONVERT THIS PYTHON CODE TO SOMETHING I CAN DO ON EXCEL . 2 . 1 8 4 7 9 1 9 0 1 3 6

CONVERT THIS PYTHON CODE TO SOMETHING I CAN DO ON EXCEL.2.1847919013601373
4,912032242851404
0.48382596761784336
0.6760879758161009
5 HWM and DD
data['Fund1cumret']= data['Fund1_plus'].cumprod()
data['Fund2cumret']= data['Fund2_plus'].cumprod()
data['HMM1']= data['Fund1cumret'].cummax()
data['DD1']=(data['HWM1']- data['Fund1cumret'])/data['HWM1']
data['HMM2']= data ['Fund2cumret']. cummax()
data['DD2']=(data['HMM2']- data['Fund2cumret'])/data['HMM2']
# MAX HWM
print(data ['HWM1'].max())
print(data ['HWM2'].max())
# MDD
print(data['DD1'].max())
print(data['DD2'].max())
252,1847919013601373
912032242851404
0.48382596761784336
0.6760879758161009
6 VaR
CONVERT THIS PYTHON CODE TO SOMETHING I CAN DO ON

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!