There are several ways to load currency information into Excel. In fact I’ve covered a couple of them in previous videos:
- Create a Live Currency Converter in Excel using Data Types
- Create a Real Time Currency Converter in Excel Using Power Query
Both of the above methods focus on the CURRENT exchange rates but there are times when you need HISTORICAL data.
Whether you’re an Economist, a Banker, a Currency Trader or part of the growing band of small and part-time business owners who get paid in a multitude of currencies, having quick access to historical currency rates is a real timesaver.
The screenshot below is based on an Excel file a friend of mine uses to track bookings and payments for his small sales training business. Column D contains the fee in the currency displayed in column E (so for example 800 USD) but, being based in the UK, he needs to record the GBP value of the fee based on the day he received payment (31 May in this example)
When I introduced my friend to the STOCKHISTORY function, available to Excel 365 users, it was a real game-changer for him. No more searching through exchange rate history websites. All the information was right there in his spreadsheet.
The STOCKHISTORY function can do more than just access historical currency exchange rates. As the name suggests, it also provides you with access to historical information about a company’s share price and volume sold.
Watch the video to learn more about how the STOCKHISTORY function works.