Discretionary trading

[asomani]

This looks like a great idea. I accept your help with great pleasure, because I am somewhat overwhelmed.
In the attached file, you will have two sets of thee colums. These are the results of either IWM/GDX or TWM/GDX combined portfolio (compared to each element separately).

I'd be happy if you could share the formula that you use to calculate the drawdowns that you mention on these equity curves. I can then generate different ratio of IWM/GDX combinations as I only use now 50/50.

Thanks again for your help.



Pascal

Attachment 8914

Hi Pascal,

Actually, I wasn't offering to help at this time. I would love to help but, you see, I'm quite busy right now with my work and other activities. I simply wanted to suggest a few ideas to you and the group to help get things rolling a bit.

I have taken a bit of time, though, to make an example for you of how to calculate drawdowns in Excel. I have attached a spreadsheet showing how the calculations should be performed, based on my knowledge. In my spreadsheet, the EOD (end-of-day) and intraday drawdown calculations are for a simple strategy that takes a buy-and-hold approach on the SPY from the beginning of the year through to yesterday.

I hope the spreadsheet is clear. Please let me know if you have questions.

You will notice that, to calculate intraday drawdown, you will need to obtain the intraday % change for the Robots based on the High of the day (if short) or Low of the day (if long) for each day of the testing period.