Are there any Metastock users in here?
I've got a formula in Metastock that I want to use in Excel but Metastock uses a function called PREV which I can't replicate in Excel so looking for some help.
Thanks.
Printable View
Are there any Metastock users in here?
I've got a formula in Metastock that I want to use in Excel but Metastock uses a function called PREV which I can't replicate in Excel so looking for some help.
Thanks.
Moved to Gen PC.
as far as i can tell by the function description, it keeps the current cell value if a certain condition is met.
You could probably simply refer to a 2nd hidden cell that is assigned the same value of that cell.
let's say cell a1 has your formula
b1 = a1
the formula in a1 is something along these lines:
iif (c2 > 5, b1 - 1, b1 + 1)
note that my excel is really rusty but that's pretty close to accurate
the formula will be ran in a1 first, and it will reference the value in b1 (your PREV equivalent). Then after a1 updates, b1 will update to the new value of a1. Therefore next time you run a1, b1 is ready to be used as your new PREV again.
I hope that makes sense.
Thanks Lord, I managed to work it out.
you're welcome (hint)