Calculating Folio Valuations

Portfolio holdings are valued by default at the last traded price, though we also provide a Site Setting that allows valuation at the bid price if preferred.

Please note that while the bid price is a better reflection of the realisable value of the portfolio, there are two issues that can cause confusion intraday. Please watch this brief video to find out more.

The Last Price is added to your portfolio holdings view by default, but you can add the Bid Price instead by clicking edit at the top of the portfolio table:

Once that's done, you can choosing Quotes > Bid from the list of options.

Dealing with foreign currencies

You can enter individual transactions in whatever currency you like. The Main Holdings view, upon entering your portfolio, will display your individual holdings in the currency in which the security trades. As part of your portfolio setup, you will chose a base currency (GBP, USD or EUR). The portfolio summary totals at the top of the portfolio will then be displayed in the base currency you selected. The total valuation sums the last price of every symbol multiplied by the number of shares held in the position including the current value of Cash, converted into the selected portfolio currency at current exchange rates

Trade Matching

Imagine a portfolio has multiple purchase prices for the same security, when it comes to sell a choice must be made against which purchase price to match with.

e.g. Imagine you have bought

  • 100 shares at 100p
  • 100 shares at 150p
  • 100 shares at 200p

And you sell 100 shares at 300p.

Your profit is the difference between the price you paid for the shares and the price received. In the UK for Capital Gains tax purposes, the law changed and all matching is done on a Section 104 'pooled' cost basis which averages the purchase price of all shares. In this case the price for matching would be 150p and the profit would be 100 * (£3-£1.5) = £150.

The alternative method is to calculate on a FIFO (or first in first out basis). In this case the cost price would be 100p, and the profit 100 * (£3-£1) = £200.

We currently match all trades on a first in, first out basis at Stockopedia although in future we may support average cost pooling and LIFO (last in first out) accounting as options. Please do let us know if that is what you would prefer.