Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 20:33:14 +0000
Post From: Limit v Chase Market Orders using spreadsheet
| [2019-06-11 13:37:18] |
| MotoMoto - Posts: 47 |
|
Hi Tomglib thankyou - for confirming some points and I clearly missed the obvious use of J 22/24 (doh!) its been a while since I was on SC and its good to see you are still here and your help is much appreciated. As a followup… I walked through the replays using the range bars, and discovered that the repainting of the range bars due to the gaps causes some issues. This is because the range bar that actually triggers the buy entry is then turned into 3 or 4 smaller range bars, due to the size of the gaps and the short time taken in the data fills (all within 1-2 seconds). Even allowing for some changes in the range bars being painted by changing Graph Draw Type in the chart settings it seems to be the same issue always. Hence suddenly there are multiple rows populated in the spreadsheet in one hit. Thus the original range bar entry trigger in Col K is triggered, but when the bars are repainted it is now down on row 6, but the limit order (or market order) is sent at the much higher price as showing in Row 3. The best way I can see to get around this is simply set the limit order to be based on a fixed price line (the original level I manually inputted). This will stop any crazy chasing the market, or really excessive limit prices being sent. It also eliminates any potentially funky formulas required that probably would not be much better than having to trade at market anyways. It is then highly likely that you need a double bottom of some sort to get set. (Such is trading!) I attach some thoughts and images for extra clarity if anyone was interested and came across this problem themselves. |
 Limit Orders.pdf - Attached On 2019-06-11 13:36:08 UTC - Size: 515.39 KB - 353 views |