Skip to main content

KR EOD Files

After each KRX trading day closes, Atomic Vaults produces three end-of-day (EOD) files for each Korean account: Balances, Positions and Transactions. They use the same column layout as the US EOD files, so one parser can read both markets. This page covers delivery and the values specific to Korea.

Delivery​

ChannelEmail
FrequencyOne email per account for each KRX trading day
TimingThe evening of the trading day (KST), after the day is closed
SubjectSettlement Files - <account_number> <YYYYMMDD>
Attachment<account_number>_<YYYYMMDD>_files.zip
Contentsbalances_YYYYMMDD.csv, positions_YYYYMMDD.csv, transactions_YYYYMMDD.csv
RecipientsSet up during onboarding. Contact Atomic Vaults to change them.

Files for a closed day never change. A correction to an earlier day arrives in a later day's Transactions file as a reversal (status C) of the original row, followed by the corrected row if there is one.

SFTP delivery and per-end-customer files are not available for Korea yet.

The transaction rows are also available through GET /kr/transactions once the day is closed.

Conventions​

  • Currency. Amounts are in KRW.
  • Settlement. Trades settle T+2 on KRX trading days.
  • Dates. system_dt, trade_dt, settle_dt and avail_dt are YYYY-MM-DD. entry_dt and exec_dt are UTC timestamps in RFC 3339 format.
  • Signs. Amounts follow the US file convention: positive when cash leaves the account (a buy, a withdrawal, a fee) and negative when cash comes in (a sell, a deposit, a dividend). Cash balances are negative when the account holds cash. Quantities are positive for shares received and negative for shares delivered.
  • Unused columns. Every column in the layout is present. Numeric columns that Korea doesn't use are 0; text columns that Korea doesn't use are empty.

Balances​

One row per account. The file has the US Balances columns except the intraday margin columns (iml_*, imd_*), which Korea doesn't use. These columns carry values:

FieldValue
requestIDUnique ID for the row
system_dtTrading date
corrGIGA
officeKR
acct_noYour account number
acct_typeC (cash)
currencyKRW
day_traderN
tcash_balTrade-date cash balance (negative when the account holds cash)
scash_balSettled cash balance (negative when the account holds cash)
acash_balSame as tcash_bal
lmvMarket value of trade-date positions at the closing price
sd_lmvMarket value of settled positions at the closing price
equityTrade-date cash plus lmv
cash_availCash available to withdraw: the lowest of settled, next-day and trade-date cash, and never below 0
cash_withdrawableSame as cash_avail
unsettled_buysAmount of buy trades not yet settled
unsettled_sellsAmount of sell trades not yet settled

Positions​

One row per symbol held. Same columns as the US Positions file:

FieldValue
requestIDUnique ID for the row
system_dtTrading date
corrGIGA
officeKR
acct_noYour account number
sub_acct_noLEQT for long positions, SEQT for short positions
acct_typeC
symbol6-digit Korean issue code, for example 005930
sym_noEmpty
hold_typeL (long) or S (short)
priceClosing price
tcloseTrade-date quantity
tmktvalTrade-date market value
scloseSettled quantity
smktvalSettled market value

Transactions​

One row per fill and one row per cash or corporate-action entry. Same columns as the US Transactions file.

Fills​

FieldValue
tr_noTransaction number: the trading date as YYMMDD followed by a 7-digit sequence, for example 2611060000001
src_cdCOS
entry_typeTRD
trd_typeB (buy) or S (sell)
cust_typeC
sub_acct_noLEQT
entry_dt, exec_dtFill time (UTC)
trade_dtTrading date
settle_dt, avail_dtSettlement date (T+2)
symbol6-digit Korean issue code
qtyFill quantity: positive for a buy, negative for a sell
priceFill price
g_amtGross amount, qty × price
commCommission on the fill
oth_feeSecurities transaction tax on the fill (charged on sells)
n_amtNet amount, g_amt + comm + oth_fee
currencyKRW
sol_unsolN
settled, availedY once the trade has settled, otherwise N
postedY
statusR
cl_order_idYour order_id
order_idAtomic Vaults av_order_id
exec_id, fill_idFill ID

Commission is charged at your agreed rate on the day's gross amount per symbol and side, rounded up to the nearest KRW, and spread across that day's fills. Commission and tax are included in the fill rows rather than listed separately.

Cash and corporate-action entries​

FieldValue
tr_noTransaction number, continuing the day's sequence
entry_typeSee Entry Types
entry_dtWhen the entry was recorded (UTC)
trade_dt, settle_dt, avail_dtDates of the entry
symbol, qty, priceSet for corporate actions on a security; empty or 0 for cash entries
g_amt, n_amtAmount of the entry
statusR (posted) or C (reversal of an earlier entry)
descrDescription of the entry
ref_idGroups the rows of one booking, for example a reversal and its correction

Entry Types​

CodeDescription
TRDTrade (fill)
WIREICash deposit
WIREOCash withdrawal
DIVDividend
DIVTAXTax withheld on a dividend
INTInterest
CILCash in lieu
SPLITStock split
RSPLITReverse split
BONUSBonus issue
REORGReorganisation
SSOSpin-off
MAMerger or acquisition
LIQLiquidation
SCSymbol change
COMMCommission
BRKCOMMBroker commission
TAXTax
CORRCorrection
ERRError offset
ADJAdjustment