Skip to main content

FactSet

Foreign Exchange Rate client library for Python

API Version PyPi Apache-2 license

Foreign Exchange Rates API in which retrieves Spots and Forwards for a given currency pair and date range.

Spots and Forwards rates are sourced from W/M Reuters.The WM Company calculates daily standardized spot rates for global foreign exchange transactions, using rates provided by Reuters. These rates are recognized globally as the standard by banks, fund managers, and index compilers; increasingly these rates are also being used for benchmark currency trading. In 1994, WM Company began calculating closing spot rates. Closing spot rates provide a standard set of currency rates so that portfolio valuations can be compared to each other and their performances measured against benchmarks, without having discrepancies caused by exchange rates. Closing spot rates are recorded at 16:00 GMT.

This Python package is automatically generated by the OpenAPI Generator project:

  • API version: 1.0.0
  • SDK version: 2.0.0
  • Build package: org.openapitools.codegen.languages.PythonClientCodegen

Requirements

  • Python >= 3.7

Installation

Poetry

poetry add fds.sdk.utils fds.sdk.ForeignExchangeRate==2.0.0

pip

pip install fds.sdk.utils fds.sdk.ForeignExchangeRate==2.0.0

Usage

  1. Generate authentication credentials.
  2. Setup Python environment.
    1. Install and activate python 3.10+. If you're using pyenv:

      pyenv install 3.10.0
      pyenv shell 3.10.0
      
    2. (optional) Install poetry.

  3. Install dependencies.
  4. Run the following:

[!IMPORTANT] The parameter variables defined below are just examples and may potentially contain non valid values. Please replace them with valid values.

Example Code

from fds.sdk.utils.authentication import ConfidentialClient

import fds.sdk.ForeignExchangeRate
from fds.sdk.ForeignExchangeRate.api import forwards_api
from fds.sdk.ForeignExchangeRate.models import *
from dateutil.parser import parse as dateutil_parser
from pprint import pprint

# See configuration.py for a list of all supported configuration parameters.

# Examples for each supported authentication method are below,
# choose one that satisfies your use case.

# (Preferred) OAuth 2.0: FactSetOAuth2
# See https://github.com/FactSet/enterprise-sdk#oauth-20
# for information on how to create the app-config.json file
#
# The confidential client instance should be reused in production environments.
# See https://github.com/FactSet/enterprise-sdk-utils-python#authentication
# for more information on using the ConfidentialClient class
configuration = fds.sdk.ForeignExchangeRate.Configuration(
    fds_oauth_client=ConfidentialClient('/path/to/app-config.json')
)

# Basic authentication: FactSetApiKey
# See https://github.com/FactSet/enterprise-sdk#api-key
# for information how to create an API key
# configuration = fds.sdk.ForeignExchangeRate.Configuration(
#     username='USERNAME-SERIAL',
#     password='API-KEY'
# )

