Novice excel spread sheets

[jasonc]

Attached are two basic excel files. The first is just basic profit/loss one and the second is to measure your foreign exchange exposure. I hope people like them but they are very basic and i am posting them for feedback on my mistakes and so hopefully people who really know how to use excel can offer input. Thanks

 

[jasonc]

Here is the other file

 

[henderson]

I think your PnL spreadsheet may be wrong......this would be great for a scalper that is flat everyday but with a position overnight the distinction needs to be made with open trade equity and realized PnL. Then if you are holding a position that is subject to +/- carry you must also account for that......not criticizing just trying to help you achieve a finished product for everyone. Please ask if you have questions.