I’m putting together an Excel sheet to keep track of things. How do I factor in the FX impact on an investment in Excel? Is there an equation or formula that will allow me to see how much (in currency and percentage) my investments are being impacted by the FX exchange?
My Excel sheet so far can automatically keep me up to date with my gain or loss. But I’m not sure how to set it up so it can also factor in the exchange — this is big, since it really does count!
Even if it can’t be automated and it’s really time-consuming, if someone could run me through how to calculate the FX impact on a stock it would be super, mega appreciated.
Your best off inputting the information into a ready made share provider ie marketwatch or webull or similar.
This will allow you to enter exact amounts and then it will automatically work it out for you.
Spreadsheets are fine for start to end tax or profit/loss calculations but pretty useless for day to day observations
Alternatively if you want to stay in Excel, you can download a foreign exchange rate CSV readily online for say the past year, and with the help of an Index/Match formula, work out the FX.
That’s the thing I’m stuck on, not sure how to work out or predict what impact FX will have or has on an investment. Trading212 says it — great! — but how do I get that into Excel and have it update automatically? That’s what I wish I could find the solution to.
Yup! Gotten stock prices from Google already — just types in AAPL, for example, and then they give you a bunch of options for what other info you’re after.
It’s just, I couldn’t find something for FX.
Doesn’t seem to work…
I’ve already converted USD to GBP, but it only offers a simple “this is the equivalent of your amount in GBP” without any mention of FX or taxes etc.