P&L spread sheet

[motorhead]

I want to add a column to my P&L speard sheet, how do I keep it updated when I download latest P&L each time??

the column is to indicate what % of my bank was at stake in every single bet. don't think there's a way to do it automatically.

[motorhead]

up

[MarketTrader]

What have you tried already?

how do I keep it updated when I download latest P&L

I recognise the words but I can't grasp what you are asking?

the column is to indicate what % of my bank was at stake in every single bet

The spreadsheet doesn't contain details of individual matched bets in the market. So I don't think you are going to be able to do this. Unless you calculate this figure as the bets are being placed and record them at that time.

[motorhead]

Unless you calculate this figure as the bets are being placed and record them at that time.

that's exactly what I'd like to do.
only I wanted the new downloaded P&L to overwrite the previous but keeping the added column. but nevermind as when I posted the question I didn't realise I could download only the not 'updated' (the ones without the new column) bets as well without having to update the old P&L.
This way I'm going to have one excel speadsheet each time though, not sure if I can put them all togheter but I think it's possible.

Don't know if it's a little bit clealer now