Login Page - Create Account

Support Board


Date/Time: Mon, 22 Dec 2025 23:39:02 +0000



Post From: spreadsheet help

[2025-11-10 20:29:45]
John - SC Support - Posts: 43584
You have a circular reference occurring. You are taking the data from Cell K, then having a study doing a Standard Deviation on it, and then looking for that data back in the spreadsheet and then manipulating it.

Do not use the "Standard Deviation" study, rather use one of the "STDEV()" functions in the spreadsheet itself. Refer to the following:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#STDEV_Function
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing