Excel- how to create external link with autoupdate
 

i am preparing an investment statement with various currencies. I need the
statement to be updated daily in a single home country currency. How do i get
the daily FX rates automatically to reflect revised positions.

Excel- how to create external link with autoupdate
 

use data import external data new we query
with a site like www.oanda.com
or the page of a national bank

import the table you need and put it on a new sheet

refresh it every day

--
Allllen


"P Bajaj" wrote:

i am preparing an investment statement with various currencies. I need the
statement to be updated daily in a single home country currency. How do i get
the daily FX rates automatically to reflect revised positions.