Login Page - Create Account

Support Board


Date/Time: Wed, 01 Jan 2025 14:01:11 +0000



J column copy across sheets

View Count: 775

[2016-05-19 09:52:47]
phaedonk - Posts: 352
Is there an easy way to copy the J column across multiple sheets? I have a spreadsheet where I am tracking 15 markets. Most of the logic in the formula source sheet's J column also applies to the others (e.g. time to disable auto trading etc.). The few that have special settings I will gladly change by hand.
It is my understanding that the J column will not automatically copy to other sheets (which is the right way for sure) but I am looking for a hint of an alternative way maybe.
[2016-05-19 17:49:28]
Sierra Chart Engineering - Posts: 104368
If you want to copy the final formula result you could use a cell reference:

http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#CellandRangeReferences

We will also look into adding an option to control whether to copy the J column from the Formula Source Sheet.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-05-19 18:17:35]
Sawtooth - Posts: 4144
We will also look into adding an option to control whether to copy the J column from the Formula Source Sheet.
+1

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

Login

Login Page - Create Account