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:

 

Sample.png

@DennisG1 

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

image.png

@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.