+ Reply to Thread
Results 1 to 6 of 6

Insert live exchange rate?

  1. #1
    Registered User
    Join Date
    12-11-2009
    Location
    Luang Prabang, Laos
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    33

    Insert live exchange rate?

    Hi there,

    I work with different currencies in my company, now I would to get an up to date state of the cask book. So I have $250, and 500EUR, now I want a formula (connecting to internet) that automatically multiplies the $250 with the current exchange rate, so I know how much I have in Euros in total.

    I hope you understand...

    thanks!

    ADB
    Last edited by ADB; 07-15-2010 at 05:02 AM.

  2. #2
    Forum Contributor
    Join Date
    07-31-2008
    Location
    Berkshire, UK
    MS-Off Ver
    2003 & 2007
    Posts
    118

    Re: Insert live exchange rate?

    There are a few ways to do this I expect but when I had to do this myself, once I went to Data--> Import External Data --> New Web Query

    I then typed http://www.x-rates.com/ into the browser window and clicked Go.

    Scroll down and click the yellow arrow which is in the top left of the currency table and then click Import.

    Stick it where you want it to go... then you can use this table for formulas and it will automatically update when you refresh using the External data toolbar.

  3. #3
    Registered User
    Join Date
    12-11-2009
    Location
    Luang Prabang, Laos
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    33

    Re: Insert live exchange rate?

    Quote Originally Posted by simjambra View Post
    There are a few ways to do this I expect but when I had to do this myself, once I went to Data--> Import External Data --> New Web Query

    I then typed http://www.x-rates.com/ into the browser window and clicked Go.

    Scroll down and click the yellow arrow which is in the top left of the currency table and then click Import.

    Stick it where you want it to go... then you can use this table for formulas and it will automatically update when you refresh using the External data toolbar.
    Excellent!! Thanks!

  4. #4
    Registered User
    Join Date
    12-06-2011
    Location
    France
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Insert live exchange rate?

    There seems to be a lot of free Apps to get dynamic exchange rates with the new version of Excel (2013).
    I have just used this one:
    http://office.microsoft.com/en-nz/st...edir=0

  5. #5
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Insert live exchange rate?

    Hi, I know that this is a post from some time ago but I am trying to do the same thing and failing to get it to work.

    I have attached what happens when I try to import the currency convertor. I am not sure if I am messing a step.

    I basically need to convert from Rand to US$

    any help will be greatly appreciated.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-26-2013
    Location
    Harare,Zimbabwe
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Insert live exchange rate?

    http://www.wikihow.com/Create-a-Curr...icrosoft-Excel

    I followed the above it works perfectly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1