BOT Historical Data API: Timeseries, Charts & Downloads

BOT Historical Data API: Timeseries, Charts & Downloads

Introduction

In the fast-paced world of finance, access to accurate and timely interest rate data is crucial for developers, economists, and financial analysts. The Interest Rates API provides a comprehensive solution for retrieving historical data, time series analysis, and real-time interest rates. This blog post will delve into the capabilities of the Interest Rates API, focusing on the Bank of Thailand Policy Rate (BOT_POLICY_RATE) and how it can be leveraged for financial applications.

Understanding the Importance of Interest Rate Data

Interest rates are a fundamental component of the financial ecosystem, influencing everything from loan costs to investment returns. Developers building fintech applications need reliable data to make informed decisions. The Interest Rates API addresses several challenges:

  • Access to real-time and historical data for accurate financial modeling.
  • Time series analysis for trend identification and forecasting.
  • Integration capabilities for seamless application development.

Without such APIs, developers face significant hurdles, including data inconsistencies, manual data collection, and the inability to perform complex analyses efficiently. The Interest Rates API streamlines these processes, allowing users to focus on building robust financial solutions.

API Overview and Key Features

The Interest Rates API offers several endpoints that cater to different data retrieval needs. Below is a summary of the key endpoints:

  • /api/v1/symbols: Retrieve a catalogue of available rate symbols.
  • /api/v1/latest: Get the latest value per symbol.
  • /api/v1/historical: Fetch values on a specific date.
  • /api/v1/timeseries: Retrieve a series of values between two dates.
  • /api/v1/fluctuation: Analyze change statistics over a range.
  • /api/v1/ohlc: Obtain OHLC candlestick data.
  • /api/v1/convert: Compare loan interest costs between two rates.

Each endpoint serves a unique purpose, enabling users to access a wealth of financial data efficiently.

Fetching Time Series Data with the /timeseries Endpoint

The /timeseries endpoint is particularly valuable for developers looking to analyze trends over extended periods. This endpoint allows users to retrieve a series of interest rates between two specified dates. Here’s how to use it:

Request Format

The request format for the /timeseries endpoint is as follows:

GET https://interestratesapi.com/api/v1/timeseries?start=YYYY-MM-DD&end=YYYY-MM-DD&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY

Example Request

curl "https://interestratesapi.com/api/v1/timeseries?start=2025-07-09&end=2026-07-09&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY"

Example JSON Response


{
"success": true,
"base": "USD",
"start_date": "2025-07-09",
"end_date": "2026-07-09",
"rates": {
"BOT_POLICY_RATE": {
"2025-01-02": 5.33,
"2025-01-03": 5.33,
"2025-01-06": 5.33
}
},
"frequencies": {
"BOT_POLICY_RATE": "daily"
},
"currencies": {
"BOT_POLICY_RATE": "USD"
}
}

The response includes the start and end dates, the base currency, and a detailed breakdown of the rates for the specified period. This data can be invaluable for trend analysis and forecasting.

Implementation Example in Python

Here’s how you can implement the /timeseries endpoint in Python:

import requests

response = requests.get(
'https://interestratesapi.com/api/v1/timeseries',
params=dict(start='2025-07-09', end='2026-07-09', symbols='BOT_POLICY_RATE', api_key='YOUR_KEY')
)

data = response.json()
print(data)

This code snippet retrieves the time series data for the BOT_POLICY_RATE and prints the response in JSON format.

Point-in-Time Lookups with the /historical Endpoint

The /historical endpoint allows users to fetch interest rate values for a specific date. This is particularly useful for financial analysts who need to reference historical data for reporting or analysis.

Request Format

The request format for the /historical endpoint is as follows:

GET https://interestratesapi.com/api/v1/historical?date=YYYY-MM-DD&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY

Example Request

curl "https://interestratesapi.com/api/v1/historical?date=2025-06-15&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY"

Example JSON Response


