2 simultanius bets...possible?

[TotalPyro]

Hi Graham
You are right I don't need 2 work sheets.... all the information is scrambling my brain!!!!!
But there are a couple of others things that puzzle me:
1) If you have races in your quicklist that start less than 5min from one another yet you are going to automatically load the races 5min from one another what happens?
For example the next race has loaded and betting has begun... but the next race is only 1min away... I presume that this means that the initial loaded race will disappear after only 1min of betting and the new comes in its place.
How do you get over this problem? I was hopin to get the whole 5mins of betting before a race?
2) How do you stop the automated betting from continuing when the race goes in-play?

Thank you for any help....

[Graham]

You wont like this, but you will need more than 2 worksheets!!!

But its not a problem.

In Options, Preferences, tick Load different venues in separate pages.

When you load the races you will then see each venue in a seperate tab.

You can then link each venue to a separate worksheet.

Regarding when the race goes in play, cell E2 will say "In Play" when the market goes in play, so you can include a simple check for this in your trigger formula.

regarding clashing race times, if you are only playing UK horse racing markets, you wont miss very many, as there are rarely markets less than 5 minutes apart. The occasional ones which are usualy have the same start time. Even any irish racing generally slots in.

[TotalPyro]

Thank you... much work to be done!!!!
I have just placed my first bet!!
But it didn't show up in the My Bets worksheet...? I have ticked in the Excel start up screen...?
What else might I have done wrong?

[GaryRussell]

Thank you... much work to be done!!!!
I have just placed my first bet!!
But it didn't show up in the My Bets worksheet...? I have ticked in the Excel start up screen...?
What else might I have done wrong?

Is the worksheet named correctly? It should be MyBets
Note that it is a capital M and capital B and there are no spaces.

[TotalPyro]

You are right...wrong spelling!!!!!!

[TotalPyro]

Does anyone know if they is a way to alter the automated offset bet in Excel.
For example if you were to type the trigger - BACK-T2 - how could a organise the initial back stake to be different from the offset lay stake?

Thanks

[Graham]

if you are looking for level profit, then BACK-TL2 will automatically fire the offset lay stake to ensure the same amount of profit whether the selection wins or loses.

[TotalPyro]

Thank you Graham......Can you give me a scenario with specific figures so I can understand better?

[Graham]

Say you back £100 at 7.0, BA will fire an lay of £106.06 at odds of 6.6, if you are laying two ticks lower.

If the selection wins, your back returns £600, and your lay pays out £593.94, netting you £6.06 before commission.

If the selection loses, your lay returns, obviously £106.06, and your back loses £100, netting you, again, £6.06.

[TotalPyro]

The sounds brilliant... thank you!
Can I just ask though, not being a budding mathmatician is that the maximum you can win in this situation on both the back and lay situation... for example if you were to lay £110 rather than 106.6 would this improve both the back and lay win situation at the end of the race?

I am also very keen to up the losing horse win... so a larger offset lay bet would be where I really want to be even though it would mean that if the horse won I would lose more....?

Is there an additional column or trigger where I can set the offset odds?

[Graham]

Its either level profit or the same stake i'm afraid.

[TotalPyro]

Hi Graham
is the automated green up facility that can be used in Excel?

[TotalPyro]

Hi Graham
Basic question... sorry.... but how to I get the charting data up. I have read the User Guide and talks about the Betting Assistant... I thought I was using the betting assisstant but can see no reference to the charts?

Tim.

[Graham]

is the automated green up facility that can be used in Excel?

No, thats a worksheet that I believe Gary developed.



Basic question... sorry.... but how to I get the charting data up. I have read the User Guide and talks about the Betting Assistant... I thought I was using the betting assisstant but can see no reference to the charts?

Click the selection you wish to see the chart for. You can change the style of chart under Options>Chart preferences.

[TotalPyro]

Thanks Graham
... and yet another question.... I what the horse to appear in Excel in odds orderp - BACK first...
I have click the appropriate BACK first buttn in Betting Assistant but this has meant that the horses appear in the same order in Excel????