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
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.