Is there any existing code for closed trade drawdown in WL5? Since each script executes separately for each symbol I don't see any easy way to do it. Any hints from the WL team?

Hi Dave,

What is "closed trade drawdown", is it different from the Position.MAEAsOfBar property?

We have source code for closed equity performance visualizer available for download:
Community.Visualizers : Closed Equity
VS2005 source code

Eugene,

The visualizer is cool although still not perfect. I could have sworn I had a visualizer I downloaded on my old PC which showed me the closed trade drawdown but I can't find it. I'm considering coding it myself but is there any code you have lying around that would do it (before I code it myself -- I'm not going to have time until after I shovel out the driveway anyway).

Dave

Dave, although I'm still not sure what this "closed trade drawdown" concept is about. Maybe you have disabled the MAE/MFE visualizer in the Preferences dialog?

Eugene,

Here's the idea behind it. Basically in the Performance tab of WL (both 4.x and 5.x) the drawdown reported is the open trade drawdown. This is simply the largest drop from an equity peak in the equity data series. However, this drawdown includes the giving back of open profits. What the closed trade drawdown would show is the worst drop in account equity of closed trades only.

The reasoning is that if you had a trade with a profit of $100,000, and it gives back half you'd see a drawdown of $50,000, but your account would never go below the initial value because you were giving back profits. Basically it's the worst drawdown of account principal (not unrealized profits).

Hope this makes sense -- it was more difficult to explain than I thought it would be.

Dave

No response yet? Eugene, when did you start sleeping at night? :)

Hi Dave,

Yes, this makes sense to me. After I finish some scheduled work, let's see if it's possible to add:

a) Closed equity drawdown -- to "Drawdown %" (as a context menu option that would switch between the traditional view and this new one)
b) Drawdown based on closed equity -- to "Performance Extras"

Glad it makes sense - after writing that I found myself more confused than when I started.

Would it be possible to publish the code behind the standard performance report? That would give me or anyone else a nice boost in trying to code our own performance indicators.

Edit (link fixed)

Fidelity holds the code behind the standard performance visualiers, so please ask them to disclose something as an example.

On the other hand, the MS123 Visualizers library is open source.

QUOTE:
Fidelity holds the code behind the standard performance visualiers, so please ask them to disclose something as an example.

Yeah, but they're the same ones holding the documentation of the public interfaces hostage, so I doubt I'll get very far :(

Hi Dave,

I guess this is how it should look like? No open trade drawdown on unrealized equity is included (the upper chart):

End of Day drawdown would be a nice feature as well.

"End of Day drawdown", what is it?

Hi Dave,

Must admit there wasn't such a thing as equity type choice on my mind when creating the visualizer. Therefore, throwing in the choice of closed vs. unrealized equity on one tab starts complicating the rest of the code. Without rewriting, it will end up as spaghetti code. So what I did was to create a copy of "Percent Drawdown" that will exclusively display the closed trade drawdown. In addition, now there are some max closed drawdown figures on the "Performance Extras" tab. Please update Community.Visualizers and let me know if there's an issue.

Looks very nice, you guys are awesome. The only downside is that I need to paste the data (I ran it on 1 minute data) into a text file to get the actual drawdown numbers.

Anything you can do to get Microsoft to allow more than 64K rows in Excel? :P

Thanks again.
Dave

P.S. Still wondering what EOD drawdown is -- is that just treating positions as if they were closed at the end of the day (for intraday data)?

Hi Dave,

QUOTE:
The only downside is that I need to paste the data (I ran it on 1 minute data) into a text file to get the actual drawdown numbers.

The mouse over tooltip and copying to clipboard didn't work?