Excel Bookmaker Help
 

I have a problem getting this right and am after some suggestions.

I currently have a spreadsheet that calculates the odds to offer based on the amount of money in the pool for each horse taking into account my takeout and the respective payouts.

What I can't get my head around, is unlike a tote pool the bets taken are paid out at the odds taken by the punter and not the final price.

Therefore I need some way of incorporating the two, a sort of parimutual/fixed odds combo.

For example: In fixed odds tote pools, they adjust the dividend based on the money on that horse at each of the odds which is what I'm trying to do.

I'm having a brain fog....any ideas?

Fog has turned to a mild haze.

I need to calculate the total money at the average price and work out on payout rather than holding.

Could be right, but then again, the fog is rolling in again :(