CurrCon Currency Converter Manual

The CurrCon Java Applet displays prices on this web page converted with today's exchange rates into your local international currency, e.g. Euros, US dollars, Canadian dollars, British Pounds, Indian Rupees… CurrCon requires Java 1.1 or later, preferably 1.6.0_06 . If you can’t see the prices, of you if just want to learn more about CurrCon, click here for help.

Introduction	Displaying Exchange Rates
Benefits	Updates
Disadvantages	FX Sources
How It Works	Comparison of CurrCon with Oanda FxCommerce
Details of the Applet Tags	Configuring
Examples Using Different Show Parameters	Daily Procedure
Displaying Large Amounts	Costs
Details of the show Parameter	Links
Macros

Introduction

CurrCon stands for Currency Converter.

The currency converter lets you display prices/amounts in the native currency of the visitors to your website. The currency converter automatically selects the default currency to display based on the locale country setting of the browser. It currently supports 169 different currencies.

The Currcon Currency Converter is available with Java source to download.

In other words, Americans automatically see American prices and Canadian see Canadian prices and the DUtch see euros. Viewers can optionally view the prices on the page in another currency. Changing any currency selector on the page instantly changes all the prices on the page to that currency.

Unlike most currency converters, with this one, the user does not enter amounts to be converted. The values come from your web page. All prices on your web pages are instantly displayed in the user’s favourite currency without him having to do anything.

Benefits

It lets you sell to an international market on the web. You quote prices in your native currency, and CurrCon deals with automatically converting all the prices on a page to the user’s favoured currency.
If the user wants, he can flip all the prices on the page instantaneously into any other currency. Unfortunately that setting is not remembered when the user flips to another page. It reverts back to his native currency.
If you write essays that mention amounts of money, you can use CurrCon so that all these amounts are automatically converted to the currency the reader is most familiar with. That ensures your readers fully understand what you are saying.

Disadvantages

The users must have Java installed to view the international prices. Otherwise they will just see the original price.
The user must have his country properly configured in the control panel. Otherwise he will see the default US prices, rather than his local currency, until he selects the currency for the page.

How It Works

Unlike most currency converters, this one requires no server-side support. It does not require JavaScript. However, it does require Java in the user’s browser. Each value displayed is a tiny Java Applet. All that is required is you upload the currcon.jar file to your website. It contains the latest exchange rates in compressed form and also the Java code to do the conversions.

If you change the currency choice anywhere on a page, automatically all the other displays on the page instantly follow suit. Try using the up down arrow to cycle through the possible currencies. Try it below:

$0.00 USD

To get a display like this:

$30.00 USD

You need to code some HTML that looks like this:

<!-- macro CurrCon C$AcN USD 30.00 -->

which expands to:

Normally you might display something simpler such as this:

$30.00 USD

To get that you code some HTML like this:

<!-- macro CurrCon cA USD 30.00 -->

which expands to this:

or even simpler like this:

$30.00 USD

To get that you code some HTML like this:

<!-- macro CurrCon A USD 20.00 -->

which expands to this:

Details of the Applet Tags

Typically to produce a CurrCon display, you need something like this in your HTML:

What is all this gobbledgook? Happily most of it is just boilerplate. You can copy/paste standard templates and just change the amount.

<applet says this is a Java Applet.
archive="currcon.jar" is the name of the file where the exchange rates are kept.
code="com.mindprod.currcon.CurrCon.class" is the name of the Java program that does the conversions.
width="120" tells how much screen width real estate in pixels to use. You must calculate the width based on how many elements you choose to include is your show parameter: c=50 C=30 N=120 A=70 $=10. More on that later.
height="20" The height of the display in pixels.
alt="30.00 USD" What to display if the user does not have Java.
<param name="currency" value="USD"> the currency used to express the base amount, most commonly USD for US Dollars, CAD for Canadian dollars, or EUR for Euros or GBP for British pounds sterling. See this complete list. Every price on the page can be expressed in a different base currency if you want.
<param name="amount" value="30.00"> specifies the amount in some base currency.
<param name="show" value="cA"> Which types of display you want to see: any combination or order of the letters: c C N A $. More on what they mean later.
</applet> marks the end of information needed to generate the display.

Examples Using Different Show Parameters

CurrCon Display Variations
How a $70 USD Price is displayed	Format Letter Combination
$30.00 USD	$AcN
$30.00 USD	$A
$30.00 USD	$Ac
$30.00 USD	c$A
$30.00 USD	C$A
$30.00 USD	$AC
$30.00 USD	A
$30.00 USD	N
$30.00 USD	C
$30.00 USD	c

Displaying Large Amounts

CurrCon Display Of Large Amounts
$1000.00 USD	1000 USD
$1000000.00 USD	1,000,000 one million USD
$1200000.00 USD	1,200,000 1.2 million USD
$10000000.00 USD	10,000,000 10 million USD
$12000000.00 USD	12,000,000 12 million USD
$1000000000.00 USD	1,000,000,000 one billion USD
$12000000000.00 USD	12,000,000,000 12 billion USD
$12300000000.00 USD	12,300,000,000 12.3 billion USD
$199300000.00 USD	19,930,000,000 19.93 billion USD, note rounding
$19000000000.00 USD	19,000,000,000 19 billion USD
$19000000000000.00 USD	19,000,000,000,000 19 trillion USD

