Support Board
Date/Time: Wed, 27 Nov 2024 08:42:08 +0000
Post From: Exploring the Reverse Function In Spreadsheet Trading
| [2014-07-22 11:30:33] |
| infpz - Posts: 826 |
|
Thanks for the responses.SC is this the relevant portion? If a cell is TRUE and there is a new bar added to the chart and the cell continues to be TRUE, because the state is already TRUE, you will not get a new signal unless the input Reset Condition on New Bar is set to Yes. If a TRUE signal has been given by the formula in a particular cell and then it goes back to FALSE and back to TRUE on the same bar, you will not get a signal if Signal Only Once Per Bar is set to Yes. I already have both of these set to "No" so I assume some actual reprogramming is needed as described below: In the case of the Buy/Sell Exit Order Action columns when using the Spreadsheet System for Trading study, if an Exit formula is TRUE before there is a Trade Position and then a Trade Position later exists, then it is going to get ignored until it goes back to FALSE and then to TRUE. Therefore, you need to program the formula to remain FALSE until there is a position. One way to get an understanding of how the TRUE signals in K3, L3, M3, N3 are processed is to do the following: Remove the formulas from the K3, L3, M3, N3 cells on the specific Sheet in the Spreadsheet window you are working with. Start a chart replay at a relatively slow speed. For example, on a 1 minute chart you may want to use 20 to 30 times. Enter a 1 in cell K3, L3, M3, or N3 to simulate it becoming TRUE. Enter a 0 to clear that state Or is "allow opposite entry with opposing entry or position" the issue as suggested by User021827? Thank you for your assistance! |