How do I limit the number of bets on a selection using Excel

[rhysw]

I have a lay strategy that I have managed to get to work somewhat clumsily using VBA in excel and one of the issues I am having with it is I only want one unmatched or matched bet (so a maximum liability) on any one selection. I have tried using booleans to tell if a bet has been placed or not but it doesnt seem to stop multiple bets being piled up on top of each other, exposing my risk in the market to a much higher amount than I am comfortable with. can anyone please help me with this problem?

[MarkRussell]

Hi,

Are you using the "log current bets" option?
With this option selected from when you start logging to Excel you can keep track of all bets for the current market.
You will need to have sheet in your Workbook named 'MyBets'

Regards,
Mark

[Captain Sensible]

If you don't want to use booleans etc can you not simply send a marker to the excel sheet each time a bet is placed i.e. Send "Y" to the corresponding cell in column AA and check that's clear before placing any bets. You can then simply clear the column each time you enter a new market to start over.

[rhysw]

I have resolved the issue, there was a bug in another part of the code regarding how the sheet was refreshing.