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
User Defined Functions
-
- Posts: 50
- Joined: Tue May 10, 2022 3:10 pm
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.
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.
You do not have the required permissions to view the files attached to this post.
-
- Posts: 50
- Joined: Tue May 10, 2022 3:10 pm
... I'm trying to compare BSP and IR High.
-
- Posts: 50
- Joined: Tue May 10, 2022 3:10 pm
Thanks, it was a bit of a shot in the dark
Got that bit sorted, stuck on the next bit now.
Got that bit sorted, stuck on the next bit now.