Triggering and Cols V & W

[excelhasey]

In excel my spreadsheet has Col V as Avg Matched Odds and Col W as Matched stake, I have noticed that when my first bet is placed these columns are populated for that particular selection

Now I have noticed that other bets are matched but the values in Col V & W for the subsequent selections remain as zero - Why is this ??

Does using the "CLEAR" trigger clear the values in Col V & W also ?? as I have been using the CLEAR trigger

If so how do I stop Col V & W being reset to zero, yet still use the CLEAR trigger ??

Is there a setting I have missed

Ta all

[excelhasey]

Ah if an InPlay bet gets CANCELLED then Col V & W get reset to zero

Can I avoid this ??