Support Board
Date/Time: Sat, 01 Mar 2025 19:41:30 +0000
SpreedSheet Study - Save regular - sometimes the rows add´s column
View Count: 485
| [2021-10-12 19:10:39] |
| User230940 - Posts: 121 |
|
Hello, I use the spreedsheet Study System/Alert with save regular option. The saved file I use in excel which works fine to me. But in some lines a addition column will be add to a date and/or time value. This column only exists in these lines with the result, that excel can`t handle this column correcty. All column behind will be moved by one or N column. For example the Problem exist on the following on a 15 Min Chart which every 1 Minute save intervall. Date Time [ID0.SG1] Open [ID0.SG2] High [ID0.SG3] Low [ID0.SG4] Last [ID0.SG5] Volume [ID0.SG6] # of Trades [ID0.SG6] # of Trades Buy Entry Buy Exitt 2021-10-12 10:00:00 4334,75 4339,50 4332,25 4333,50 5772 4547 Last Bar End DateTime (read-only): 2021-10-12 19:39:09 The columns of the of the Date and the Time at end does not exist on a normal line. Two column will be add the line. The column will be start at "J". Because of that the whole Save File can not be used in Excel, or does not provide correct entries. Is it possible to remove the lines like "Last Bar" or "Chart End Time" or "Chart Start Time". I think there are more line with dynamic input. Or can save file include from the beginning all correct columns? Or did I make any mistake? Thanks for help regards carsten |
| [2021-10-13 00:01:45] |
| John - SC Support - Posts: 38292 |
|
You are saving the information in the correct way. Your choices are to either edit the file before you open it in Excel and get rid of the data that you do not need. Or, you can use the Import function in Excel and remove those columns before importing into the program. This is a bit more advanced, and if you are not familiar with the Import process in Excel, then we recommend the first option. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-10-13 09:15:06] |
| User230940 - Posts: 121 |
|
Hi, thanks. But how should I remove random column which are added or not? Is it possible to remove or disable the column from "J". Why are these columns not definied and used for all lines instead of adding one or two column to a dedecated line. thanks carsten |
| [2021-10-13 14:32:17] |
| John - SC Support - Posts: 38292 |
|
What you are seeing is what is in the Spreadsheet. The I and J columns have the information for the chart in order to allow you to have that information in the Spreadsheet when developing your algorithm. Those columns are not removable with the Spreadsheet System for Trading or Alerts. There is an option with the standard Spreadsheet Study for "Output Additional Values in Columns I and J", which can be set to No in order to remove those. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-10-13 16:17:46] |
| User230940 - Posts: 121 |
|
Hi, I will test it and will let you know. regards carsten |
| [2021-10-19 08:36:12] |
| User230940 - Posts: 121 |
|
Hello, I am sorry. All was my fault. My script to transform the data, had an error which has the result of one or two additional Column`s after Column J. This was totaly my fault. I works perfect with "Spreadsheet Study" and/or "spreedsheet Study System/Alert". Thanks and Sorry regards carsten |
To post a message in this thread, you need to log in with your Sierra Chart account: