Excel Live Currency Exchange Rate Using Web Query



Create a table of live currency pair exchange rates using a web query in excel! This video will show you not only how to get the live exchange rate using the …

source

Excel Live Currency Exchange Rate Using Web Query

Create a table of live currency pair exchange rates using a web query in excel! This video will show you not only how to get the live exchange rate using the currency.com API, but also how to turn that query into a function that can be merged with another query to get the rate for multiple pairs. You can use the resulting rates to convert currency with a VLOOKUP, INDEX-MATCH or other functions.


API: https://currency.com/api
Written tutorial: https://syntaxbytetutorials.com/excel-live-currency-exchange-rate-with-web-query/