cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Foreign Exchange Currencies in MathCad

SOLVED
jcaruso
Newbie

Foreign Exchange Currencies in MathCad

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Foreign Exchange Currencies in MathCad

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

View solution in original post

12 REPLIES 12

Re: Foreign Exchange Currencies in MathCad

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

Re: Foreign Exchange Currencies in MathCad

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.

Re: Foreign Exchange Currencies in MathCad

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.

Re: Foreign Exchange Currencies in MathCad

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).

Re: Foreign Exchange Currencies in MathCad

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.

Re: Foreign Exchange Currencies in MathCad

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

View solution in original post

Re: Foreign Exchange Currencies in MathCad

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

Re: Foreign Exchange Currencies in MathCad

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:

rub.png

Re: Foreign Exchange Currencies in MathCad

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

Bit.png

Re: Foreign Exchange Currencies in MathCad

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!

currency.png

Re: Foreign Exchange Currencies in MathCad

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

Re: Foreign Exchange Currencies in MathCad

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.

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."