Perform FOREX or Currency Exchange in Excel using Currency Tool and the STOCKHISTORY Function

This video shows how to convert currencies using Excel and use this in formulas to show live foreign exchange FOREX rates of different countries. This video has two parts: the use of Data Currency Pair tool and the use of STOCKHISTORY function in Microsoft 365 to generate even an entire history of currency close amounts up to the most recent or last close.

[@user-ec9hq6md1f]

hello, thanks for this helpful video, just wondering if the stockhistory formula can use dynamic currencies based on a column like column for currencies (i want to convert all to USD)