Last price befor the off

[anama]

How can we put in our excel trigger the last price (odds) BEFORE THE OFF??
I ve made an nice trigger, that has made some nice profits till now. I lay some horses at the last price "just" before the off. Till now i have to do it manually.There are 2 problems:
1) i cant know when the market goes exactly in play. I just watch the timer and when it goes negative i type the odds. As you know sometimes there is a delay for the event start and the prices keep on changing!!!
2)i have to be on the computer to do this. I want to make my trigger automate
There are 2 more questions about my trigger. I do not put them now because i have to solve this problem first
Thanks

[joe lively]

Hi Anama, i'm no excel expert but I think you have 2 options. Of course you can't tell when the event is about to start but you can tell when the scheduled off time is and when the event has just started.

1) You could tell your IF function to wait untill D2="00:00:00".
or
2)Tell your IF function to wait for E2="In Play", F2="" . Hopefully you'll catch the event just as it turns in play.

Hope this helps.

[anama]

thx for the answer. I knew that i could do what you say but it is not what i want. I want the LAST odds before the market goes in play.
Yesterday i downloaded a trial version of a program (i dont know if it fair to mention it) which did exactly what i want. But it is expensive and i prefer Betting Assistant interface.
Thx again

[alrodopial]

You have to log the prices at every refresh and then use the last one when the race turns inplay.There are several theats and code discusing this.
Take a look here and also do a search:
http://gruss-software.co.uk/forum/viewtopic.php?t=2512

[anama]

thx a lot. i ll read the post you say and inform you if it ok

[anama]

unfortunately i didnt unterstand what he means. Maybe because i dont know anything about VBA. I dont know where i put all this code....