Converting stock purchases made in USD to GBP

Question

I have an Excel spreadsheet with a list of historical stock purchases made in USD on various dates. I would like to convert the purchase amounts to GBP for each of the historical dates. Is there a way to do this in Excel?

lorenzo · Answer

Hi&nbsp;DennisG1&nbsp;&nbsp;With STOCKHISTORY&nbsp;function:&nbsp;

sergeibaklan · Answer

DennisG1&nbsp;
I'd modify a bit&nbsp;Lorenzo&nbsp; formula to take the latest published exchange rate

dennisg1 · Answer

Lorenzo&nbsp;&nbsp;Thank you!&nbsp;

dennisg1 · Answer

Thank you!

dennisg1 · Answer

Hello Sergei,Do you know how I can find the gain or loss in GBP on different share lots purchased in USD? I seem to remember seeing a post by you on this subject. Any help is appreciated.Thank you.

Forum Discussion

Converting stock purchases made in USD to GBP

Share

Resources