# Account Analytics

The Account Analytics provides analysis of a specific account. The fields for the Account Analytics table are:

**Table Name:&#x20;*****AccountAnalytics***

| **Column Name** | **Data Type** | **Valid Values** | **Allow Nulls** | **Description**                           |
| --------------- | ------------- | ---------------- | --------------- | ----------------------------------------- |
| FK\_AccountID   | bigint        |                  | No              |                                           |
| SharpeRatio     | decimal       | ((0))            | Yes             |                                           |
| MaxDD           | decimal       | ((0))            | Yes             |                                           |
| LastMonthReturn | decimal       | ((0))            | Yes             |                                           |
| YTD             | decimal       | ((0))            | Yes             |                                           |
| LastUpdatedTime | datetime      | (getutcdate())   | Yes             | The time when the last update took place. |
