Support Board
Date/Time: Fri, 29 Nov 2024 06:52:35 +0000
Having problems with importing trade data
View Count: 332
| [2023-03-05 22:21:31] |
| DanDimon - Posts: 4 |
|
Hi guys, I am trying to import trade data from Tradovate into Sierra Chart in order to be able to review it. I have read the instructions and created an Excel macro to convert a list of orders from Tradovate into the format that Sierra Chart accepts. I have made sure to set a unique value for the "FillExecutionServiceID" and made sure that the file is saved as a .TXT that is tab-delimited. When I attempt to import the file - I receive the following error "Error reading from the file C:\......\ConvertedSCLog.txt. Error: End of line is not found." I don't know what this means, since each line is a separate row, with a \n character at the end to signify a new line. I have compared a Sierra Chart .txt file that I exported and the file I'm trying to import, and they both look the same at the end - no difference. What am I missing here? Thanks, Dan |
| [2023-03-05 22:44:48] |
| Sierra_Chart Engineering - Posts: 17221 |
|
There must be something wrong with the internal format of the file. Make sure the character encoding is ASCII and it actually does contain the newline characters.
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 Date Time Of Last Edit: 2023-03-05 22:45:37
|
| [2023-03-06 14:11:13] |
| DanDimon - Posts: 4 |
|
I was able to resolve the issue. The problem was not with the encoding of the file. Instead the issue was that the last line of the file, the last row of data, did not have a newline character at the end of it. That's how excel generated it and I think it's pretty common from tab delimited and comma-separated files. Once I added a new line character to the last line, Sierra Chart was able to read the file. Thank you for your help! |
To post a message in this thread, you need to log in with your Sierra Chart account: