Excel- how to create external link with autoupdate

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Import external data link disappears 1
How to import external data into excel? 2
How do I create an Excel spreadsheet that shows how to save taxes 1
How to use DOUBLE striketrough effect on a font in Excel 1
How do I get an #N/A field to return 0? 2
How do I create a meesage to display when opening Excel 1
How do I automatically send daily email of updated Excel workbook. 1

Top