Thatās a buggar.
DM me tomorrow night and Iāll try something
Thank you millions!
Happy new year to you and everybody here! <3
Something that may (or may not) interfeer with this is that Iām using the online OneDrive / Office365 Excel not the downloaded software.
Take care all!
Hey again. As otherās said above, Google Sheets might be best as it can do the forex calculations. I havenāt seen this function in any version of Excel Iāve used but would be interested to know if it exists!
You could do something in Excel like the below. The problem here is that you need to manually input the historic fx rates in the āfxā sheet. And also youāre always working one day in arrears, not live.
In your a screenshot also, it seems the āTotal Paidā in the first row should be 2.2 * 99.63 = 219.19
Any chance you can make the Google Sheet public? Itās currently on private. 
Sorry yes its public now.
I fiddled with it for a while. I had to alter it a little, mainly because the FX Impact was added on top of the Gain/Loss, as supposed to having it impact the bottom line. Not sure if this was the best way to do it, but I basically wrapped your original formula ā Net FX Impact * GBP/USD Price on Date Bought ā with brackets and times it by -1, as the FX will always impact negatively my bottom line ā unless of course the company is located in the UK, in that case I wonāt factor in the FX values as there arenāt any.
- =(Q4/O4)*-1
where:
Q4 = Net FX Impact
O4 = GBP/USD Price on Date Bought
Itās around 8 to 20p off ā more accurate when I only bought stock from the same company only once, less accurate when Iāve made multiple investments in the same company over time; in the latter case, I needed to average out the āBuy Price per shareā and the āGBP/USD Price on Date Boughtā which makes my number less accurate.
Thank you @Jobloggs and @obrienciaran for your massive help! I hope 2021 repays you sevenfold for your kindness.
Take care! 
Correct, so your (gain/loss +/- FX impact) will give you your total net profit or loss.
Not exactly! By multiplying by minus 1, in this example, you will turn a positive number into a negative number, meaning you are saying you will lose on FX! This is not the case. FX might work in your favour sometimes and you can gain money!
Take a look at the screenshot here:
Cell M2 = % FX change (FX Change/FX Rate on day bought).
In this case, the pound grew stronger by 2.38%. So 2.38% of your purchase price of Ā£219.19 (cell G2) is Ā£5.22 (cell N2).
This is basically the same calculation I am doing. By doing this, you will get 0.0238 which is the same as my 2.38%. No need to multiply by -1 to make it negative! If āO4 = GBP/USD Price on Date Boughtā is negative, your calculation result will be negative, then you multiplying it by -1 will turn it positive!
Okay, so what Iāve done was:
[ 1 ] Removed the multiply by -1
[ 2 ] Changed the formula for NET P/L from āFX Impact + Gain/Lossā to āGain/Loss - FX Impactā.
I tested no. 2 by changing the GBP/USD Price Today.
When I increase todayās FX, Net P/L goes down, and when I decrease, it goes up.
It looks like it works fine. Does that sound about right?
Yes perfect. The calculation result will naturally be positive or negative so no need to multiply by -1.
Iād stick with FX Impact + Gain/Loss. Here is an example:
FX Impact = Ā£-1.00 (youāve lost 1 pound in FX impact)
Gain/Loss = Ā£100 (youāve gained 100 pound on your stock)
FX Impact + Gain/Loss = Ā£-1.00 + Ā£100 = Ā£99 
Correct!
However:
Gain/Loss - FX Impact = Ā£100 - (-Ā£1.00) = Ā£101 
Incorrect!
note:
The first one is saying +FX Impact + Gain/Loss while the second one is saying +Gain/Loss - FX Impact. You can see in the second one that the FX Impact has become a negative number.
Can you send a full screenshot of your sheet? If it looks correct, it probably is correct!
Cool.
Iām just looking at the first row of Alibaba. 3.3*236.37= 780.02. You have 783.22. Maybe take a look at the formula there? Or is there some extra element included in the calculation?
[ D4 ] =(D5+D6+D7+D8)/4 <āThis is an average of below 4
[ F4 ] =(F5+F6+F7+F8) <āThis is an average of below 3
[ F4 ] I didnāt want to do C4 * D4 since D4 is an average, and not the msot accurate. Instead I used the formula aboveāthought it was more accurate to what I actually paid (as Iāve made multiple investments with different buying prices per share).
Do you think I should just stick with C4 * D4?
Just tried to change to C4 * D4, but Iām getting numbers that are too way off from what Trading 212 are offering me.
I also tried C4*D4 and addition instead of substraction for P/L, but again, numbers are way off.
Ah I see what you mean. Sorry I see now the 3.3 is a rollup of the lines below of 0.3, 1, 1 and 1. I do the same as you did in D and F, I also take averages. Iām sure there is a better way but I feel the results will be negligible!
Looks good though! Seems sensible and logical to me. Well done! I love these kind of tracking tools.
Take a look at Google Sheets as well, a lot of users on this forum recommend it as it can pull in share prices live very easily. I have no experience with it however.
No problem at all!
Happy new year and hopefully we all stay healthy and make some wedge in 2021 
Thatās great. I have a Mac so Microsoft Excel is so poor. I canāt download any stocks Add Inās either as I need a Microsoft account to do so, and letās just say Excel didnāt come with this computer so I had to 'procure it 
'online. Best of luck with Excel though!