Your symbol for Tufton Asset is ‘SHIP.L’. This is the security denoted in USD:
If you want your security in GBX you have to use the symbol ‘SHPP.L’
So you use the quotes in USD but declared it as GBP.
So we need to find out why you use ‘SHIP.L’ and not ‘SHPP.L’ for Tufton Asset.
If I understand you correctly the security was created automatically during the import.
Can you please show us the values for Tufton Asset that you used for the import.
If i try to add Tufton Assets as a new security I get the following options:
Clicking on Portfolio Performance (built-in) I get the following options:
I then selected the different options and as you can see the first entry, the entry for ‘Yahoo SHIP.L’, is wrong. The quote is for USD, but the currency is set to GBP. The other 3 options are correct.
You could try to change the Symbol from SHIP.L to SHPP.L and/or use the ISIN instead of the Symbol and do a Test Import.
What Happens if you delete the transaction currency, Quote and value from the import ?
So I decided to delete the Securities account for Tufton Assets, then recreated it from the SHPP.L listing. I then manually entered Delivery Inbound transactions for each of the 3 accounts:
This time the values are correctly stated in the Statement of Assets. BUT…the total value of the 3 transactions is showing as a capital gain in the Performance report (for the period from May 19th 2026 - the date of the Delivery Inbound transactions:
There are no other transactions for Tufton. Why is this being treated as a capital gain?
What does it show you for Tufton Assets if you click on ‘Assets at start’ and ‘Assets at end’?
Hi @itm
Unfortunately, I don’t have any personal experience with PP’s CSV import, so I can’t offer you a solution on how to get everything right with just one import.
If I were in your situation, I would proceed as follows:
This way, you’ve already set up most of the transactions automatically, which makes things easier, and you’ll also learn some important basics for future transactions in PP.
I wish you the best of luck with PP. Personally, I can’t imagine investing without this tool anymore, but I understand that getting started with a large portfolio might seem daunting. Fortunately, I started using PP right at the beginning of my investing journey about six years ago.
Thank you - that sounds like good advice. That is pretty much the situation that I have stumbled into, with the problematic holdings being deleted and then re-created manually.
It looks as if there is no good solution for the UK Gilts, as there does not seem to be a usable source of quotes for these. I guess I will need to manually update these prices every time I want to get a performance update?
For the T27 Gilt you can use “Table from website” in historic quotes tab of the manually created security and paste the following link:
https://www.ariva.de/GB00B128DH60/kurse/historische-kurse?go=1¤cy=GBP
It will give you always at least the past 30 days of historic quotes. So if you open PP at least once a month, you are good to go. If you need longer time period, you can create a free account with ariva website and download the desired time period as csv and import the missing quotes in PP.
Thanks so much for that. I can use the same approach for all of my UK Gilt holdings by substituting the relevant ISIN in the URL. That’s a great solution!
I see. The quotes from Yahoo are really bad. The best quotes are from Built-In, but they are in GBX, not GBP.
Nevertheless I think you should create the Security for Built-in GBX and then enter the transactions by hand.
Ok I deleted the Tufton Assets account and replaced it with a GBX from the built-in quote provider. I then manually re-entered the Delivery (Inbound) transactions. They are now no longer reported as capital gains.
But…most of my UK gilt holdings which I had similarly deleted and manually re-created the transactions for are now showing as capital gains instead. Plus their value in the Statement of Assets has been multiplied x100,
Here are the manually-entered transactions:
It looks like some sort of pricing/quoting event is occurring which is messing up the valuations and also causing phantom capital gains to appear. When I manually re-entered the UK Gilt transactions I used the “Table on web site” quote option suggested above, with this format of URL: GROSSBRIT. 20/31 (WKN A285BD, ISIN GB00BMGR2809) - Historische Kurse - Aktien, Aktienkurse - ARIVA.DE
It’s beginning to feel alot like whack-a-mole at the moment ;0)
Makes sense to me. Ariva responses % (around 100), you have delivered inbound around 1.
If you have an delivered inbound of 196.712 a 100 instead of 19,671.2 a 1 evereything is OK, I think. They’re just bonds.
To trace what’s happening I deleted one of the UK Gilt holdings (TG27) and associated transactions and re-entered them manually. I chose the built-in quote provider for the security. There were no historical quotes showing when I created the security.
I then changed the Latest Quote and Historical Quotes to “Table on web site”, and used this URL: 1,25% Großbritannien Treasury 17/27 auf Festzins (WKN A1V3HB, ISIN GB00BDRHNP05) - Historische Kurse - Aktien, Aktienkurse - ARIVA.DE
A table of historical quotes appeared, with quotes around 96.00 (so priced in pence/GBX).
I then created a Delivery Inbound, dividing my number of shares by 100 to reflect the pricing in pence rather than pounds:
When I looked at the Statement of Assets (immediately after creating the transaction) the valuation had changed slightly to 35,987.43:
…and there was a capital gain of 37.22:
So following this exact process seems to get me pretty much to where I need to be for my UK Gilts, although I’d be curious to know why the price seems to be recalculated as soon as a new transaction is entered.
I should add that the capital gain didn’t correctly reflect the difference between the valuation when the transaction was entered (35,898.12) and the revaluation on the Statement of Assets (35,987.43). The actual capital gain should have been 89.31, but it was reported as 37.22 in the Performance report
???
