Pulling Historical Exchange Rates

%3CLINGO-SUB%20id%3D%22lingo-sub-2282795%22%20slang%3D%22en-US%22%3EPulling%20Historical%20Exchange%20Rates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282795%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EExcel%20has%20the%20function%20to%20bring%20in%20Exchange%20Rates%20%22live%22%20with%20a%20circa%2015%20minutes%20delay%2C%20which%20works%20fine%3B%20however%2C%20does%20anybody%20know%20how%20to%20cause%20Excel%20to%20being%20in%20exchange%20rates%20by%20dates%2C%20so%20that%20I%20can%20create%20a%20list%20of%20USD%2FGBP%20Close%20Rates%20which%20automatically%20update%3F%3C%2FP%3E%3CP%3EThanks%20and%20Kind%20Regards%2C%3C%2FP%3E%3CP%3EB.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2283072%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20Historical%20Exchange%20Rates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283072%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1035101%22%20target%3D%22_blank%22%3E%40WOODBR_1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhy%20don't%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSTOCKHISTORY(%22gbp%2Fusd%22%2C%20TODAY()-30%2C%20TODAY()%2C0%2C1%2C0%2C1)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Ework%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.

3 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