Sun Jul 19, 2015 9:27 pm
Mon Jul 20, 2015 8:43 am
Mon Jul 20, 2015 11:41 pm
Tue Jul 21, 2015 12:11 pm
Fri Aug 28, 2015 8:05 am
Gavin wrote:Very good work adenlark.
I've made another version to make it easy to choose a target profit amount (what you win if any of the horses you've backed actually wins the race).
I expect some folks will want other options too, such as target exposure (what you lose it none of the horses you have backed actually wins the race).
I have also converted some of the check boxes into radio buttons (so that only one option can be selected).
I'm not sure if there is a more elegant way of designing the target profit aspect, but I used a model in which it tests the profit with a standard 'basis' value, so that it can adjust it to be some multiple of that for getting the actual basis value that is needed for the target profit calculations.
I've also added a column to show the profit or loss on that would entail on each selection. There are also several hidden columns that do intermediary calculations behind the scenes.
I must state very clearly that I have done nothing for the LAY side of things. All of the features that I have added are just for dutching using BACK bets.
Please use in demo mode only.
Kind regards,
Gavin
Tue Sep 01, 2015 6:26 pm
Tue Sep 01, 2015 9:29 pm
bamthwok wrote:Hi,
Many years ago (that was in 2007 ), I've written a spreadsheet that calculates the stake for individual profit target in lay dutching. I like lay dutching because a "reverse lay dutch" usually give the better profit than a back dutch.
So I have the math to calculate adjustable stakes / profits and liabilities but I can't amend the existing dutching spreadsheet by myself. I don't have enough background knowledge about the design of it.
If I find a volunteer who is interested to develop the existing spreadsheet further to include lay dutching then I'm interested to work on this project and make it available to the community. But please, no time pressure....
Basically I can contribute with the math logic but I need someone who can implement it to the spreadsheet.
Anyone???
Cheers,
bamthwok
Wed Sep 02, 2015 11:17 am
Fri Sep 04, 2015 7:58 am
Fri Sep 04, 2015 8:09 am