Support Board
Date/Time: Fri, 10 Jan 2025 09:42:52 +0000
sorting of export data
View Count: 1753
| [2016-08-17 17:32:07] |
| User15326 - Posts: 18 |
|
Hi, I want to export all real-time data in the chart, so I add a spreadsheet study Real-time data shown in descending order, but I want it shown in ascending order. Tried the "sort" function in spreadsheet, old data is in ascending order now (but real-time data will keep showing on the first row and back to descending) Would like to know the method that can export all real-time data in the chart and shown in ascending order. (tick by tick) Thanks |
| [2016-08-17 17:48:10] |
| |
|
You need to use this command on the Edit menu: http://www.sierrachart.com/index.php?page=doc/EditMenu.html#ExportBarDatatoText 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 |
| [2016-08-17 20:13:57] |
| User15326 - Posts: 18 |
|
Hi, tried "Edit >> Export Bar Data to Text File & Export Bar Data and Study Data to Text File", the data output is updated as the time I exported. Is there any method that data keep updating. Thanks |
| [2016-08-17 20:34:51] |
| |
|
Yes you can use this study instead: http://www.sierrachart.com/index.php?page=doc/TechnicalStudiesReference.html#s182 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 |
| [2016-08-18 12:53:24] |
| User15326 - Posts: 18 |
|
"The study data will not be written", is the above method can output all study data in the chart and update in real time?
|
| [2016-08-18 17:21:31] |
| |
|
No, it is not possible to continuously output the study data in real-time. Do you require that?
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 |
| [2016-08-18 19:20:30] |
| User15326 - Posts: 18 |
|
Yes, real-time updated every 5-min, in ascending order
|
| [2016-08-19 17:48:04] |
| |
|
Did you want to output the data of just one study Subgraph to a text file?
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 |
| [2016-08-20 07:54:39] |
| User15326 - Posts: 18 |
|
I want to output data of 4 studies (in the same chart) to a text file, which updated every 5-min in ascending order
|
| [2016-08-21 11:26:34] |
| |
|
In the next release this study will be added: Write Bar and Study Data to File 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 |
| [2016-08-22 16:59:55] |
| User15326 - Posts: 18 |
|
Thank you so much!
|
| [2016-08-24 00:06:41] |
| |
|
The new study is now out in the latest release. Refer to: https://www.sierrachart.com/index.php?page=doc/Whats_New.php 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 |
| [2016-08-24 17:33:46] |
| User15326 - Posts: 18 |
|
Hi, thanks for your update, just tried the latest release, keeping .txt open, but the data won't update automatically after 5-min, I have to exit and open again to view the latest data, is it the expected outcome ? thanks
|
| [2016-08-24 17:41:24] |
| |
|
What is the name of the study you are using? This should work properly. We verified that previously. And what is the text editor you are using? You should use a text editor like Notepad ++ and use the File >> Reload command to reload the data from the text file. 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 |
| [2016-08-25 04:25:37] |
| User15326 - Posts: 18 |
|
I use notepad++ and it refreshed every 5-min, thanks I have 3 studies in the chart, RSI, MACD & OBV, .txt file shows data 3 studies in separate rows, can it show in same line, just like the way shown in spreadsheet, thanks 2016/08/24, 23:30:00, 33.33, 70.00, 30.00, 19.44, 0, 0, 0, 0 > RSI 2016/08/24, 23:30:00, 0.07, 0.16, -0.09, 0.00, 0, 0, 0, 0 > MACD 2016/08/24, 23:30:00, 342708.00, 0.00, 0.00, 0.00, 0, 0, 0, 0 > OBV 2016/08/24, 23:30:00, 2175.25, 2175.25, 2175.00, 2175.25, 157, 83, 48, 109 > Price Date Time Of Last Edit: 2016-08-25 04:40:32
|
| [2016-08-25 05:47:17] |
| |
|
The chart bar and study data for each column in the chart is outputted to a single line. This has been verified: Date, Time, Open, High, Low, Last, Volume, # of Trades, OHLC Avg, HLC Avg, HL Avg, Bid Vol, Ask Vol, RSI, Line1, Line2, RSI Avg, MACD, MA of MACD, MACD Diff, Line, OBV 2016/8/15, 16:25:00.0, 2186.00, 2186.50, 2186.00, 2186.25, 2239, 373, 2186.19, 2186.25, 2186.25, 1124, 1115, 0.00, 70.00, 30.00, 0.00, 0.000, 0.000, 0.000, 0.000, 0 It is not even technically possible for the studies to be on separate rows. 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 |
| [2016-08-25 17:11:23] |
| User15326 - Posts: 18 |
|
Resolved, sorry that I am still using "Write Bar Data to File" Last question, for the 1st set of data (price graph, it output Date, Time, Open, High, Low, Last, Volume, # of Trades, OHLC Avg, HLC Avg, HL Avg, Bid Vol, Ask Vol), is it possible to eliminate the data feed that I won't use? Thanks |
| [2016-08-25 17:16:28] |
| |
|
Did you want to remove: Open, High, Low, Last, Volume, # of Trades, OHLC Avg, HLC Avg, HL Avg, Bid Vol, Ask Vol 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 |
| [2016-08-25 17:25:56] |
| User15326 - Posts: 18 |
|
I only want "last" Thank you |
| [2016-08-25 17:52:00] |
| |
|
That really is not possible without customized changes to how that study interacts with another internal function. And it is not very simple to do.
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 |
| [2016-08-25 18:25:17] |
| User15326 - Posts: 18 |
|
Understood, thank you!
|
| [2016-08-25 20:55:44] |
| |
|
We are hoping you can work with what we currently offer. If it is absolutely necessary, we can do it.
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 |
| [2016-08-26 16:09:49] |
| User15326 - Posts: 18 |
|
Hi, for the text file, is there any setting that I can change so that the data is reloaded 5-min automatically (now it has pop-up and I have to click "yes" every 5-min) thanks
|
| [2016-08-26 17:24:43] |
| |
|
No this is not within our control. This is only something done by the text editor. You could look at using "Auto Hotkey" to automate this. Just run an Internet search for that program. 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: