Hiya everyone - newbie Freetrade investor here. I’ve put together an excel sheet using the stocks rich data type to try and keep track of my portfolio. I just cannot, however, seem to quite match the £ value displayed on the portfolio page.

I’ve triple checked that all the calculations work out to the current value of each share and the calculated value for each position held is spot on in excel i.e. it matches with Freetrade perfectly.

But when I work out the total current value of my portfolio minus the total cost of those shares it does not give me the value that is shown on the portfolio page (the Up by £xx since you began investing line). According to my sheet, the total value of my portfolio is up by is £3,58 but according to Freetrade it is £7,87.

I don’t know why there is a discrepancy between the two and it is driving me nuts. I know it isn’t a large amount but I want to iron out any bugs in my calculations so that once I have more invested it doesn’t show correspondingly huge differences.

Any comments and tips are appreciated, thank you!