InvestCEO TradeLog "Rate of Return" calulation needed

Perhaps Kyle's trade log didn't have this formula or I deleted somehow, but my column AA "Rate of Return" does not have a calulcation in the field. This calculation would need to factor in if the trade is a long or short position, AND the number of contracts, AND if you scaled out of the position with orders in the Close #2 and Close #3 columns. I am sure if i sat down and thought hard enough I could figure it out, but I was hoping someone here already had that Rate of Return calculation mastered in their own sheet. If so, please share.

8 comments