Login Page - Create Account

Support Board

Date/Time: Mon, 27 Jun 2022 02:19:25 +0000

Where to put spreadsheet columns for background calculations?

View Count: 69

[2022-05-19 00:29:43]
User14953 - Posts: 108
I have 8 spreadsheet columns that are not graphed which are used for background calculations required for my analysis method.
They reside within columns K through Z.
I want to free up this space.

The sheet I just looked at is populated out to column GH.
Where's the best place to relocate these 8 spreadsheet columns that are not graphed so they don't interfere with the Sierrachart Studies like Moving Averages, Pivots, etc.??
[2022-05-19 14:50:07]
John - SC Support - Posts: 16924
The first thing we want to point out is that you have control over how many calculation columns there are and also where the study information will start in the spreadsheet, not to mention you can turn off whatever data you not want from studies going into the spreadsheet.

Refer to the following to control the number of calculation columns:
Spreadsheet Study Inputs: Number of Formula Columns

Refer to the following to control where the study information is started:
Spreadsheet Study Inputs: Blank Columns Before First Study

And refer to the following for how to control whether a study's subgraph data is output to the spreadsheet:
Chart Studies: Settings and Inputs Tab >> Include in Spreadsheet

Given the above, you should be able to determine what works best for your situation in terms of moving things around in order to get room to place the columns of data you want.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-05-20 01:08:41]
User14953 - Posts: 108
Thank you.
Date Time Of Last Edit: 2022-05-20 01:29:33

To post a message in this thread, you need to log in with your Sierra Chart account:


Login Page - Create Account