Create A Live Currency Converter In Excel

[@MuarifMuzammil]

You are the saviour of many. Thanks for this video.

[@TheTechTrain]

Thank you! You're very welcome!

[@travisroark8773]

Thank you for the video. Nice, simple and works great. Have a blessed and wonderful day

[@MChinwala]

You are explaining the steps to do things very nicely. Thank you very much for uploading great videos. Greatly appreciated.

[@TheTechTrain]

You're very welcome!

[@juanctejedaperez]

this is a great tutorial thanks! but I havent been able to use it bc the mac version (using updated excel 365 for mac) seems to have the very same button (from web) but it won't open any box where to insert the link... any idea on why it wouldn't work on excel for mac or whether anyone has found the same predicament as I had? once again, thanks for your tutorial. JC

[@JB-xh3gr]

Hi Tech Train, thank you for the perfectly explained video. Please, may you advise how we can create a table with formula, that allows the previous currency conversions to remain the unchanged and only new and future currency conversions to be updated. For example, if on 22/03/2021 I've recorded £1 = $1.50 and today £1 = $1.30, I would like my table to only change todays value and leave yesterdays as it was? Many thanks

[@darrellmartinquinn6605]

Thanks mate! I need it right tmr for my project!

[@darrellmartinquinn6605]

I also got another great short one on VANNA EXCEL. Both solve my problem.

[@mikhailtsypan9193]

You have an amazing heart of a teacher! It's was a delight to sit through the whole 7:49 of the video! Thank you! by the way, is this possible in the Google Sheets? I can't seem to figure it out there:(

[@TheTechTrain]

I'm not sure about Google Sheets - I'll have a look into that.

[@mikhailtsypan9193]

@@TheTechTrain no worries! After further look into it, I’ve managed to get in done in Google sheets:)

[@TrottiersFishingTips]

i keep getting a #value error, any idea?

[@recepalici6552]

Cheers mate. You helped me complete my coursework

[@TheTechTrain]

I'm so glad! Good luck with your coursework.

[@Exonic]

Thank you for this Video. Very helpful

[@TheTechTrain]

I'm so glad!

[@telljansiddiqi]

Amazing ..............you are diff and your videos are valuable THANK YOU

[@saint4rmheaven]

Hi Tech Train The currency data is loading as text type and therefore showing a Value Error when doing conversions. How can I fix this?

[@Siddddd]

Thank you so much. Just wanted to ask one thing, how do I manually refresh it?

[@Meleny95]

hi, I have a table with multiple items in need of currency conversion. Some of a currency of the same date, and some of other dates. (for instance, several items bought on same day with different prices in need of conversion, and other items bought on a different day, all varrying in prices) I have made two sheets one with currencies pullled from the net, the other with item names, prices, and spaces for conversion beside each. Is there a way of doing multiple silmutaniously? or a pre-set? or is it smth to be done one by one?

[@MarisolRamos-1971]

Muchas gracias. Feliz año nuevo

[@medoleader91]

Thanks so much for this tutorial it was so helpful ... is there a possibility to make it vice-versa which means i can enter UK to be converted to US and also enter US to be converted to UK in the same cells?

[@Vitor108]

Hello, I have the same issue as many others here, with the error "#value!". The formula is correct and everything looks exactly like in your video. I notice that if I manually change the value in the table (from the website) the formula works but as soon as I "refresh" the table the formula goes back to the error... I don't understand what's wrong with it if you could help it would be very kind of you. Thank you :) PS: I just found the problem! The table shows the number as for example 0.18548 if I change the dot "." to a comma "," then it works, but again as soon as the table is refreshed the new data will appear with the dot instead of the comma, do you know any way around it?

[@Vitor108]

kzbin.info/www/bejne/q4i4oWWll65sgrc problem is sorted with this video. Still want to thank you for your simple, yet powerful tutorial, GREAT JOB!

[@whiteboardmarketing1979]

Excellent Tutorial! :-)

[@AhmadSohailWahab]

I have a BANK statement and have a bunch of dates in it with my spendings, the spendings are all in lira. All i wanna do is to see what are the equivalent of those spendings in USD. In other words I want to get the currency exchange rate for all the specific dates provided on the bank statement so as to multiply them with the amount of TRY spent on that specific date to see how much was spent in USD.

[@qba269]

Great tutorial! thanks

[@geirwulff5781]

Excellent, How do you convert these data to numbers?

