Spread sheet to record trades

awoodj

Active member
142 0
Apologies if this is not the right board but i have been trying to put together a decent spreadsheet to record trades for my own records and to give me something i can analyse later to look for patterns of where i am winning and loosing and try to figure out why. I am sure many of you must already have something in Excel etc and i am looking for some help or pointers to the best way to do this or if anyone knows of somewhere i can get one already made all the better.

I have attached the current version of mine but it is still far from finished.

I trade long and short so need to be able to handle this as well as US + UK stocks and Indices (just made separate pages for US and UK so far)

Thanks for any help you can give.
 

Attachments

Skimbleshanks

1
2,325 16
I use two linked Excel sheets - the first is for individual trades, and the second is for my end of day summary.

My headings for individual trades in US futures are:
day (Wednesday)
date (28 May)
action (sell)
entry price (959.25)
exit price (953.5)
lots (1)
points (5.75)
$ (287.5)

My headings for daily summary are:
$ EOD gains/loss (not telling)
minus commission (-43.2)
$ EOD (not telling)
$ balance (not telling)
£ balance (not telling)
$ to £ exchange rate (1.6383)
profit % (not telling)

:D
 

Ph1lly

Active member
118 20
Hi Skimbleshanks,

I would love to have a spreadsheet such as this and am useless at creating one myself, would you sell me one?

Cheers


Phil
 

barjon

Legendary member
10,602 1,741
This thread's a bit long in the tooth - here's a version with later excel
 

Attachments

shekarj

Newbie
6 0
I think no one can without keeping track of records of trade. Keeping record includes lot of discipline and grit. All losing traders must start immediately keeping track of the records.
 

4xpipcounter

Experienced member
1,556 29
I tend to agree with you, even though I don't do it myself, because of the discipline and grit you mentioned. OTOH, I do a Weekly Report of 28 pairs and gold, which is discipline in itself. I just make sure I trade my own forecasts.


I think no one can without keeping track of records of trade. Keeping record includes lot of discipline and grit. All losing traders must start immediately keeping track of the records.
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock