Login Page - Create Account

Support Board


Date/Time: Tue, 03 Mar 2026 07:02:00 +0000



Post From: spreadsheet help

[2025-11-10 20:29:45]
John - SC Support - Posts: 44891
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