Support Board
Date/Time: Wed, 30 Apr 2025 14:54:17 +0000
Post From: SC Automatically Adjust Trade Target/Stop Parameters Before Trade Is Entered?
| [2025-04-10 14:53:34] |
| absorrel4 - Posts: 100 |
|
I like the Trade Management by Study! However, I have one issue that I can not seem to solve. Within my Spreadsheet ("Spreadsheet System for Trading") I create a formula that provides the target and stop levels by adding/subtracting the Average True Range from the bar closing price. I can get the "Trade Management by Study" to reference my Spreadsheet study and subgraph (i.e., where my target and stop levels are calculated), and it appears to work. HOWEVER, I would like to create a formula in my Spreadsheet that has the target and stop levels calculated from my actual fill price (not the bar closing price). I can not seem to do this. I tried adding the study "Trading Position Average Price" to my list of studies so that it shows up in my Spreadsheet. I then reference this "Trading Position Average Price" cell when doing my target and stop calculations within the Spreadsheet. But, the Spreadsheet formula does not work when I do this. When I get a fill in a long or short position, the Trading Position Average Price shows up in the spreadsheet, but my stop/target formulas will not use the fill price cell...my formula immediately ignores the fill price and does the calculation as if the fill price was zero. The result is that the ATR becomes the target/stop level because the Average Fill Price is zero...and my position gets immediately exited within SC. This all happens in a micro-second. I tried moving the "Trading Position Average Price" study up within my list of studies so that it will appear in earlier cells within my Spreadsheet. My hope was that would (somehow) affect the sequence of how things were being utilized within the SC Spreadsheet...but it did not help. Any suggestions for how to get the Trade Management by Study to utilize my actual fill price? |