More than one excel sheet

[Hill16]

Quick question...

I have two separate strategies for laying outsiders under certain conditions in certain races. Both strategies use excel to trigger the bets. Mostly, the selections for each strategy are different but the odd time, they both throw up the same horse.

When this happens, I end up with rather large liabilities (as it gets layed twice) and when I hit a winner, it's a double blow and is very expensive.

Is there quick way to tell spreadsheet two (which places the bets a few seconds after spreadsheet one) not to lay the horse if spreadsheet one has already done so, or left an order to do so?

Thanks!

[crocogotter]

As long as the sheets are in the same workbook it should be fairly easy to do, although I suppose it depends on exactly how you trigger your bets.

For instance, if sheet 1 generates a lay for a horse, you can use a simple "if" function to see this (eg by using the function to determine whether the horse has a bet ref in column T such as if(T5="",1,0) ). You can create a column with this formula copied down so that any horse that has been layed will show 0, and those that haven't will show 1. The values from this column then can be copied directly onto sheet 2 (simply select the cell you want value in, type = then click on the tab at the bottom for sheet 1 and click on the cell on sheet 1 that has the 0 or 1 in it generated by the formula). You can then use the 1 to muliply your trigger for a horse on sheet 2 that hasn't yet been layed, but if the horse has been layed it will multiply by 0 and thus you can (depending on exactly how you set your triggers of course) ensure a horse already laiyed won't be layed again.

I've tried to explain the mechanics of this so you understand it, the neatest way would simply be to create a column in sheet 2 using the following function

=IF('sheet1'!T5="",1,0)

This should generate, in a column in sheet 2, a 1 for each horse on sheet 1 that hasn't been layed and a 0 for each horse on sheet 1 that has been layed.

Hope this helps and is what you're after.

[crocogotter]

Sorry, I should have added that this works as long as you're not doing anything like re-ordering the horses in a different way on each spreadsheet; as long as the horses are listed in the same order in column A then the solution in my above post should provide a simple solution for you.

[Hill16]

Thanks for that crocogotter.

I actually have them in separate workbooks so maybe I'll have to look at combining them and trying out the above.

[osknows]

If you enable logging current bets to the MyBets sheet then BA will write the current live bets for that market to the MyBets sheet. Any bets will show in multiple workbooks as long as each one is linked to MyBets so you should be able to use this to determine if a bet has already been placed. The only time this may not work is when both bets are sent very close together.

Additional coding is required when you do want to run multiple workbooks and need to know which workbook the bets came from but in your case this should work as you just don't need to know this.

Os

[Hill16]

Thanks guys, I'll try spend a bit of time over the weekend to look at this more and combine the workbooks. I thought there would be something simple enough to alert a stand alone workbook if a bet/order has been placed on a horse already from another source but it looks like combining might be the way to go.

Wayne