Calculating Folio Valuations

Based on user feedback, we now value portfolio holdings at the bid price rather than the last price as default. This is because it is a better reflection of the realisable value of the portfolio. This way, there is no disappointment when you come to sell. It's the approach now used by most, if not all, online brokers.

If it's not already showing, you can change the default holdings view to include the Bid Price 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.