by canuk » Fri Nov 06, 2015 7:54 pm
Dilemma using STOPLOSS In the Excel command line.
Hi Gavin:
I notice this has been a topic, prior to the availability of Excel, so posting my experience here, rather than a new topic. I know how busy you are, and if this maybe a major programming. I only raise again to enlighten, Excel users to the issue.
I would like to use the OFFSETx to escape a BACK order if it is beginning to fail, but do NOT want it to trade out, if it goes on to win.
As Cymatic requires an OFFSETx to enable STOPLOSx, to function. AND
While it is possible to calculate a max. offset, based on "Asking Price".
The OFFSET value has to be rational, otherwise the order fails. (cannot result in an offset <1.01)
e.g. putting an offset of 999 fails to execute (programming this might be quick work around option??)
The actual "Matched Price" can be far higher, even higher than the "Order @ Price", in a volatile market.
This results in a premature market exit, at the OFFSETx of a winning choice.
Using the "Last Matched Price" to calculate the max offset is also questionable.
As a workaround I have tried using detection logic to initiate a "GREEN" order as a defence, but the delays, in keeping the status cells clear, for this to be immediately are not very effective. It would be far for effective if this could be locked in with the initial order, with Cymatic.
If it was possible for Cymatic to accept a stoploss request without the offset, and to be effective at whatever the "Matched Price" was settled at, it would be GREAT.
Regards
Bob