{
"success": true,
"date": "2025-06-15",
"base": "USD",
"rates": {
"BOT_POLICY_RATE": 5.33
},
"currencies": {
"BOT_POLICY_RATE": "USD"
}
}

This response provides the interest rate for the specified date, allowing for precise historical analysis.

Implementation Example in JavaScript

Here’s how to implement the /historical endpoint in JavaScript:

const response = await fetch(
'https://interestratesapi.com/api/v1/historical?date=2025-06-15&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY'
);

const data = await response.json();
console.log(data);

Building Candlestick Charts with the /ohlc Endpoint

The /ohlc endpoint provides OHLC (Open, High, Low, Close) candlestick data, which is essential for visualizing interest rate trends over time. This data can be used to create insightful charts for financial analysis.

Request Format

The request format for the /ohlc endpoint is as follows:

GET https://interestratesapi.com/api/v1/ohlc?symbols=BOT_POLICY_RATE&period=monthly&start=YYYY-MM-DD&end=YYYY-MM-DD&api_key=YOUR_KEY

Example Request

curl "https://interestratesapi.com/api/v1/ohlc?symbols=BOT_POLICY_RATE&period=monthly&start=2025-07-09&end=2026-07-09&api_key=YOUR_KEY"

Example JSON Response


{
"success": true,
"period": "monthly",
"start_date": "2025-07-09",
"end_date": "2026-07-09",
"rates": {
"BOT_POLICY_RATE": [
{
"period": "2025-01",
"open": 5.50,
"high": 5.50,
"low": 5.33,
"close": 5.33,
"data_points": 23
}
]
}
}

This response provides the OHLC data for the specified period, which can be used to create candlestick charts. Below is an example of how to integrate this data with Chart.js:

const ctx = document.getElementById('myChart').getContext('2d');
const myChart = new Chart(ctx, {
type: 'candlestick',
data: {
datasets: [{
label: 'BOT Policy Rate',
data: [
{ x: '2025-01', o: 5.50, h: 5.50, l: 5.33, c: 5.33 }
]
}]
}
});

Analyzing Fluctuations with the /fluctuation Endpoint

The /fluctuation endpoint allows users to analyze changes in interest rates over a specified range. This is particularly useful for understanding market dynamics and making informed decisions.

Request Format

The request format for the /fluctuation endpoint is as follows:

GET https://interestratesapi.com/api/v1/fluctuation?start=YYYY-MM-DD&end=YYYY-MM-DD&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY

Example Request

curl "https://interestratesapi.com/api/v1/fluctuation?start=2025-07-09&end=2026-07-09&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY"

Example JSON Response


{
"success": true,
"rates": {
"BOT_POLICY_RATE": {
"start_date": "2025-07-09",
"end_date": "2026-07-09",
"start_value": 5.50,
"end_value": 5.33,
"change": -0.17,
"change_pct": -3.09,
"high": 5.50,
"low": 5.25
}
}
}

This response provides detailed fluctuation statistics, including the percentage change and the highest and lowest values during the specified period. This data is crucial for risk assessment and strategic planning.

Implementation Example in PHP

Here’s how to implement the /fluctuation endpoint in PHP:

<?php

$url = 'https://interestratesapi.com/api/v1/fluctuation?start=2025-07-09&end=2026-07-09&symbols=BOT_POLICY_RATE&api_key=YOUR_KEY';

$response = file_get_contents($url);
$data = json_decode($response, true);
print_r($data);

?>

Conclusion

The Interest Rates API is an invaluable tool for developers, economists, and financial analysts seeking reliable interest rate data. With endpoints for historical data retrieval, time series analysis, and fluctuation statistics, users can build robust financial applications that leverage accurate and timely information. By utilizing the Interest Rates API, developers can save time and resources while delivering high-quality financial solutions.

To explore more features and get started with the Interest Rates API, visit Explore Interest Rates API features and Get started with Interest Rates API.

Ready to get started?

Get your API key and start validating bank data in minutes.

Get API Key

Related posts