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.

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

WOODBR_1 Why don't =STOCKHISTORY("gbp/usd", TODAY()-30, TODAY(),0,1,0,1) work?

Thanks a lot Sergei, brilliant!!!

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

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 🙂

Pulling Historical Exchange Rates | Microsoft Community Hub

SergeiBaklan
MVP
Apr 23, 2021
WOODBR_1

Why don't

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

work?
- HarshChutani
  Copper Contributor
  Dec 22, 2022
  Excellent! Thanks a ton!
  Even this variation works
  =STOCKHISTORY("USD/GBP",DATE(2019,07,24),,,0,1)
- WOODBR_1
  Copper Contributor
  Apr 26, 2021
  SergeiBaklan
  
  Brilliant! Thank you, that works perfectly.
  - SergeiBaklan
    MVP
    Apr 26, 2021
    WOODBR_1 , you are welcome
OmerAyan
Copper Contributor
Jan 08, 2024
WOODBR_1 Excellent knowledge, thank you Sergei, you have saved lots of time
- ingstephenmallia
  Copper Contributor
  Mar 20, 2024
  OmerAyan , SergeiBaklan
  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.
  - MarekBernolak
    Copper Contributor
    Mar 20, 2024
    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 🙂

Forum Discussion

Pulling Historical Exchange Rates

Share

Resources