How To Get Equal Profit On Matched Bets via Guardian

[natbat32]

Hello

I am using a script within my Excel spreadsheet to place upto 7 matched BACK bets at different odds, in the same match, and on the same Under 1.5 goals market. Sometimes its only 2, 3 or 5 BACK bets that are getting matched. Its anything from 1 to 5 BACK bets getting matched.

However, I need to LAY this same market, when LAY odds are at 2.00 to get equal profit on both sides.

Is it possible for Guardian to be used on this same match and same market, so when LAY odds have reached 2.00, it works out how many BACK bets have been matched, and then it can work out how much money is needed to put on the LAY side to split the profit on both sides for equal profit?

Hope that makes sense.

See attached screenshot. Shows that 7 BACK bets have been matched at £700, so it has worked out that I would need £1,184.50 to be placed on the LAY side. I need Guardian to be able to do this, dependant on how many of the BACK bets have been matched.

OR can Excel template do this? Can I write a code/fromulae, so when LAY odds have hit 2.00, I then ask it to input the value 'GREEN' in cell 'L6'? Will this act as the LAY bet and green whatever has been matched evenly for equal profit?


Thank you

[jtrader]

You could just use that formula to make an excel template or .baf file in Guardian :

2nd Stake ( to hedge ) = ( 1st Odds / 2nd Odds ) * 1st Stake

In your case Lay Stake = ( Back Odds / Lay Odds ) * Back Stake

Back Odds = £2369 / £700 = 3.3842

Lay Stake ( to hedge ) = ( 3.3842 / 2 ) * £700 = 1.6921 = £1184.47

You just need to calculate your average Back Odds in excel template or in your .baf file.

[natbat32]

Thanks for getting back to me so quickly

Ok, will see if I can create that.

If not, do you think the other way is to to use the 'Global Command' function?

If I write a code/fromulae, so when LAY odds have hit 2.00, I then ask it to input the value 'GREEN' in cell 'L6'?

Will this act as the LAY bet and green whatever has been matched evenly for equal profit?

Yesterday was the 1st time I ever used the 'Global Command' function, so not 100% if the above can also work?

Thanks again.

[jtrader]

I've never used global command 'GREEN_ALL' on excel spreadsheet ( you could check it in 'Practice Mode'if you wish ),but

you could place that greening bet as an individual lay bet @ 2 odds on selection ( in L9 ,L11, L13 and etc. ) as your back bets

are placed only on one

selection and use 'KEEP_ALL' global command.

[hunbieni]

Can you provide guidance on writing an Excel formula or script that triggers a specific action, such as inputting 'GREEN' in cell 'L6', when LAY odds reach 2.00, and how this could interact with the existing BACK bet data to ensure equal profit distribution?

[jamesedwards]

Can you provide guidance on writing an Excel formula or script that triggers a specific action, such as inputting 'GREEN' in cell 'L6', when LAY odds reach 2.00, and how this could interact with the existing BACK bet data to ensure equal profit distribution?