Calculate according to conditions

see attached spreadsheet.

I need two profit calculations done, firstly i need the macro to distinguish between the type of bets win which is identified in column I by "W" and place identified in the same column by "P". Then if the bet type is "W" i need it to divide 1 by the win odds in column G and then check the system results column J to see if it has won in this case and all win bets this will be identified winners in column J by a "W" if it loses it will be "L". For place bets i need it to divide 1 by place odds in column H, wins are identified by "P" and losses by "U".

I also need it to automatically do full loss recovery so if the first bet i a win bet and it loses .50 i need it to stake enough to win 1.5 points basically every loss has all previous losses for that day added together and then add 1, once a winner is hit either by a place bet or win bet i need it to stop and go back staking to 1pt.

I need the results displayed on a daily basis even if the last bet of the day loses start fresh the next day i need the results displayed in column L.

I also need this done fully, by fully i mean pay no attention to the day e.t.c just to the bet type and results and display the results in column M

I have manually done some calculations on the attached spreadsheet to help explain what i'm looking for.

Thanks

ian

I can't see from your examples how the Daily P/L is calculated. It is not the inverse of the odds for winning bets.

Please post a link to your cross-post on Oz.

Clear as following a mudder on a go-kart, Ian. Whole sentences would help.

If you win at 2:1, don't you win $2?

lol...wrote that one on my mobile so sorry about that. what you describe is level stakes betting. lets use your 2:1 as an example, my 1pt profit is equal to $1 therefore i look to win one pt, so at 2:1 i would need to stake $0.50 in order to profit by $1, however if it loses i would lose $0.50 and would then need to stake enough on the odds of the next horse to win $1.50, so if the odds were 3:1 i need to stake $0.50. Lets say that bet also lost we have lost $0.50,$0.50 the next bet needs to win $2 ($0.50,$0.50 and also $1 profit), the next horse is a place bet and the odds are .58:1 so we need to stake $3.45 because ($2 divided by 0.58 = 3.448) this bet wins so we win $2 and we take away $0.50 and $0.
50 which we lost leaving $1 profit. After a win we revert back to staking to win $1.

I don't see it over there now either.