Photo Finish

[Spike]

Does anyone have a simple way distinguishing between a market that's in normal running, and one which is betting on a photo finish in excel?

I'm left scratching my head about this at the moment, and would really appreciate a good solution.

[jokerjoe]

No so much a method but a couple of observations:

• There'll probably be only two selections you can back at anything other than 1000.
• The market will have gone from Inplay + Suspended to just Inplay. You'd have to use VBA to look out for that.

[Spike]

Thanks for your thoughts- I'm currently using a method very like your first suggestion but it sometimes filters out close finishes in normal running, which is not what I want.

I've been thinking about a VBA method like the one you mentioned but I was just wondering if anyone had thought of something simpler.

[Captain Sensible]

Have you thought about some VBA code setting a variable to monitor when a market goes inplay then changing it once the market hits suspend to effectively shut down betting on that market.

[GaryRussell]

One thing to be careful of is that the market can sometimes alternate between suspended and not suspended just after going in play. To allow for this don't set your flag until the market has been in play for say 30 seconds.

[Spike]

Thanks to everyone for your suggestions, in the end I got frustrated with putting it all together (in-play+suspend+a race timer) and just bodged it by advancing to the next market as soon as the race goes into suspend and it looks like it's finished based on the odds. Not a great solution I know but it'll do for now untill I can find the motivation to set up something more robust.