Converting from world currencies to dollars on the fly...

DeVore

I am working with a company who need to do a daily(?) conversion from just about any world currency to dollars and need a feed of exchange rates to do it with.

I've no idea where to start and wondered if anyone here had done this before?
My first thought is that somewhere there must be an XML feed of exchange rates... I grab that and parse it and then run a SQL script to recalce everything (or if I'm very clever, use a trigger )

But can anyone point me in the direction of such a feed? Even if it has to be paid for...

DeV.

Gordon

I'm not sure if this is what you need but you can glean some sort of info from it I'm sure. link

I'm using it on a php site to simply display current currencies. It takes a feed from the bank of Canada's website and does stuff to it.. for want of a better term.

You may be able, at least, to use this to connect to the csv file that thebank of Canada output. BOC site - csv file

JazzyJ

The links below provide XML feeds. They are subscription services.

http://www.oanda.com/products/fxml/index.shtml

http://www.xe.com/dfs/


The following page also lists a bunch of free public feeds (daily) and the two services above:

http://www.currencysystem.com/currencyserver/feeds/

Evil Phil

I'd suggest http://www.xe.com/dfs/ too

Oh, and I'm watching you DeVore, I'm watching you with an itchy banning finger ....

ButcherOfNog

Dev, some Banks provide external facing web services that provide uptodate currency rates.....not sure which one but I had this conversation with some folk who were using this about a month ago....I am pretty certain it was Fortis Bank (or some other big european bank) that provided them. Not sure if it was a free service or subscription based (think it was free) but external 3rd party software was getting the exchange rate info from it.

And don't use triggers

Nog

oh and the software was german, so the info you are looking for might also be in german

DeVore

Evil Phil wrote:

I'd suggest http://www.xe.com/dfs/ too

Oh, and I'm watching you DeVore, I'm watching you with an itchy banning finger ....

Have I done something wrong? I hate it when I break charters (though I did read this one!)

Anyway, if you ban me I'll run to feedback and scream blue murder about my rights and THEN YOU'LL BE SORRY YOU FASCIST MODERATOR!!!!

DeV.
ps: thanks for the links, I knew of XE.com but didnt realise they did a daily feed... thats just what I'm looking for.

damnyanks

If you are looking for something mroe up to date reuters / bloomberg provide market data inc. fx rates. Will probably cost a lot more though.