Discussion in 'Trading Software' started by hans123, Feb 25, 2006.
=If( G = "-1" , F * -1)
That's not a complete if,then,else statement
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.
I was bored...
I made the assumption that Neutral was no trade since in your example the result didn't change.
I couldn't react earlier, but this is what I was looking for.
Separate names with a comma.