Support Board
Date/Time: Sat, 23 Nov 2024 23:34:40 +0000
Post From: Spreadsheet trading not firing off orders although conditions ar
| [2013-04-02 15:16:06] |
| TheOddsAreYouDontKnowTheOdds - Posts: 29 |
|
OK, I think I figured it out (exactly 5 minutes after I sent the help message!). I found this in your DETAILED documentation. "When using the Spreadsheet System for Trading study and a formula returns TRUE in the Buy Entry (K3), Buy Exit (L3), Sell Entry (M3), or Sell Exit (N3) cell, a trade signal is not necessarily going to be given. You will see an arrow on the chart indicating a buy or sell signal, assuming the corresponding Subgraph Draw Style is set to a visible style. However, this does not necessarily mean that the formula TRUE result will be followed and a trade signal will be given. The BuyEntry (K), BuyExit (L), SellEntry (M), SellExit (N) Spreadsheet Order Action Columns rules must be met and the additional conditions imposed by the related study Input Settings must be met, for a trade signal to be actually given. If one is ignored, then a message will be added to the Trade >> Trade Service Log indicating the reason. Please review that log for the reason. To see on the chart the actual filled orders from trades made, refer to Displaying Filled Orders. When using either the Spreadsheet System for Trading or Spreadsheet System/Alert studies, the TRUE signals given from cells K3 through Z3 may not always be followed and give an alert or trade signal, even though they still return TRUE or a non zero value and an arrow shows on the chart. If a cell is TRUE and there is a new bar 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 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. If you have the Signal Only On Bar Close (Column K,M) input set to Yes, then a TRUE signal will be ignored on cells K3 and M3, and only the cells K4 and M4 will be monitored for signals. Likewise with the Signal Only On Bar Close (Column L,N-Z) input. In all these cases, when a signal is ignored, there is no message added to the Trade Service Log or the Alerts Log, except in the case of the Spreadsheet System for Trading study when the signal has been ignored as the result of Signal Only Once Per Bar ." |