Auto clearing bet ref when kill or fill fails........

[Al See]

Is there an easy way to stop the bet reference cell displaying 'cancelled' when a kill or fill bet fails as I want BM to try placing the bet again providing conditions are met again.

As I understand it, once kill of fill fails once then the cell displays 'cancelled' and this precludes BM from trying to place the bet again. If the bet ref is a genuine matched one then I don't want it auto clearing, only if the bet fails.

Any ideas?

[GaryRussell]

You can't set Betting Assistant to do this, but you could use the Worksheet_Change event in Excel VBA to remove CANCELLED whenever it appears. Insert the following code into the worksheet module.

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Columns.Count = 16 Then
        Application.EnableEvents = False
        With Range("t5:t54")
            Set c = .Find("CANCELLED", LookIn:=xlValues)
            If Not c Is Nothing Then
                firstaddress = c.Address
                Do
                    c.Value = ""
                    Set c = .FindNext(c)
                    If Not c Is Nothing Then
                        If c.Address = firstaddress Then c = Nothing
                    End If
                Loop While Not c Is Nothing
            End If
        End With
        Application.EnableEvents = True
    End If
End Sub


[dogform]

If I wish to clear the BetRef field of any types of value except PENDING could I use a modified version of the code posted above ?

For example, if I trigger a bet from excel with the properties of:

BACK-TL2-F5-SL5

ie, a back bet with an auto levelling 2 tick offset, the back side filled or killed in 5 seconds with a 5 tick stop loss. The options that I think will be in the BetRef field in excel are, PENDING, CANCELLED or an actual numerical bet reference? These are the values that I have observed in practice but I am not sure if any others could arise that I did not notice while testing.

If my bet is placed or cancelled then I wish to clear the BetRef field automatically to allow the process to repeat itself in a loop.

The above code will clear the CANCELLED value but i am not sure how to modify it to clear all values except PENDING due to a severe lack of VBA knowledge.

Thx for any help

Rgds
Dog

[doris_day]

I've been trying to get CANCELLED cleared too but am not having a great deal of luck. I put the code above into the relevant module but its still not clearing.

Is there anything I can add to the trigger to do this or any other VBA code I can use ? Or even a suggestion as to why the above code isnt doing the job ?

I've tried IF(T5="CANCELLED","CLEAR","") but that doesnt seem to work for some strange reason.

Any suggestions would be helpful. Thx

PS Can anyone suggest a good site where I can learn VB ?

[kiint]

I can't test it out as I'm in work, but should Gary's code say:

If Target.Columns.Count <> 16 Then

instead of

If Target.Columns.Count = 16 Then

[robm232]

@ doris_day,

I'm trawling through vba sites at present and the following seem to have some positives:

http://www.mrexcel.com/articles.shtml
http://www.vtc.com/
http://www.functionx.com/vbaexcel/index.htm
http://www.techbookreport.com/tutorials/excel_vba1.html
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
http://www.excel-vba.com/

Hope that might help,

Cheers, rob

[2020vision]

Nice one robm232

I am just beginning to try and use the Excel functionality of Gruss BA
and I will certainly have a look around these sites for educational reasons.

Ttfn - Michael

[doris_day]

Thanks rob. I'll take a look...

[doris_day]

I've found a workaround which seems to work fine....