Account Data Report (UAD)

This message is sent by the CQG gateway in response to an Account Data Request (MsgType=UAR) message. A separate Account Data Report is sent for each account.

Aggregated balance information is reported in the account’s operational currency (converted using current CQG gateway currency rates).

BalanceGrp is present if IncludeBalanceGrp (20031) = Y in the Account Data Request. It contains one entry per individual balance record in that balance record’s currency, as reported by the FCM.

There can be multiple balance records for a single currency. All components of an individual balance record are not reported by every FCM - TotalEndingCashBalance is most likely available, but other components (e.g. TotalAccountValue and CashExcess) may not be available and could thus be reported as 0.

 

Tag

Name

Format

Req

Comments

 

Standard Header

 

Y

MsgType = UAD

1

Account

String(256)

Y

Account ID (managed by the CQG gateway).

15

Currency

String(64)

C

Currency code associated with the price. Sent only if tag 150 (ExecType) is 1 (Partial Fill) or 2 (Fill) on reports for single securities. For multi-leg securities, tag 50556 (LegCurrency) is populated instead. Currency format is ISO-4217-based currency code, note that cryptos use codes that are ISO-4217-style, though usually not actual ISO codes and can be longer than 3 chars.

325

UnsolicitedIndicator

Boolean

Y

Set to Y if message is sent as a result of a subscription request or out-of-band configuration as opposed to an Account Data Request (UAR).

20003

AcctReqID

String(64)

Y

If tag 325 (UnsolicitedIndicator) is N, AcctReqID is unique ID provided by the FIX Client in corresponding Account Data Request (UAR) message. If tag 325 (UnsolicitedIndicator) is Y, AcctReqID is unique ID of report series generated by the CQG gateway.

20010

AccountName

String

N

Symbolic name of account.

20011

AsOfDate

UTC Timestamp

N

Last FCM clearing date.

20012

CashExcess

Amt

N

Account cash excess.

20013

CollateralOnDeposit

Amt

N

Total amount of funds on collateral deposit.

20014

FCMAccountNumber

String

N

Unique identifier of the account of the FCM.

20015

InitialMarginReqs

Amt

N

Initial margin requirement for this account.

20016

MaintenanceMarginReqs

Amt

N

Maintenance margin requirement for this account.

20017

MarketValue

Amt

N

Market value of options and Fixed-Income.

20018

OpenTradeEquity

Amt

N

Unrealized P&L for futures.

20019

TotalAccountValue

Amt

N

Total funds amount on this account.

20020

TotalEndingCashBalance

Amt

N

Total balance for this account as reported by FCM.

20021

UnrealizedPL

Amt

N

Unrealized P&L for options and Fixed-Income.

20062

SalesSeriesNumber

String(16)

N

Reserved for account sales series identification used by custom FIX Connect vendor. It should not appear for FIX vendors that do not have it explicitly configured.

50912

LastRptRequested

Boolean

N

Indicates whether this message is the last report message in response to a request.

Valid values:

N = Not last message (by default)

Y = Last message

Start of component block, expanded in line <BalanceGrp>

20061

NoBalances

Int

N

Number of balances to follow; each represents one balance record for the account. All values are reported in the balance record’s currency, and ‘total’ values are total for that balance record (not for the entire account).

à

20063

BalanceCurrency

String(64)

C

Currency of this balance record. Must be the first field in the repeating group. Required if NoBalances > 0.

Currency format is ISO-4217-based currency code, note that cryptos use codes that are ISO-4217-style, though usually not actual ISO codes and can be longer than 3 chars.

20064

BalanceEndingCashBalance

Amt

N

This balance record’s end cash balance.

20065

BalanceTotalAccountValue

Amt

N

This balance record’s total account value.

20066

BalanceOpenTradeEquity

Amt

N

This balance record’s unrealized P&L for futures.

20067

BalanceUnrealizedPL

Amt

N

This balance record’s unrealized P&L for options and Fixed Income.

20068

BalanceMarketValue

Amt

N

This balance record’s market value of options and Fixed Income.

20069

BalanceCashExcess

Amt

N

This balance record’s cash excess.

20070

BalanceCollateralOnDeposit

Amt

N

This balance record’s amount of funds on collateral deposit.

20071

BalanceInitialMarginReqs

Amt

N

This balance record’s initial margin requirement.

20072

BalanceMaintenanceMarginReqs

Amt

N

This balance record’s maintenance margin requirement.

End of component block, expanded in line <BalanceGrp>

 

Standard Trailer

 

Y

 

 

Example: Account Data Report

8=FIX.4.2 | 9=310 | 35=UAD | 49=CQG_Gateway | 56=fix_client | 34=7 | 52=20061123-11:26:32.554 | 1=533 | 20010=Nymex_Floor | 20014=CQGACCT | 15=USD | 20020=10000000.00000000 | 20019=0.00000000 | 20018=0.00000000 | 20017=0.00000000 | 20021=0.00000000 | 20012=0.00000000 | 20013=0.00000000 | 20015=0.00000000 | 20016=0.00000000 | 20011=20000101-00:00:00.000 | 20003=AR1 | 325=N | 20061=2  | 20063=USD  | 20064= 10000000.00000000 | 20065=0.00000000 | 20066=0.00000000 | 20067=0.00000000 | 20068=0.00000000 | 20069=0.00000000 | 20070=0.00000000 | 20071=0.00000000 | 20072=0.00000000 | 20063=EUR | 20064=0.00000000 | 20065=0.00000000 | 20066=0.00000000 | 20067=0.00000000 | 20068=0.00000000 | 20069=0.00000000 | 20070=0.00000000 | 20071=0.00000000 | 20072=0.00000000 | 50912=Y | 10=142 |