Get currency exchange rates from Bloomberg Open API

[vbdbcoder]

Has any one tried to use Bloomberg Open API to get the currency exchange rates from their web site and populate to Accpac? My client has concern over the Accpac default GETRATE.avb, which pulls currency exchange rates from "

http://www.oanda.com/currency/historical-rates".

http://www.openbloomberg.com/open-api/

http://www.bloomberg.com/markets/currencies/cross-rates/

I am experiencing technical difficulties with their APIs.

Thanks in advance.

 

[ettienne]

I've used other websites for rates, not Bloomberg. The challenge is in getting the rates from the site, once that is done the rest is easy. I don't use the GETRATE macro (though I'm sure it's usable), I just prefer to do my own thing.

 

[vbdbcoder]

What other websites would you recommand?

 

[ettienne]

None...
I go with what my clients want to use, mostly their own bank. Some banks are friendly and allow you to download the rates without a problem, other banks want to charge you for the service. With the banks that allow a download I pull the rates directly from the website, with other banks I have the client download the rates to a file and then import the file.

 

[ettienne]

OK here's something I'm working on right now, pulling Euro rates for a Netherlands company from a Dutch website.
I use a URL and feed it the right dates and save the info to a text file, then process the text file - that's it in a nutshell.

Here's the URL:

http://www.statistics.dnb.nl/en/fin...=d&begin=20120101&end=20121128&s=1 2 4.10 5.1

You can see the dates after [begin=] and [end=].
The other parts specify the currencies I want to pull, they happen to be USD, JPY, GBP & HKR.

Each website is different, they do not always make it easy but this one turned out to be very easy.
If you use Chrome then you can right-click and select Inspect Element and start digging.

Watch this short video for some clues on how to pull the data in VBA:

http://www.youtube.com/watch?v=7sZRcaaAVbg