Support Board

Date/Time: Tue, 14 May 2024 23:48:17 +0000

Post From: Cross above negative value??

[2017-03-24 00:09:53] Link To Thread - Link To Post [Go To First Post]
tunah - Posts: 16
There definitely is no bug. You just need to understand that the CROSS functions use the actual values and perform no rounding like you visually see in the outputted/displayed values of the study. This is well documented here: Study/Chart Alerts And Scanning: The Effect of the Value Format on Identifier Values The CROSS function still wouldn't work so I had to use the formula bellow =AND(ID3.SG1[-1] < -0.099 , ID3.SG1[0] > -0.099 ), and I'm using -.099 since -.1 wouldn't work. I'm still making it work for me but if you happen to have the time at some point, you might want to take a second to look at it, the said formula with the Linear Regression Slope study. Could the fact that I'm using SC on Mac have anything to do with this behaviour? The CROSS function works fine with positive values and LR regression. You can control the limit order prices through these cells: https://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#LimitPrices Yes, that's what I referenced to arrive at this logic: =B3 +/- x(currency equivalent of ticks) and it works fine, my question was wether one could use something like "2 ticks" in a spreadsheet instead of say .50 for the /ES for example. I imagine one could coding a custom advance study? Thanks for your help!