Support Board
Date/Time: Mon, 25 Nov 2024 14:38:51 +0000
Spreadsheet Study some fields not showing up in spreadsheet
View Count: 350
| [2024-02-27 14:13:48] |
| TopGunTrader - Posts: 172 |
|
Very bizarre creating spreadsheet study to create a Market Stats to help my trading and as you can see added 30m Period OHLC Variable Period to use in spreadsheet and many of the SG values aren't in spreadsheet. For Example ID45 for XLK tech sector it only shows SG1, SG2, SG3 doesn't have SG4 the close or SG9 the Midpoint I need. Others like for Financials ID47 its missing SG1-SG6. I can't figure this out. |
 Capture.PNG / V - Attached On 2024-02-27 14:10:57 UTC - Size: 14.38 KB - 60 views Capture2.PNG / V - Attached On 2024-02-27 14:11:52 UTC - Size: 204.07 KB - 62 views Attachment Deleted. |
| [2024-02-27 16:49:29] |
| John - SC Support - Posts: 36243 |
|
By default, any subgraphs that are set to "Ignore" will show in the Spreadsheet Study, but this can be changed by the following Input for the Spreadsheet Study, which it sounds like you may have set to "Yes": Spreadsheet Study Inputs: Do Not Output Subgraphs Set To Ignore For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-28 02:03:40] |
| TopGunTrader - Posts: 172 |
|
Hi, Appreciate the response but I have "Do not output subgraphs set to ignore" to NO and I also am not ignoring that column. I've attached pics to show. As you can see have NO and the column I want the 30m previous close SG4 is set to Dash but its not showing up in spreadsheet. Is there any limit to how many studies and sub graphs can be in there? |
| Capture2.PNG / V - Attached On 2024-02-28 02:00:32 UTC - Size: 46.7 KB - 56 views Capture.PNG / V - Attached On 2024-02-28 02:00:41 UTC - Size: 52.03 KB - 64 views |
| [2024-02-28 15:02:18] |
| John - SC Support - Posts: 36243 |
|
Please get us the chartbook and the Spreadsheet that shows this issue by following these instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile And please let us know the particular chart that shows the problem. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-28 15:06:59] |
| Sawtooth - Posts: 4120 |
|
I can't figure this out.
If you have output columns with data, and no title in row 2, then you need to clean all output columns so you can see the real outputs.This happens when you add/delete/remove/rearrange studies in the Studies to Graph list, or you insert/delete Formula Columns, or you change the Number of Formula Columns setting. Once you do this, you'll see all of the expected data where it belongs. To clear the output columns, highlight all of the output columns (Not Formula Columns), press the Delete key... Then do a Chart >> Recalculate. Date Time Of Last Edit: 2024-02-28 15:12:14
|
| [2024-02-28 20:48:31] |
| TopGunTrader - Posts: 172 |
|
Hi, I copied the chartbook to new workspace and went through and put ignore on all the fields not needed to make spreadsheet smaller. It's so bizarre that the SG4 close of previous 30m bar isn't in spreadsheet. Doesn't matter what I try it won't show up. Also odd is on this new one created a new column with the formula I wanted and it didn't copy it down to all the other rows like before. |
 MarketStats.Cht - Attached On 2024-02-28 20:46:06 UTC - Size: 15.96 KB - 202 views Private File |
| [2024-02-28 21:29:21] |
| John - SC Support - Posts: 36243 |
|
Everything looks fine when we open this. Have you gone through the suggestion from Sawtooth given above? It sounds like this is the problem you are having. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-02-29 02:58:40] |
| TopGunTrader - Posts: 172 |
|
Yes I tried those suggestions and even got rid of the Spreadsheet study, created a NEW one, new spreadsheet name and same problem exists. As you can see from this picture Study ID45 has all fields set to Ignore except Close and HL Avg SG4 and SG9 I've included them in spreadsheet but as you can see in row FA it has just the SG9 field not the SG4 Close value. I can see maybe the last spreadsheet got corrupted there were a lot of fields that went away after I turned all the fields I didn't want to Ignore but setting up a brand new spreadsheet study has the exact same problem. |
| Capture.PNG / V - Attached On 2024-02-29 02:57:28 UTC - Size: 373.01 KB - 62 views |
| [2024-02-29 03:05:47] |
| TopGunTrader - Posts: 172 |
|
I tried to remove the SG9 HL Avg and it just skipped it nothing was displayed. So I tried to display them all and all are on there except the one I want Close(SG4). Here's pic. Can you send me pic showing the values on yours? Maybe I need to upgrade Sierra weird bug fixed but not in my version 2568. |
| Capture2.PNG / V - Attached On 2024-02-29 03:05:40 UTC - Size: 162.5 KB - 57 views |
| [2024-02-29 03:08:29] |
| TopGunTrader - Posts: 172 |
|
Installed from Help menu newest version 2604 same problem not displaying Close SG4 for any of those studies. What version are you guys running where it works. Can you send screen shot showing ID45.SG4 is in spreadsheet.
|
| [2024-02-29 16:42:57] |
| John - SC Support - Posts: 36243 |
|
In the chartbook you sent, Study ID45 has only the Close and HL Avg subgraphs set to display and your setting for "Do Not Output Subgraphs Set to Ignore" is to "Yes". And also, you had the "Close" subgraph not set to "Include In Spreadsheet". When we add the "Include to Spreadsheet" for that item and then clear and recalculate (as per Sawtooth's suggestion) then everything is showing as we expect. Attached is an image showing this for that particular study. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| Sierra_Chart_MainWindow_2024-02-29 10_34_56.928.png / V - Attached On 2024-02-29 16:42:54 UTC - Size: 227.8 KB - 75 views |
| [2024-02-29 18:43:00] |
| TopGunTrader - Posts: 172 |
|
Hi, Thanks you fixed it. I thought on subgraphs tab when adding a study they were all the same. I can't recall unchecking include in spreadsheet but must have or had it saved as default that way. Thank you guys so much, I'm new to using Spreadsheet study. |
To post a message in this thread, you need to log in with your Sierra Chart account: