Hi all,

I have a sheet (attached) containing foreign exchange data and need to do some calcs.

Sheet is as follows:

Column A: currency symbol

B: Date

C: Time in minutes (each row represents 1 minute)

D: Opening price

E: High price

F: Low price

G: Closing price

Every day at time 00:00hrs (0 in column C) I place orders at the opening price in D, I'll call this entry price.

I then need to check if at any time during the day the price in E went higher than entry price, and if the price in F went lower than entry price.

The higher or lower prices in E and F specifically need to be 14 ticks higher or lower, so if entry price is 0.8500, then 14 ticks higher would be 0.8514, and 14 ticks lower would be 0.8486.

I don't need to count exactly how much higher or lower the price went, only whether the required 14 ticks has been reached or exceeded.

As I said the entry price is at 0 in column C (00:00hrs), and the order remains open until 234500 in C (23:45hrs), if the high and/or low prices have not exceeded 14 ticks by 23:45 then the order would be closed.

After closure at 23:45 the whole process starts again 00:00hrs the next day.

Some dates are missing because the exchange is closed at weekends.

Also I would need some way of recording/signalling for every situation, i.e., some days both high and low will not exceed 14 ticks, some days both will exceed, and some days high may exceed but not low etc..

I think I can sort out the formula's myself but I don't know how to tackle the problem without making it overly complicated.

I just need a push in the right direction...

Thanks!