ADO.NET Provider for Open Exchange Rates

Build 21.0.7930

Timeseries

Query historical exchange rates for a given time period.

Table Specific Information

Select

If you do not provide a Start and End date, results are returned for a default range of three months.

SELECT * FROM Timeseries WHERE Start='2013-01-01' AND End='2013-01-07'

If you want to show more Currencies, set the Location connection property and modify the Timeseries.rsd file. You can base your column off an existing one; for example, the USD column below. Columns need at least a name and data type:

<attr name="USD" xs:type="double" desc="U.S. Dollar Currency."/>
Then define the list of Symbols that you want to select in a comma-separated list:
SELECT * FROM Timeseries WHERE Symbols='BTC,EUR,HKD' AND Start='2013-01-01' AND End='2013-01-07'

Columns

Name Type References Description
Date Date Date of current currency.
EUR Decimal European Euro currency.
JPY Decimal Japanese Yen Currency.
GBP Decimal British Pound Currency.
CAD Decimal Canadian Dollar Currency.
CHF Decimal Swiss Franc Currency.
USD Decimal U.S. Dollar Currency.
Base String Base currency (3-letter code. Default: USD).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Start Date Start date.
End Date End date.
Symbols String Limit results to specific currencies (comma-separated list of 3-letter codes).

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930