Getting currency data online?

[jobro]

Is there any way that one can get actual currency status from internet in some way or another?

[mudraker]

The normal method is to use
Data Menu
Import External Data
New Web Query
Follow prompts

You will need to provide a lot more details before you can get a more detailed reply

[jobro]

More information you request. And more you get.

I have a set of 9 currencies that my pricelist can be displayed in. The currencies has a temporary data in their fields that is used for now. But I'd love to fetch the current values of each currency online so that the prrice information can be updated properly. The prices are calculated properly and are used in a reciept system which our customers will use when order stuff. The prices are taking VAT and bundle offers into count, but it is the currency system that I really need to get going.

http://www.speedyshare.com/738163650.html

The currencies is in the Data sheet third field down in the left column.

I had some problems uploading this file via the manager, heence my choice Speedyshare.

[dominicb]

Good morning jobro

First set up a new sheet in your workbook, to hold all the currencies. You will need to use a lookup table or something to grab the currency, but that is beyond the remit of this question.

Now go to Data > Import External Data > New Web Query
Using Ctrl + v paste this into the address bar :
http://moneycentral.msn.com/investor...xcel/rates.asp
and click Go.
Now click Import, select your sheet and start of the range and click OK.
It will take about 5-10 seconds to run the query.
Once set up, to update the information go to Data > Refresh Data.

HTH

DominicB

[dominicb]

It seems that the site software is truncating the web address you need.
Use this instead.

Please Login or Register  to view this content.

DominicB

[jobro]

Nice one. Say can one get the currencies based on say Swedish Krona instead of US Dollars?

[mudraker]

The following site lists exchange rates based on yesterdays date
http://www.x-rates.com/d/SEK/table.html

The following code will preform a webquery on the above url and download the prices to Sheet1

Please Login or Register  to view this content.