How to use MyBets to check for unmatched bets

[Herbie1809]

Hi everyone,

My apologies if this question has already been posted before.

I'd like to use the MyBets worksheet to check if two bets have been matched.

For instance, if I back AnotherNag at price A, then I lay the same horse at price B, how can I use a formula to check if both bets have been matched and filled?

I'm sure its relatively straightforward in VBA but I would prefer to use a formula as they appear more dependable and less bug-ridden- or is that just my attempts at VBA???

So far, I've been using a combination of VLOOKUP, MATCH, and INDEX during various unsuccessful attempts.

Any ideas?



Cheers

[Graham]

Are you just trying to find out whether or not you have a matched back and a matched lay on a given selection? If so a (not very elegant solution) would be to use a COUNTIF formula, referencing conditional formalue in the MyBets Worksheets.

[Herbie1809]

Hi Graham,

Thanks for the reply.

I've tried COUNTIF-but not with a conditional formula.

The hardest part is looking up the name of the selection and checking whether or not it has been matched.

Finding a selection is straightforward. discovering if you have more unmatched bets than matched bets is also quite simple. But accurately checking if a specific bet has matched is very difficult.

Any kind of LOOKUP returns the back bet, which has matched, and not the unmatched LAY bet.

I've also tried using the profit/loss column, but this is calculated on all bets on the field, rather than just that one selction.

I'll keep plugging away. God loves a trier!

[Graham]

ok, i assume you will be happy knowing if you have a matched back and lay on a selection, although i might be wrong. As i say, it is inelegant but COUNTIF will help if i am correct. here goes:

in MyBets, G2, place the following:

=IF(E2="F",IF(F2="B",B2,""),"")

in MyBets, H2, place the following:

=IF(E3="F",IF(F3="L",B3,""),"")

Paste those down

In the worksheet which is logging the market, place the following in Y5

=COUNTIF(MyBets!$G$2:$G$25,A5)

And in Z5:

=COUNTIF(MyBets!$H$2:$H$25,A5)

AGain paste those down

You will then get a 1 in column y for a matched back, and a 1 in column z for a matched lay.

I hope this is useful, let me know how you get on, sorry its not perfect

[Herbie1809]

Cheers Graham,

You've definitely given me something to work on!!!


I'll let you know how it goes,mate.

Well done!