We made an excel worksheet I thought we'd share. It is used to confirm the running portfolio equity from a list of orders.

To use it -- simply copy the trades output from your backtest into the first excel columns. It will then automatically update the running portfolio equity. Be sure to delete the other example trades in the file first - but don't delete the formulas!

You can download it here.

(PS: We're currently using a portfolio averaging system for calculation of equity and order fill prices but have been requested to upgrade to a FIFO order system. This is on the to do list for 2014)

Author