Order of the MyBets sheet

[Timstertoo]

In which order do bets get placed on the MyBets sheet?

First come first serve or back bets first then lay?

Or maybe unfilled on top and then filled under?

Just wondering as I need to know the exact order I can expect the bets to appear for one of my bots.

Cheers!

[GaryRussell]

I'm afraid they are not guaranteed to appear in any particular order. They are generally in order of bet ref, but not always so it cannot be relied on. I can consider it as a suggestion to enforce an order.

[Lewis]

Just a suggestion - would it not be able to leave the program the way it is and sort them in Excel? or would this mess up the way that BA writes into the Mybets sheet?

[not something I have, or intend trying - just a possible 'messy' workaround]

[Timstertoo]

I'm afraid they are not guaranteed to appear in any particular order. They are generally in order of bet ref, but not always so it cannot be relied on. I can consider it as a suggestion to enforce an order.

Well if I'm the only one who's asked this up till now I'd say it's fair to say no one else is having problems with it.

Maybe someone can tell me how they deal with it?

[throwmeadisc]

I just use the MyBets sheet as a lookup table and then use the Bet Ref as the lookup value with the VLOOKUP formula. Be sure to use the range_lookup value as false as the MyBets sheet is not always in order.

Code: Select all

=VLOOKUP(BetRef,MyBets,3,FALSE)

*BetRef is the Bet Reference that betfair provides.
* MyBets is a named range, or this could equal a range like A1:G5000
*3 is the column of the MyBets table you want to return
* FALSE makes sure the item gets looked up correctly if the bets are not in order


Al