Registered User Joined: 10/16/2005 Posts: 3
|
Hello, I am trying to create a PCF to compare today spread to yesterday one: (L1-H1)/(H-L) The result is a negative number as I expected but the value is strange and I do not get what I want.
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I don't understand the logic of your PCF.
Try this:
ABS(H1>L1)*((H-L)/(H1-L1))
- Craig Here to Help!
|