Using Indices-API to Fetch Philippine Stock Exchange PSEi Price Time-Series Data for Predictive Analytics

Introduction

About the Philippine Stock Exchange PSEi (PSEI)

API Description

Indices-API Website or refer to the Indices-API Documentation for detailed guidance on implementation.

Key Features and Endpoints

Latest Rates Endpoint

{
"success": true,
"timestamp": 1755536456,
"base": "USD",
"date": "2025-08-18",
"rates": {
"PSEI": 0.00029,
"DOW": 0.00029,
"NASDAQ": 0.00039
},
"unit": "per index"
}

Historical Rates Endpoint

{
"success": true,
"timestamp": 1755450056,
"base": "USD",
"date": "2025-08-17",
"rates": {
"PSEI": 0.00028,
"DOW": 0.00028,
"NASDAQ": 0.00038
},
"unit": "per index"
}

Time-Series Endpoint

{
"success": true,
"timeseries": true,
"start_date": "2025-08-11",
"end_date": "2025-08-18",
"base": "USD",
"rates": {
"2025-08-11": {
"PSEI": 0.00028
},
"2025-08-13": {
"PSEI": 0.00029
},
"2025-08-18": {
"PSEI": 0.00029
}
},
"unit": "per index"
}

Convert Endpoint

{
"success": true,
"query": {
"from": "USD",
"to": "PSEI",
"amount": 1000
},
"info": {
"timestamp": 1755536456,
"rate": 0.00029
},
"result": 0.29,
"unit": "per index"
}

Fluctuation Endpoint

{
"success": true,
"fluctuation": true,
"start_date": "2025-08-11",
"end_date": "2025-08-18",
"base": "USD",
"rates": {
"PSEI": {
"start_rate": 0.00028,
"end_rate": 0.00029,
"change": 0.00001,
"change_pct": 3.57
}
},
"unit": "per index"
}

Open/High/Low/Close (OHLC) Price Endpoint

{
"success": true,
"timestamp": 1755536456,
"base": "USD",
"date": "2025-08-18",
"rates": {
"PSEI": {
"open": 0.00028,
"high": 0.00029,
"low": 0.00027,
"close": 0.00029
}
},
"unit": "per index"
}

Bid/Ask Endpoint

{
"success": true,
"timestamp": 1755536456,
"base": "USD",
"date": "2025-08-18",
"rates": {
"PSEI": {
"bid": 0.00028,
"ask": 0.00029,
"spread": 0.00001
}
},
"unit": "per index"
}

Data Processing Steps for Predictive Analytics

1. Data Collection

2. Data Cleaning

3. Data Transformation

4. Exploratory Data Analysis (EDA)

5. Model Selection

6. Model Training and Validation

7. Model Deployment

Examples of Predictive Model Applications

1. Stock Price Prediction

2. Market Trend Analysis

3. Risk Assessment

Conclusion

Indices-API Documentation and explore the Indices-API Supported Symbols for a comprehensive understanding of the available data.