HomeЛюди и блогиRelated VideosMore From: MJ Tube

How to Add Real Time Currency Converter in Excel Sheet (Calculate Currency & Update)

419 ratings | 121757 views
Add and Calculate All Currencies in Real time in Excel Sheet also update currency.. Click here for more detail... http://www.bsocialshine.com/2016/04/how-to-add-real-time-currency-converter.html Euro, dinar, US dollar, taka, rupees, franc, real, peso, pound, rupiah, rial, yen, shilling, dirham, rupee, riyal, rubie, Saudi riyal, rand, won, lira,
Html code for embedding videos on your blog
Text Comments (61)
Matthew Chapman (1 year ago)
Thanks for this! Worked just fine, it's just what I needed! I'm very glad there's a way to do this by setting up a connection -- I did NOT want to have to use an add-in or something else unless it was absolutely necessary. This is cleaner. I especially like the Refresh ability.
Don Mega (6 days ago)
crashes excel for me. worked only on 5th time. phew... btw having it update every time the file is opened makes it take 10sec to open the file. and even having it "silently" do it once an hour causes excel to freeze for 5sec even with background refresh enabled, with a pretty fast system too. so i ended up setting mine to update only once per 12h.
Deepika Sharma (1 month ago)
Tough
ishak kezzim (1 month ago)
thanks you master
NutHouseProductionz (1 month ago)
does anyone know if you can refresh every second?
An observer (2 months ago)
Nailed it. Fabulous, thank you.
Tsk (3 months ago)
Thanks for this couldn't be more happier. Works brilliantly!!!
Benjamin Feltham (3 months ago)
X-Rates does not have Fiji Dollars. So doesnt work for me.
jagdish kumar (3 months ago)
This is not real time!!!!
Reinner Gregorio (3 months ago)
followed the instructions, but unfortunately, I can't have the rates table only. what I'm getting is the entire page being copied to Excel... tried with Excel 2016, Chrome/Firefox
Tanusha Goswami (4 months ago)
Thank you so much!
Dale Towert (4 months ago)
Excellent - thank you - works perfectly.
Brian Kemp (5 months ago)
That's absolutely brilliant.  Thank you very much.
Wynton Visser (5 months ago)
Love it! Works well for me - Many thanks, MJ.
Yevgeni (5 months ago)
When I try to do this I get, for example: 1.00 USD -> 857475 euro. What did I do wrong?
My exel does not have the Import from web setting. What do I do...
English Rain (6 months ago)
Beautiful! Thank you so much, very easy!
Danny Williams (6 months ago)
What about Zambian Kwacha???
SHUJAT MUNAWAR (7 months ago)
You are Amazing :) Thank you so much Salute ...
Shikhar Varshney (7 months ago)
Thanks for the easy and to the point explanation! Works as I wanted it to.
misomalu (8 months ago)
Fantastic guide! I'll be sure to use this feature for a bunch of other things too.
HI CHAM (8 months ago)
Works, thank you
Ahmet Emre Takcı (8 months ago)
When I try to click on the checkbox to import, there is no checkbox to choose the table. Could you please help me?
Milke workout (8 months ago)
Hello people https://www.bestchange.com/?p=537160 JOIN this site and START earning FREE MONEY ! Just register and you will get $$$$ !!!!
Ankit Chakraborty (8 months ago)
Amazing !!! This is a great stuff
Jose Mascarua (8 months ago)
Excelent
R0tten (9 months ago)
nice tutorial. it just didn't work for me since I need to convert currency for specified dates in a row.
Tsk (3 months ago)
Hi. Did you find an option to update on specific date? Past&present date? CC @ MJ Tube
millerslocal (9 months ago)
Thanks for the video MJ! Just one question - is there a way to set it so that previously populated cells retain the original currency exchange rate they were calculated using at the time of entering the data? I will be filling in the table over the course of a month, and wish the forex rate I use to be relevant to the day on which I did the calculation. So for instance, if the USD/EUR rate was X on Monday, and I entered a line item on Monday which used that rate, I want that rate to remain unchanged when on Friday I return to the table and enter another line item and Friday's rate which is now Y. I want the calculation for the original item entered on Monday at X rate to stay at X rate and not update to Y rate. Is that possible? Thanks in advance.
Excel For Freelancers (7 months ago)
I like your idea. I will take this currency converter to a MUCH higher level in my next video (releasing in 4 days from now) so stay tuned.
Alfred Aidoo (9 months ago)
I love this dude. Thanks a lot
Dimitri Vlachos (11 months ago)
Oh this was exactly what I was looking for. It helped so much! Thank you!
John Collins (1 year ago)
Very good. Works excellent for what I need it for.
Jagshemasher (1 year ago)
Very helpful - thanks
Xiryum (1 year ago)
Better use loquendo...
Chris Laing (1 year ago)
Excellent video. What version of Excel are you running? Does this feature exist in Excel 2011?
Chris Laing (1 year ago)
There is no button called "From Web" where you can paste a URL. Can you suggest how to do it in a previous version? There is a button which says "Import data from a HTML file", but it requires you to open up a file, not paste a weblink.
MJ Tube (1 year ago)
using excel 2016, yah it will on other excel version
Works brilliantly, thank you. I have subscribed for more :)
MJ Tube (1 year ago)
welcome
Nick Zezovski (1 year ago)
Excellent. Works perfectly.
The Accountant (1 year ago)
Thanks for this! Great tool that is going to save me time!
Stealthy Archer (1 year ago)
I understand what to do but instead of it saying "From Web", it says "From HTML" XD and btw you should try and speak more clearly into the mic man
Vettippuzha city (1 year ago)
how can i use this function in google spreadsheet online there is no option(from web) in DATA
same problem here.
recordinginprogress1 (1 year ago)
in getting a #value error
Thomas Stange (1 month ago)
Im gettings the same, any fix?
RealtorGlen.ca (1 year ago)
Thanks for this - used it and it worked very well.
Fhazel Johennesse (1 year ago)
Hi MJ - I tried this. Repeatedly. I am getting the dreaded '#value' error in the destination cell (your cell J3 in the example) for the calculation. When I step through the calculation steps, it seems that the imported currency format cell does not have required format for the calculation. What am i doing wrong?
Fhazel Johennesse (1 year ago)
Tx but I worked it out eventually: the default decimal indicator in my country (South Africa) is a comma. I Changed this to a 'full stop' and the imported numbers are no longer being treated as text. Worked like charm!
MJ Tube (1 year ago)
i think something wrong with linking website to excel sheet
Ekubo Bird (1 year ago)
Thank you very much! Useful information and easy to follow. Exactly what I needed!
TNM (1 year ago)
Hi, I just followed your steps and my desktops a windows 8, does not show after I hit Data the other from web on it help?
HUMAYUN (1 year ago)
I'm preparing Trial balances with different currencies and I have to finalise my report in USD .. please help me
HUMAYUN (1 year ago)
x-rate don't have Uganda Shilling(UGX) and kenya shillings:(
Kenn Magnum (2 years ago)
Using Excel 2016 for Mac - Data -> (No Option for From Web, instead same icon shows "From HTML") -> Gives me a menu to select HTML on my own system by not from an outside site. Am I doing something wrong or is there a work around in Mac version?
same problem
Theta Chirwa (2 years ago)
Euro
Veronica Cervantes (2 years ago)
thank you. My question is how to lock an exchange rate in a daily real time currency converter excel spreadsheet.
MJ Tube (2 years ago)
u mean u dont need to daily real time update? if yes, than dont refresh
Harrison Delfino (2 years ago)
I use MarketXLS for this. It worked great for me.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.