Support Board
Date/Time: Mon, 29 Dec 2025 11:49:29 +0000
Using exported Data
View Count: 229
| [2025-11-12 20:11:56] |
| cmack1011 - Posts: 174 |
|
I'm having difficulty getting an AI engine (ChatGPT) to parse and see exported data (TXT files) from SC. I'm using the "Export bar and study data to text file" to create the data file. Do you have any recommendations to prevent these issues and make the process smoother? Thx
|
| [2025-11-12 20:15:53] |
| John - SC Support - Posts: 43619 |
|
We have no idea what you would need to do to get ChatGPT to recognize the file. It seems pretty silly that it can't parse out a comma separated file with headers that give the information on what each column contains.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-13 16:28:52] |
| cmack1011 - Posts: 174 |
|
For some reason CHatGPT is only seeing odd numbered bars of an export file of a 1 minute candlestick chart with the "Number Bar Calculated Values" study applied. IS there a setting that I am missing that is excluding some of the data?
|
| [2025-11-13 16:39:48] |
| cmack1011 - Posts: 174 |
|
I am trying to export data for a date range that includes both reg and after hours 1 minute data. However, the chart comes back without after hours data and many 1 minute intervals are skipped (see timeline).
|
 Screenshot 2025-11-13 at 10.36.55 AM.png / V - Attached On 2025-11-13 16:39:44 UTC - Size: 160.64 KB - 40 views |
| [2025-11-13 17:49:17] |
| John - SC Support - Posts: 43619 |
|
That symbol is not very highly traded, especially Prior to November 6, 2025. What you are seeing is correct, as that is what was actually traded at that time.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-13 18:34:20] |
| cmack1011 - Posts: 174 |
|
Yes, that does explain it. Thank you. When exporting "Number Bar Calcualted Values" study, I've noted that some rows of data are not included in the export and some data gets "transformed" into other types of data. For example, I do not see any "Uptick" or Downtick" volume or "ask volume/sec" among others. Is there a limit to how many rows get exported at one time in this study? |
| [2025-11-13 19:40:40] |
| John - SC Support - Posts: 43619 |
|
There is special consideration done in the programming for how certain items will be displayed. We can see where this might lead to some items not being outputted properly. Try setting the Input for "Use Default Number Formatting for All Subgraphs" to be "Yes", and then set the "Value Format" for the study to be whatever you feel is best for the numbers you want to output. Then export the data and see if there are still items you are not getting. Let us know if there are specific items that are still not output. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-14 15:38:34] |
| cmack1011 - Posts: 174 |
|
Worked!! Thank you!!
|
| [2025-11-18 02:48:11] |
| cmack1011 - Posts: 174 |
|
I thought it worked, but I've just noticed that when exporting data via a TXT file then opening with Excel does not accurately replicate the data. I get very strange values that do not match the values on the screen at all (for example, sometimes getting rows of 0's and 1's where there should be multi-digit numerals). I'm specifically trying to export the data in the "Numbers Bars Calculated Values" study. Any advice?
|
| [2025-11-18 15:14:55] |
| cmack1011 - Posts: 174 |
|
Is it possible to export "Volume by Price" data from the "Volume by Price" study (or any other type of study) such that I can obtain Volume by price in 6 second intervals (bars) using a 1 minute candlestick bar chart? Currently, when I try to export this data, in order to display volume by price in 6 second intervals, I need to use a 6-sec bar chart when I prefer to use a 1 minute bar chart so that I can merge the data with other types of 1-minute data. Thx
|
| [2025-11-18 16:12:16] |
| cmack1011 - Posts: 174 |
|
Actually, I am trying to export the VbP data in "block" or "flat Table" format per bar# - please advise. (See attached for example) Thx
|
| Screenshot 2025-11-18 at 10.10.53 AM.png / V - Attached On 2025-11-18 16:12:10 UTC - Size: 242.28 KB - 40 views |
| [2025-11-18 19:27:20] |
| John - SC Support - Posts: 43619 |
|
The only way the "Volume by Price" data is accessible is through the Spreadsheet Study. Refer to the following: Spreadsheet Study Inputs: Output Volume at Price Data You need to setup your chart as you would need to get the data you want. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-18 21:36:01] |
| cmack1011 - Posts: 174 |
|
So I can get teh spreadsheet study to create a spreadsheet that lists total volume along a row with time and price per tick, but is it possible to display ask and bid volume along these same parameters? Is it possible to structure the data in "block" format in the spreadsheet? (see attached for what I have now) Thx
|
| Screenshot 2025-11-18 at 3.34.59 PM.png / V - Attached On 2025-11-18 21:35:54 UTC - Size: 81.21 KB - 43 views |
| [2025-11-18 22:15:06] |
| John - SC Support - Posts: 43619 |
|
The only option is for the Total Volume as we specified above. The only way to get to the Bid and Ask Volumes is to use a Custom Study. Refer to the following: ACSIL Programming Concepts: Accessing Volume at Price Data Per Bar For the most reliable, advanced, and zero cost futures order routing, use 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: