Converting stock purchases made in USD to GBP

[DennisG1]

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?

[#2]

Hi @DennisG1 

With STOCKHISTORY function:

[#3]

@DennisG1 

I'd modify a bit @Lorenzo  formula to take the latest published exchange rate

[#4]

@Lorenzo 

Thank you!

[#5]

Thank you!

[#6]

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.