Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 14 May 2024 02:28:27 +0000
Export .txt - Volume values
View Count: 478
| [2021-05-28 11:22:44] |
| User58008 - Posts: 32 |
|
Hi, I recently exported data from NQ100 actual contractual period to a .txt file for a usage in my automated system and I find out that the values in the Volume / Number of trades column within the data dont match to the Volume indicator I use in Sierra when evaluating my signals. Could I ask you for an explanation if there is a correlation between these two things? Is the Volume or Number of Trades or any column in the exported .txt file (Edit - Export intraday data to a txt file) the same that I can see in the Volume indicator (just Volume in the Studies)? Is there any way I can export the values from Volume indicator? What I did was I took the .txt file data, sum the columns for the particular minute and compare to the value of the minute bar in the Volume indicator to see if the volume is the same and it wasnt. It was different by hundreds or more, sometimes less, but definitely different. Thank you |
| [2021-05-28 14:22:54] |
| John - SC Support - Posts: 31602 |
|
The sum of the Intraday data should match what you see in your chart. To get the Volume data you can use the Edit >> Export Bar Data to Text File, which will output the bar data as it is in the chart to a text file. Refer to the following: Edit Menu: Edit >> Export Bar Data to Text File For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-05-28 14:38:07] |
| User58008 - Posts: 32 |
|
Thank you, this works and the Volume is equal. Thanks !
|
| [2021-07-06 22:35:53] |
| User146848 - Posts: 120 |
|
I want to delete this Monday's data (07.05.21). I found 2 methods: export and edit the intraday data file OR use ALT+E with the Intraday Data Editor. Exporting the data works. But the exported file is over 700mb big and all editors i tried did stop working and had to be canceled via windows task manager. I guess in the end i dont have enough RAM. Using ALT+E gets my hand sour. Its simply not ment to be used to deleted a whole day of data. It takes an hour at least. So at this point, what are my options to get rid of the data in a working and reasonable way? |
| [2021-07-07 09:30:22] |
| |
|
Try using the 64-bit Notepad ++ editor. You can exclude days in a chart before exporting by using this Chart Setting: Chart Settings: Set Dates To Exclude (Button) (Chart >> Chart Settings >> Chart Data >> Chart Data menu) 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 |
| [2021-07-07 10:41:56] |
| User146848 - Posts: 120 |
|
64bit Notepad ++ was the first editor i tried. A window pops up, saying: "Notepad ++ cant open such large files." Libre office writer seems to run out of RAM. The windows task manager shows this program is using over 7gb of RAM while opening the file. But i run out of RAM at this point and the file is still not opened. I tried the exclude feature and dont understand how it helps to edit intraday data. I loaded an intraday chart from the starting date 2021-07-02. Exporting this data always seems to export the whole file and not just the loaded days in the chart. So i end up with a big file anyway. What i didnt try is exporting bar data as i am not sure if this is suitable for an intraday file regarding importing the data back. |
| [2021-07-07 10:43:36] |
| Sierra_Chart Engineering - Posts: 14342 |
|
Yes you need to export the bar data only. You can import it back, but make sure the time zone of the chart is set to UTC before exporting.
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, 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: