Multiple In Running Excel Triggers

[Pug Munter]

Hi,

I want to set a lay trigger at the beginning of the race, then - if conditions are met - set off another triggered bet later in the same race. I can set up all the conditions in Excel but have only managed to get the second bet to fire if I have two spreadsheets running, and the triggers are in separate sheets.

Is the software designed so that only one trigger will ever work per race per spreadsheet, or have I set something up wrongly?

Many thanks.

[I'll Get Me Coat]

That is how I do triggerred bets. One sheet to set up, the next to trade out.

I don't think it can be done in 1 sheet.

Since I upgraded my PC and got Office 2007 everything happens faster than the eye can see.

Oh, and just for those with a poor refresh rate - it's your PC (or network connection) not BA, I have 400mS refresh rate on 4 windows and all 4 run at 400mS with a lowly 2Mb connection - ditto if all four are linked to Excel.

[Captain Sensible]

It can be done on one sheet just need to add other conditions to your triggers and use the clear commands o clear bet references. Probablt a lot easier if you're programming in vb but can be acheived using basic formulas. Depending on what you're doing you just need to set a few extra if statements to switch the formula depending where you are in your chain. I used to use the profit/loss column to decide whether to back/lay

[Pug Munter]

It can be done on one sheet just need to add other conditions to your triggers and use the clear commands o clear bet references. Probablt a lot easier if you're programming in vb but can be acheived using basic formulas. Depending on what you're doing you just need to set a few extra if statements to switch the formula depending where you are in your chain. I used to use the profit/loss column to decide whether to back/lay

Captain,

I have all the conditions in my Excel formula. And it's when a profit / loss appears (ie the first bet has been matched) that I then want the second trigger to work. Same as you're doing then.

I think what you are saying though is that the key thing to do is clear the first set of bet refs before the second trigger will work?

Have I got that right.....in other words, set up a formula which says place first bet, then immediately clear the bet ref., then have the second bet waiting to trigger once the profit / loss appears.

IGMC - thanks for your comment as well. But if the above is right, you may be running even a bit quicker!!

Cheers!

[Captain Sensible]

Yep that's basically it. easiest thing is to start breaking things down into managable chucks rather than have one massive formula in a cell. I have separate cell in a named reference called trigger that switches between BACK LAY CLEAR & "" dependant on the conditions at the time.

Just add some extra condition into calcs to switch to CLEAR when say there's a bet reference and the amount matched is right level. Bit hard to advise any further as everyone has diferent systems they play to but just a case of setting it to switch between your back and lay formulas with a clear in the middle

[Pug Munter]

Yep that's basically it. easiest thing is to start breaking things down into managable chucks rather than have one massive formula in a cell. I have separate cell in a named reference called trigger that switches between BACK LAY CLEAR & "" dependant on the conditions at the time.

Just add some extra condition into calcs to switch to CLEAR when say there's a bet reference and the amount matched is right level. Bit hard to advise any further as everyone has diferent systems they play to but just a case of setting it to switch between your back and lay formulas with a clear in the middle

Just as the old saying from his hometown of Croydon went........Captain Sensible is indespensible!!! Thanks very much for this info. But could you explain a bit more about the separate cell with named reference and how it's set up? I have always thought that the trigger must be set up from the one designated cell in Excel, so I have some long formulas there!! Your way sounds like it will be much better.

[Captain Sensible]

It's basically where you just use a separate cell to do one part of your calculation and can call it into any other formula just by using the name rather than typing out the formula again. It gives you a bt more flexability when you need to alter formulas cos everything is in smaller chunks and less likely to to mess things up by missing a comma here and there in a long cell formula. There's no need to actually name the cell and could easily use some cell out of the way like say Z1. Naming it just means if you copy and paste formulas around they'll always use that cell rather than the fact it may get transposed to Z2 etc when pastng.

To name a cell you just click on the cell, say K1, in the top left hand corner on excel you'll see a white box showing th cell you're in,K1. Just click on the white box and change it to whatever you want to call that cell, say TRIGGER. You can now call the contents of cell K1 by using TRIGGER instead of K1. You can add lots of the named cells in your formulas and copying and pasting them down your sheet means they'll all be relative to the actual trigger cells.

i.e. =+IF(P8=MAX,TRIGGER,"")

[Pug Munter]

Captain,

Thanks very much for your help, but I have to say I didn't get too far with your idea, couldn't seem to get stuff working for some reason.

But still, the info that there has to be a "clear" submitted in the middle has helped a lot.

Now all I need to do is work out how to clear and do a second bet (thats the easy bit) - but make sure (before 2nd bet is matched and the P/L changes) that the same criteria that caused the first clear aren't still in place, potentially setting off an unwanted further bet (or even a cycle of multiple clears / second bets)! I think I'll get there though......

Thanks again for taking the time out.