New feature - Export your investing history

Its a standard CSV file format.

You just need to tell excel that the comma is the delimiter - takes 2 seconds.

1 Like

Hi @Jeffrey_C,

Make sure you specify “,” as a delimiter when you import the file in your spreadsheet software.

3 Likes

Hi @George

could you please explain how to workout the avg price for currency pair and non currency pair ?
I have a EU account and I invested in currency as well, so I wanted to use the spreadsheet exported to recalculate the avg price. Thanks for explaining

What are you trying to do? Work out the average local price of the stock in the stocks currency, and your account currency?

Yes I am trying to obtain the avg price that I see on the app. I cannot find the way to make it even the one you said : sumif etc .

Its the balance on tab 6 divided by tab 5 for the same date.

Same should work for your other question on this thread.

When I get time, I will tweak the tracker, as trying to make it work more efficiently.

I can only see N/A error on the spreadsheet you have shared.

Give it a minute - it has to reload the prices from GoogleFinance, when it does that all the formula’s will error out as it recalculates. Patience :slight_smile:

To be fair it is not very clear in your spreadsheet.
I think @George can explain how it gets the avg cost since he works on the pie feature.

The average cost should be the sum of all the money paid for a stock, divided by the total shares purchased.

It becomes more difficult when you sell a security and that is probably why the spreadsheet looks complicated to you.

You need to maintain the running balance each day and then if you had 100 shares at 100, and sell 20, then you are left with 80 shares at 80, even if you sold them at a price of £2 or whatever.

I find something about this problematic. I’ve always thought that the average cost per share should go up if you sell some shares at a loss.

If I buy 100 shares at £2 each, then my investment is £200 and my average cost per share is £2.
If I then sell 20 shares for £1, I am left with 80 shares and a net investment of £180. Which should surely mean my average cost per share is now £2.25. What am I missing?

Well myself I have used:

N of shares
Price per shares

I have made the total of shares, then I took the price per shares and done an avg on the price per share, this should give me my avg cost since it is the price per share itself. So I am not sure how T212 is doing it.

You get different methods -

FIFO
LIFO
AVCO

I use AVerage COst, but for all 3 in your scenario work out the same.

Even though you sold 20 shares for a quid, all you have done is realise a loss of £20, the other shares you still hold, still cost you £2 each, they didn’t become more expensive as the price you paid was the price at the time.

2 Likes

That only works if you bought shares in equal quantities and did not sell.

Yes that’s the way I would do but I can’t get the one I see on the app

If you wouldn’t mind, if you could share trade history for that one stock and what the current figure is, we could work between them. That way would have something to backup, if for whatever reason the numbers in the app were wrong.

Time ISIN Ticker Name No. of shares Price / share Currency (Price / share) Exchange rate Result (EUR) Total (EUR)
25/09/2020 13:34 US88579Y1010 MMM 3M 1.0938659 159.52 USD 1.16329 150
04/11/2020 14:56 US88579Y1010 MMM 3M 0.0031852 161.65 USD 1.1704 0.44
18/11/2020 15:32 US88579Y1010 MMM 3M 0.0061542 173.57 USD 1.18696 0.9
24/11/2020 14:35 US88579Y1010 MMM 3M 0.0035677 176.02 USD 1.18496 0.53
30/11/2020 14:40 US88579Y1010 MMM 3M 1.7093364 175.43 USD 1.19938 250.02
15/12/2020 15:53 US88579Y1010 MMM 3M 0.0035174 172.74 USD 1.21532 0.5
18/12/2020 14:30 US88579Y1010 MMM 3M 1.7551961 177.4 USD 1.22461 254.26
22/12/2020 14:35 US88579Y1010 MMM 3M 0.003632 175 USD 1.2223 0.52

I replied below hope this gonna help

Does this new feature only work for real accounts or even demo ones? I cannot find the CVS data download in the desktop app. Same thing for the android app, even after the update, I can’t find the download button.

Can exported data have price per share not rounded to 2 decimal digits? E.g.
Platform: 100 shares sold 0.2950/share = total 29.50
export: 100 shares sold 0.30/share = total 29.50

1 Like