+ Reply to Thread
Results 1 to 4 of 4

currency rates into spreadsheet cells

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    currency rates into spreadsheet cells

    I am seeking a way to have cells with currency rates automatically update via the internet. I will then reference these cells for other calculations. The rates can be todays or yesterdays, it doesn't have to be too exact. I presently have to manually input the rates each time I use the spreadsheet and it would be great to if it could be automated.

    Attached is a sample spreadsheet. Thanks in advance for any assistance
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: currency rates into spreadsheet cells

    Searching through other posts, I've found discreet weblinks for each exchange rate. However I'm still working on how to get the cells to update with the external info. Sheet attached.

    Edit: also found the MSN Money link in Excel, but it is USD centric, so not a help
    Attached Files Attached Files
    Last edited by Romsky; 07-23-2013 at 06:57 AM.

  3. #3
    Registered User
    Join Date
    09-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: currency rates into spreadsheet cells

    Experimenting further, I've found a way to automatically populate the cells by creating an extra sheet "FXRates" and using the Bloomberg Cross Rates Table http://www.bloomberg.com/markets/cur...s/cross-rates/ and referencing the cells with the needed rates - not elegant, but it works.

    To get this I used:

    Data - From Web - Inserted Link & chose entire page (only possibility) - import - entered in cell A3 on FXRates sheet
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: currency rates into spreadsheet cells

    This still doesn't work. I've got the Bloomberg Cross Rates table going into the second sheet "FX Rates" to cell A3 and then the first sheet "Calc Sheet" has cells that reference the required three cells (using =FXRates!E81 for example).

    It initially works, but on subsequent refreshes of the data, my required cells can move up/down the table a cell or two - it doesn't stay the same.

    Any ideas or help on solving this? I'm just needing the highlighted cells to calculate the rates for GBP/USD, GBP/EUR and GBP/CHF.
    Attached Files Attached Files
    Last edited by Romsky; 07-26-2013 at 11:49 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match up currency exchange rates and calculate
    By zl068565 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2013, 02:46 PM
  2. Pull in Currency Rates
    By robo1991 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2009, 07:09 PM
  3. $ to conversion and currency rates
    By mabel in forum Excel General
    Replies: 2
    Last Post: 08-25-2007, 06:13 AM
  4. currency rates
    By nowfal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2005, 08:05 AM
  5. [SOLVED] How do I import daily currency rates?
    By Sverchok in forum Excel General
    Replies: 2
    Last Post: 02-13-2005, 07:07 AM

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