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...
On this page of the site you can watch the video online Excel Live Currency Exchange Rate Using Web Query with a duration of hours minute second in good quality, which was uploaded by the user SyntaxByte 31 May 2020, share the link with friends and acquaintances, this video has already been watched 10,349 times on youtube and it was liked by 118 viewers. Enjoy your viewing!