mathare
27th February 2007, 18:09
Here's a tricky one for you...
Suppose you have a load of lay data and want to work out the BB how would you do it if you don't know the staking plan in use (FL, FS) or the cut-off? Can you work it out?
I am working on improving the stats produced by my spreadsheet to help make my diary more accurate and also more complete, to reflect my actual portfolio those days, and also to future-proof the spreadsheet somewhat. And I have got to the lays and hit the problem above.
Those of you who read my diary know I like to express all my results in BB, and this is something I would like for all my bets going back right to day 1. But for some systems (pro lays, for example) I have used a variety of staking plans as I saw fit at the time. I've been FL up to 11.0 and FS above that up to 21.0; FL 11.0 and under; FS 11.0 and under and perhaps others.
So how can I work out what the BB on any given day is from the bets for that day?
FS is easy - sum all the stakes for that day and average them out. Multiply by 10 to get the BB. But then suppose I only get partially matched on a bet - does that count as a fraction of a full BB or contribute equally to the BB calculation and reduce the average stake used to calculate the BB? If I count it as a fraction of a BB, what do I use as the stake for the BB? The largest stake? The most common stake for that day?
FL is also easy - sum all the liabilities, average them out and there's your BB. The figure may need rounding off though as you don't always get matched exactly to your BB, sometimes you are a few pence off.
But my weird FL/FS hybrid - where do I start? :helper
I guess I know the switchover point was always 11.0 and it was always FL under and FS over on that plan, never the other way round.
But can anyone think of a way of determining from the data whether I was on FL or FS for a particular bet?
Suppose you have a load of lay data and want to work out the BB how would you do it if you don't know the staking plan in use (FL, FS) or the cut-off? Can you work it out?
I am working on improving the stats produced by my spreadsheet to help make my diary more accurate and also more complete, to reflect my actual portfolio those days, and also to future-proof the spreadsheet somewhat. And I have got to the lays and hit the problem above.
Those of you who read my diary know I like to express all my results in BB, and this is something I would like for all my bets going back right to day 1. But for some systems (pro lays, for example) I have used a variety of staking plans as I saw fit at the time. I've been FL up to 11.0 and FS above that up to 21.0; FL 11.0 and under; FS 11.0 and under and perhaps others.
So how can I work out what the BB on any given day is from the bets for that day?
FS is easy - sum all the stakes for that day and average them out. Multiply by 10 to get the BB. But then suppose I only get partially matched on a bet - does that count as a fraction of a full BB or contribute equally to the BB calculation and reduce the average stake used to calculate the BB? If I count it as a fraction of a BB, what do I use as the stake for the BB? The largest stake? The most common stake for that day?
FL is also easy - sum all the liabilities, average them out and there's your BB. The figure may need rounding off though as you don't always get matched exactly to your BB, sometimes you are a few pence off.
But my weird FL/FS hybrid - where do I start? :helper
I guess I know the switchover point was always 11.0 and it was always FL under and FS over on that plan, never the other way round.
But can anyone think of a way of determining from the data whether I was on FL or FS for a particular bet?