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

A Big Thank you!!

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

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

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

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

how import one currency for a month ago

Excellent tutorial! Thank you Chester!

Thanks a lot , Perfect ...

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

thank you!!! it is very helpful!

Can you do it in google sheets??

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

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?

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

thank you sir, very helpful

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.

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

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!!

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