Gruss Forum • View topic

by **Graham** » Mon Jun 27, 2011 1:39 pm

If you reorder the grid, excel is unaffected, see below from the help file:

The sort oder dropdown box allows you to re-order the selections in the grid.

The default option is 'Not Sorted' meaning that the selections will be in the same order as if you were viewing the market on the Betfair website.

The sort options are back and lay prices being the best prices on offer, selection name, and saddlecloth number (applicable to horse racing only).

Please be aware that if you have the grid sorted on back or lay prices then this order will be maintained meaning that if for example you were sorting on back prices and the 2nd favourite becomes the favourite then the grid will automatically be re-sorted to show this.

Also note that when you change markets the sort option is remembered.

If you have a market linked into Excel then sorting the grid has no effect on the order that is displayed in your Excel sheet.

by **TotalPyro** » Mon Jun 27, 2011 1:56 pm

Thank you...
... another question a usual, thatnk you for all your time and help...!

I am trying to write a excel formula around the time on the clock….
Trying to stop any betting after a certain time….
I placed the following formula in the cell above the clock:
=IF(D2 >0,1,2)

This seems to work as a formula but I unable to test it if works when the Clock crosses from 00:00:01 to 00:00:00 because as soon as it fires and the number 1 or 2 appears in the cell it delets the formula in the cell and then disappears!!!!

Do you know how I can stop this happening….. how I can always have a 1 or 2 present in the cell depending on the time on the clock?
.

by **Graham** » Mon Jun 27, 2011 2:20 pm

BA could be overwriting the cell, where do you have the formula? Try moving it to say, Z1.

I think you'll find also that when the time goes negative your formula wont work. Probably best to just check whether the time is negative with:

=IF(LEFT(D2,1)="-",2,1)

by **TotalPyro** » Tue Jun 28, 2011 9:50 am

Thank you for that Graham... genius!

Do you know genallu how long is takes a horse to run a race - I am basically looking for a time between when the race goes 'In Play' to when it goes 'Suspended'?
I appreciate that this depends on many factors from the length of the race to the 'going' to quality of fields etc...... but I am looking for general figure....
From what I can see 1 mile is about the longest that is run in the UK generally... is this right? But in the US there are frequently 2-2.5 mile races in the us..... can you help?

Also is it possible to 'close out my automated offset bet before the race starts? For example a fire a back bet into market it is mathed and a offset ley bet is fired into the market.... it isn't matched is it possible to fire another lay bet into market at what ever the price is at that time to to cover the back bet already in the market... I hope this makes sense....!!!!!

by **Graham** » Tue Jun 28, 2011 10:08 am

Do you know genallu how long is takes a horse to run a race - I am basically looking for a time between when the race goes 'In Play' to when it goes 'Suspended'?

see here: http://gruss-software.co.uk/forum/viewtopic.php?t=6008

I appreciate that this depends on many factors from the length of the race to the 'going' to quality of fields etc...... but I am looking for general figure....
From what I can see 1 mile is about the longest that is run in the UK generally... is this right? But in the US there are frequently 2-2.5 mile races in the us..... can you help?

No, flat races are generally shorter, but NH are longer, the grand national for example is 4 and a half miles i think.

Also is it possible to 'close out my automated offset bet before the race starts? For example a fire a back bet into market it is mathed and a offset ley bet is fired into the market.... it isn't matched is it possible to fire another lay bet into market at what ever the price is at that time to to cover the back bet already in the market... I hope this makes sense....!!!!!

Yes, you could, at a certain point ,cancel all unmatched bets and use Gary's Green-Up sheet to close all positions. There may be other ways, but this is the first which comes to mind

by **TotalPyro** » Tue Jun 28, 2011 3:59 pm

Hi Graham
Thank you for the advice.....
I am trying to use Garys GreenUp sheet but even if I place the simplest bet, such as 'BACK' I just get an error in the the betref and no bet is placed.....? Do you have any idea what I might be doing wrong?
I do remember that when I initially saved it I was having problems with entering passwords etc... but it eventually let me.... not sure if this is the problem?????

by **Graham** » Tue Jun 28, 2011 4:15 pm

Have you populated the odds and stake in columns r and s?

by **TotalPyro** » Tue Jun 28, 2011 5:02 pm

hOW STUPID OF ME!!!!!!
I have now placed a BACK bet on a horse on the green up sheet....
what are the following coloums supposed to do...
Green up bet Stake Odds Greened up P&L

presently they are doing nothing?

by **Graham** » Tue Jun 28, 2011 5:10 pm

i haven't really used that sheet often, but i believe that they are meant to be advisory. you can then conditionally use them to populate the relevant cells.
By that, I mean that you can use, for example the greened up p and l as the criteria of whether or not to to place the green up bets, and the green up stake and odds to populate columns r and s. I hope that makes sense.

by **TotalPyro** » Mon Jul 04, 2011 5:10 pm

Hi Graham
Do you know a way I can record the odds from Gruss, then I can test my stratergiys before putting them into live play?

thanks

2 simultanius bets...possible?

Who is online

Sports betting software from Gruss Software