Support Board

Date/Time: Thu, 02 May 2024 15:10:02 +0000

Post From: Custom reset using ACSIL

[2016-02-24 04:31:06] Link To Thread - Link To Post [Go To First Post]
User713273 - Posts: 409
Hi SC Support, Say I want to reference column E which is last trade price utilizing the second chart, and I want to have a .15 cent reset, for instance if I enter a buy entry trade at 95.00, I would not receive any more buy entries in the spreadsheet until that trade hit 94.85 in column E or a reversal/sell entry was triggered. If I entered a Sell Entry at 95.00, I would not receive any more sell entries in the spreadsheet until that trade hit 95.15 in column E or a reversal/buy entry was triggered. One caveat, once the trade progresses, say the 95.00 buy entry trade goes to 95.01 the new reset price would be 94.86 and so on, the exact inverse for the sell entry trade. Could this be done programmatically and if so any direction towards SC documentation would be great. I tried to do this via a formula in the spreadsheet itself but was having issues because some alerts were ignored but recognized by the formula.