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
MVP

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)

Resources