Database Table "hyp_TPM Open Positions"

Table Description

Open trades that the Clients has executed on the organization trading platforms

Normal Storage

All trades here

Archive Storage

No Use - should stay empty

Deleted Storage(Recycle)

No Use - should stay empty
Field Name English Title Data Type Text Length Editor Attributes
File Number Integer 0 Edit Hidden
Read Only
Key Field
Trade ID Real 0 Edit Read Only
Key Field
Open Time FixDT 0 SelectEdit Read Only
Command String 15 Select Read Only
Symbol String 25 Edit Read Only
Open Price Real 0 Edit Read Only
Volume Real 0 Edit Read Only
Last Price Real 0 Edit Read Only
Trade P&L Money 0 Edit Read Only
Swap/Cost Money 0 Edit Read Only
Total P&L Money 0 Edit Read Only
Comment String 32 Edit Read Only
Stop Loss Real 0 Edit Read Only
Take Profit Real 0 Edit Read Only
Symbol A String 15 Edit Read Only
Symbol B String 5 Edit Read Only
Symbol A Volume Real 0 Edit Read Only
Symbol B Volume Real 0 Edit Read Only
Volume in Lots Real 0 Edit Read Only
Trade P&L in Pips Real 0 Edit Read Only
Trade P&L by Symbol Real 0 Edit Read Only
Trading Account Integer 0 Edit Read Only
Last Update FixDT 0 SelectEdit Read Only
Data Source String 2 Edit Read Only
Position ID Real 0 Edit Read Only
Deal ID Real 0 Edit Read Only
Hyper Status Flag String 1 Edit Hidden
Read Only
Open Trade Convertion Rate Real 0 Edit Read Only
Commission Money 0 Edit Read Only
Swap Money 0 Edit Read Only
Commission USD Money 0 Edit Read Only
Swap USD Money 0 Edit Read Only
Total P&L USD Money 0 Edit Read Only
Spread at Open Real 0 Edit Read Only
Open Spread in Deposit Currency Money 0 Edit Read Only
Open Spread in USD Money 0 Edit Read Only
Open Trade Volume in USD Money 0 Edit Read Only
TP Open Volume Backup Real 0 Edit Hidden
Read Only
Open Time UTC FixDT 0 SelectEdit Read Only
Trading Account String String 15 Edit Read Only
Spread at Open to Deposit Currency Convertion Rate Real 0 Edit Hidden
Read Only
Spread at Open to USD Convertion Rate Real 0 Edit Hidden
Read Only
Open by Device Flag String 1 Edit Read Only
Open State Flag String 1 Edit Read Only
Jump to tables index

Database Table "hyp_TPM Closed Positions"

Table Description

Journal of trades that the Clients has executed on the organization trading platforms

Normal Storage

Trades from the last months - The system administrator decide when to move to archive

Archive Storage

Previous Years Data

Deleted Storage(Recycle)

No Use - should stay empty
Field Name English Title Data Type Text Length Editor Attributes
File Number Integer 0 Edit Hidden
Read Only
Key Field
Trade ID Real 0 Edit Read Only
Key Field
Open Time FixDT 0 SelectEdit Read Only
Command String 15 Select Read Only
Symbol String 25 Edit Read Only
Open Price Real 0 Edit Read Only
Volume Real 0 Edit Read Only
Close Time FixDT 0 SelectEdit Read Only
Close Price Real 0 Edit Read Only
Trade P&L Money 0 Edit Read Only
Swap/Cost Money 0 Edit Read Only
Total P&L Money 0 Edit Read Only
Comment String 32 Edit Read Only
Stop Loss Real 0 Edit Read Only
Take Profit Real 0 Edit Read Only
Symbol A String 15 Edit Read Only
Symbol B String 5 Edit Read Only
Symbol A Volume Real 0 Edit Read Only
Symbol B Volume Real 0 Edit Read Only
Volume in Lots Real 0 Edit Read Only
Trade P&L in Pips Real 0 Edit Read Only
Trade P&L by Symbol Real 0 Edit Read Only
Trading Account Integer 0 Edit Read Only
Last Update FixDT 0 SelectEdit Read Only
Data Source String 2 Edit Read Only
Commission Real 0 Edit Read Only
Swap Real 0 Edit Read Only
Position ID Real 0 Edit Read Only
Deal ID Real 0 Edit Read Only
Open Time UTC FixDT 0 SelectEdit Read Only
Hyper Status Flag String 1 Edit Hidden
Read Only
Close Time UTC FixDT 0 SelectEdit Read Only
Sync Status Flag String 1 Edit Hidden
Read Only
Total P&L USD Money 0 Edit Read Only
TP Open Volume Backup Real 0 Edit Hidden
Read Only
Open Trade Convertion Rate Real 0 Edit Read Only
Close Trade Convertion Rate Real 0 Edit Read Only
Open Trade Volume in USD Money 0 Edit Read Only
Close Trade Volume in USD Money 0 Edit Read Only
Commission USD Money 0 Edit Read Only
Swap USD Money 0 Edit Read Only
Spread at Open Real 0 Edit Read Only
Spread at Close Real 0 Edit Read Only
Open Spread in Deposit Currency Money 0 Edit Read Only
Close Spread in Deposit Currency Money 0 Edit Read Only
Open Spread in USD Money 0 Edit Read Only
Close Spread in USD Money 0 Edit Read Only
Trading Account String String 15 Edit Read Only
Open by Device Flag String 1 Edit Read Only
Close by Device Flag String 1 Edit Read Only
Open State Flag String 1 Edit Read Only
Close State Flag String 1 Edit Read Only
Jump to tables index

Database Table "hyp_TPM Commands"

Table Description

Requests for modifications in external trading platforms through their API. The table can contain requests initiated by Hyper or by other systems.

Normal Storage

Requests from sync process

Archive Storage

Previous Years Data

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes
File Number File Number Integer 0 Edit Hidden
Read Only
Key Field
Created On Created On FixDT 0 SelectEdit Read Only
Created By Username Created By Username String 40 Edit Read Only
Created By Module Created By Module String 10 Edit Read Only
Command Command
Values List:
--Select--
Create New User
Deposit Funds
Withdraw Funds
Modify Account's Credit
Modify Real Password
Create Demo Account
Modify Demo Password
Recharge Demo Account
Enable Trading on Account
Disable Trading on Account
Close Trading Account
Status 0 Select Read Only
Value Value Money 0 Edit Read Only
Comment Comment String 50 SelectEdit Read Only
Spare Field
Status Status
Values List:
Waiting in Queue
O.K. Done.
Error - Failed
Status 0 Select Read Only
Response Notes Response Notes String 100 Edit Read Only
Data Source Data Source String 2 Edit Read Only
Dep/Wd Purpose Dep/Wd Purpose
Values List:
NA / Unknown
Client Transaction
Bonus
Tax
Fix an Error
Trade Profit/Loss
Fee
First Deposit
Interest
Dividend
Debt Relief
Internal Transfer
Contract Rollover
Status 0 Select
Platform Processing at Platform Processing at FixDT 0 SelectEdit Read Only
DateTime UTC DateTime UTC FixDT 0 SelectEdit Read Only
Trading Account Trading Account Integer 0 Edit Read Only
Trading Account String Trading Account String String 15 Edit Read Only
Order / Ticket ID Order / Ticket ID Real 0 Edit Read Only
Account Currency String 4 Edit Read Only
Commission to Username Commission to Username String 40 PopupList Read Only
Jump to tables index

Database Table "hyp_TPM Equity History"

Table Description

This table includes the clients records for the beggining of each trading day and includes the Balance, Equity, Credit and Margin.

Normal Storage

Current Fiscal Year

Archive Storage

