Excel Formula

[delghisallo]

Hi all,

I'm hoping one of the excel wizards on here can help me with a formula or set of commands.

I'm using the BetAngel_1.xls spreadsheet and when the the countdown (cell f3)reaches specific times, I want to be able to copy the back price (G9 etc) at that time to another cell. This would then enable to plat the price at these specific times.

Can anyone help?

Thanks

Gareth

[6thSense]

It might be worth checking out this spreadsheet here - viewtopic.php?f=31&t=7208

[delghisallo]

Thanks 6th Sense, I'm not sure this does what I want....but I may be wrong.

In effect I want to time stamp at different intervals, I dont know the syntax, but I think it should be something like "If countdown=X then copy value from back price cell". I would then copy this formula to various cells and "x" would change to different periods before the off, enabling me to plot the price movement as it either drifts, steams etc as it reachs the off.

Hope this makes sense?

Cheers

Gareth

[LinusP]

This does everything...

viewtopic.php?f=31&t=8896

This is great for recording data and less computing power is needed...

viewtopic.php?f=31&t=2385&hilit=record