I can’t see the option for the BETA website version aswell… tried on a fresh icognito page aswell but still can’t see any option… Can you guys confirm at the moment this is only on mobile? (it works there)
Good information thanks for sharing
Im v happy with the new export feature. Any tips how to import the csv file into Yahoo Finance or some other preferably low cost or free portfolio management system? I need to track my profit/loss for tax reporting. I’m not IT-savvy🥺
thanks for adding the ticker column. It would be awesome if we algo got some columns with pie data (if the order what from a rebalance, or not from a pie…)
How did you sort everything? When I export to Microsoft office I get a huge mess.
Where can I find the download data from the website? I can only see this option on my iPhone. Thanks
It’s not yet available on desktop site. But you can do things like: download on phone, open with Google sheets app, save to Google Drive cloud storage, and then open from there on desktop.
Anyone have much luck parsing the data into useful pivot tables and charts in google sheets?
So far I’ve managed to pull current stock prices using:
and apply currency conversions using:
=GOOGLEFINANCE(“Currency:USDGBP”) (for example)
The result of which allows me to pull together a simple graph showing current return on my investments;
Note: I’ve intentionally obscured the graph above to not reveal all of my investments and returns
Couple of significant limitations/challenges I’ve come across so far are more related to google sheets than anything else:
- Google sheets doesn’t seem to recognise GBX as a currency, so you need to build in manual checks for this currency and apply a conversion
- The currency and value that Google Sheets lists for some stocks doesn’t seem to match Trading212. Maybe someone with more investment experience can shed some light on this. For example, Renault (RNO) is listed at ~33 euro per share on Trading212, but when you use =GOOGLEFINANCE(“RNO”,“price”) its listed as 14.5GBX.
I think google sheets can pull historic stock prices, so my next project is to explore displaying return values over time.
An area I’m struggling with is on sold stocks. Because of how the data is displayed in the CSV, the default output when you try to take into account both buys and sells doesn’t quite work.
For example, I buy £10 worth of stock, then sell it for £8. Its difficult to extrapolate from these two values that you’ve lost £2. For the calculation to lead to negative £2, you would need to consider the £10 as negative and the £8 as positive. But doing this leads to all of your bought stocks counting negatively towards your portfolio value. Still trying to figure this out…
This stock trades on Paris exchange.
You can use IF to distinguish Buy and sell.
=IF(a1==“Market buy” || a1==“Limit buy” , f1, - f1)
Ah I see, thanks! In that case, I have a request for the CSV to include the exchange that the trade was completed on (@George). So that this can be factored in when looking up current stock prices using the =GOOGLEFINANCE(“ticker”) formula.
That bit I can do, what I don’t understand is how to get from that to a value that shows whether you have gained or lost for that particular stock.
I suggest you create a lookup table with a column of tickers against a column of Google reference names for all the stocks you follow. Then something like
=VLOOKUP(A1, A200:B300, 2, FALSE)
Try the function SUMIF to sum cost of purchases and sum proceeds of sales.
I can’t see the option on how to do this on the web app? Legacy or new. Is this ready yet or am I just overlooking the setting?
Quick update. I’ve got to the stage where I can automatically show percentage change in value over time for each of the stocks I own (see below for example);
Next step is to tie this in with the purchase and sell dates/values from the exported CSV file. Hoping I can get to the stage where I have a single stacked chart showcasing the value of my portfolio over time while easily revealing the stocks having the greatest and weakest impact.
Yeah, that’s what I’m aiming for. But it gets super complicated (unless I’m missing something obvious).
- you buy 2 stocks for £20 (£10 each)
- next day they drop in value to £5 each
- you sell 1 of them for £5 (making a loss of £5 on that 1 stock)
- you’re left with 1 stock worth £5 that you paid £10 for, plus you’re £5 out of pocket, so you’re down £10 overall
I don’t think a simple sum of the purchases (£20) and sales (£5) can give you the full picture, the formula needs to consider the stock value and consider both realised gains and unrealised gains.
I think I’m going to be wrestling with this for a while to figure out how to meaningfully represent the value of my portfolio within google sheets (and don’t get me started on trying to factor dividends into the whole thing haha).
I also posted on the wallmine thread, as its getting too fidgety to setup. The issue is more on the Wallmine side, than the data content from the 212 extract.
I am going to attempt finishing something along the lines of the below next week in google sheets with the new 212 export:
- Tab 1: 212 import
- Tab 2: Table of all the individual stocks ever held, current position, first purchase date, last purchase date.
- Tab 3: A download of all the prices needed from Tab 2 to value securities between required dates. It might need a lock in/reload function to remove formula to speed up spreadsheet.
- Tab 4: A breakdown of all units held per stock on a day by day basis.
- Tab 5: A breakdown of the bookcost of each stock held per day (Purchase less sales less dividends).
- Tab 6: A breakdown of the current valuation of each stock.
- Tab 7: tab 6 less 5 figures.
- Tab 8: Graph of performance summary over time - Total Return / unrealised / realised / dividends to date.
- Tab 9: Ability to change filter to view all google finance stock history information.
Tabs 2 to 8 should auto update.
I will look to include a means to compare against 5 benchmarks potentially as well.
I’m not sure if it will ever be simple to break down performance by ‘pies’, especially if the same stock is held over multiple pies when you import your trading history.
If anyone is interested, or has some ideas how to improve before I start, feel free to give me a PM.