Trade analysis & record keeping : Excel Trading Analysis

Post Reply
nigelk
Posts: 444
Joined: Wed Apr 15, 2009 11:00 pm

Mon May 18, 2009 12:16 pm

All,

I've made a spreadsheet that can be used in conjunction with the spreadsheet that can be downloaded from Betfair that lists your trades over a period of time.

It gives the total races you have traded and the overall profit/loss figure

It also lists details of your trades by course/racetype/distance and gives the profit/loss figure against each one.

You can also double click on a track/race type/distance to get further details.

On the sheet attached, you can see that at Bangor, I traded 5 races, double clicking brings up more details (under the blue header), that lists all 5 trades, their distances, race types and profit loss.

You can do the same with the race type and distances.

Ticking one of the boxes at the top will also sort
by profit/loss and number of trades

It will work on Excel 2000/2003

However, you do need to change the pathway to tell it where the Betfair spreadsheet is.

Press alt/f11 scroll down a little bit down you should see:

'***************************************************************

'COPY DATA FROM DOWNLOADED BETFAIR SPREADSHEET

ChDir "C:\Users\nigel\Desktop"
Workbooks.Open Filename:="C:\Users\nigel\Desktop\BettingPandL.xls"

As long as you save the Betfair spreadsheet to the desktop and don't rename it, all you should have to change is the user name.

Once you have done that, just press the "update" button.

Sheets 1 and 4 are hidden, purely for cosmetic purposes. However, deleting/moving columns will have a detrimental effect as I have not included any error checking routines.

It does contain macros, so don't be alarmed about the warning that pops up when you first open it.

Any problems, please get back to me.

Nigel

chris_ri
Posts: 34
Joined: Wed Apr 15, 2009 1:57 pm

Mon May 18, 2009 1:21 pm

Sounds interesting Nigel, however there is no spreadsheet attachment with your message (or at least I cant find one).

Cheers,

Chris

nigelk
Posts: 444
Joined: Wed Apr 15, 2009 11:00 pm

Mon May 18, 2009 3:03 pm

Ok, Excel files are not allowed to be uploaded.

The only way around it is to ask Admin, or leave your e-mail address so I can send you a copy directly.

Admin, Can you help?

Thanks,Nigel

User avatar
jimrobo
Posts: 1284
Joined: Wed Mar 25, 2009 12:49 pm

Mon May 18, 2009 3:24 pm

like the sound of this if someone can get allow .xls files to be uploaded and someone could test it would like to have a go myself

Bet Angel
Bet Angel
Bet Angel
Posts: 3553
Joined: Tue Apr 14, 2009 3:47 pm

Mon May 18, 2009 8:37 pm

Sounds like a really useful tool. Please it email support and we will find a way of putting it up for you.

User avatar
BAP-Admin
Forum Admin
Forum Admin
Posts: 142
Joined: Tue Mar 17, 2009 1:11 pm
Location: UK
Contact:

Tue May 19, 2009 1:44 pm

You could have upload it within a zip file.

Anyway, I have enabled xls files.

Bet Angel
Bet Angel
Bet Angel
Posts: 3553
Joined: Tue Apr 14, 2009 3:47 pm

Tue May 19, 2009 9:52 pm

Please see attached..
You do not have the required permissions to view the files attached to this post.

User avatar
jimrobo
Posts: 1284
Joined: Wed Mar 25, 2009 12:49 pm

Wed May 20, 2009 10:32 am

very good!!! Great piece of work!

The only addition I wanted was an extra column next to each profit/loss which is an average.

Any advice on the best way to do it?? If I do it manually then it messes up the display with the analysis

It would be nice to have strike rate somewhere next to the profit columns to!

User avatar
mugsgame
Posts: 1235
Joined: Wed Mar 25, 2009 11:41 pm

Wed May 20, 2009 9:23 pm

Top work Nigel

Thanks very much

Steve

nigelk
Posts: 444
Joined: Wed Apr 15, 2009 11:00 pm

Wed May 20, 2009 11:03 pm

Glad you all like it.

I've added an average column as Jimrobo asked next to the profit/loss figures and also an overall strike rate.

I'll have a look at putting the strike rate alongside the other figures, but it might be a bit of a struggle fitting it all on the same screen.

I should also mention that sometimes the Betfair spreadsheet does contain some oddities. For example,
a 2m1f national hunt flat race was listed as a "2m INHF"
and also sometimes a GRP3 is also listed as a GRP 3.

So be prepared to see some unusual race types. My favourite so far was an "XC Chase".
Thanks,
Nigel.
Last edited by nigelk on Tue Oct 27, 2009 2:51 pm, edited 2 times in total.

Post Reply

Return to “Trade analysis & record keeping”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 0 guests