[@TheTechTrain]

Do you mean how to format the numbers as currency? Just highlight the cells, go to Format Cells at the top and then choose the currency option, and change the symbol to the one appropriate.

[@geirwulff5781]

@@TheTechTrain Excuse me for being unclear. The number i get from the import, doesn't work in my calculations, I only get: #VALUE! I tried to format to numbers and even multiply the cell with "1" On my excel I need to put " , " before decimals. Do you know how to fix this problem?

[@usynnstradler]

how do you make it update live?

[@TheTechTrain]

It does that automatically. Every time you enter a value, it will access the online currency rates and do the calculation using the latest data. If you press F9 it will also do an update on data already entered.

[@vinceskinner9357]

Thank you very much

[@luyao5534]

how come I don't have that button

[@MrKristian1974]

This doesn't work if your on a Mac

[@pixelfrenzy]

Right, the From Web button isn't there. Typical Microsoft.

[@pixelfrenzy]

Try over here, it worked for me: kzbin.info/www/bejne/hqbUh6KMg7x5aJI

[@omar-revision9936]

Thanks for this, wasted 10 minutes trying to find it, saved me wasting more time.

[@CarlosCastillo04]

Hello! thank you for this video! I am trying to do this, but the formula is not working for me, coming out as a value of 0,00 for every calculation

[@TheTechTrain]

Difficult to know what the cause is without seeing the spreadsheet.

[@mickeyg100]

Hi - when I try to load the data (also from floatrates) it doesn't bring up the table of data on a new worksheet but a table with column headings like title, description, xmllink, etc. The 'Navigator' box that appears in your tutorial doesn't pop up for me, allowing me to select 'Table 0' in the way you do. Any ideas how to fix? I'm using Microsoft Office Home and Student 2019. Thank you!

[@alielgazar5276]

bro did you find an answer for this

[@tamerewimer6483]

nice and teady

[@neiltristanyabut]

floatrates doesn't have all currencies, for example btn

[@jirjeesal-shammaa8246]

Thanks

[@aljlogistics5823]

in my enhanced version, i give user option to select any currency and covert it , in this you can only select usd value to get from pound,

[@jannettehibbert1953]

Do you have the link to the enhanced version please I cannot find it.

[@syahminkamarudin6602]

how to make currency exchange daily updated?

[@henkvinck1809]

Thank you so much for this great video and the sublime explanation. However, I have a problem I am not getting a normal currency indication I will give an example. ₺8.623.242 These are Turkish lira or so the swiss francs CHF 1,075,516 looks like in the converted version. This is the conversion rate from euro to currency as I video you. The turkish lira should indicate this ₺ 862.32 CHF 107.55 and that does not work, you have a solution for that. greetings Henk

[@oneliewijerupa5403]

How to refresh the currency rates?

[@TheTechTrain]

The spreadsheet uses live online currency rates, so whenever you open the spreadsheet it pulls the live rates from the web and uses the most up to date exchange rates for the calculations.

[@UniqueSoulSA]

I keep on getting a #ValueError if I try to put any calculations

[@TheTechTrain]

That means your formula is trying to do a calculation with a cell that contains data that isn't valid - such as trying to add two cells, one of which contains a word rather than a numeric value.

[@johnbang66]

nope. dont work

[@TheTechTrain]

It definitely does work. You've probably just made a coding error. Don't worry, everyone makes mistakes when coding! If you want to describe the problem on here you'll probably get some help.

[@hobzyx3184]

Keep getting script errors

[@TheTechTrain]

Without more information I'm afraid it's difficult for me to guess what the problem might be.

[@alielgazar5276]

Hi - when I try to load the data (also from floatrates) it doesn't bring up the table of data on a new worksheet but a table with column headings like title, description, xmllink, etc. The 'Navigator' box that appears in your tutorial doesn't pop up for me, allowing me to select 'Table 0' in the way you do. Any ideas how to fix? I'm using Microsoft Office Home and Student 2019. Thank you!

[@faizk5490]

Hi - when I try to load the data (also from floatrates) it doesn't bring up the table of data on a new worksheet but a table with column headings like title, description, xmllink, etc. The 'Navigator' box that appears in your tutorial doesn't pop up for me, allowing me to select 'Table 0' in the way you do. Any ideas how to fix? I'm using Microsoft Office Home and Student 2019. Thank you!

[@alielgazar5276]

bro did you find an answer for that