Skip to main content
J
jcaruso1-Visitor
1-Visitor
January 2, 2012
Solved

Foreign Exchange Currencies in MathCad

  • January 2, 2012
  • 2 replies
  • 8887 views

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?

Best answer by ValeryOchkov

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

2 replies

V
VladimirN24-Ruby III
24-Ruby III
January 2, 2012

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

J
jcaruso1-VisitorAuthor
1-Visitor
January 2, 2012

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.

J
jcaruso1-VisitorAuthor
1-Visitor
January 2, 2012

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.

V
ValeryOchkov24-Ruby IV
24-Ruby IV
January 3, 2012

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

J
jcaruso1-VisitorAuthor
1-Visitor
January 3, 2012

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

Terms & ConditionsAccessibility statement