Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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

Options
  • 12-12-2006 5:46pm
    #1
    Business & Finance Moderators, Entertainment Moderators Posts: 32,387 Mod ✭✭✭✭


    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.


Comments

  • Registered Users Posts: 35,524 ✭✭✭✭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


  • Registered Users Posts: 683 ✭✭✭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/


  • Registered Users Posts: 7,468 ✭✭✭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 ....


  • Registered Users Posts: 3,316 ✭✭✭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 :)


  • Business & Finance Moderators, Entertainment Moderators Posts: 32,387 Mod ✭✭✭✭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!) :p

    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.


  • Advertisement
  • Registered Users Posts: 4,276 ✭✭✭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.


Advertisement