Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 17:46:36 +0000



Spreadsheet Formulas Disappearing

View Count: 2906

[2014-09-04 23:36:30]
User16114 - Posts: 153
Using the Cumulative Sum of Study on the Volume study in a spreadsheet. Column AD provides the sum I want to put on a chart as a custom study. When I put the formula in column K (Draw Style: Line) referencing the cells in column AD, the column K results are correct but the Line does not appear on the chart. As well, the column K formulas have disappeared when I come back to the spreadsheet.
[2014-09-05 05:21:29]
Sierra Chart Engineering - Posts: 104368
Refer to Formula Source Sheet Number about this here:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#FormulaSourceSheetNumber

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
[2014-09-05 09:39:57]
User16114 - Posts: 153
The Formula Source Sheet is #1 (from D1 on Sheet20) for a Spreadsheet Study opened on Chart 20, so the chart data appears on Sheet20. When I input the formula below to cell K3 on Sheet1 I get the #NAME? spreadsheet error. When I input the formula below to cell K3 on Sheet20 I do not get the #NAME? error but the formula disappears when the spreadsheet updates.

=SUM(ID2.SG1@3+ID2.SG1@17+ID2.SG1@31+ID2.SG1@45+ID2.SG1@59+ID2.SG1@73+ID2.SG1@87+ID2.SG1@101+ID2.SG1@115+ID2.SG1@129+ID2.SG1@143+ID2.SG1@157+ID2.SG1@171+ID2.SG1@185+ID2.SG1@199+ID2.SG1@213+ID2.SG1@227+ID2.SG1@241+ID2.SG1@255+ID2.SG1@269+ID2.SG1@283+ID2.SG1@297+ID2.SG1@311+ID2.SG1@325+ID2.SG1@339+ID2.SG1@353+ID2.SG1@367+ID2.SG1@381+ID2.SG1@395+ID2.SG1@409+ID2.SG1@423+ID2.SG1@437+ID2.SG1@451+ID2.SG1@465+ID2.SG1@479+ID2.SG1@493+ID2.SG1@507+ID2.SG1@521+ID2.SG1@535+ID2.SG1@549+ID2.SG1@563+ID2.SG1@577+ID2.SG1@591+ID2.SG1@605+ID2.SG1@619+ID2.SG1@633+ID2.SG1@647+ID2.SG1@661+ID2.SG1@675+ID2.SG1@689)/50
[2014-09-05 22:15:52]
User16114 - Posts: 153
Changed all the ID2.SG1@ entries in the formula above to AD (which is the column of the study I want to reference in Sheet20) and the Spreadsheet Study Custom Indicator shows on the Chart as desired.

I understand the benefit of using the ID2.SG1@ format to reference columns in Spreadsheet Studies. Is this format available now? If yes, what was I doing wrong in post #3 above? Thanks!
[2014-09-06 00:19:07]
Sierra Chart Engineering - Posts: 104368
We are looking into this. Please wait until we have had a chance to look into this. Will be sometime next week.
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
[2014-09-06 15:42:37]
abrown8703 - Posts: 64
I've been having similar issues with spreadsheets as well. A quote board that I created years ago is a total mess now. Chart output data is being sent to wrong sheet #. Please advise.
[2014-09-07 09:40:05]
Sierra Chart Engineering - Posts: 104368
We need more information about the problem. It is far from clear.

You make mention of a Quote Board and then you talk about chart output data. Are you using the Spreadsheet Study?
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
[2014-09-07 12:30:53]
abrown8703 - Posts: 64
Each instrument listed on quote board(see image) has a separate daily chart with "spreadsheet study." That Data then is sent to a spreadsheet that then feeds the Quote Board spreadsheet. Very simple. A few days ago for reasons I am not sure of, data started to be sent to the wrong sheet # thus my Quote Board spreadsheet data was all wrong.
image1.png / V - Attached On 2014-09-07 12:29:55 UTC - Size: 276.98 KB - 453 views
image2.png / V - Attached On 2014-09-07 12:30:03 UTC - Size: 58.04 KB - 439 views
[2014-09-11 03:39:10]
Sierra Chart Engineering - Posts: 104368
We apologize for the late reply on this.

We think this has to do with adding and deleting Sheets and affecting references to existing Sheets. This is thoroughly documented in this section here:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#OutputSheetNumber
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
[2014-09-11 11:52:34]
Bedhog - Posts: 179
I'm at a loss as to why this is happening.

I can take an existing chart and insert the name of a new spreadsheet.

A new spreadsheet opens up. There is only 1 chart writing to this spreadsheet.

I enter the value 1 in Column O3
I enter a formula in P3 that says =O3

Both cells go empty right away.

sc v1187 (new spreadsheets)

How I got here:
I started with 1 chart and 1 spreadsheet that was working well and duplicated it 5 times for different symbols. Then I modified the spreadsheet names for the duplicated 5 charts.

End result:
1 chartbook with 6 charts referencing 6 uniquely named spreadsheets.


Date Time Of Last Edit: 2014-09-11 11:57:41
[2014-09-11 16:36:49]
Sierra Chart Engineering - Posts: 104368
It sounds like the Formula Source Sheet Number input with the Spreadsheet study is not set correctly. This is documented here:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#FormulaSourceSheetNumber
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

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

Login

Login Page - Create Account