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