Importing web data into Excel 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SteveG - 09 Oct 2007 11:58 GMT

I want to be able to automatically import data from web sites into
Excel 2000.

An example web site would be ...

<http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-
usd.en.html>

or using the link to the XML data file

<http://www.ecb.int/stats/exchange/eurofxref/html/usd.xml>

I have tried using "get external data" but it looks like I would have
to parse the data to make it usable.

What is the best way to do this?

Reply to this Message

Don Guillett - 09 Oct 2007 16:05 GMT

One way to start is from the web site>place your cursor where you can right
click to get an option to import to excel>do so and build your external
query from there. You then use macros or indirect formulas to extract the
desired data. What data are you trying to get? For a client, I recently
created a project that gets 4000 days of trading history for about 50 pairs
of currencies using onada.com
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-gbp.en.html
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-aud.en.html

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I want to be able to automatically import data from web sites into
> Excel 2000.
[quoted text clipped - 12 lines]
>
> What is the best way to do this?

Reply to this Message

SteveG - 10 Oct 2007 07:48 GMT

"place your cursor where you can right click to get an option to
import to excel"

I don't seem to see this! Is it available with XLS 2000? How
dependent am I on the web site design.

For info I want EUR:USD exchange rate and Oil price.

Thanks

Steve

Reply to this Message

Don Guillett - 11 Oct 2007 13:40 GMT

In excel 2003>data>import>new>Type or paste your url>import
http://www.ecb.int/stats/exchange/eurofxref/html/eurofxref-graph-usd.en.html

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> "place your cursor where you can right click to get an option to
> import to excel"
[quoted text clipped - 7 lines]
>
> Steve

Reply to this Message

SteveG - 11 Oct 2007 19:35 GMT

Unfortunately I am blessed with XLS 2000.

Is there an alternative solutions?

Steve

Reply to this Message