#1
|
|||
|
|||
Automatically updating currency exchange rate?
Can this be done?
Right now I have two very simple currency conversion formulas, like =SUM(A1:A15)/5,92 and =SUM(A1:A15)/7,46 and then I just added currency symbols via format cells. But this means I would have to constantly check online and manually readjust values. Obviously I would have to make some elaborate checking online function and importing values from a very specifically formatted website so it can recognize which values to check and download, if such an option even exists? |
#2
|
|||
|
|||
Never mind, there is "connection" option under data to import MSN list but my country is not listed in it, so it can't be done if that is the only way.
|
#3
|
||||
|
||||
You could, perhaps, gather the exchange rate data from one of the various sites that publish this info (eg xe.com), but do note that the rates you find on some websites don't specifically reflect a given broker's buying and selling rates.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create automatically updating fields in Word 2010 | tryer | Word | 8 | 01-08-2014 12:39 AM |
Monthly Growth Rate Formula | meggenm | Excel | 2 | 04-22-2013 09:21 PM |
Can you stop Cross References from Updating Automatically? | Welshie82 | Word | 2 | 05-14-2012 02:10 AM |
Formatting Cells for Currency and Accounting | Sparetyme | Excel | 1 | 07-11-2010 01:26 PM |
change currency $ to £ on excel invoice help | deanorx7 | Excel | 3 | 07-08-2008 04:40 AM |