Support Board
Date/Time: Fri, 09 May 2025 19:26:20 +0000
[User Discussion] - spreadsheets
View Count: 1155
| [2014-10-31 21:17:01] |
| jivetrader - Posts: 410 |
|
3 issues with spreadsheets: i am using Old spreadsheets, and using Excel. I added a spreadsheet system/alert study to chart #19. 1. Chart Data Output Sheet Number = 0 but the data appears on Sheet2 not Sheet19 2. cell D1 of Sheet 2 does not display "Formula Source Sheet #1. Enter and modify formulas for this sheet on Sheet1." (example text) 3. Formula Source Sheet Number=4 but formula in sheet4 cell O3 does not appear on Sheet 2. TIA |
| [2014-10-31 21:46:37] |
| |
|
1. Therefore, we cannot accept this as being true. The data must be outputted to sheet 19 based upon what you have said. Check Sheet 19. 2. This could be if Sheet 2 is not being used. 3. This make sense if sheet 19 is being used. 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 Date Time Of Last Edit: 2014-10-31 21:47:18
|
| [2014-10-31 23:05:39] |
| jivetrader - Posts: 410 |
|
1. sheet 19 is absolutely blank. 2. Sheet2 *is* being used. it is the only one used. 4. also, the sheets in Excel are in reverse order i.e. the leftmost sheet in the spreadsheet is Sheet19 then decrements down to Sheet2 at right. |
| [2014-10-31 23:13:08] |
| jivetrader - Posts: 410 |
|
I tried copying it to new chart in a new chartbook and it behaves the same. then I reset to default study values, readded the study, and now it outputs only one sheet (Sheet1) to which I can add formulas. also these formulas are not being deleted upon spreadsheet refresh. so a study setting must be the culprit. thanks for your attention note: I am using the Spreadsheet Study for Alerts. I am still not clear on when I can write formulas on the source sheet, or when they must be entered on Sheet4. had trouble understanding the documentation. |
| [2014-10-31 23:45:36] |
| jivetrader - Posts: 410 |
|
when I copy the correctly working chart from the empty test chartbook, back to the chartbook with the 19 charts in it, it no longer works, in the following ways: 1. Sheets are numbered Sheet1, Sheet19, Sheet18.....Sheet2 2. data is on Sheet2 not Sheet19 3. formulas are not copying down, whether I enter them in Sheet4!O3 or Sheet2!O3 there seems to be a bug in Chart numbering when there are 18 other charts in the chartbook. also, study values are incorrect on this spreadsheet, too. the problem comes when the chart is put into the Chartbook with the 19 charts in it. I am using Old Spreadsheets and I updated the platform yesterday. please advise ASAP thanks. |
| [2014-11-01 00:03:47] |
| jivetrader - Posts: 410 |
|
further testing: the issue only happens in Excel not in native spreadsheets. however, I need to use excel. 1. In Excel, the actual data from the ZigZag study is wrong (but correct in native spreadsheet). this is a major concern! 2. I have removed most of the charts from the chartbook, yet both versions still create at least 19 sheets in their spreadsheet. please advise |
| [2014-11-01 00:05:06] |
| jivetrader - Posts: 410 |
|
see attached files.
|
 excel wrong.png / V - Attached On 2014-11-01 00:04:07 UTC - Size: 117.22 KB - 382 views native right.png / V - Attached On 2014-11-01 00:04:32 UTC - Size: 153.88 KB - 398 views |
| [2014-11-01 00:14:18] |
| jivetrader - Posts: 410 |
|
after restarting the computer, the data in Excel is now correct. However, there are still about 20 sheets in the Spreadsheet for no reason since there are now only 3 chart windows open in this chartbook. also, when I use native (old) spreadsheets, I cannot seem to enter certain letters in a cell. is this normal? e.g. in O3 I tried to type =if( and it would not let me. |
| [2014-11-02 10:26:15] |
| |
|
We realize you are using Excel. We do not provide support for that. We are declining support. This is now marked as a user discussion. There will be no further support from us on this. 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: