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
Bookmarks