Loading 'Home Team Clean Sheet' markets into Guardian?

[jamesedwards]

Hi all. Is there any efficient way to load only the 'Home Team Clean Sheet' markets into Guardian?

If I use coupon it seems I can only filter markets by 'CLEAN_SHEET' which therefore brings back two markets for each fixture, both the 'Home Team Clean Sheet' and the 'Away Team Clean Sheet' markets. I can go through and manually select the home team from each fixture but it's a faff and a high risk of human error.

clean sheet 1.PNG

clean sheet 2.PNG

For comparison using the 'Win To Nill' markets they are split within the coupon settings into Team A and Team B so it is possible to select only the 'Home Team Win To Nill' easily in this way.

clean sheet 3.PNG

[jamesedwards]

Anyone any idea for any way around this? I thought I had a breakthrough by saving part of the 'match odds' market name as a 'text stored value' and then comparing this against a 'clean sheet' market name using a 'text comparison condition' but there seems to be no way to do this?

Experience tells me there's always a workaround on Bet Angel but this time I really can't find one.

[Dabbla]

You were on the right track, but you needed to extract the names from the clean sheet market. Then compare them as SV not text.
Here’s the file,

Clean Filter.baf

Cleansheetje.PNG

Add a column to guardian, display a SV called (HOME_TEXT) for the market. That will tell you if the clean sheet market is home or away.

[jamesedwards]

You were on the right track, but you needed to extract the names from the clean sheet market. Then compare them as SV not text.
Here’s the file, Clean Filter.baf
Cleansheetje.PNG

Add a column to guardian, display a SV called (HOME_TEXT) for the market. That will tell you if the clean sheet market is home or away.

Thanks so much for taking the time to post this. I hadn't twigged that the market name was "x-team clean sheet", I thought it was "x-team v y-team - x-team clean sheet". I also didn't know that you could compare stored values with stored values when they are text.

Presumably the watch out here would be the very rare occasion when the first word of the home team is the same as the first word of the away team, eg Man City v Man Utd.

Thanks again!

[Dabbla]

Yep ,you beat me to it

I was just thinking; you may get conflicting results if 2 team have a similar name. I have added a rule that should show the (HOME_TEXT) as (conflict). Its not been tested. You may also want to experiment with the file for better results.

Clean Filter 2.baf

[jamesedwards]

Yep ,you beat me to it

I was just thinking; you may get conflicting results if 2 team have a similar name. I have added a rule that should show the (HOME_TEXT) as (conflict). Its not been tested. You may also want to experiment with the file for better results.
Clean Filter 2.baf

Cheers. Already added in a failsafe that ignores the markets when the first word of the home team = the first word of the away team.

Thanks for all your help on this. I was so near yet so far...