Calculating results in Excel

[IV_Trader]

Quote from hans123:

I post my original file. I want to calculate my results based on my position. My position is short (-1). neutral (0) or long (1). When I am short and the result is negative, my trading result should be positive. When I am long and the result is negative I want to subtract it from the total I have at the moment.

Hans

=If( G = "-1" , F * -1)

 

[hopback]

Quote from IV_Trader:

=If( G = "-1" , F * -1)

That's not a complete if,then,else statement

 

[hopback]

take a look at this spread sheet.
is this what you wanted?


I assume that you are back testing a strategy?

Note: on the sheet you posted the position column had little green corner tabs, excel recognized them as text not a number value. I changed them but going forward you will need to make sure they a not entered as numerical text.

 

[hopback]

I was bored...

I made the assumption that Neutral was no trade since in your example the result didn't change.

 

[hopback]

Your welcome

 

[hans123]

I couldn't react earlier, but this is what I was looking for.

Thanks.

Hans