Support Board
Date/Time: Fri, 07 Nov 2025 03:51:38 +0000
Post From: Handling Stop and Limit orders with the Spreadsheet for trading
| [2025-11-05 13:18:22] |
| Fabio - Posts: 129 |
|
Good morning SC support! I am running in some technical issue, and I am banging my head against a wall... I am trying to automate a strategy with the use of the Spreadsheet System for Trading. I read all the documentations and all, yet I cannot find an answer to my challenge; I want the spreadsheet to fire off not only the entry with a predetermined size, but also a stop loss and target price at a specific price level (i.e. 6912.25 for target and 6864.25 for stop considering a long at 6876.50) Now, I am using the "Use column I and J values Version 2" set to yes, and there is no documentation for that but just for the version one, so I have to reverse engineer all of those cells. Why have I decided to use the version 2 in the first place is a mystery considering that all documentations are for version 1 but this is an argument for another topic (please update the documentation also for version 2 lol!). Now, I figured out how to place the entry limit order as well as the stop order using column L - Buy Exit (Sell). I was able to do this by setting Cell J74 (old J72) to "S" for Stop order, the price I wanted the stop to be in cell J79 (old J22) and with the use of the "AND" function column L for the formula to handle the position quantity in Cell J31 (old J8). This seems to work just fine. However, I couldn't figure out a way to handle the target for the exit with the use of a limit order (sell limit at xyz above the entry price or buy limit "xyz" below current price). I asked the chat gpts and all but I just couldn't figure that part out. Can you please help me figure out how I can handle both stop and target with the use of stop and limit orders? At least pointing me out to the documentations in a way I can handle the workflow because I got lost in it. Thanks and kind regards, Fabio. |