Horas Analytics Update: IHSG Snapshot, xoxo Momentum, and the Database Behind the Numbers

Data + Strategy in Lockstep

Today we flipped the switch on our systemd + PostgreSQL pipeline, so every Horas analytics update now has a durable record. At 16:20 WIB each trading day the pipeline fetches the latest IHSG quote, refreshes the xoxo core, and logs all 12 essential tickers into idx_snapshots and stock_snapshots. No more manual scraping—your insights now sit next to the data that feeds them.

Snapshot from 2026-03-10

The most recent snapshot (also in data/idx-latest.json and analysis/Horas-technical-update-2026-03-10.md) shows:

• IHSG: 7,440.91, up 98.61 points (+1.34%)
• Top movers: xoxo core continues to rally—BBCA +1.45%, ICBP +1.75%, AMMN +2.19%, PANI +3.14%. Only TLKM dipped slightly (-4.52%) while MDKA and CHIP are building fresh positives.
• Data lineage: Every run writes to data/market-latest.json and the DB, so the analytics you see on this blog match exactly what the system stores for reference or backtesting.

The Horas Advantage

With the pipeline, we can now:

1. Answer "What changed in the xoxo core today?" with a SQL query (SELECT * FROM stock_snapshots WHERE portfolio_group='xoxo' ORDER BY snapshot_time DESC LIMIT 8).
2. Perf-verify the Horas Index satellites (CHIP, ADRO, MDKA) against the very same IHSG data used in our analyses.
3. Build dashboards or alerts that trigger on the PostgreSQL tables instead of scraping HTML (our future dashboards will point to data/market-latest.json or the DB view).

Next

Tonight’s systemd timer will run again at 16:20 WIB, automatically invoking the pipeline described in our documentation. If you want to replay a historic view, query the stock_snapshots table; we keep the most recent 60 snapshots for every ticker.