Is there a program to plot your daily

Dominic · Apr 5, 2004

profit and loss on a chart to show your equity curve? There must be some program that I could enter my daily P&L which would form some type pattern or curve. I found that after approx 8 winning trades I would have a drawdown so I have started to trade more cautious around those times. Any help or insight much appreciated.

Dominic

Pig Porky · Apr 5, 2004

microsoft excel....among others

Boomer · Apr 5, 2004

i have messed with excel spreadsheets, but does anyone have a template that works well for them? if you wouldnt mind sharing, that would be great...

OrangeCat · Apr 5, 2004

Dominic:

Try checking out markettide.com and check out Trading System Testing Software. The price is for less than $50 but you need to input your data by hand. Also, for a price, the author will taylor the program to your needs.

If you have IB as your broker, check out Maxtrader.com. This software will keep tract of your trades you made through TWS and among other things, create an equity curve and the data is downloaded into the program. Also, it prepares the stats need for your year end taxes. The light version is about $199.

Finally, check out armencomp.com for their accounting software which I believe also calculates and equity curve from the data furnished by your broker. I supports downloads from a number of on line brokers.

Hope that helps

Dominic · Apr 6, 2004

Thanks OrangeCat; I appreciate the help.

Dustin · Apr 6, 2004

I plot my daily, but I think you are referring to plotting intraday also...? It would be tough to plot intraday with more than 20+ trades.

Dominic · Apr 6, 2004

Quote from Dustin:

I plot my daily, but I think you are referring to plotting intraday also...? It would be tough to plot intraday with more than 20+ trades.

What do you use to plot your daily? Excel? What are the plug ins you use?

Thanks

Dominic

Dustin · Apr 6, 2004

I just use excel...fairly basic to set up. No fancy plugins needed.

lindq · Apr 6, 2004

Quote from Dominic:

profit and loss on a chart to show your equity curve? There must be some program that I could enter my daily P&L which would form some type pattern or curve. I found that after approx 8 winning trades I would have a drawdown so I have started to trade more cautious around those times. Any help or insight much appreciated.
Dominic

In Excel, simply create a column listing the gains/losses of each trade. Next to that column, create another column that uses those gains/losses to sum a running total. (You are just adding each gain/loss to the cell before it.) Then use the Excel charting function to access that column of data, and it will chart it for you as a rising and falling equity curve. Play with it, and you'll find your way.