Hi. I have a spreadsheet with 4 columns related to my trading. The columns are A: Fill Price, B: Current Price, C: Long/Short (I have used 1 or -1 as data) and D: Change.
I want to calculate D being a positive or negative figure.
This will need to work both for the situations where I am going Long, so hopefully B will be greater than A producing a positive figure, and also where I am going Short, so that hopefully B will be less than A in order to produce a positive figure.
I am assuming that C will be required as a "switch", but I can't resolve how to do this.
Thanks
I want to calculate D being a positive or negative figure.
This will need to work both for the situations where I am going Long, so hopefully B will be greater than A producing a positive figure, and also where I am going Short, so that hopefully B will be less than A in order to produce a positive figure.
I am assuming that C will be required as a "switch", but I can't resolve how to do this.
Thanks