# Enter a context with an instance of the API client
with fds.sdk.ForeignExchangeRate.ApiClient(configuration) as api_client:
    # Create an instance of the API class
    api_instance = forwards_api.ForwardsApi(api_client)
    ids = ["USDGBP"] # [str] | The currency pair requested in the format of a ISO {source}{target}. For a complete list of ISO currencies, please visit [OA 1470](https://my.apps.factset.com/oa/pages/1470)
    forward_period = "ON" # str | Bid, offer, and mid rates are available for the following 11 time periods.  * ON - Overnight  * TN - Tomorrow Next  * SW - One Week (Spot Week)  * 1M - One Month  * 2M - Two Months  * 3M - Three Months  * 6M - Six Months  * 9M - Nine Months  * 1Y - One Year  * 2Y - Two Years  * 5Y - Five Years  (optional) if omitted the server will use the default value of "1M"
    start_date = "2019-01-01" # str | The start date requested for a given date range in **YYYY-MM-DD** format. If left blank, the API will default to latest available.  (optional)
    end_date = "2019-12-31" # str | The end date requested for a given date range in **YYYY-MM-DD** format. If left blank, the API will default to latest available.  (optional)
    frequency = "D" # str | Controls the display frequency of the data returned.   * **D** = Daily   * **W** = Weekly, based on the last day of the week of the start date.   * **M** = Monthly, based on the last trading day of the month.   * **AM** = Monthly, based on the start date (e.g., if the start date is June 16, data is displayed for June 16, May 16, April 16 etc.).    * **CQ** = Quarterly based on the last trading day of the calendar quarter (March, June, September, or December).   * **AY** = Actual Annual, based on the start date.   * **CY** = Calendar Annual, based on the last trading day of the calendar year.  (optional) if omitted the server will use the default value of "D"

    try:
        # Gets Forwards for a list of currency pairs
        # example passing only required values which don't have defaults set
        # and optional values
        api_response = api_instance.get_fx_forwards(ids, forward_period=forward_period, start_date=start_date, end_date=end_date, frequency=frequency)

        pprint(api_response)
    except fds.sdk.ForeignExchangeRate.ApiException as e:
        print("Exception when calling ForwardsApi->get_fx_forwards: %s\n" % e)

    # # Get response, http status code and response headers
    # try:
    #     # Gets Forwards for a list of currency pairs
    #     api_response, http_status_code, response_headers = api_instance.get_fx_forwards_with_http_info(ids, forward_period=forward_period, start_date=start_date, end_date=end_date, frequency=frequency)


    #     pprint(api_response)
    #     pprint(http_status_code)
    #     pprint(response_headers)
    # except fds.sdk.ForeignExchangeRate.ApiException as e:
    #     print("Exception when calling ForwardsApi->get_fx_forwards: %s\n" % e)

    # # Get response asynchronous
    # try:
    #     # Gets Forwards for a list of currency pairs
    #     async_result = api_instance.get_fx_forwards_async(ids, forward_period=forward_period, start_date=start_date, end_date=end_date, frequency=frequency)
    #     api_response = async_result.get()


    #     pprint(api_response)
    # except fds.sdk.ForeignExchangeRate.ApiException as e:
    #     print("Exception when calling ForwardsApi->get_fx_forwards: %s\n" % e)

    # # Get response, http status code and response headers asynchronous
    # try:
    #     # Gets Forwards for a list of currency pairs
    #     async_result = api_instance.get_fx_forwards_with_http_info_async(ids, forward_period=forward_period, start_date=start_date, end_date=end_date, frequency=frequency)
    #     api_response, http_status_code, response_headers = async_result.get()


    #     pprint(api_response)
    #     pprint(http_status_code)
    #     pprint(response_headers)
    # except fds.sdk.ForeignExchangeRate.ApiException as e:
    #     print("Exception when calling ForwardsApi->get_fx_forwards: %s\n" % e)

Using Pandas

To convert an API response to a Pandas DataFrame, it is necessary to transform it first to a dictionary.

import pandas as pd

response_dict = api_response.to_dict()['data']

simple_json_response = pd.DataFrame(response_dict)
nested_json_response = pd.json_normalize(response_dict)

Debugging

The SDK uses the standard library logging module.

Setting debug to True on an instance of the Configuration class sets the log-level of related packages to DEBUG and enables additional logging in Pythons HTTP Client.

Note: This prints out sensitive information (e.g. the full request and response). Use with care.

import logging
import fds.sdk.ForeignExchangeRate

logging.basicConfig(level=logging.DEBUG)

configuration = fds.sdk.ForeignExchangeRate.Configuration(...)
configuration.debug = True

Configure a Proxy

You can pass proxy settings to the Configuration class:

  • proxy: The URL of the proxy to use.
  • proxy_headers: a dictionary to pass additional headers to the proxy (e.g. Proxy-Authorization).
import fds.sdk.ForeignExchangeRate

configuration = fds.sdk.ForeignExchangeRate.Configuration(
    # ...
    proxy="http://secret:password@localhost:5050",
    proxy_headers={
        "Custom-Proxy-Header": "Custom-Proxy-Header-Value"
    }
)

Custom SSL Certificate

TLS/SSL certificate verification can be configured with the following Configuration parameters:

  • ssl_ca_cert: a path to the certificate to use for verification in PEM format.
  • verify_ssl: setting this to False disables the verification of certificates. Disabling the verification is not recommended, but it might be useful during local development or testing.
import fds.sdk.ForeignExchangeRate

configuration = fds.sdk.ForeignExchangeRate.Configuration(
    # ...
    ssl_ca_cert='/path/to/ca.pem'
)

