Pulling Historical Exchange Rates

Copper Contributor

Hi,

Excel has the function to bring in Exchange Rates "live" with a circa 15 minutes delay, which works fine; however, does anybody know how to cause Excel to being in exchange rates by dates, so that I can create a list of USD/GBP Close Rates which automatically update?

Thanks and Kind Regards,

B.

9 Replies

@WOODBR_1 

Why don't

=STOCKHISTORY("gbp/usd", TODAY()-30, TODAY(),0,1,0,1)

work?

@Sergei Baklan 

 

Brilliant! Thank you, that works perfectly.

@WOODBR_1 , you are welcome

Excellent! Thanks a ton!
Even this variation works
=STOCKHISTORY("USD/GBP",DATE(2019,07,24),,,0,1)
Thanks a lot Sergei, brilliant!!!

@yunussirin , you are welcome

@WOODBR_1 Excellent knowledge, thank you Sergei, you have saved lots of time

@OmerAyan , @Sergei Baklan 

I am trying to get USD to EURO for a particular date.

The date is in 'date' format.  Can you help me out, please?

 

Thanks in advance.

Hi @ingstephenmallia,
I guess, what you need is to type a date between double quotes, i.e. "19/03/2024" or to reference to a date in another cell.

 

Best Regards :)

 

Zrzut ekranu 2024-03-20 230442.png

Zrzut ekranu 2024-03-20 230840.png