Looking for Excel P&L/trade tracking sheet

April 21st, 2015, 09:51 PM

I'm pretty sure it's here someplace, but there is so much and I can't seem to find it.

I'm looking for the download of an Excel based trade log/journal to track trades and P&L. After 30 mins of hunting, I figure asking is a smart move.

I think @Big Mike posted one, and perhaps some others as well but I'm not finding it/them. I'm finding lots of things that mention excel and spreadsheet, but so many hits I can't find the actual sheet.

Thanks to all that contribute such stuffs - I can't say how much I'm appreciating this site!

Blessings,-g

April 21st, 2015, 10:29 PM

I post a where is it type question and ...

Then I finally find it. I swear if I hadn't asked, I'd still be looking.

First one I found was this:

Trade tracking spreadsheet

Attached is a spreadsheet that you can use as is, if the design suits your trading plan, or modify to fit. It is set up to collect data on sets of 25 trades each for analysis.

It assumes that a portion of a multiple contract trade will be exited on …

Then this:

Trading Journal example (Excel spreadsheet)

First, I encourage you to journal your trades here on the forum. By doing so you'll take your trading to a whole new level, you can read more why I think so here:

Now if you are unwilling to do that then at least journal your trades in a spreadsheet, …

Another:

Trading Metrics for journals/record keeping

I'm on a mission to improve my Excel trade journal.

I'd like to hear input on what metrics you guys measure in your journal. For instance:

Sharpe ratio
Expectancy
Win/Loss Dollar Ratio
Win Percentage
Dollar gain per trade put …

If there are any more, please reply with links. Perhaps this thread will help the next trying to find this great stuff!

Blessings,-g

April 9th, 2022, 08:33 AM

Heres one i made, it is kinda basic but has most things you may need.

Hope it helps

Looking for Excel P&L/trade tracking sheet

Discussion in Psychology and Money Management

Looking for Excel P&L/trade tracking sheet