PERSONAL FINANCE SPREADSHEET WITH REAL-TIME CURRENCY CONVERSION

[MadisonStreet]

This may have been addressed before but the forum suggested I open a new topic.

In my day-to-day personal budgeting and financing, I deal with dollars and euros. I would like to create a personal budgeting spreadsheet (preferably Excel but not absolutely necessary) that can convert these currencies in real-time. Any suggestions, tips (sample spreadsheet?) would be greatly appreciated! Thank you.

[londongrad]

A quick look at the internet gave this result:
https://www.excelforum.com/excel-new-users-basics/737065-insert-live-exchange-rate.html

I'm not sure what version of Excel you have but on Office 365 if you do the following
Data Tab
Get Data
From Other Sources
From the Web
Type in http://www.x-rates.com/    into the basic URL box
Click on Table 0
Load

This should have columns for the USD, GBP, EUR and AUD available. A right click on the table gives you a refresh option.