Is anyone else having an issue with their FT portfolio not matching up with their spreadsheets?
I have a transaction sheet. Where the formula is:
Cost - Stamp Duty - Commission = Value
Then I have the following Sheet, using the google finance numbers for change / price / changepct
The cost col is the value col in the above img.
Value: =G2 * D2
P/L: =I2 + M2
M2: =H2 * -1 - (you can barely see the figures but they’re there)
This all has me at -103 but FT is saying im down by ~ -130 - now i am trying to figure out where there extra 30 is coming from.