Apr 23 2021 09:08 AM - last edited on Nov 09 2023 11:10 AM by
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.
Apr 23 2021 12:41 PM
Apr 26 2021 08:44 AM
Dec 22 2022 04:32 AM
Jan 08 2024 09:40 AM
@WOODBR_1 Excellent knowledge, thank you Sergei, you have saved lots of time
Mar 20 2024 01:50 PM
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.
Mar 20 2024 03:12 PM
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 :)