Calculating results in Excel

Discussion in 'Trading Software' started by hans123, Feb 25, 2006.

  1. =If( G = "-1" , F * -1)
    #11     Feb 26, 2006
  2. hopback


    That's not a complete if,then,else statement
    #12     Feb 26, 2006
  3. 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.
    #13     Feb 26, 2006
  4. hopback


    I was bored...

    I made the assumption that Neutral was no trade since in your example the result didn't change.
    #14     Feb 26, 2006
  5. hopback


    Your welcome
    #15     Mar 1, 2006
  6. hans123


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


    #16     Mar 3, 2006