Jack o'Clubs
Experienced member
- Messages
- 1,554
- Likes
- 342
This is a bit esoteric, so very grateful in advance for any help offered.
I've got a big works spreadsheet where I record all my trades, P&L etc. All the calculations are very simple, of the ((buy price - sell price) * units bought - comms) type argument. But I noticed the other day that sometimes the calculations 'stick'. That is, if I update a price, the calculated P+L cell doesn't change. The only way to get it to work again is to copy or retype the formula into the cell. It doesn't happen often, but I've noticed it three or four times. How many have I not noticed that are now corrupting the calculation of my totals?
I use this spreadsheet to calculate my tax liabilities, work out how much I'm making, the lot. Now I'm worried because some rogue cells might be throwing the whole lot out. Other than going through it line by line (and in which case I might as well use a bloody paper ledger), does anyone have any tips on how I can either force a proper recalculation, or check which cells are stuck? Just recopying the formulas isn't as simple as it sounds, because I've got all sorts of different instruments in there, which all have different constants. Needless to say, the Microsoft support website had nothing on this...
Thanks in advance.
I've got a big works spreadsheet where I record all my trades, P&L etc. All the calculations are very simple, of the ((buy price - sell price) * units bought - comms) type argument. But I noticed the other day that sometimes the calculations 'stick'. That is, if I update a price, the calculated P+L cell doesn't change. The only way to get it to work again is to copy or retype the formula into the cell. It doesn't happen often, but I've noticed it three or four times. How many have I not noticed that are now corrupting the calculation of my totals?
I use this spreadsheet to calculate my tax liabilities, work out how much I'm making, the lot. Now I'm worried because some rogue cells might be throwing the whole lot out. Other than going through it line by line (and in which case I might as well use a bloody paper ledger), does anyone have any tips on how I can either force a proper recalculation, or check which cells are stuck? Just recopying the formulas isn't as simple as it sounds, because I've got all sorts of different instruments in there, which all have different constants. Needless to say, the Microsoft support website had nothing on this...
Thanks in advance.