Details of the show Parameter

Letter	What it looks like	Width in Pixels	Purpose
c	$0.00 USD	50	Allows user to change the currency for all displays on the page.
C	$0.00 USD	30	Compactly let’s user know what currency is being used with a three-letter abbreviation.
N	$0.00 USD	120	Spells out the currency name being used in easy-to-understand words.
A	$30.00 USD	70	Show the amount, converted into the user’s favoured currency. If there is no A in the show parameter, you need not bother specifying the currency and amount parameters.
$	$30.00 USD	10	Put a lead $/euro symbol etc. on the following amount.

You can use any combination of the letters c C N A $, in any order, leaving any out. You need to add up the widths of each piece an put that in as the width of the entire Applet. Unfortunately currCon can’t add them up for you, since by the time it starts the amount of screen real estate is already fixed. For example:

Yuchh, that’s too Complicated! Macros to the Rescue

Don’t give up yet. There are several possible alternatives to manually coding the <APPLET tags.

If you want, for no extra cost, I will write you an Java Application to help with the show letter symbols. You fill in the blanks to select which elements you want to display, the amount, the currency, and the nesting level and it both shows you what it will look like, and pokes the equivalent HTML <APPLET tags into clipboard where you can paste them into your HTML document. I have not written this HTML generator since no one has asked for it yet. It could have it ready in a day or two.
You can just embed the short form static HTML macros in your HTML and have them expanded for you. It this how I handle them on my own website. You can see the macros I use on the my own website by using view source.
```

```
expands to:
The tricky part in doing it manually is getting the right number of ../../ in the archive jar name, and figuring out the exact width and height.
I run the macro processor on all my files just prior to any upload. I expand the macros, generate an index, compact the HTML, and provide a mirror website via the Replicator. The macro generator stripped down to handle just CurrCon macros is optionally included, but not the Compactor or the Replicator. I have not prepared the stripped down version of the macro generator since no one has asked for it yet. It could have it ready in a day or two at no extra cost.
You could also generate the <APPLET tags with JSP, servlets or ASP. I have not yet written code to do that, but I could work with you on developing it. I have no ASP experience at all, so all I could do in provide you equivalent Java code. You might wonder why bother with CurrCon in that case. Why not just generate the page with the conversions pre-expanded? The advantage of using CurrCon is the user can switch every price on the page with a click of a mouse. He does not have to wait for a whole new page to be generated and delivered. However, you could do it that way, cannibalising some of CurrCon’s logic, giving you the advantage of no reliance of a working Java in the client machine.
You could simplify the <APPLET tags by creating a special version of CurrCon that used your usual Show tags and base currency as the default. Further you could leave out the material for-non-Java users, and put that somewhere on your page once.

Displaying Exchange Rates

You can also use CurrCon to display exchange rates like this:

1 Euro is	€1.00 EUR	$0.00 USD
1 British pound Sterling is	1.00 GBP
1 US dollar is	$1.00 USD
1 Canadian dollar is	$1.00 CAD
1 New Zealand dollar is	1.00 NZD

Updates

Exchange rates change daily. I update the exchange rate tables daily and post them on my website. You are free to download the latest versions every day and upload them to your website. Alternatively, you can use your own source and add the massaged serialized data to the jar yourself. I have written code to do this the Bank of Canada, the source I use on my own website. I could write you an automated extractor for other sources. Most likely I would charge $50.00 USD , but it depends on the complexity. In any case, I give you a fixed price ahead of time. It is not hard to do yourself using the two sample extractors I have written as models.

FX Sources

You need to pick a source for your exchange rates.

Foreign Exchange Rate Currency Sources
Source	Number Of Currencies	Format	Notes
Bank Of Canada alterate format	59	CSV downloadable file, very convenient. Relative to Canadian dollar.	Official Government source, comes out 1 PM EST each day. Has last 7 days of rates. This is the source I use at mindprod.com. Free. You can also pick them up indirectly already massaged into a jar file from the mindprod.com website each day.
oanda.com	167	Requires licencing the feed.	Makers of the FxCommerce product that competes with CurrCon. It is illegal to use this site to feed data into CurrCon by screenscaping or copying from the screen. Their lawyer explained this in series of emails. Apparently, it would be legal if either you or I signed a licence agreement with them and paid a fee to use a special feed they have. If you curious about the history of how the US dollar (code USD) has been doing relative to the Canadian dollar (code USD), the Euro (code EUR) even the Iraqi Dinar (code IQD) see Oanda’s fxhistory. The US dollar is in deep trouble, but most Americans are unaware of what is happening. Money is fleeing America causing the value of the dollar to drop relative to other countries. The net effect is America has to pay more for imported goods which puts her still deeper in debt in a vicious spiral of debt.
Bank Of Montreal	62	HTML table screenscrape	listed with both country and currency.
University of BC	44	HTML table screenscrape	Updated each noon Pacific Time
US Federal Reserve Bank	25	text in columns screenscrape	Official government source.
CustomHouse	26	HTML table screenscrape	rates are one day behind.
Microsoft	15	HTML table screenscrape	Updated frequently
XE.com	68	as an email in columns surrounded by extraneous text.	Email would need to be extracted manually when it arrived.
newspaper	?	you type them in daily using a csv file.	This is a lot of work. It is error prone. The main advantage is no issue of paying royalties.

