New Posts For Thread: Gruss Formulahttps://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formulaI've asked on the Gruss forum, but it's very quiet on there.I've downloaded the software again after a few years away from it.I want to lay lots of horses throughout the day but to a fixed liability.I know it's easy enough to do it manually, but it'sNo problem, Kev Be luckyhttps://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559970439#559970439No problem, Kev Be luckyThu, 08 Oct 2020 06:44:30 -0500It worked.You sir are a star. Thanks for all the advice.Now you couldn't give me a list of horses that might lose?https://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559970381#559970381It worked.You sir are a star. Thanks for all the advice.Now you couldn't give me a list of horses that might lose?Thu, 08 Oct 2020 06:30:46 -0500Hmmm, my most recent reply hasn't appeared.We've essentially told the Market sheet to ignore the stakes in the Selections sheet, so they don't need to be filled in. Once you've got Excel logging prices for a market, you should see stakes filled in (https://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559970335#559970335Hmmm, my most recent reply hasn't appeared.We've essentially told the Market sheet to ignore the stakes in the Selections sheet, so they don't need to be filled in. Once you've got Excel logging prices for a market, you should see stakes filled in (Thu, 08 Oct 2020 06:21:10 -0500Hi mate.All that is in order as I've used Gruss before for level stakes laying.The first race of the day is coming up so I'll give it another go.I'm guessing the figure I put in S2 on the Market sheet has to be the same as the whole B column in the Shttps://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559970303#559970303Hi mate.All that is in order as I've used Gruss before for level stakes laying.The first race of the day is coming up so I'll give it another go.I'm guessing the figure I put in S2 on the Market sheet has to be the same as the whole B column in the SThu, 08 Oct 2020 06:07:19 -0500Hi Kev,Essentially the sheet is checking that a number of criteria are met before the bet will trigger. First, the name of the horse (Column A of Selections sheet) has to be EXACTLY as it appears in the market on Gruss, if you are always wanting tohttps://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559970295#559970295Hi Kev,Essentially the sheet is checking that a number of criteria are met before the bet will trigger. First, the name of the horse (Column A of Selections sheet) has to be EXACTLY as it appears in the market on Gruss, if you are always wanting toThu, 08 Oct 2020 06:03:43 -0500Hi mate.Sorry to be a pain, but I give it a little go on the US racing last night and the bet didn't trigger.I'm wondering if I have to put something different in Column C in the "Selections" sheet?https://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559970237#559970237Hi mate.Sorry to be a pain, but I give it a little go on the US racing last night and the bet didn't trigger.I'm wondering if I have to put something different in Column C in the "Selections" sheet?Thu, 08 Oct 2020 05:28:37 -0500Thanks so much, I'll give that a go tomorrow.https://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559969311#559969311Thanks so much, I'll give that a go tomorrow.Wed, 07 Oct 2020 17:03:52 -0500I would put the word "Liability" in cell R2 of the Market worksheet and the amount you're wanting as your liability in cell S2.I would change the formula in cell S5 to:=$S$2/(h5-1)I'd then use the plus symbol in the bottom right hand corner of cell Shttps://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559969187#559969187I would put the word "Liability" in cell R2 of the Market worksheet and the amount you're wanting as your liability in cell S2.I would change the formula in cell S5 to:=$S$2/(h5-1)I'd then use the plus symbol in the bottom right hand corner of cell SWed, 07 Oct 2020 16:27:55 -0500Thanks for the quick reply.I'm pretty basic with Excel, but do I need to put in a formula somewhere on the spreadsheet that will automatically the liability according to the odds?The spreadsheet can be found here:http://www.gruss-software.co.uk/Excelhttps://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559968845#559968845Thanks for the quick reply.I'm pretty basic with Excel, but do I need to put in a formula somewhere on the spreadsheet that will automatically the liability according to the odds?The spreadsheet can be found here:http://www.gruss-software.co.uk/ExcelWed, 07 Oct 2020 15:06:27 -0500Ah, I didn't realise you were trying to do them all from a single worksheet.In SM: Liability mode, when you manually navigate between markets (ie not via Excel), it WILL treat your default Lay Stake as your liability and calculate your stakes accordihttps://community.betfair.com/general_betting/go/thread/view/94082/31670233/gruss-formula?post_id=559968787#559968787Ah, I didn't realise you were trying to do them all from a single worksheet.In SM: Liability mode, when you manually navigate between markets (ie not via Excel), it WILL treat your default Lay Stake as your liability and calculate your stakes accordiWed, 07 Oct 2020 14:49:50 -0500