Excel- how to create external link with autoupdate

P

P Bajaj

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.
 
A

Allllen

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
 
Top