Comparison of CurrCon with Oanda FxCommerce

Oanda makes a similar product to CurrCon called FXCommerce.

Feature	CurrCon	FxCommerce
Requires special Code on the server?
Automatically selects user’s currency
Requires user to have JavaScript enabled
Requires user to have Java enabled
Requires user to reload page to see prices?
Lets you control font, color etc. of prices with style sheets?
Includes daily feed of exchange rate changes?
Cost	free	$30.00 USD per month.

Configuring

You will likely need my help getting started. I am opening to creating custom versions of the program.

CurrCon itself free but if you need help installing or configuring CurrCon, I am available on a consulting basis for a fee. I will help you configure CurrCon for your needs. I need to know which technique you will use to generate the Applet tags and what source you plan to use for the exchange rates. I need to know what program you use to upload to your website.

To help you get started quickly, I need to know which currency choices you want to offer.

currency for the possible choices
other downloads

You can configure the files to restrict the currency choices and control the default currency for each country.

The list of choices is limited by both what your source offers and by the list of currency descriptions. A currency must be in both lists to show up on the web page. The currency details list looks like this, with columns for abbreviation, decimal places, Unicode currency symbol, description:

Key Files Used by CurrCon
File	Purpose
boccodes.csv	Codes for currencies used by the Bank of Canada. They are different from ours and need to be translated. This table defines the translation.
countrytocur.csv	Country code to Currency code conversion lookup table. In other words, which currency do people use in each country?
CurrCon.java	CurrCon Java Applet source. Uses the exchs.ser file prepared each day to display prices as an Applet embedded in HTML.
currcon.jar	The jar containing the CurrCon java Applet and the exchs.ser digested daily exchange rates. It is a compact 13K for fast loading. It is freshly prepared each day with the new exchange rates and uploaded to the website. Alternatively, you can just borrow mine from my website if you have no customisation.
CurrConAux.java	CurrConAux main Java program source. Prepares the exchs.ser digest of exchange rates each day from the bank of Canada file.
currencydetails.csv	Details about each currency, its name, how many decimal places you use to display it, what symbol to use for the dollar sign if any.
daily.bat	Run daily to prepare jar for uploading to the website.
exchange_eng.csv	File downloaded each day to the C:\com\mindprod\currconaux directory from the bank of Canada website http://www.bankofcanada.ca/en/markets/csv/exchange_eng.csv containing the daily exchange rates for various countries.
exchs.ser	The massaged and predigested exchange rates in a compact form ready for the CurrCon Applet. It is included in the currcon.jar prepared each day and uploaded to the website.

Daily Procedure

Start a browser.
Any time after 1 PM Eastern time, when the Bank of Canada posts the new exchange rates, download http://www.bankofcanada.ca/en/markets/csv/exchange_eng.csv to the C:\com\mindprod\currconaux directory.
Run daily.bat
Upload currcon.jar to your website.

Costs

All prices are in $0.00 USD , but of course, you now know how to change that.

$30.00 USD for the Currency Converter and coaching you through installation and your first CurrCon is free. It comes with source, and your right to modify it and use it throughout your company.

Package	Version	Released	Licence	Language	Notes
CurrCon Currency Converter	3.4	2008-02-15	free	Java	summary / PAD description / manual / screenshot for the current version of CurrCon Currency Converter. Currency converter for web pages. download CurrCon Currency Converter source and compiled class files to run on your own machine as an Applet. First install the most recent Java. To install, extract the zip download with Winzip, (or similar unzip utility) into any directory you please, often J:\ — ticking off the “user folder names” option. download ASP PAD XML program description for the current version of CurrCon Currency Converter. CurrCon Currency Converter is free. Full source included. You may even include the source code, modified or unmodified in commercial programs that you write and distribute. Non-military use only.

buying CurrCon
currency
Currency Converter Student Project
How to configure your country/currency in Vista
other downloads

	Please email your feedback for publication, errors, omissions, broken/redirected link reports and suggestions to improve this page to Roedy Green :
	Canadian Mind Products
	mindprod.com IP:[65.110.21.43]
	Your face IP:[38.103.63.18]	The information on this page is for non-military use only.
	You are visitor number 12,616.	Military use includes use by defence contractors.
	You can get a fresh copy of this page from:	or possibly from your local J: drive (Java virtual drive/Mindprod website mirror)
	http://mindprod.com/applet/currconmanual.html	J:\mindprod\applet\currconmanual.html