Excel Conditions, but only place once

[SheppardIE]

Hi

I have developed a list of conditions in excel I want to use for tennis games. But I have run into a problem I've been try to solve for the last few hours.

One of the conditions I have is, if the bet price increases 25% more than a certain price then place a lay in the market.

My concern is if the price increases by 25% above the base multiple times during the game excel will place multiple lays.

How do I over come this issue? If I had multiple lines for the same player it wouldn't be a problem as "Placed" would overcome this. Or if I could record what bets were placed by excel I could make sure they were only done once.

My question is how do you ensure excel only executes conditions once and not multiple times?

Thank you for your help

[beepbeep20]

I' probably misunderstanding what you mean. Because the way BA/Guardian operates with Excel is exactly what you want.

On a single row in excel the only way to get more than one bet placed is to clear the PLACED text (either cleared manually or via a VBA macro). If you don't clear the PLACED text a 2nd bet (on that selection) won't be fired. Also the PLACED text stays there even if the bet ends up unmatched and being killed.

Or do you want to place one bet on Player A and once you've done that not place a bet on Player B (even if the conditions are met) ?

I've never traded tennis and, obviously because of that, never connected a tennis match to excel. So perhaps there's something I'm missing.

[SheppardIE]

Maybe I didn't explain that well enough, my head was fairly wrecked trying to figure it out.

I want to be able to place multiple bets during a game based on certain conditions during the game.

During any one game I may need to bet several times but never repeat a bet if you get me. In any one game I will need to bet at least twice but never repeat a bet.

eg if condition 1 met for Manu bet @ this price
if condition 2 met for Manu lay @ this price

So say condition 1 is met during the game for Manu and a bet is place @ a price. Then condition 2 is met for Manu and layed at a price. If condition 1 is met again I don't want it to place another bet @ a price. I only want it done once.

Is it possible to bet multiple times on the same team using the excel spreadsheet, but never have a bet repeat itself.

Some possible solutions:
Is it possible to record placed bets?
Is it possible to record when cert odds have become available?
Is it possible to have the same game listed several times?
Is it possible to have multiple lines for a team?

I'm finding it very difficult to solve this problem, I would be grateful for any suggestions.

Thanks, Stephen

[SheppardIE]

Is there a way to pull in the bet high/low and lay high/low during game play into your excel spreadsheet?

[beepbeep20]

OK I understand what you want now.

You're correct, as it stands Excel/BA doesn't tell you what bets have been sent already really. The only info you get (relating to your past bets) is your P/L, Greening and a count of the unmatched bets.

I think it should be possible to record placed bets if you use VBA to look for 'Placing' and copy it (it = the bet text, stake and odds) to an unused part of the spreadsheet.

Another approach might be beneath the bet/stake/odds Betangel sends back something like 'Back bet on player A completely unmatched'. (I don't have a betangel sheet in front of me to get the exact text it sends back)

Have you tried linking one sheet to a match via Guardian and then also using the 'excel' tab in the main 'BA app' (the 'excel' tab between 'saved bets' and 'log') to link the market to another sheet? I've never tried that, it might work though.

[SheppardIE]

I don't know much about VBA but thats a good idea about using the two excels tabs.

Thank you for your help