Novice excel spread sheets

Discussion in 'Risk Management' started by jasonc, Sep 25, 2009.

  1. 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
  2. jasonc


    Here is the other file
  3. 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.