Keeping Records of trades

Post Reply
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

We all know the importance of keeping records of trades for analysis or just for profit/loss over the year.
I have created a spreadsheet that works for Horses, Greyhounds and every sport imaginable in to one
Spreadsheet. This spreadsheet can also graphically represent your profit/loss or your intended profit for
the month/year. I have populated some examples to give people an idea of what information goes where.
I find it really useful to have all the information in one place. i know this sheet takes a lot of manual input
but if your serious about your trading then this becomes second nature after a while.
The file is a whopping 32mb so i can't upload it here but can be accessed from my dropbox.

The link is https://drive.google.com/open?id=1z2b08 ... U-AoFvLTNN

enclosed some screenshots.
example.JPG
grteyhounds.JPG
horses.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
melvidge
Posts: 16
Joined: Wed Sep 06, 2017 11:48 am

MemphisFlash wrote:
Sat Dec 30, 2017 10:14 am
I have created a spreadsheet that works for Horses, Greyhounds and every sport imaginable in to one
You've obviously put in quite a lot of work in creating this (which is much more comprehensive than the one I've been using) - so thank you for sharing it. Very much appreciated. :)
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

if you have any questions about what the colours mean or maths or just inputting data feel free to ask
convoysur-2
Posts: 1110
Joined: Thu Jan 12, 2012 10:00 am

sweet,thank you
mejmon
Posts: 4
Joined: Mon May 11, 2015 10:22 pm

Hi. This looks really great. I have tried to download it but it doesn´t work. How can I get access to it?

Best regards
Janne
User avatar
Dublin_Flyer
Posts: 688
Joined: Sat Feb 11, 2012 10:39 am

Looks like a lot of effort went in Memphis, fair dues for sharing. I like the bit on the first screenschot, How much would you like to make this month? Eh 70 grand or so please :lol:
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

that is editable, enter the amount in the last day of the month and the graph and figures will change to suit, look at summary page as well, it changes there also
Kirisute62
Posts: 4
Joined: Tue May 15, 2018 6:17 pm

Looks Great but it loads about half way and not open any advice ??
User avatar
Hepburn
Posts: 173
Joined: Sun Feb 25, 2018 11:58 pm

Hi memphis, does this spreadsheet record the highest and lowest profit and loss figures per selection? can that be done?
im a super noob @ excel recording data.
User avatar
Derek27
Posts: 23470
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

You can use the MAX and MIN functions for that.

For example, MAX(E5:E99) will return the highest figure within the range E5-E99.
User avatar
Hepburn
Posts: 173
Joined: Sun Feb 25, 2018 11:58 pm

Thanks Derek perfect answer :)
eightbo
Posts: 2154
Joined: Sun May 17, 2015 8:19 pm
Location: Malta / Australia

Here's an example of how to identify your maximum drawdown on a set of results:
You do not have the required permissions to view the files attached to this post.
User avatar
twenty2
Posts: 47
Joined: Tue Jan 21, 2020 5:38 pm

Hi Memphis, im trying to download your spreadsheet but it not downloading ?
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

User avatar
twenty2
Posts: 47
Joined: Tue Jan 21, 2020 5:38 pm

still not working mate, also trying to open in excel and it doesnt open
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Trade analysis & record keeping”