Trade log generator
A trade log is only useful if it is complete, consistent and easy to read back, which is hard to keep up in a hurry. Paste or type your trades one per line, set your starting balance and any contract multiplier, and this generator turns them into a clean journal with profit and loss per trade, a running balance and an equity curve. It also works out your win rate, profit factor and maximum drawdown, and you can download the whole log as a CSV file.
Equity curve
Your balance after each closed trade.
Your trade log
Every trade with its result and the running balance.
| # | Date | Symbol | Side | Qty | Entry | Exit | Fees | P&L | Return | Balance |
|---|
How the log is built
Each line is read as one closed trade. Results are worked out in dollars, added to a running balance and summarised.
Read each line
Fields can be separated by commas, tabs or semicolons. Lines that do not parse are skipped and reported.
date, symbol, side, quantity, entry, exit, fees
Profit and loss
Direction decides which way the price move counts.
long: (exit − entry) × qty × multiplier − fees
Return per trade
Profit and loss against the money the position used.
return = P&L ÷ (entry × qty × multiplier)
Running balance and drawdown
Balance after each trade, and the largest fall from any earlier high.
drawdown = peak balance − balance
Profit factor
Total won divided by total lost.
profit factor = Σ wins ÷ Σ losses
Trade log questions
What should a trade log include?
At minimum: the date, the instrument, long or short, the size, the entry and exit prices and the fees. That is enough to work out profit and loss, win rate and drawdown. Many traders add the setup name, the reason for the trade and a note on how well they followed their rules.
What format does this generator accept?
One trade per line: date, symbol, side, quantity, entry price, exit price and fees, separated by commas, tabs or semicolons. Side can be long, buy, short or sell. Lines that do not start with a valid trade, such as column headings, are skipped and listed so you can fix them.
Can I paste trades from my broker's export?
Yes, if you arrange the columns in this order first, for example in a spreadsheet. Copy the columns straight from the spreadsheet and paste them in; tab-separated text works fine.
How is profit and loss calculated?
For a long trade, exit price minus entry price, times the quantity, minus fees. For a short trade, entry minus exit, times the quantity, minus fees. For futures or forex, enter the quantity in the units that make that sum come out in dollars, or use the multiplier setting.
What is maximum drawdown in a trade log?
The largest fall in your running balance from a high point to a later low, after closed trades. It shows the worst stretch you had to sit through and is a better guide to risk than any single losing trade.
Is my trade data uploaded anywhere?
No. Everything is worked out in your browser. The trades are kept in the page address so you can bookmark or share the log, which means anyone you send the link to can see them.