OK I just discovered the option to convert buy/sell transactions to Delivery inbound/outbound transactions. If I use that I don’t get the single large cash entry in the deposit account, which helps. But those four stocks still show inflated market values until I change the quote provider to Yahoo Finance and delete the historical price data.
One other anomaly that I’ve noticed is that one of my holdings (Tufton Assets Ord - symbol SHIP.L) is not having its value reported correctly. It is being over-stated by a factor of about 1.3. I think this is usually because its price is usually quoted in USD on Yahoo Finance, although the Value that I imported in my CSV was in GBP. So the value in my CSV file was £61,307, but the Statement of Assets reports it as 83,244. I hold this asset in 3 securities accounts.
Here is an example of one of the imported transactions. It has the correct share price (0.89 GBP), but for the purpose of the Statement of Assets it seems to be calculating the Market Value by multiplying the share quantity by the USD share price ($1.215), which I guess it has retrieved from Yahoo Finance.
Any idea how I can manage this anomaly?
