HomeНаука и техникаRelated VideosMore From: ExcelIsFun

Excel Magic Trick #108: Exchange Rate Table From Web Query

68 ratings | 50051 views
See how to do a Currency Web Query, the CHAR function and concatenation to create an Exchange Rate table. CHAR function DOLLAR function VLOOKUP function Currency Web Queries
Html code for embedding videos on your blog
Text Comments (21)
Holly Lor (4 years ago)
Hi, I have the same MS Excel version as you in this tutorial, but when I import the  MSN Currency Rate, it looks nothing like yours. Do I have to sign into MSN or was there a step that needed to be done prior to your video?
Holly Lor (3 years ago)
+Nathalie GEORGIOU there was and probably still is an issue with msn wesite, its not excel. I had to find a different website to import. Try x-rates.com. It's been useful for me
Nathalie GEORGIOU (3 years ago)
+Tall Hat Has anyone answered to that issue? I have the same issue too, so I can't do much after. Thanks!
BJ L (3 years ago)
+Holly Lor Me too :(
pratheesh rajan (4 years ago)
Hello Mark, In the MSN data there are couple of currencies which are not available, eg: Russian Rubel, so is there any way we can add those currencies as well when we generate the report?
Neethu Eby (5 years ago)
Mark, You can add a drop down list in A13 instead of selected currencies. (Data - Validation) List of currencies from MSN (A23 - A66)
Mark Said Camilleri (6 years ago)
Any way to do this in EURO?
ExcelIsFun (6 years ago)
I am not sure. Try posting to the BEST Excel questions site and say you need an Excel web query for Euro: mrexcel [dot] com/forum
ExcelIsFun (6 years ago)
I am not sure where they are on your computer, they are usually in the C drive Microsoft Office folder, then in the Office folder, then in the Queries folder. Use the Browse button to get to it.
ExcelIsFun (6 years ago)
It is the same path in Excel 2010 and 2013; Data ribbon tab, Get External Data Group. All the functions you see here work that same in any of the versions. In any version you may have to Browse for your built in web queries.
ExcelIsFun (7 years ago)
I am glad that the videos is useful!
吴半仙Diverse Link (7 years ago)
This is nice stuff. XE.com sells currency exchange data for commercial use at $540USD to $3,000+++ per year. Poor merchants who bought them...
吴半仙Diverse Link (7 years ago)
This is nice stuff. XE.com sells currency exchange data for commercial use at $540USD to $3,000+++ per year. Poor merchants who bought them...
ExcelIsFun (8 years ago)
some of the early videos (23-89) were deleted and the content was redone in more recent videos. To find all the videos, serach for "excelisfun" and go to the channel link, then watch the auto play video - it shows the best way to find any video you wnat and how to download the workbooks and free books.
iamasif1986 (8 years ago)
I like all of your videos. I am not able to find some videos like Excel Magic Trick 23 to 89 , 109 , 227 , 342 , 464 and 683. Please give me the links if they are available.
ExcelIsFun (8 years ago)
I do not know how to do it. The problem is that most historical stock quote sites require a number of inputs before it spits out the historical prices and I do not know how to get the web query to enter the inputs. Try THE best Excel questions site: mrexcel[dot]com/forum Maybe someone there knows how.
MrStriter (8 years ago)
Hey there, thanks for this video. I'm wondering if it’s possible to get historical exchange rates from the web into Excel. I mean, I want to know what was the exchange rate on mm/dd/yyyy from other currencies into USD. I have 3 columns on my worksheet: one with the date, a second one with the country code of the foreign currency (like EUR, JPY, AUD, GBP) and a third one with the exchange rate. Is there a way to do this? Thanks.
Axel Erwast (8 years ago)
Great video!!
ExcelIsFun (8 years ago)
Woo Hoo!!!!!
ExcelIsFun (8 years ago)
You are welcome. To get the most out of this free resource, search for and watch this video title: excelisfun Search for Excel Videos, Playlists & Download Workbooks
ExcelIsFun (9 years ago)
Thanks! I am glad that you liked the video!

Would you like to comment?

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