User Defined Functions

[nigelk]

Hi all,

I've written 3 user defined functions that hopefully will make things a bit easier than keep manually writing formulas in cells.

They are:

1. A 'Minutes til Off' function
2. A 'difference between ticks' function
3. A 'percentage difference between ticks' function

To use them, just goto 'insert,function' and you'll find then under the 'user defined category.

The 'mins til off' just requires you to click on cell B1 and C3

The 'tick difference' needs the list of prices to work.

Any ideas for any more?

Cheers,Nigel

UDF.xls

[MartinJWilliams]

Hi,

I came across this and found it really useful, thankyou!
I'm new to VBA so am just trying to get my head around it. I've used your function to try and compare two columns in a spreadsheet but am getting an error on the rows with a highest traded price of 1000, do you know why this may be? Thanks.

[MartinJWilliams]

... I'm trying to compare BSP and IR High.

[Dallas]

That OP is approaching 14 years old and Nigel hasn't been active on the forum for nearly 5 years now

[MartinJWilliams]

Thanks, it was a bit of a shot in the dark
Got that bit sorted, stuck on the next bit now.