Skip to main content

Updating Non-SysControlled EOD Prices

Overview

GAIA End-of-Day (EOD) prices are inserted manually into the system. These prices are not system-controlled and originate from the 1_DAY_OHLC tables in the historic database.

While the API is functioning correctly and is hosted directly on the box, the issue lies with the sequencing and dependency of pricing data population.

Issue

  • GAIA EOD prices are manually inserted.

  • When the market closes, a system trigger fires to populate EOD prices.

  • However, if GAIA prices are inserted manually, the dependent prices may not yet exist, leading to incomplete or incorrect pricing data.

🔹 Root Cause

The pricing trigger assumes all prices, including GAIA, are present before execution.
Manual GAIA insertion happens before other dependent prices are available, resulting in incomplete EOD pricing.

The following issues have been observed when cross-referencing API results with website-displayed trades:

  • 4AARB (SEC_ID 1000000334):

    • API returns no data for 07/07/2025.

    • Website shows trades with values 345, 149, R514.05.

  • 4ABKB (SEC_ID: 1000000209):

    • API reports total trade size: 12910 on 07/07/2025.

    • Website reflects trade size: 15744, with high at 520 and low at 510.

    • API data does not reflect these values.

  • 4ANWKH (SEC_ID: 1000000146):

    • API is missing data for 08/07/2025.

    • Website displays trades for this date.

 

No comments to display

Back to top