Trigger bets in Place Market From Win Market Prices (Excel)

[Betscrew]

Hi.
I am trying to put lay bets in the Place Market based on the Win Market back price, for example, if the win back price is 6.0, I want to lay for a place at 2.0 (ie. a 1/5th odds).
This was pretty easy to achieve using the LAY trigger but how do I update the place price every time the win price changes?

It seems I need to use the LAY trigger combined with the UPDATE trigger, or simply the LAYR trigger but I couldn't find any examples of how to use the latter two.

Any advice gratefully recevied!

Cheers,
Betscrew

[Captain Sensible]

I think you'd use LAYR if you wanted to submit a completely new bet ie both odds and stake. Using UPDATE would only update the odds or stake not both, I think.

Hopefully you'll code it not to kick off at every odds change or it could get very costly in transaction charges with the amount of odds changes we get

[Betscrew]

Thanks Capt, I appreciate your comments.
I am in desperate need of an example of using a LAYR or UPDATE triggers.

For example, say I have the current set-up:

LAY (trigger), 2.0 (odds), 2.0 (Stake)

How do I use the UPDATE trigger to change the odds or LAYR to change both stake and odds? I have looked though the entire forum (and manual) and there are no examples or explnations on how these work!


Cheers,
Betscrew

[Captain Sensible]

There are plenty of examples on how to use the triggers on the forum. Basically you've got a bet already submitted, to update just the odds you'd replace whatever trigger is in the trigger column with UPDATE and change the odds column with your new odds. An update request is then made and your bet submitted with the new odds and same unmatched stake as before, a new bet reference would be entered in the bet ref column and appended with an N, the N stops the update from refiring in a loop. So remember to tix that box on the logging options when you connect BA to excel. Obviously if you want it to refire endlessly you could use a little VBA to replace the N from the bet ref column.

If you want to change both the odds and stake if say you're laying to a liability you'd use LAYR instead of UPDATE in the trigger column and whatever new stake and new odds you want for the bet. Basically LAYR is cancelling the original bet and submitting another one but done in one trigger command rather' than two to make life easier. Again it appends an N to the bet ref to stop the trigger from looping.

http://gruss-software.co.uk/forum/viewt ... light=layr

[Betscrew]

Thanks for the info, especially the link - exactly what I was looking for!

Betscrew

[zuqiu123]

thanks

[Betscrew]

Hi.
I have some success so far using the following formula as a base and calculating my place odds from the Win Market price (eg. F5/4):

=IF(T5="CANCELLED","CLEAR",(IF(T5="","LAYR-F60","")))

This re-submits my bet every 60 seconds.

However, what I am now trying to achieve is to simply place a LAY bet and then UPDATE it only if the odds (F5) have changed by a pre-determined amount. The UPDATE should continue to loop (as the current LAYR formula abaove does).

Any pointers or clues would be gratefully recevied!

Cheers,
Betscrew

[Captain Sensible]

I'm guessing you're using formulas rather than vba to fill the trigger columns? You basically need to record the odds you originally submit to compare against the new odds to decide whether to update, with VBA it's a doddle otherwise might be easiest for you to use a MyBets sheet that you can reference to find the odds the bets are submitted at.

With formulas things might get a bit messy with all the VLOOKUPs what advantages do you think it'll bring over your current method? If you're changing odds and stake it's not going to be much quicker and submitting a new bet every 60 seconds isn't going to have any effect on you transaction charges. I guess you'll maintain your position in the queue for very liquid markets but thats pretty much all

[Betscrew]

Hi Captain.
Once again thanks for your help - I will look into your points in detail shortly.
To answer your question, the advantage that this improvement will bring is that if the odds move quickly (normally hammered on the downside), I won't be sitting up there (for up to 60 seconds) like a duck waiting to be shot down with odds way over par!

Betscrew

[Captain Sensible]

K, I thought the 60 seconds was part of your strategy, you could always lower that for an easy option. But realistically learning a bit of VBA to log the original bet price submitted and using UPDATE is always going to be more efficient and the best option in the long run.

[Captain Sensible]

There's a sheet somewhere on the forum that uses UPDATE to chase prices when closing out. Not sure what it's called but should be able to find it with a search and maybe just amend that to update your own prices.

[Betscrew]

Having done a whole load of reading last night, it seems I was way over-complicating things!
This looks promising:

IF(T5="","LAY","UPDATE")

I am trying to trigger a LAY bet then update it when the odds change - can be "looped" by un-checking the "append N" option.

Thanks for all your help, especially the Captain!

Betscrew