|
|
Currency Rate Settings |
Currency defaults and exchange rates are used when you generate exposure views, run analyses, and view results. To manage currency defaults, exchange rates, or currency conversion tables, use the Currency Rate Settings pane in the Administration Console.
You can specify project-level currency rate settings to override the global currency rate settings.
|
The term "saved currency" applies to contracts and locations. Saved currency is imported with the imported exposure data; it is the original currency. It is saved in the database. A user can have one saved currency for the contract and different saved currencies for various locations. |
You can import currency rate settings from a CSV file and export currency rate settings to a CSV file.
Parameters & Buttons |
Description |
||
Use these buttons (when applicable) and the parameters below to create and modify currency rate settings. |
|||
Currency Rate Table |
The left column in the Currency Rate Settings
pane (not labeled) includes a list of currency rate tables. The
"AIR
Default" rate table always exists and is not modifiable.
To create your own table, click |
||
Display Defaults |
This currency setting applies by default
to all monetary values displayed in the user interface. Touchstone uses the selected
currency conversion table to convert analysis currency values
to the default display
currency. The *Saved Currency option in various panes in the user interface enables you to display exposures and results in the currency they were imported in or analyzed in respectively. |
||
Analysis Defaults |
This currency setting applies by default
when any analysis is run. If you select a different currency and rate when you configure an analysis, the new currency and rate apply only to the analysis that you are currently configuring.
|
||
Name |
Displays the name of the selected currency conversion table. You can use this field to rename every table except for "AIR Default". |
||
Base Currency |
Select a base currency from the list. This is used as a basis (1 unit) from which to convert one currency to another currency using the selected currency conversion table. While you can select any base currency, there can be only one per currency conversion table. |
||
Rate |
To modify a particular currency rate, click in the Rate cell for the currency rate you want to change, edit the rate, and then press Enter. A rate value must be a valid decimal value with a minimum value greater than "0". |
Refer to Guidance for Currency Settings for more information.
• To view the currency codes supported by Touchstone, log in to the Client Portal, navigate to the Touchstone Developer Zone, click the Touchstone Databases link (under "Database Documentation"), and then search for "tCurrency Table". The Description field for the Currency Code column lists the ISO 3-character code for each currency.
To copy an entire currency rate set, select the set so that it appears in the pane, right-click in the pane, select Select All, right-click again, and then select Copy.
To paste the copied currency rate set into another set, select the set so that it appears in the pane, right-click in the pane, and then select Paste.
You can also copy/paste to/from an Excel spreadsheet.
When you import a currency exchange rate set from a CSV file and the file contains deprecated currencies or is missing new currencies, Touchstone removes the deprecated currencies and adds any new currencies that the current version of Touchstone supports.
If the CSV file includes duplicate currencies, Touchstone will reject the import.
The file name must be unique; if you export a currency set and then import it, you must also rename the rate set before importing it, as noted in Exporting a Currency Exchange Rate Set.
To import a currency exchange rate set:
1. On the toolbar, click 
(Import Currency Exchange Rate Set).
The Import Currency dialog box opens.
2. Browse to the location of the currency file that you want to import.
The path must be a valid UNC path, such as to a shared network folder.
3. In the Open dialog box, select the currency file and then click Open.
The selected file is then listed in the Browse Currency File field.
4. Click Import.
If a file with the same name exists, the system prompts you to decide whether to replace it or not. If a file with the same name does not exist, the export process continues and the imported currency file is included in the list of currency rate tables.
If you export a rate set that you want to import into the same Touchstone client, you must change the file name and the rate set name after you export the rate set. If you do not change the rate set name, you will get an error when you try to import the rate set, even if the file name is different.
To export a currency exchange rate set:
1. In the Currency Rate Settings pane, in the list of currency rate sets, select the rate set that you want to export.
2. On the toolbar, click 
(Export Currency Exchange Rate Set).
The Export Currency dialog box opens.
3. Specify the export destination (a valid UNC destination path and file name).
4. Click Export.
If the file exists, the system prompts you to decide whether to replace it or not. If the file does not exists, the export process continues. When the export has succeeded, a Notification dialog box appears with details about the location to which you exported the rate set.
5. To edit the name of the rate set:
a. Browse to the location where you exported the rate set.
b. Open the CSV file in a text editor—not in a spreadsheet application.
The currency code and the rate set name are separated
by a comma on the first line. 
Example
c. Change the rate set name and close the text editor.
|
© 2020 AIR Worldwide. All rights reserved. Touchstone 7.0 Updated September 03, 2020 |
(Create new Exchange Rate Set). When the new "Custom Exchange
Rate Set" table appears, specify the defaults, modify the
table as needed, and then click 