What's the easiest free way to get an approximate daily FX rate in the current version of Excel (Office 365 / Feb 2019).
I'm not interested in historical data, I just want the last known day rate from currency X to currency Y, and have that auto refresh only once on opening the document.
There used to be some VBA that could extract the data from some finance sites, but I can't find any that still work.
One possible solution is openexchangerates.org but how would I use their API in Excel?
The macro from Matteo NNZ is really nice :)
As well as it is possible by using Data -> From web (insert the link of website with table and select the table). After then the excel will automatically gathers information from website. In order to refresh the informations You need to select cell in new table and click the Query tab -> Refresh.
For refreshing everytime when you open Your workbook just look on the right side of Your sheet and You will see Your table under Queries and Connections list. Hit rigt mouse button on proper table -> properties and select "Refresh data when opening the file". You can add the timer to refresh data e.g. every one minute :)
In my case I use link : https://www.x-rates.com/table/?from=USD&amount=1
Click ok save workbook and it is done.
Examples:
1) properties for refreshing: https://i.sstatic.net/GRTsM.png
2) information about table https://i.sstatic.net/7Odrh.png - here You have currency from around the world :)
