Trade analysis & record keeping : Excel Trading Analysis

Post Reply
Posts: 66
Joined: Sun Sep 06, 2009 6:46 pm

Tue Oct 13, 2009 7:57 pm

Hi NigelK / Everybody,

I am trying to add the strike rate for each course on the default page so I can sort my courses into strike rate success.

If you double click into the course it gives you the strike rate for that course, I cant see where this data is being held, is there a fairly simple way I can add an extra column onto the main sheet so I can sort the course by strikerates ?


Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Tue Oct 13, 2009 8:18 pm

Hi Mtrend
Unfortunately there is no simple way to insert a column as you'd have to change various references in the code. ( I think but can't remember for sure!)

Right click on the sheet tab, and 'View code'
This is the line you are after

'strike rate
Sheets("sheet3").Range("b5") = Sheets("sheet1").Range("ap4").Value

and if you select 'format', 'sheet' and unhide sheet 1
Range AP2, AP3, and AP4 contain the figures you are after. AI2 contains the value of the cell you double clicked on and AK to AO all the info for that track.

Hope it helps.

Posts: 66
Joined: Sun Sep 06, 2009 6:46 pm

Tue Oct 13, 2009 8:25 pm

Cool, il take a look, thanks !

Posts: 281
Joined: Sun Sep 13, 2009 3:41 pm

Thu Oct 15, 2009 9:23 pm

This looks really clever, you must be an IT whizzkid,

cheers, P

Posts: 70
Joined: Thu Apr 16, 2009 1:31 pm

Wed Oct 21, 2009 10:01 am

Excellent work NigelK and many thanks for sorting out a version that works with my data.

One suggestion I have is to have columns which show the P/L per trade for Course, Race Type and Distance. This gives another view on where one is going wrong. I have added these to columns S, T and U (which I presume is OK) but it would be better if they were columns which immediately followed the P/L they were using. Is that possible or a pain?

On the earlier subject of how to treat scratches in the strike rate, my personal view is they should be treated positively. I always note a scratch as +0. My reasoning is:

My primary objective is to make profit on a trade.
My secondary objective is to preserve capital.
My third objective is to limit any loss to a small one.

A scratch trade satisfies objective 2 and I think objectives 1 and 2 are successes. In any case it is psychologically good to consider a scratch in the glass half full category.

One thing your analysis spreadsheet has shown me is that if my scratch level is high on any given day I am more likely to make profit. I believe that that is because I am more on the ball that day. The more I'm prepared to scratch and not let the trade drift all over me the more I'm likely to profit.

Anyone agree that scratches should be considered positively?

Thanks again.

Posts: 227
Joined: Mon May 18, 2009 7:35 am

Mon Feb 15, 2010 7:22 am

Where do I find the version with the date option?


Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

Sun Apr 18, 2010 11:30 am

Hi Nigel

Having trouble getting this to work. I think I have done it as you say but when I connect it I get an error message Run-time error'1004' 'C:\Users\Dad\Desktop\BettingpandL.' could not be found.

I do have other markets on there like without fav and forecasts so that my be the problem.

dont know if you can help.


Posts: 204
Joined: Fri Apr 17, 2009 1:04 pm

Mon Apr 19, 2010 11:36 am

Got it working on the comuter at work this morning.
It makes very interesting reading.

A great tool ....well done


Posts: 30
Joined: Sun May 17, 2009 11:34 am

Fri Jun 18, 2010 8:38 am

Hej nigelk

im a total newbee to excel

could you please tell me where i can download the spreadsheet that your spreadsheet connects with, from betfair

User avatar
Posts: 80
Joined: Mon Jul 12, 2010 1:45 pm

Fri Aug 06, 2010 1:26 pm

Hi Nigel

This is a very useful tool and after a bit of playing about I have got it to work.

Very impressed indeed.

Well done Sir.

Post Reply

Return to “Trade analysis & record keeping”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest