Gruss Forum • View topic

by **mak** » Mon Mar 22, 2010 11:22 am

Gary hi
first of all thanks for your xl sample sheet for green up
haven't test it yet but can you explain how & when the green or red bet fired? :oops:

by **GaryRussell** » Mon Mar 22, 2010 11:36 am

It's not fired. It only performs the calculations. It's up to the user what they do with this information.

by **mak** » Mon Mar 22, 2010 12:02 pm

thanks

by **2020vision** » Mon Mar 22, 2010 12:03 pm

Hi

Works for me!
All I need now is to get advice on how to fix the trigger to only fire at a set time before
the event start? e.g. 20 seconds (or less) and not before.

How would I be able to auto-load market x-seconds before event start - seems to allow
only multiples of minutes? Would this idea work?

Thanks to anyone for reply - Michael

P.S. I expect this is pretty straight forward, please bear in mind I am a relative newbie
regarding Excel and triggers - Thanks.

by **Timstertoo** » Mon Mar 22, 2010 2:33 pm

This doesn't cover you whole question but what I use to fire at a certain time is.

Put in a cell the time you want to fire the bet. Like 00:00:20 being 20 seconds before the off.

Then you put in the trigger

IF((MinutesToOff<MyTriggerTime),BACK,"")

With MinutesToOff being the timer Gruss auto imports into the sheet and MyTriggerTime being the cell you set the value yourself.

To make things easier I put them under each other. So I just make on cell that simply says =MinutesToOff and then put the MyTriggerTime cell under it so I can see what's going on.

Hope this helps, just don't risk your bankroll on anything I say as I'm only less then a week into this automation stuff :wink:

by **2020vision** » Mon Mar 22, 2010 2:48 pm

Thanks Timstertoo for input

Not even sure how to get my head around your suggestion yet?
Maybe if I explain a little more, assuming I have matched bets.

Using Greenup.xls linked to market my trigger is simply:
Q5=Y5 (trigger, BACK or LAY) - R5=AA5(odds) - S5=Z5 (stake)
I always do greyhounds so these cells are always same from 5-10.

All I want is how to fire Q5 at a specified time - say 20 seconds or
less to start. Otherwise it fires immediately - not good.

Hope this makes sense? Michael

P.S. Something like =IF(<20secs,Y5,"") or =IF(D2<00:00:20,Y5,"")

by **2020vision** » Mon Mar 22, 2010 3:15 pm

Looks like I have cracked it using Timstertoo idea.

IF((MinutesToOff<MyTriggerTime),BACK,"")

With MinutesToOff being the timer Gruss auto imports into the sheet and MyTriggerTime being the cell you set the value yourself.

Did not realise the clocks would work this way.

Thanks, Michael

by **mak** » Sat Apr 10, 2010 10:55 pm

Gary,
I give it another try today but still a little confused.

1.Can you you explain how the odds & stake are calculated? With the opposite available odds?

2.When i manually move form a market to another the odds stake,and kind of bet column wasn't removed.What i was missing?

3.Is there a way to "ask' through you code for minimum winnings?

ty

by **GaryRussell** » Mon Apr 12, 2010 9:12 am

1.Can you you explain how the odds & stake are calculated? With the opposite available odds?

1) The profit/liability if the selection wins is calculated from MyBets. Call this W
2) The profit/liability if the selection loses is calculated from MyBets. Call this L
3) One of the following two simple calculations is performed using the above two values depending on whether W is greater than L or L is greater than W
a) W > L
(W-L) / best lay odds
b) W < L
(L-W) / best back odds

2.When i manually move form a market to another the odds stake,and kind of bet column wasn't removed.What i was missing?

It shouldn't do that. I will investigate.

3.Is there a way to "ask' through you code for minimum winnings?

Not sure what you mean. Can provide an example?

by **GaryRussell** » Mon Apr 12, 2010 9:24 am

2.When i manually move form a market to another the odds stake,and kind of bet column wasn't removed.What i was missing?

I cannot reproduce this problem. Is the MyBets sheet updating when you move to another market?

by **mak** » Mon Apr 12, 2010 11:45 am

GaryRussell wrote:
2.When i manually move form a market to another the odds stake,and kind of bet column wasn't removed.What i was missing?

I cannot reproduce this problem. Is the MyBets sheet updating when you move to another market?

Just download a fresh worksheet and now it is working fine

by **mak** » Mon Apr 12, 2010 12:52 pm

Now that i saw how the calculation is working (with the available prices) I understand.Thanks

There was a case where i had a match back bet at 30 odds with stake 0.5€
The available lay odds where 25 (0.6€ to green up for 0.10€) but I could manually place a lay bet at odds 15 (1€ to green up for 0.5€)

The available Back odds at the time were 14

Ideally i would like to be able to green up automatically or at least offer the best odds.Have you got any suggestions?

by **mak** » Mon Apr 12, 2010 1:10 pm

Really would be to difficult for the macro code to check for the LAY bet In above example) the available Back Odds + 1 tick (your other code) for example?

hope that you can make sense...

by **GaryRussell** » Mon Apr 12, 2010 1:14 pm

mak wrote:Really would be to difficult for the macro code to check for the LAY bet In above example) the available Back Odds + 1 tick (your other code) for example?

hope that you can make sense...

It would not be too difficult. I will post an example later.

by **GaryRussell** » Mon Apr 12, 2010 3:31 pm

I have added another example which uses the opposite odds. See http://gruss-software.co.uk/forum/viewtopic.php?t=4659

Green Up (xl sample)

Green Up (xl sample)

Who is online

Sports betting software from Gruss Software