Support Board
Date/Time: Thu, 16 Jan 2025 09:01:49 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
| [2016-03-18 15:52:17] |
| User791263 - Posts: 151 |
|
Thanks Tom. SC might want to capitalize on this, their unique intrabar entry capability, carefully, however. I think they prematurely designate "User Discussion" sometimes. Clarifying, Tom, I am not exiting within the Buy Entry bar. I THINK S.C. said that the spreadsheet posts only the end-of-bar (EOB) bar trade-status in the row. That's what I am seeing and testing. That is, SC said the spreadsheet will not show the "true" (1) in the row when the end of bar condition is not true, even if it was briefly true and a trade occurred, with my settings. I see the same in regard $J entries; It seems to follow that same spreadsheet rule. That is, I see trades happen on my chart and Trade Activity Log>Trades, and appear in top of the Trade Window, but no "1" in the row in which it occurred. Unless you have my exact settings above, you won't see the true appear, the trade happen,and the "1" not appear at EOB & No Position in J8 (though there IS a position). Current Position quantity $J$8 obviously reflects the sum of Order quantities per bar from each "true" row, added together, which is correct ONLY if EOB status in K-col is "1". Because it isn't in this rare instance, $J$8 seems to not match actual positions elsewhere. I've seen it several times now. Nor can L-Exits detect it. That's why/how this investigation began (my first post). In this case, the L-Exit formula can't look back how many rows for entry, or anything but fly manual over-ride via attached orders, or use L-col blind (conditions of current bar). I've seen it. I know the trade does not get into $J$8. I will verify it in slow-mo this weekend. S.C.'s advantages include Speed & Flexibility, to instantly get into a trade this way. So PLEASE, SC, don't "fix it", unless by adding a Trade Spreadsheet setting to choose: "Update J-Col Positions/Entry price from Actual Trade Log" and include a new J- field for "Bars since Last Long Entry" Even smarter would be to do that automatically for my Trading Spreadsheet settings. If I confirm this, the above will become a Feature Request. |