Support Board
Date/Time: Thu, 16 Jan 2025 09:01:31 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
| [2016-03-18 14:57:17] |
| Sawtooth - Posts: 4153 |
|
Note: I'm not SC Support; I am only an experienced spreadsheet study user. Since SC Support marked this as User Discussion, I am offering tips/suggestions. Buy Entries that Fill, but don't then show in the Spreadsheet make it impossible to ever find actual Positions if the intrabar fills don't get posted into $j$8 or the last entry price in J-col.
J8 is realtime; it never holds any prior value. J48 only holds the most recent entry price, but nothing historical.To see historically the intrabar trades on the spreadsheet, you might try using one of the Trading: ... studies, however, these will only update at close of bar. Positions on the Trade Window & Positions Window will not agree with the Spreadsheet
I've never found this to be true. Data in these are from the chart occurrences, not the reverse.What you want to do might not be possible with a spreadsheet study, especially when scalping intrabar on a 10 second chart. |