Support Board

Date/Time: Mon, 06 May 2024 16:18:34 +0000

Post From: Spreadsheet Multiple Entries

[2019-06-25 16:32:33] Link To Thread - Link To Post [Go To First Post]
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?