Trapping the starting price of the fav at the off?

[Toma]

I don't know if anyone can help me out here but what I want to do is trap and record the SP of the favourite when the market goes "SUSPENDED" i.e just before the off.

I have tried using =IF(E3="In Play",0,MIN(O5:O50)) which works fine and give me the odds of the shortest traded horse for a splt second when the market goes Not In Play (E3) Suspended (F3). What I want to be able to do is save this figure at this point.

The problem is when the market goes "In Play" I obviousley lose the price?

I don't think this can be done in Excel and I maybe need to start lookign at Macros or VB and that scares me !

any advice would be greatly appreciated. I have what I think is a great little system but it takes much manual activity to perform it and it is very repetative. If I can overcome this issue I think I can automate the whole process (as it all revolves around the price of the Fav!!).

Cheers
Guys!

[Toma]

Guys no worries I think I have it sorted.....!

[winabit]

Hi Toma and everyone,

First post from a newbie, lol.

Could you let know how you solved this, please? i've something in mind to use in running, which depends on the favourite's sp.

Thanks for any help.

Regards

[mak]

sp price it will be available if in excel if you tick sp in additional columns (when you log prices in excel)

[winabit]

Thanks for your speedy reply, Mak, very kind. i'll open my eyes wider next time!

Also found this from Osknows...

http://gruss-software.co.uk/forum/viewtopic.php?t=3910&highlight=log+prices

Cheers