Support Board
Date/Time: Mon, 25 Nov 2024 15:15:03 +0000
[User Discussion] - VALUE! error
View Count: 1484
| [2014-02-09 14:55:01] |
| Litz - Posts: 131 |
|
Trying to add a check for position condition prior to buy/sell entry formulas. ie =AND($J$8<=0),CROSSFROMBELOW(AH3:AH5,AI3:AI5) but get a #VALUE! error result on entering the formula Trying to eliminate trades entries being ignored resulting reversals ie should have reversed long, signal ignored, short remains and is covered some time later for loss. |
| [2014-02-09 15:06:16] |
| Sawtooth - Posts: 4120 |
|
Two things: 1) Parenthesis position needs correction: =AND($J$8<=0,CROSSFROMBELOW(AH3:AH5,AI3:AI5)) 2) Make sure there are data in columns AH and AI. |
| [2014-02-09 15:38:15] |
| Litz - Posts: 131 |
|
Thanks for the formula correction. New to spreadsheets and formulas but learning quickly. I don't know how to make sure there is not data in columns AH and AI. |
| [2014-02-09 15:50:10] |
| Sawtooth - Posts: 4120 |
|
You'll get a #VALUE! error if there are no data in columns that the CROSSFROMBELOW function references. Scroll the spreadsheet to the right and see what columns your study is outputting data to. You may need to edit the formula to reference the correct columns, or rearrange the order in the Studies to Graph list. Studies output to columns AA and above (when the default Number of Formula Columns is 16). If you add, remove, or rearrange studies in the Studies to Graph list, the output columns will change. |
| [2014-02-09 16:41:37] |
| Litz - Posts: 131 |
|
OK, misunderstood your reply. The data in those columns is correct. Down to just a few buy entries being ignored. Big improvement!! Auto-Trading: Replay 2880.0X: ES-201403-GLOBEX 1.50 Range #1 | YYYYYY | BuyEntry signal is ignored because Short position quantity or working Sell order exists. Position with working orders quantity: -1. | Bar Start Time: 2014-02-07 10:46:44. Order didn't show on chart, orders and positions, or activity log, although they show on the Alert Manager as being TRUE. Allowing entry with working orders to Yes has no effect. Only Yes are "Signal Order on Bar Close" K,L&M,N. |
| [2014-02-09 17:10:26] |
| Sawtooth - Posts: 4120 |
|
Try also setting 'Cancel All Orders On Entries and Reversals' to Yes. Here's a link to the documentation: http://www.sierrachart.com/index.php?l=doc/doc_SystemsAlerts.php#SystemInputs |
| [2014-02-09 19:46:37] |
| Litz - Posts: 131 |
|
Yes, I read that several times and tried various combinations over the past several days, but none seem solve the problem. Cancel All Orders on Entries and Reversals' has no effect. Although the alerts arrows show on the chart, no corresponding entries show on the Alert Manager. Sell entries and exits work fine. I guess the arrows represent just K/N. The L/M formula does not register TRUE while the K/N does =AND($J$8<=0,CROSSFROMABOVE(AH3:AH5,AI3:AI5)) L/M Short trades results are registering off K/N Date Time Of Last Edit: 2014-02-09 19:48:09
|
| [2014-02-09 19:58:56] |
| Litz - Posts: 131 |
|
Looks like enabling Support Reversals and Cancel All Orders on Entries and Reversals solved the problem. Thanks for your help and time. Starting to get the hang of this with the excellent help from the Support Board. |
To post a message in this thread, you need to log in with your Sierra Chart account: