Forum Discussion

WOODBR_1's avatar
WOODBR_1
Copper Contributor
Apr 23, 2021

Pulling Historical Exchange Rates

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 th...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 23, 2021

WOODBR_1 

Why don't

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

work?

  • HarshChutani's avatar
    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's avatar
    WOODBR_1
    Copper Contributor
    Apr 26, 2021

    SergeiBaklan 

     

    Brilliant! Thank you, that works perfectly.

      • yunussirin's avatar
        yunussirin
        Copper Contributor
        Jan 17, 2023
        Thanks a lot Sergei, brilliant!!!

Resources