Foreign Exchange Currencies in MathCad

[jcaruso]

I am interested in finding a way to process foreign exchange rates in MathCad. Does anyone know of a workaround or add-in that will allow me to declare the value of one currency in terms of another, and then use that value to complete my calculations?

[VladimirN]

Maybe these links can help you:

"Connect Mathcad to a Forex Web Service": http://investexcel.net/550/mathcad-forex-import/

"Download Stock Quotes into Mathcad": http://investexcel.net/408/yahoo-finance-mathcad/

http://mathcadworksheets.blogspot.com/2011_04_01_archive.html

[jcaruso]

I should have stated more clearly my issue; I am not seeking to import current foreign exchange rates, but to work various CFA Level II problems dealing with foreign exchange rates. I need to create units of foreign currency, for example, euros, and define the units in terms of other foreign currencies, for example, dollars. However, MathCad was created with only physical units and there is no unit to which to relate a created unit. It would have been nice if MathCad creators could have included the dollar as a unit --- then I could create the other foreign currency units to do my calculations. If I could just import the unit definitions and not the actual data, I would be ahead of the game.

[jcaruso]

I just found an article that partially addresses the problem at:

http://www.imakenews.com/ptcexpress/e_article001061411.cfm?x=b11,b3jsqcsB,w

It seems that monetary units were only added after MathCad 14. I am using older versions of MathCad.

[VladimirN]

John Caruso wrote:

I just found an article that partially addresses the problem at:

http://www.imakenews.com/ptcexpress/e_article001061411.cfm?x=b11,b3jsqcsB,w

The correct link is: http://www.imakenews.com/ptcexpress/e_article001061411.cfm?x=b11,b3jsqcsB,w

John Caruso wrote:

It seems that monetary units were only added after MathCad 14.

The cost unit was added to Mathcad 14.0 in M010.

John Caruso wrote:

...I am using older versions of MathCad.

Why do not you update your version of Mathcad (last stable release for today - Mathcad 15 M010)? You can download the 30-day trial version of Mathcad 15 here: http://www.ptc.com/products/mathcad/mathcad-15-0/free-trial.htm .

P.S. Has attached to the message Mathcad file from specified above article (from www.imakenews.com).

[jcaruso]

Thank you, Vladmir, for the link and the article; I have saved them. I am aware of the 30-day trial, but I am being frugal with it since there is six more months before the CFA Level II exam in June. Valery's workaround (please see the other answer to my post below) is very interesting and something I will definitely try with my MathCad 11 version. In the future maybe I will be able to purchase MathCad 15.

[ValeryOchkov · Accepted solution]

It seems that monetary units were only added after MathCad 14. I am using older versions of MathCad.

In older versions of Mathcad.

US$ := mole (or cd (candela) if you do not use mole or cd in your sheet)

rub := US$/32.1961 etc

[jcaruso]

This worked perfectly and totally solved the problem --- thank you very much!

[ValeryOchkov]

John Caruso wrote:

This worked perfectly and totally solved the problem --- thank you very much!

You welcome!

One typical calculation with currency units in Mathcad<14:

[ValeryOchkov]

We can use this tip in Mathcad 15 and Mathcad Prime too:

[ValeryOchkov]

One way to the solving this problem - a Reference on the special sheet on PlanetPTC.

I do so for solving the problem of the inserting functions of materials properties in Mathcad-sheets:

see the article - http://twt.mpei.ac.ru/ochkov/WSPHB/Ochkov-Znamensky-Web-Rankine-Eng.html

and the video - http://www.youtube.com/watch?v=Gwv2vfNR-3o

When I have new data of materials properties I change this functions and my customs have only fresh data!

PTC team or some others must automatically change currencies rates in this sheet with name Foreign-Exchange-Currencies.mcdx and all Mathcad-users can have fresh rates!

[jcaruso]

Hello, Valery --- thank you for your post; I will definitely try this and post here my result.

[JohnDoe]

You can get download up-to-date forex rates directly into Mathcad with worksheet: http://investexcel.net/550/mathcad-forex-import/

It uses scriptable components so you can only use it with Mathcad 15.