human element

[Captain Sensible]

You're welcome glad to have been of help. If you want to add a fourth column to enter BACK or LAY in sheet2 Column D

the trigger code from N5 to N50 just needs to change to



=IF(AND(MINUTE($D$2)<1,O5>0),VLOOKUP(A5,Sheet2!$A$1:$D$100,4,FALSE),"")

[robin09]

thanks to all who helped out will try some of this stuff out when have more time.

this looks a very interesting subject because this column is growing fast so shows its what people are lookin for to leave out a lot of the human element and have bets placed or cancelled automatically..........

[Kevsy]

I was playing with this for quite a bit yesterday but found it a bit inconsistent. I found it sometimes placed the bets and other times simply said pending. At the triggered bet time it would move one by one down the race card saying pending, pending etc then do nothing when it came to the bet it was supposed to make. I tried putting in a bet for every horse in the race and this worked at first (laying most at 1.01 for 2 quid) then after it a while it decided it didn't like this. Sometimes I just got an error message for all. One thing which did work was to delete whatever it said in the bet ref column then it worked fine, but this isn't practical. Worryingly a couple of times I received a bet reference but nothing was actually placed. I am wondering if there something I am missing? The Vlookups are spot on, the triggers are triggering, its just sometimes with effect and sometimes not.

[Kevsy]

Just add I haven't changed the refresh rate or anything like that. Its set at 1.0. Also I have verify bets ticked, this this make a difference? As I said it places bets some of the time without needing to untick that.

[Captain Sensible]

might be best starting a separate thread stating exactley what went wrong kevsy. usually the pending comes up when it's placing bets less than £2.00. If you're requesting certain odds 1 miniute before the off those odds might not be reached so the bet might not be matched.

There's so many scenarios that are possible that may be the reason why you're getting errors. You can always add extra criteria to avoid errors such as seeing if a market is in play etc. Without knowing why the errors are occuring there's no way of fixing them.

If you're just laying the field at 1.01 when the market goes in running it's easy enough to write codes to do this

[andyh]

Hi, I have been trying to recreate the method detailed in this post but I'm not having great success. I am trying to get the markets to update using quick pick and having my list of horses on sheet 2. What seems to be happening is when the market changes on sheet 1 the formulas that check for my horse and place odds and stake in sheet 1 disappear. Am I doing something wrong as I must admit my knowledge of how and what is happening is rather poor. If anybody can point me in the right direction I would be very grateful.

Thanks

Andy

[jokerjoe]

Just a little suggestion for autobetting in the minutes before the off, add an hour condition, as I've just discovered to my cost!

=IF(AND(MINUTE($D$2)<1,O5>0),"BACK","")

changes to

=IF(AND(HOUR($D$2)=0,MINUTE($D$2)<1,O5>0),"BACK","")

[jokerjoe]

andyh: formulas are probably disappearing due to a change in the program since captain sensible posted the worksheet clearing macro. Range wiped should be changed as highlighted below.

Private Sub Worksheet_Calculate()
Static MyMarket As Variant
Application.EnableEvents = False
Application.Calculation = xlCalculationManual
If [A1].Value = MyMarket Then
GoTo Xit
Else
MyMarket = [A1].Value
Range("T5:U80").Value = ""
End If
Xit:
Application.EnableEvents = True
Application.Calculation = xlCalculationAutomatic
End Sub