Excel Help for Profit/Loss Analysis

Suppose that post is a bit vague.

I've converted the Stake column to Numbers and summed it so now I have my total stake for backs and lays.

Is there anything useful I can do with this now ?

Check whether you do best backing or laying and analyse both by price range. Be careful not to change strategy on small data sizes. Continue to monitor. If you record your bets yourself, you could consider adding other details. e.g. If it's horse racing, the trainer & Jockey.

Hi Rocket. I always felt that you should decide what you want to analyse and then base your stats on this, rather than get a load of information and then try to work out what you can do with it. I suppose my question back to you would be what is it you really want to know/what information are you after? Sorry I can't be of more help, hopefully others can be.

Cheers for the replies.


I want to see how my stake has increased, what the average stake is, what my average odds are and how much profit I have made on each day.

Because I back and lay many times in a market I'm not sure how to extract meaningful results from the P&L data.

Also I'd like to see what % of my profit comes from each football market that I bet in./

I guess you're talking about the account statement listing all transactions?
On the market PnL you only see profit per market, not individual bets.

I've automated everything now. But if you want to work out profit by market type: correct score, match odds etc, do the following:

!)download the three month market PnL from your account (you can do it with the account statement too, but it's a bit more complicated) Convert the amounts to numbers.

2) Left Click on column B and select insert to insert a column. Then right click Column A.

3) Go to Data -> Text to Columns, select delimited and in the 'other box' enter the ":"
sign. Hit finish and column B only contains the market types, you can now sort by column B and work out profit per market type.
----------------

For Average stake, you sort by bet type (to weed out commission payments and other transactions. Then enter "=sum($A$1:A1) and drag down. which will show you how stakes are increasing.

For the first few years on here, my back and lay bets PnL were almost 100% negatively correlated. Now that's not the case anymore.

regarding the process above, if you record it as a macro you can use it again and again. I have another macro that totals up the PnL of different markets for the same game, so that I can see how much I make per match.
This is interesting because it weeds out 'phantom' volatility.
For instance, If I lose £10k on over 5.5 goals, and win £10 in the total goals market, that means I haven't really won or lost those large amounts at all. Taken in isolation, it looks like I'm taking massive risks and my PnL is swinging all over the place, but add them together and you get a more realistic picture.

you do come across as the most intelligent person on these boards mr investor.

i assume you missed a k off the £10

i used to use macro's at uni for project management.

the old adage is true though that he who fails to record or keep a close eye in his bets, fails.

*on

That's the sort of thing I'm after, cheers Investor.