Offset bets in Excel

[2020vision]

Hi All

Have just been looking at trigger modifiers in the help guide but unless
I have missed something there is not an offset requests trigger that would allow
placing of bets e.g. 2 ticks above/below available price? Bearing in mind
I would quite likely also want to include an opposite tick offset bet?

Without having to resort to "getclicks" code is there a way please?

Thanks, Michael

P.S. As described in this post from a while back:
http://www.gruss-software.co.uk/forum/v ... ight=ticks

[GaryRussell]

There isn't a trigger. The only way at present is to use that code you mention. It's very easy to insert that code into a spreadsheet. Once it is there you can just use "=minusTicks(F5,2)" in column R5 for example so that any trigger will use the best back odds minus 2 ticks. I can send an example spreadsheet with the code included if you need.

Bearing in mind
I would quite likely also want to include an opposite tick offset bet?

Do you mean you want a lay bet placed once a back bet is matched for example? You can use the tick offset modifier. eg. "BACK-T2" to place a lay bet at 2 ticks below the matched back odds.

[2020vision]

Hi Gary,

please send example spreadsheet if you don't mind, Thanks.

But how would I be able to then place an opposing bet say 5 ticks automatically?
Entering code, clearing cells, etc., is not my strong point - any chance of maybe in the
future of building in trigger something like BACK-O2-T3? (O=offset ticks btw)

I tried the BACK-T2 trigger but obviously this will not place the first bet say 2 ticks
above available price will it? Or is there a way to achieve what I ask?

Please bear in mind I am not very good on Excel at the moment, just trying to learn.

Ttfn - Michael

[2020vision]

Am just looking at a spreadsheet now and am I correct in assuming if
R5 contains =minusTicks(F5,2) and trigger in Q5 contains BACK-T2 then
the bet will fire at 2 ticks below best price and still input the offset at yet
2 additional ticks? Hope you get what I mean?

Would this simply work in reverse for lay bets too?

Cheers - Michael

P.S. Hope I don't sound stupid but gotta start somewhere

[2020vision]

Give myself pat on the back

Got it working - placed automatic bet 2 ticks below available price using
my trigger, matched, it also place opposing bet 3 ticks away, matched!

Great so far but could anyone give me a quick simple way to clear bet
reference so that I could do it over again? Possibly with set time period?

Thanks - Michael

[GaryRussell]

If you select "Offset bet matched flag" from additional columns when setting up the Excel link then you could use this in the trigger formula.

For example
=if(Y5="Y","CLEAR","BACK-T2")
The Above trigger will clear the bet ref column when the offset bet is fully matched. This example does not incorporate any conditions for placing the back bet though, it's just an example. If you post the formula you are currently using I can tell how to incorporate this.

[GaryRussell]

Would this simply work in reverse for lay bets too?

Yes it will.

[2020vision]

Thanks thus far

I get the idea of offset flag (I think)?

To keep it as simple as possible for now my first successful attempt above
was in odds column =plusTicks(F5,2)
and trigger =IF(F5>7.8,"LAY-T3","")

This is as good as I can remember - not terrific logic yet because I realise
to lay lower would have been better but just learning. This bet above was a
complete success - layed at 8.4, backed at 9, same stake. I realise also that
I could have use auto-level trigger too. Hope I'm right?

Questions: How to resubmit within my parameters over again but NOT get
into a neverending loop? e.g. how to stop after so much stake or time limits?

Maybe I am trying to run before I can walk, but have to start somewhere.


Thanks for any help and patience, Michael

P.S. I reckon I learn better by example than actual study.

[Timstertoo]

What I'd like to do is if my back odds are matched to do an automatic laybet using plusTicks. But I'd like that bet to be an auto level profit amount.

Is this possible with the current code?

We've got quite the botmania going on over the road at the moment So expect some more n00bs like me coming in.

[2020vision]

Hi Timstertoo, Nice to meet you - everyone's welcome

