Currency

Select the Currency.

Rate Type

Select the Rate Type.

From Date

Select the start date to enter the exchange rates for.

To Date

Select the end date to enter the exchange rates for.

Grid Fields

Date

Enter the effective date for the exchange rate.

Exchange Rate

Enter the exchange rate for that date.

Reciprocal Rate

This is calculated as 1 divided by the exchange rate. If you adjust the reciprocal rate, the exchange rate is back calculated.

Expiry Date

If you are not entering exchange rates daily, you can key in a rate to be used from the date up to the expiry date. If the expiry date is not entered the rate remains valid till the next exchange rate effective date.

Grid Toolbar

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Insert (F4)

Insert a new line.

Delete (F3)

Delete a selected line.

Print (Ctrl+P)

Print a report for the grid.

Filter / Sort List (Ctrl+F2)

Clear Filter / Sort (Ctrl+F3)

Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Import From File (Ctrl+I)

Import exchange rates from a file.

Export To File (Ctrl+E)

Export exchange rates to a file.

Customise Toolbar

Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.

Field

Format

Size

Effective Date

Date

Exchange Rate

Numeric