For my spreadsheet, I’m trying to figure out the formula to calculate what the share price was for a position using just the price paid in my home currency £GBP and the number of shares.
Example, I bought 0.24390069 shares at $279.54. However when I do this:
£49.91 (Price paid in GBP) x $1.3659 (FX rate at the time of purchase) = $68.172069 (price paid in $USD)
$68.172069 / 0.24390069 = $279.51 (rounded up).
Why isn’t it £279.54? I used FX rate, and not the Base FX rate, which I think is correct?
If I do the calculation in reverse, I do get nearer (£49.92).