broker statements data pain in the ass to sort

Discussion in 'Data Sets and Feeds' started by RobinHood, Jul 18, 2008.

  1. My brokers statements are all setup in the following pisspot fashion:

    Columns deal time / order type / instrument / amount of contracts / price

    so lets say I start the day by shorting 5 gold futures, I'll get (5) under amount of contracts. If I were to go long at the start of the day I would get "5" without brackets.

    When I cover going short, the next row will be "5", again without the brackets. Copying this into excel will also return "-" instead of brackets.

    Problem is I don't know how to sort this into an entry /exit column. Doing it manually is impossible as I can make a few hundred trades a day. Any solutions?