Help required with time issues using Excel

[davebeddo]

Hello folks,
The past couple of months I have been working on a bit of a side project trying to use Excel to automatically dutch races.
I have been able to make progress but have come across some problems and was wondering if anybody would be able to help.

I have attacted a copy.
My problem is regards timing. I would like the sheet to enter the Dutched bets in fav order at a specified time.

However, if the order changes and a different runner goes higher in the order it fires another bet. This "extra" bet is either making a profitable position less efficient or producing a loss which otherwise would have been a profit.

I have been using If function and thoughtI had cured the problem by reducing refresh to 1 per second and then using =IF(F4=30*(1/24/3600. But once this is put into live it will not always be able to find a match within a 1 second window.

Has anyone had a similar problem or know of a possible solution?

Thanks for the help

[markjacks]

I think this one is a tough one to create but good luck though.

[floydiano7]

First of all sorry for my english.
I'm not sure if I understood your problem correctly, but if it is what I'm thinking you can use the time function.
For ex: =IF(AND(F4<TIME(0,5,0);F4>TIME(0,4,58);all the remaining parameters that you want...
This means that if the time is less then 5 minutes and greather that 4:58 and the other criteria is meet the bets will be triggered.
Best regards.

[davebeddo]

Hi thanks for the replies and apologise for the delay in replying. Will try the time function and see if that solves the problem.
Its very frustrating as it triggers perfectly most of the time.
will see if can solve it and hopefully post the solution.
Cheers guys helpful ad always