Return to 連接 EXCEL

用外置程式 控制策略

用家可以自己寫程式(例如 VBA,JAVA,C#) 從外部控制 SPARK 的 策略. 方法是用家的程式把策略的參數寫入一個簡單的文字檔.

檔案名每天不同. 定為 ExtStrategies-YYMMDD.txt 如今天日期是 2017年 1 月 10 日, 檔案名便是 ExtStrategies-170110.txt 這檔案要放在 SparkSetup 資料夾內的 ORDERS資料夾內


Name=External Strategies File
Description=External Strategies File


[Modify Strategies]

[Delete Strategies] 



例如要增加一個新限價策略, 只需加一行在 [Strategies]下面

20170110-001=Type=BARRIER~Product ID=HSIZ5~Is Simulation=FALSE~Is Bullish=NO~Barrier=21770~Take Profit Adj=20~Stop Loss Adj=40~Not Filled Cancel Seconds=55~Quantity=-1~Open Toler=-40~Close Toler=4~Start Time 1=09:15:00~End Time 1=11:57:00~Force Close Time 1=11:58:00~Start Time 2=15:58:00~End Time 2=16:10:00~Force Close Time 2=16:12:00~Start Time 3=23:25:00~End Time 3=23:30:00~Force Close Time 3=23:40:00~After Loss Wait Seconds=300~After Profit Wait Seconds=60

The above is a very long line, make sure you drag to the right most to see all of it.  The blue part is a unique ID you give this strategy. The ~ symbol is a separator between each field. Each field is in the format of Field_Name=Field_Value

The field Type=BARRIER specifies the type of the strategy. Different types of strategies contains different fields. e.g.

For Barrier, this field means a bearish barrier strategy: "Is Bullish=NO"
Most strategies supports this field "Take Profit Adj=20" which means to place an OCO Stop Loss order of taking 20 points profit.  The Stop Loss Level is specified by the field "Stop Loss Adj=40"

Copy Fields to Clipboard

There is a button "Copy Fields to Clipboard" in every strategy. Clicking it will copy the field values of the current strategy user controls to the clipboard, which you can then paste to add Strategy Text Control file. You can use it to learn the field names and format of this strategy.

Feedback File

Your program or Excel VBA can constantly read back the feedback file ExtStrategies_Feedback-YYMMDD.txt  (e..g. SparkORDERSExtStrategies_Feedback-151210.txt )

Name=External Strategies Feedback File
Description=External Strategies Feedback File

20151509-009=[Feedback]~Status=Active~Status At=15-12-10 09:49:52.775~~

This file will be updated when Spark receives or rejects your new Strategy.  If the new strategy is accepted, the feedback line will be like

20151509-009=[Feedback]~Status=Active~Status At=15-12-10 09:49:52.775~~


If the addition is rejected, an audio warning will be played and the feedback line will be like:

20151509-010=[Feedback]~Status=ERROR~Error=Cannot find Subscribed Ticker Product "HSIH6"~Status At=15-12-10 09:54:28.860~~

In the above example, the product code is HSIH6 which is not on the Spark Subscription List, so it cannot find it and rejected the new strategy.


Modify Strategy

If you want to modify the Barrier price level, add a line under [Modify Strategies] e.g.

The blue part is a unique number that you give to each modification. Even it you are modifying the same strategy for the second time, you need to give a new unique number.

The modification will be shown in the feedback file, under [Strategies]

20151509-009=[Feedback]~Status=Triggered Open~Status At=15-12-10 09:57:51.604~Modify History=001~~[Feedback-Open]~Order ID=2C5-095751.12709

Once an Open Order is triggered, you cannot modify the strategy fields except  Take Profit Adj and Stop Loss Adj and Close Toler.

However, you can modify the open order via Spark User interface or External Order Control by specifying the Order ID given to you in the feedback.


Delete Strategy

To delete a strategy, add a line under [Delete Strategies] , put = after the Strategy ID.  e.g.

[Delete Strategies]

Check the feedback line of  [Delete Strategies] for the deletion status

[Delete Strategies]
20151509-013=[Feedback]~Status=DELETED~Status At=15-12-10 15:28:39.841~~


Click here for External Order Control Details

Click here for Other Functions of Spark

You can see our demo videos on this youtube channel 
Email us at or whatsapp 3502 1457 or LINE (Line ID: spark-spapi) to get a FREE TRIAL

Line ID : spark-spapi


If you are a futures/securities broker, contact us for cooperation in promoting program trading.