Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Converting stock purchases made in USD to GBP

Copper Contributor

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?


5 Replies

Hi @DennisG1 


With STOCKHISTORY function:




I'd modify a bit @L z.  formula to take the latest published exchange rate


@L z. 


Thank you!


Thank you!
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.