Account Metrics Per Master Slave

The Account Metrices Per Master Slave table details the account description of the Slave with respect to the Master accounts. The fields for the Account_MetricesPerMasterSlave table are:

Table Name: Account_MetricesPerMasterSlave

Column Name	Data Type	Valid Values	Allow Nulls	Description
PK_ID	int identity		No	It is a unique ID.
AccountID	bigint		No	This field states the Account ID of a slave (or follower) in the Tradesocio environment and is referenced from the Accounts table.
MasterAccountID	bigint		No	This field lists the Account ID of the Master whom the slave is following and is referenced from the Accounts table.
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.
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.
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.
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.
UPNL	decimal	((0))	No	This field lists the Unrealized Profit and Loss, i.e., the loss or profit has occurred on paper, but the transactions are not yet completed.
LastUpdatedTime	datetime	(getutcdate())	No	The time when the last update took place in this specific table.