Request Retries

In case the request retry behaviour should be customized, it is possible to pass a urllib3.Retry object to the retry property of the Configuration.

from urllib3 import Retry
import fds.sdk.ForeignExchangeRate

configuration = fds.sdk.ForeignExchangeRate.Configuration(
    # ...
)

configuration.retries = Retry(total=3, status_forcelist=[500, 502, 503, 504])

Documentation for API Endpoints

All URIs are relative to https://api.factset.com/content

Class Method HTTP request Description
ForwardsApi get_fx_forwards GET /foreign-exchange/v1/forwards Gets Forwards for a list of currency pairs
ForwardsApi get_fx_forwards_for_list POST /foreign-exchange/v1/forwards Gets Forwards for a list of currency pairs
SpotsApi get_spots GET /foreign-exchange/v1/spots Gets spots for a list of currency pairs
SpotsApi get_spots_for_list POST /foreign-exchange/v1/spots Gets spots for a list of currency pairs

Documentation For Models

Documentation For Authorization

FactSetApiKey

  • Type: HTTP basic authentication

FactSetOAuth2

  • Type: OAuth
  • Flow: application
  • Authorization URL:
  • Scopes: N/A

Notes for Large OpenAPI documents

If the OpenAPI document is large, imports in fds.sdk.ForeignExchangeRate.apis and fds.sdk.ForeignExchangeRate.models may fail with a RecursionError indicating the maximum recursion limit has been exceeded. In that case, there are a couple of solutions:

Solution 1: Use specific imports for apis and models like:

  • from fds.sdk.ForeignExchangeRate.api.default_api import DefaultApi
  • from fds.sdk.ForeignExchangeRate.model.pet import Pet

Solution 2: Before importing the package, adjust the maximum recursion limit as shown below:

import sys
sys.setrecursionlimit(1500)
import fds.sdk.ForeignExchangeRate
from fds.sdk.ForeignExchangeRate.apis import *
from fds.sdk.ForeignExchangeRate.models import *

Contributing

Please refer to the contributing guide.

Copyright

Copyright 2026 FactSet Research Systems Inc

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Metadata

Release files for fds.sdk.ForeignExchangeRate 2.0.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for fds.sdk.ForeignExchangeRate 2.0.0
File Size Uploaded
fds_sdk_foreignexchangerate-2.0.0.tar.gz 60.7 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for fds.sdk.ForeignExchangeRate 2.0.0
File Interpreter ABI Platform
fds_sdk_foreignexchangerate-2.0.0-py3-none-any.whl Python 3 none any Details

Total release size: 150.9 kB

Release files / fds_sdk_foreignexchangerate-2.0.0.tar.gz

Download URL fds_sdk_foreignexchangerate-2.0.0.tar.gz
Size 60.7 kB
Tags Source
SHA-256 checksum
How to use checksums
f169bf7c40373d0d4f5fbf034a26321fdcc0f84acf5d2e2f89fd17e7babe5de4
BLAKE2b-256 checksum
How to use checksums
071de141e680f959505aed3ed01ba2d298d18c13a664b97e3ff82a7bce42f208
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.14.5

Release files / fds_sdk_foreignexchangerate-2.0.0-py3-none-any.whl

Download URL fds_sdk_foreignexchangerate-2.0.0-py3-none-any.whl
Size 90.2 kB
Tags Python 3
SHA-256 checksum
How to use checksums
ba2036ab243dd392df0ea6ada26663e423e315e2870194f10cb066b9e73d05cd
BLAKE2b-256 checksum
How to use checksums
f7234bff5cc9592ebda501bc92f6c98caa6cea0bd103efe4c86212adafb6361b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.14.5

Release history Release notifications | RSS feed

This release

2.0.0 This release

2 release files

1.0.13

2 release files

1.0.11

1 release file

1.0.10

1 release file

1.0.9

1 release file

1.0.8

1 release file

1.0.7

1 release file

1.0.6

1 release file

1.0.5

1 release file

1.0.4

1 release file

1.0.3

1 release file

1.0.2

1 release file

1.0.1

1 release file

1.0.0

1 release file

0.21.0

1 release file

0.20.0

1 release file

0.9.1

1 release file

0.9.0

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page