Download broker summary data as CSV or Excel

You can get broker summary data as a CSV or Excel file two ways: export it from the dashboard, or save an API response to a file with your own script.

The dashboard export requires no code. Sign in, pick one or more tickers, a date range, an investor type, and a market, then click Download CSV or Download Excel. The file contains one row per broker for the selected range - the same aggregated view the API returns.

Every export uses these columns: Ticker, Broker, Buy Volume, Sell Volume, Buy Value, Sell Value, Buy Frequency, Sell Frequency, Buy Avg Price, Sell Avg Price. Volume is in shares, value in IDR, and the average prices are weighted averages.

Multi-day ranges are aggregated into a single row per broker - totals for the whole range, not per-day rows. Pick a single day if you need daily records.

API to file

Prefer scripting? Fetch the JSON response and write it to a CSV with the standard library.

import csv
import requests

API_KEY = "<YOUR_API_KEY>"
BASE_URL = "https://api.indexalpha.id"

headers = {"Authorization": f"Bearer {API_KEY}"}
params = {"ticker": "BBCA", "from": "2026-03-26", "to": "2026-03-26", "investor": "all"}

resp = requests.get(f"{BASE_URL}/stocks/broker-summary", headers=headers, params=params)
resp.raise_for_status()
rows = resp.json()["data"]

with open("broker-summary.csv", "w", newline="") as f:
    writer = csv.DictWriter(f, fieldnames=rows[0].keys())
    writer.writeheader()
    writer.writerows(rows)

Related