Table Name: Account
Provides access to the Trading Accounts for a user.
Allows viewing the Trading Accounts available to the user.
|Account||String||IS, IN||The unique identifier of the Trading Account.|
|Name||String||The friendly name of the Trading Account.|
|Source||String||The name of the data feed the Trading Account comes from.|
|Currency||String||The default currency for the Trading Account.|
|FeedStatus||String||Overall status of the data feed for this Account. One of:
Initialising: Feed is establishing, and will be online shortly.
Active: Feed is active and online.
Closed: Feed is active, but outside hours.
Inactive: Feed is offline, and outside hours. Data may be unavailable.
Impaired: Feed is unexpectedly offline, and data may be stale or unavailable
Select all Trading Accounts for the user:
SELECT * FROM Account
Select the details of a specific Trading Account:
SELECT * FROM Account WHERE Account = '123ABC'
Select the details of a set of Trading Accounts:
SELECT Account,Name FROM ACCOUNT WHERE Account IN ['1001[Demo]', '1002[Demo]']