wait for races to be processed

[easternpromise]

I would like to bet on all of the days horse races, but with a full bank each time and have no bets unprocessed.

because the races may start every 5-10 mins, this is difficult.

Is there a way to set up BA or my spreadsheet to only bet if the previous race has been processed?

Thanks

[silver]

Within your trigger formula, you can refer to the cell which shows exposure - I think it's L2. If that's zero, you have no unsettled bets.

[silver]

I should add that you will probably need to include some VBA code to frequently update the balance/exposure data in your sheet. As default, I think this only updates when a new market loads - which will not be sufficiently often. Entering U in cell J2 requests the update, but because BA overwrites the cell each time, you cannot do this with a normal sheet formula.

[easternpromise]

Hi All,

On the back of silver's reply.

Can anyone help me with a VBA code for frequently updating balance/exposure data ?

[sjaak1943]

Why not use 2 or more spreadsheets and spread the races?
I also use the resultsheet "RESULT_NOT_AVAILABLE" in F2 no bet.

[silver]

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)

 
If Target.Columns.Count = 16 Then
Application.EnableEvents = False

    ThisWorkbook.Sheets(1).Range("J2").Value = "U"
   
Application.EnableEvents = True
End If

End Sub


The code above presumes that Betting Assistant is logging to the first sheet in your workbook and that you are logging to the default A1 cell. You can adapt the bracketed number after 'Sheets' and the J2 cell reference if those presumptions are wrong.

You'll need to open the VBA editor and on the left hand side you will see a list including a folder called Microsoft Excel Objects. Double click the Object which has the name of the worksheet that Betting Assistant logs to and paste the code above in to the main window.

That's it - you can close the VBA editor.

You will know its working if J2 = U when BA is logging.

I'm presuming that you haven't already got other code in there. If you have, then don't paste the code above in - further changes will probably be necessary to get it all to work together.

VBA is something I'm a beginner with myself, so if anyone has advice to add / corrections to make, please do!

[silver]

With regard to finding the Microsoft Excel Objects folder etc, provided you are viewing the sheet Betting Assistant logs to when you open the VBA editor (keyboard shortcut to open is Alt+F11), the main window that appears should be the one relevant to that sheet, so no need to find it in the list in that case.

[easternpromise]

Thanks silver I'll give it a go