Connect Mathcad to a Forex Web Service

This Mathcad worksheet automatically downloads historical forex (or foreign exchange rate) rates. It does this with a VBScript component that imports data from a web service. You simply need to specify two currencies (via the three-letter currency codes) and two dates. Currency codes can be found at

Mathcad will then download the closing bid prices for each trading day between the two dates and place the data in a table.

Mathcad Forex ImportThis Forex data can then be analysed in Mathcad. As an example, Bollinger Bands are plotted. These are used by technical traders on the foreign exchange markets to determine when it is appropriate to buy or sell specific currencies.

Mathcad Bollinger BandsNearly all of the movement of exchange rates is between the two Bollinger Bands. When the exchange rate hits the bottom band, it’s likely to rebound upwards, and when the exchange rate hits the top band it’s likely to fall. Traders use this behaviour (along with many other signals) to indicate when to buy or sell specific currencies.

If you’ve enjoyed this Mathcad worksheet, then here’s

If you use or share this Mathcad worksheet, then I would appreciate a link to

Download Mathcad worksheet to connect to a Web Service to download Forex Data

Leave a Reply

Your email address will not be published. Required fields are marked *

What is 4 + 4 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)