Real-Time Currency Converter in Excel | Multiple Currencies | Web Query & Currency Data Type Methods

In this video I demonstrate two methods for creating a currency converter in Excel; both methods are real-time meaning the exchange rate will automatically remain up-to-date.

The first method will work for you if you have Excel 365 which includes data types. The currency data type allows you to load currency exchange rates that automatically update every five minutes.

The second method uses Power Query to load a table of exchange rates from a web page. This method allows you to set your own refresh frequency.

Table of Contents:

00:00 - Intro
00:25 - Excel 365 Method Using Data Types
04:52 - Using Power Query (Old Excel)
------------------------

[IvanCortinas_ES]

Fantastic tutorial. I think it is a very original topic, not covered in other channels. Thanks for being so innovative Chester.

[Silviu-MihneaVoicu]

Excellent tutorial! Thank you Chester!

[princess_rez]

Great tutorial. I am not very good with excel formulas but I had no problem following this.

[stevedavey]

Excel master! I take my hat off to you Sir!

[sijoneyyan]

The table doesn't seem to be copying the decimal point and the numbers are all huge now.

[RayWhite]

Great! BUT ~ how do you build a foreign currency list for specific foreign currencies you utilize all of the time AND are NOT on the displayed table of top currencies?

[wayneedmondson]

Hi Chester. Awesome! On my Microsoft 365, the Refresh Settings option is not on the menu. Maybe I'll get it in the future. Thanks for sharing this.. very interesting! Thumbs up!!

[goldplaybest]

im having a problem bcs the numbers imported are using points not comma's ( 0.00 i need 0, 00 )

[jacobzak]

Is there any way I can keep track of the exchange rates of a currency on specific dates?

[Kyle-Q]

Really nice! Followed the step exactly but idk why the UNIQUE function is returning number values. Not the letter currencies

[moi]

Beautifull as always! Can I also insert a refreshable table from Web for a website where I have to login to? For instance something like my banking account.

[Crawling_Sloth]

does the variable currency converter need to be in a separate sheet?

[thegunnersrule]

When I drag the formula to other cells, the exchange rate doesn't pull through. Why is that? Am I doing something wrong?

[TheKing-]

I work online where my earnings are in USD which is then converted to EUR and finally I get paid in INR, every Friday How do I calculate that in one go?
Secondly currently INR is steep fall against INR but still I am getting less Euro than previous which is affecting my earnings.
How is that possible?

[syre]

how import one currency for a month ago