Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2012, 08:48 AM
Metamag Metamag is offline Automatically updating currency exchange rate? Windows 7 64bit Automatically updating currency exchange rate? Office 2010 64bit
Novice
Automatically updating currency exchange rate?
 
Join Date: Apr 2011
Posts: 23
Metamag is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 09-04-2012, 01:07 PM
Metamag Metamag is offline Automatically updating currency exchange rate? Windows 7 64bit Automatically updating currency exchange rate? Office 2010 64bit
Novice
Automatically updating currency exchange rate?
 
Join Date: Apr 2011
Posts: 23
Metamag is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 09-07-2012, 09:00 PM
macropod's Avatar
macropod macropod is offline Automatically updating currency exchange rate? Windows 7 64bit Automatically updating currency exchange rate? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

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
Automatically updating currency exchange rate? Monthly Growth Rate Formula meggenm Excel 2 04-22-2013 09:21 PM
Automatically updating currency exchange rate? 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
Automatically updating currency exchange rate? change currency $ to £ on excel invoice help deanorx7 Excel 3 07-08-2008 04:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft