Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 10:17:34 +0000



Spreadsheet Multiple Entries

View Count: 1077

[2019-06-25 16:32:33]
User714077 - Posts: 2
I've built an auto trading spreadsheet that creates lines from various hi and low bars. The idea is to enter short when crossing the bottom line, and go long when crossing the hi. This all works fine.

I would like to have the ability to have multiple entries, ie as price moves up and a new line is created an crossed, we add on to the position.

Again this is working fine and as expected.

The problem is, if price is hovering around the hi trigger line, I get multiple entries at the same level on subsequent bars. I would like to only have one entry per level.

So, price crosses level=buy, do not buy again until crossing a new level.

I'm using crossfrombelow as the main signal. Is there a way to have a cell record that crossfrombelow has fired on a given bar, even though it may have crossed back and therefore not been recorded?
[2019-06-25 21:03:57]
Sierra Chart Engineering - Posts: 104368
See if this method here would help:
Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition
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
Date Time Of Last Edit: 2019-06-25 21:04:26

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

Login

Login Page - Create Account