Account Daily Return Detail
The Account table details the account description of the Slave with respect to the Master accounts. The fields for the AccountDailyReturnDetail table are:
Table Name: AccountDailyReturnDetail
Column Name
Data Type
Valid Values
Allow Nulls
Description
PK_ID
int identity
No
This field consists of unique IDs of the account, which is further used in various other tables in database.
AccountID
bigint
No
This field states the Account ID of a slave (or follower) in the Tradesocio environment generated by TC.
Balance
decimal
((0))
No
The field lists the balance, i.e., the amount of funds in an account after the closing of all trades.
Equity
decimal
((0))
No
This field lists the equity, i.e., the amount of funds in an account that includes all open trades.
DDCalcBalance
decimal
Yes
DDCalcEquity
decimal
Yes
MaxDDPercentForDay
decimal
((0))
No
This field lists the maximum drawdown, i.e., the decline of investment from peak to dip in a day. It is calculated as a percentage of the peak value.
EOD_DDPercent
decimal
((0))
No
End of the Day Drawdown percent
VAMI
decimal
((0))
No
This field lists the VAMI, i.e., a measure to track the monthly performance of an investment.
ReturnPercent
decimal
((0))
No
Return value in percentage.
BrokerTime
datetime
(getutcdate())
No
This field specifies the time when deductions and update occur in the table in a day.
LastUpdatedTime
datetime
(getutcdate())
No
The time when the last update took place in this specific table.
PNL
decimal
((0))
No
This field lists the realized Profit and Loss, i.e., the loss or profit has been added to the equity as the transaction is completed.
AUM
decimal
((0))
No
This Sum of current allocation for all slaves under a master.
Credit
decimal
((0))
No
Not in use
isEOD
int
((0))
No
0 = The current day status is not yet updated and will get updated by end of day.
1 = The previous day status is updated.
Last updated
Was this helpful?