Gruss Forum • View topic

by **Des911** » Sun Jul 25, 2010 5:56 pm

Had a little problem today. When I have the min max odds set to 2 and 100, it tried to place a back bet at 100 which didn't of course get matched.

I'm using the place bet spreadsheet off the forum but I'm not really bothered about any odds but if I delete the figures in the Min Odds and Max Odds cells again the bet doesn't get place.

Any ideas?

by **excelhasey** » Sun Jul 25, 2010 8:16 pm

I have not looked at the spreadsheet but I assume it needs data adding to the Min & Max cells otherwise it won't trigger, why can't you add values into these cells ??

by **GaryRussell** » Mon Jul 26, 2010 8:29 am

Des911 wrote:Had a little problem today. When I have the min max odds set to 2 and 100, it tried to place a back bet at 100 which didn't of course get matched.

I'm using the place bet spreadsheet off the forum but I'm not really bothered about any odds but if I delete the figures in the Min Odds and Max Odds cells again the bet doesn't get place.

Any ideas?

I'm not sure why it did that. Have you changed the formulas in any way? If the odds are below the minimum odds then it will back at the minimum odds. If the odds are between the minimum and maximum then it will back at the current odds. If the odds are above the maximum then it will not be backed at all. It shouldn't just back at the maximum odds unless the odds happen to equal the maximum odds at the time.

If you entered them the wrong way round, ie. 100 in the min odds column and 2 in the max odds then it will back at 100. Did you do this by any chance?

by **Des911** » Mon Jul 26, 2010 9:38 am

I haven't changed anything and didn't get it the wrong way round either which is why I thought it was odd.

I will try again today and if the problem persists will download the Place bets spreadsheet again and see if that works.

thanks for replying, appreciate it.

by **Des911** » Mon Jul 26, 2010 2:32 pm

Still not working, I downloaded the spreadsheet again and tried again but it still places the bet at 100 and doesn't get matched.

Is it because I'm using BACK-PL20-IP, should I have done something else?

by **GaryRussell** » Mon Jul 26, 2010 2:37 pm

Very strange. Should work with that trigger. Can you send me a copy of a spreadsheet where this happened? You can email it to admin@gruss-software.co.uk. If you can monitor a race and watch out for the bet being triggered at 100 and then immediately click the save button at that time it would be helpful so that I can see the state of play just after it triggered.

by **Des911** » Mon Jul 26, 2010 3:12 pm

Thanks Gary, my next planned race is the 3.45 so I will try to do it then.

by **Des911** » Mon Jul 26, 2010 4:46 pm

Just to add something to the thoughts. I changed the max odds to 2 (leaving the min odds at 2) and it placed the bet and the lay ok, don't know why but it did.

by **Des911** » Mon Jul 26, 2010 5:16 pm

Just worked again with both min and max set to 2

Not a problem because I'm not bothered about the odds but might be intersting to see why it's happening.

by **GaryRussell** » Mon Jul 26, 2010 5:28 pm

I have got your spreadsheet, thank you.

The problem is caused by using BACK-PL20-IP on the selections worksheet. This worksheet only expects BACK or LAY. I have corrected the spreadsheet and sent it back to you.
Note that cell AA2 on the Market worksheet contains the trigger modifier “-PL20-IP”. Note that the formula in column Q checks if AA9=”BACK”, it did not when AA9=”BACK-PL20-IP” which it did when the selections worksheet contained BACK-PL20-IP. This confused the formula and gave unpredictable results.

by **Des911** » Mon Jul 26, 2010 5:30 pm

That's great Gary, many thanks for your help.

by **Des911** » Mon Jul 26, 2010 7:45 pm

Back again, sorry but it didn't place any bets in the 7.40 at Windsor where it was supposed to place 2 bets

by **Des911** » Mon Jul 26, 2010 7:57 pm

Then in the next race it tried to place just one bet at 100.00 again.

To sum up, it didn't place either bet when trying to back 2 selections and placed a back bet at the max odds when backing one selection.

Do I need the BACK-PL20-IP on the selections sheet or just back because you've done something on the other sheet Gary?

by **GaryRussell** » Tue Jul 27, 2010 8:55 am

You only need "BACK" on the selections sheet, because of the change I made to the other sheet. If it doesn't place bets at all then can you do the same and save a copy just after you think it should have triggered a bet and send me a copy. There must be a logical explanation like last time because this spreadsheet definitely works.

by **Des911** » Tue Jul 27, 2010 9:04 am

Thanks Gary, it still had BACK-PL20-IP on the selections sheet so I'll change it to just BACK

Green up in running

Who is online

Sports betting software from Gruss Software