Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 05:22:08 +0000



#VALUE! error on buy/sell entries

View Count: 1128

[2014-02-09 14:59:33]
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.

service log:

BuyExit signal is ignored because Long position quantity does not exist or there are already working exit orders that will flatten the position. Current Position quantity with working exit orders: -1. Current Position quantity with exit market orders: -1

SellEntry signal is ignored because a Short position exists or working order quantities indicate a potential Short position, and Multiple Entries in Same Direction is not enabled. Position quantity: -1. Position with working orders quantity: -1
Date Time Of Last Edit: 2014-02-09 15:00:54
[2014-02-10 04:56:23]
Sierra Chart Engineering - Posts: 104368
The formula was not written correctly. This is the correct format:
=AND($J$8<=0,CROSSFROMBELOW(AH3:AH5,AI3:AI5) )

Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2014-02-10 05:04:00]
Litz - Posts: 131
Yes got it straightened out. I accidentally posted the topic twice and was addressed on the other thread.

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account