Previous Years Data

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes
File Number Integer 0 Edit Hidden
Read Only
Key Field
Created On FixDT 0 SelectEdit Read Only
Beginning of Day Date 0 SelectEdit Read Only
Balance Money 0 Edit Read Only
Equity Money 0 Edit Read Only
Credit Money 0 Edit Read Only
Margin Money 0 Edit Read Only
Margin Level Money 0 Edit Read Only
Data Source String 2 Edit Read Only
Trading Account Integer 0 Edit Read Only
Spare Field
Trading Account String String 15 Edit Read Only
Spare Field
Account Status Status 0 Select Read Only
Spare Field
Sync Status Flag String 1 Edit Read Only
TP Capture Time FixDT 0 SelectEdit Read Only
Spare Field
Account Currency String 4 Edit Read Only
Jump to tables index

Database Table "hyp_TPM Positions PnL History"

Table Description

This table includes the data of the end of the day and the beggining of the next day, for all of the open trades.

Normal Storage

Trades from the last months - The system administrator decide when to move to archive

Archive Storage

Previous Years Data

Deleted Storage(Recycle)

No Use - should stay empty
Field Name English Title Data Type Text Length Editor Attributes
File Number Integer 0 Edit Hidden
Read Only
Key Field
Created On FixDT 0 SelectEdit Read Only
Beginning of Day Date 0 SelectEdit Read Only
Trade ID Real 0 Edit Read Only
Command String 15 Select Read Only
Symbol String 25 Edit Read Only
Volume Real 0 Edit Read Only
Close Price Real 0 Edit Read Only
Trade P&L Money 0 Edit Read Only
Swap Money 0 Edit Read Only
Commission Money 0 Edit Read Only
Comment String 32 Edit Read Only
Data Source String 2 Edit Read Only
Trading Account Integer 0 Edit Read Only
TP Amount Backup Real 0 Edit Read Only
Hyper Status Flag String 1 Edit Hidden
Read Only
Trading Account String String 15 Edit Read Only
Open Price Real 0 Edit Read Only
Stop Loss Real 0 Edit Read Only
Take Profit Real 0 Edit Read Only
Open Time FixDT 0 SelectEdit Read Only
Jump to tables index

Database Table "hyp_Trading System Feed History"

Table Description

Price Feed sampling table, used for Accounting and Risk management reports

Normal Storage

Current Working Year

Archive Storage

Previous Years

Deleted Storage(Recycle)

Not in use
Field Name English Title Data Type Text Length Editor Attributes
System Name String 2 Edit Hidden
Key Field
Sample Time (GUTS) FixDT 0 SelectEdit Read Only
Symbol Name String 25 Edit Read Only
Bid Real 0 Edit Read Only
Ask Real 0 Edit Read Only
Tick Time FixDT 0 SelectEdit Read Only
Jump to tables index

Database Table "hyp_Trading System Feed VaR"

Table Description

Daily Summary of Price Feed sampling table, used for Accounting and Risk management reports

Normal Storage

All Data Stored Here

Archive Storage

Not In Use

Deleted Storage(Recycle)

Not In Use
Field Name English Title Data Type Text Length Editor Attributes
Created On FixDT 0 Edit Read Only
Key Field
For Date Date 0 SelectEdit Read Only
Symbol Name String 25 Edit Read Only
First Sample Real 0 Edit Read Only
Close Price Real 0 Edit Read Only
Low Real 0 Edit Read Only
High Real 0 Edit Read Only
Daily Read from TP (UTC) FixDT 0 SelectEdit Read Only
Close Spread Real 0 Edit Read Only
Low Spread Real 0 Edit Read Only
High Spread Real 0 Edit Read Only
First Sample Time FixDT 0 Edit Read Only
Last Sample Time FixDT 0 Edit Read Only
Exposure Symbol A String 15 Edit Read Only
Exposure Symbol B String 5 Edit Read Only
Calc from feed table (UTC) FixDT 0 SelectEdit Read Only
Jump to tables index