Creating a spreadsheet to view exported P&L in more detail?

[Trader_Tom]

Hi everyone. I recently went through my P&L in excel and fettled about a bit to see which race types/tracks I appear strongest at and more importantly, which I am weak. Unfortunately my excel skills are limited but I learned a lot from messing about this evening. Most importantly, my belief that I always lose on novice races turned out to be incorrect. Had I skipped every notice race this month I would actually be down £144 on my monthly profits.

I was thinking about being able to group results in some form (either a pie chart or some sort of other graph etc) that shows individual profit/loss figures, strike rates and average profit etc.

Filters I was thinking of were things like...

Race type
Track
Time of day (could possibly be helpful for flagging up if performance decreases towards the end of the day etc)
Strike rate

As with anything like this, the more information the better. I'm also aware that it would really only work over long term results (due to variance) unless you were making some big changes to your trading.

So the big question is. Is anyone up to the task of making such a spreadsheet, or does one already exist? Switesh has an awesome data collection sheet so I'm sure it's something he would be able to tackle but I'm not sure if he is about anymore?

I'd also like to add that for the right spreadsheet I'd also be willing to pay for it. I'm not a tight arse wanting something for nothing but I do see the value in being able to group your results in to an easy to read format.

Cheers!

Tom

[Dallas]

Heres a simple one if you want to add your own data
http://www.betangel.com/forum/viewtopic ... 31&t=12327