Database Table "hyp_Trading Systems List"

Table Description

The trading platform definitions table (exposure and coverage) connected to Hyper. After changing definition in this table, it is recommended to reset the relevant automation (via Hyper Client), in order to verify that the definitions were fully implemented.

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
Data Source String 2 Edit Mandatory
Key Field
TP Friendly Name String 15 Edit Mandatory
System Purpose Status 0 Select Read Only
Platform Type String 3 Edit Read Only
Time Zone String 50 Select Mandatory
Mark to Market Hour UTC Hour 0 Edit Mandatory
Connected to Hyper Database String 40 Edit Read Only
Broadcast Realtime data on Channel # Integer 0 Edit
Server URL String 80 Edit Mandatory
Backup Server URL String 80 Edit
Integration App Username String 30 Edit Read Only
Control Client Accounts Bool 0 Select Read Only
Control Balance Orders Bool 0 Select Read Only
Control Deals / Positions Bool 0 Select Read Only
Copy Fields from CRM to TP String 150 GroupSelect
Create New Real Accounts As Read Only Bool 0 Select
Create Trading Account Convert Client to Real Bool 0 Select
Default Account Currency String 4 Select Read Only
Default Account Group String 50 PopupList
Default Account Leverage Integer 0 Edit
TP Next Login Value Integer 0 Edit
Deposit for New DEMO Account Integer 0 Edit
Block Accounts with EMail from Domain String 150 TextMemo
Log Instruments Daily Events Bool 0 Select
Exposure must be Covered (Abook) Bool 0 Select
Filter Accounts by Groups String 200 Edit
Import New Symbols into "Deleted" storage Bool 0 Select
Analytics Currency String 4 Edit
Margin Level Alerts Under Integer 0 Edit
Missing Feed Alerts Bool 0 Select
Alert when "Deleted" account open new trade Bool 0 Select
Jump to tables index

Database Table "hyp_Trading System Symbols"

Table Description

One table for all financial instruments available to dealers (customers), in all trading platforms linked into the current database.

Normal Storage

Current Active instruments

Archive Storage

Instruments that were legal in the past !

Deleted Storage(Recycle)

Instruments that should be declined by Hyper are stored here
Field Name English Title Data Type Text Length Editor Attributes
Symbol Name String 25 Edit Key Field
Description String 100 Edit
Type Status 0 Select
Contract Size Real 0 Edit
Tick Price Coefficient Real 0 Edit
Primary Bool 0 Select
Exposure Symbol A Acquired Asset String 15 Edit
Exposure Symbol B at Currency String 5 Edit
Bid Real 0 Edit Read Only
Ask Real 0 Edit Read Only
Last Update FixDT 0 SelectEdit Read Only
Trading Status Status 0 Select Read Only
Created On FixDT 0 SelectEdit Read Only
Swap Type Status 0 Select
Swap Long defined by Type Real 0 Edit
Swap Short defined by Type Real 0 Edit
Alert Feed after # Seconds Integer 0 Edit
Alert Feed Priority Integer 0 Edit
Follow TP String 2 Select
Exist on TP String 30 Edit Read Only
Margin Currency String 4 Edit
TP Types String 20 Edit
Regulation Trading Status Status 0 Select
Bg Color Integer 0 Edit
Jump to tables index

Database Table "hyp_Trading System Symbols Translation"

Table Description

One table to all financial instruments in which the organization trade on outward Brokers (or Banks).
The goal is to adjust the settings of the broker financial instruments in terms of the organization, to perform calculations.

Normal Storage

All records here

Archive Storage

No Use

Deleted Storage(Recycle)

No Use
Field Name English Title Data Type Text Length Editor Attributes
System Name String 20 Edit Hidden
Mandatory
Key Field
S.N. Function Status 0 Select
Symbol Name String 25 Edit Mandatory
Type Status 0 Select
Contract Size Real 0 Edit
Exposure Symbol A String 15 Edit
Exposure Symbol B String 5 Edit
Jump to tables index