If you are working with financial data within Adobe InDesign in order to build catalogs, financial reports or menu maybe, you may need to convert prices from one currency to another.
Of course, you shouldn’t have to deal with currency conversion as it is your client ‘s responsibility to provide them. But you end up in charge of the conversion of the 5000 prices in euros in US dollars within your indesign document.
What a tedious task. Put the calculator away, we are going to change all our prices in a blink. Ice on the cake : In Real Time ! Prices conversion is not your nightmare any longer.
A) Nice euros prices
We are going to generate a dummy and really basic list of prices thanks to this website : generatedata
This is a really useful website for one looking for building quick and small databases.
Our script is going to execute a HTTP request toward this website : rate-exchange.appspot.com thanks to a Socket Object. I take this opportunity to thank our great friend and colleague Martinho da Gloria from Automatication for delivering a code designed for http requests.
All we have to now is to use this script with EasyCatalog.
We will create a custom field, named “Prix en dollars US” and we will use the “CALLSCRIPT” function:
Et voilà, in a blink, all our euro prices are converted in US dollars :
What’s great here is that our dollars prices are dynamically linked to the “Prix” column values. If any value is subject to changes, then the price will be automatically converted again ! Our document can then be updated very easily !
Once again a graphic designer has not to deal with prices conversions. The clients has to. However we wanted to demonstrate through this example the feasibility of a real time currency conversion within InDesign thanks to the advanced features of EasyCatalog.
In our case, more than a currency conversion, we bring reactivity as the ratio is calculated in real time. A Stock Market crash, a skyrocketing share, a supply shortage and eventually rates going up and down ? In a blink all the prices are calculated over without the need of looking for the rate at this time.
Also, some websites offer to do currencies conversion regarding to specific past rates. This may be interesting for who may ever want to do comparison in prices evolution from one date to another. And who knows : generate a nice bar graph ?