Yeah, you need to change the forumulae in those columns by way of an IF function, so it inputs a different formula for short positions. Very simple.
For example in cell G4, you would put "=IF(q4<0, -(f4/c4)-1,(f4/c4-1)). All this is saying is if the value in Q4 is negative i.e short, then use...