Right off the top of my head using the example above the formula to
level profit would have been: =IF(F5>7.8,"LAY-TL3","")

TLn - Submits a Tick Offset bet with Auto Level Profit where n represents the
number of ticks to be used.

Why not peruse the user/help guide found here:
http://www.gruss-software.co.uk/Betting_Assistant/help/help.htm

If I am wrong would someone please correct me asap - Thanks.

Ttfn - Michael

[Timstertoo]

Hi Timstertoo, Nice to meet you - everyone's welcome

Right off the top of my head using the example above the formula to
level profit would have been: =IF(F5>7.8,"LAY-TL3","")

TLn - Submits a Tick Offset bet with Auto Level Profit where n represents the
number of ticks to be used.

Why not peruse the user/help guide found here:
http://www.gruss-software.co.uk/Betting_Assistant/help/help.htm

If I am wrong would someone please correct me asap - Thanks.

Ttfn - Michael

Thanks for the warm welcome!

I found the Tick Offset auto level function but I want to do that after I get backed first.

Simply put I get backed @ 50, then I want to lay it a couple of ticks over best price for a price that autolevels the profit (or loss).

I've only started on this automation stuff this week so I'm a bit green. If what you said above is an exact answer to what I just said I simply don't get it yet.

[2020vision]

Timstertoo,

The above example simply meant that I layed first and then put the back
bet in three ticks higher than the price I was matched at.

Hope this at least helps - I am only just above a newbie myself!

Ttfn - Michael

[Timstertoo]

Timstertoo,

The above example simply meant that I layed first and then put the back
bet in three ticks higher than the price I was matched at.

Hope this at least helps - I am only just above a newbie myself!

Ttfn - Michael

I've already noticed that hands on is the only way to learn this. Every mistake gives you a chance to learn a new solution.

I thought that was what your bit did and it's less complex because you can use the tickoffset tool which will also manage the stake.

For me I need to set odds first. Then after it gets matched the odds have to change to x ticks above best price.

But also the trigger needs to fire twice.

What I have up till now is this:

odds

=IF(T14="",odds,IF(T14=MATCHED,plusTicks(H14,3),"" ))

T14 is where the bet reference is. So if there's no reference he should just use "odds". But if the bet reference says it's MATCHED I want him to use plusTicks and use odds 3 ticks above current best price.

I let Gruss start at A10 so T14 is Bet ref of the 1st runner and H14 is Lay Odds 1.

Then I have the trigger like so:

=IF(AND(time_off>bet_finish,time_off<bet_bet),"BACK",IF(T14=MATCHED,CLEAR-LAY,""))

This is work in progress. The first bet just fires in a back bet at a certain time. I had this working before. Starting from the 2nd if I let him check if the bet reference is matched. Because if it is it needs to fire in the 2nd bet it needs to clear the bet reference first. I know CLEAR-LAY won't work but it's the best I could come up with and it let's me know what I intend to do there. Also I'm still stuck with staking as it won't put in a profit level amount on the lay and even worse if I just get partially matched on the backside it will fire in a full stake on the layside!

My head is spinning from all the new info I'm trying to get under control. I really need to step away for a bit every now and again just to clear my head and get stuck in again fresh

[Timstertoo]

Haven't found the edit button yet on this forum.

Your situation is less complex not only becuase the offset will take care of the stake for you but it will also take care of the odds of the 2nd bet.

So I'd better be off just using your bot!

[2020vision]

Timstertoo,

looks like I don't yet have the expertise to help enough - sorry. Patience.

I've already noticed that hands on is the only way to learn this. Every mistake gives you a chance to learn a new solution.

Yep, that seems to be the best way - learn by example. Just make sure your
balance in account just enough for testing. i.e. transfer excess to Aus wallet!

Haven't found the edit button yet on this forum.

There is no edit button available for normal users, try to get right or post another?

Good luck - Michael