Hello! I’m trying to use Google Sheets to track my stocks and it works perfectly for the UK ones cause theres no conversion in currency… but for the US stocks in $ I can’t work out how Freetrade are getting the value back into £??
When I do the conversion using the live exchange rate my £ value is always out by a little bit so it isn’t reflecting my portfolio correctly.
I know that theres a 0.45% charge on US stocks so I guess my question is how are freetrade using this value? Is it a fixed live thing that is added onto the live exchange rate? or is it taken at time of purchase?
EA is at $141.56
The exchange rate is 0.7906 USD to GBP
So therefore EA is at £111.92 in
now I haven’t added the 0.45% cause I don’t know were it goes?
I own 1.0283 shares and market value of my stock below
Google Sheets - £115.09
Freetrade - £115.11
I know it’s not a delay either because the UK stocks show correctly?