ONHOLD TRADES

How the application works ?

1. OnHold trades will holds the trades when the trades needs to fired. Once it fires it ensures all the trades are moved out of the OnHold trades.

2. If a trade depends on the condition should ensure that the threshold is passed or is more than threshold. If it more it immediately moves all the trades. In the onhold trades.

3.Onhold trades ensures that trades are fired when a particular price is below the price, we should ensure that the threshold is passed.

OnHold_Trades holds the following details in its table.

COLUMN	TYPE	PURPOSE
ID	INTEGER	NEED LESS TO SAY
ASSET_ID	INTEGER	Assetid that trade needs to be fired.
RULE_ID	INTEGER	RULE ID THAT ORDERED THIS GRADUAL TRADES
KEYWORD	VARCHAR/STRING	TRADE THAT WOULD BE BOOKED UNDER THIS TRADE.
SUB_KEYWORD	VARCHAR/STRING	Subkeyword that is ordered under this category.
PRICE	FLOAT	Price that has reached.
QUANTITY	INTEGER	Quantity that should be ordered to the broker website.
ORDER_ID	INTEGER	After order is placed it would be updated.
LOCATION	INTEGER	Before order has been placed.
TIME	TIMESTAMP	WHEN ORDERED.

AUDIT LOG has two entries :

1. THRESHOLD_PASSED_TODAY is Daily entry.

2.Single entry THRESHOLD_PASSED_TODAYS_VALUE; Should be available.

AuditLog is the place that holds the total trade that has been fires so far, if the trade are booked out side the minimum limit it directly updates the trade and change the data at

Column	Value it should hold	Reason/Description
DETAIL	THRESHOLD_PASSED_TODAYS_VALUE	Fixed
OLD_Value	FLOAT	Changed by 2 functions in AuditLogService · TotalValueInThreshold- Total Traded value · UpdateThreshold this updates the trade done so far.
NEW_VALUE	“ “	EMPTY
FOREIGN_ID	-387781	IGNORE THIS JUST NOT TO GET EXCEPTION.

How to find where number of trades that has been booked:

Column	Value it should hold	Reason/Description
DETAIL	THRESHOLD_PASSED_TODAY	Fixed
OLD_Value	“ “
NEW_VALUE	dd-MM-yyyy	When the limit has crossed, this will help us know when the last limit was crossed.
FOREIGN_ID	-387783	IGNORE THIS JUST NOT TO GET EXCEPTION.

How Matching works ?

Once the order is placed (BROKER WEBSITE)then an entry is made on order_id in ONHOLD_TRADES.

CASE 1: NO TRADE IS EXECUTED

• ORDER_ID is removed with NULL

CASE 2: PARTIAL QUANTITY EXECUTED

• ORDER_ID is removed.
• quantity unexecuted are put in QUANTITY.

CASE 3: FULLY EXECUTED

• Remove the row completely.

Once the whole orders are matched we then check what is remaining in the ONHOLD_TRADES and addup SUM(( quantity * price )) goes into

AUDIT_LOG – THRESHOLD_PASSED_TODAYS_VALUE

Can i trade any thing below LIMIT ?

Yes, we can trade offline, once we trade offline trade or non gradual trades it just updates the limit table and trigger a check, if total is cross then it fires rest all trades are fired that moment only.