A few suggestions for Excel - feedback from yourself and the community most welcome.
I use a simple 'feedback' formula in my sheets, which displays the state of current bets, for example:
IF(AND(AR8>0,BD8<>""),"MATCHED","")
I also have other cells which provide information based on whether or not a bet has been matched. If I only place one back or lay bet per selection, this formula works fine. If I place multiple bets on a single selection, this formula is useless, as AR and AU display the average matched odds for all bets. Using BE8 may or may not work, due to the following from the User Manual:
If the bet is matched instantly in the moment that it arrives at the exchange, then the Matched Odds and Amount Matched columns will show those results. However, if the bet is matched later, the details will only be reflected in the bet summary columns (the ones to the left of the commands), not in the Matched Odds and Amount Matched columns to the right of the commands (these will remain empty).
I understand why the Matched Odds column works this way, but I don't think it's intuitive or useful in it's current setting. I suggest the following:
- Columns AL:AW remain as they are, the information is clear and useful
- Column BE is changed to show the most recent Matched Odds for that selection. When a new bet is submitted, the old value is replaced. The contents of these cells are not persistent (as is the current setting, I believe).
- Column BD to release more information, for example 'PARTIAL' for partially matched bets (unless it already does so - I haven't tested that yet!)
I think the above will be easier to use, and easier to code for - at least for novices like me anyway. For those wanting to track multiple bets on a single selection:
MyBets sheet - yes, I 'borrowed' this idea for other software! I don't use it myself, but others may wish to log their bets to a separate sheet. This may have been mentioned on the forum somewhere - props to that guy
SP and Estimated SP - another idea I've borrowed. I've seen Estimated SP and BSP released to Excel in other software, and found it a useful addition to my workbooks.
Feedback and workarounds welcome!
Cheers, adenlark