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 |