Support Board
Date/Time: Sun, 24 Nov 2024 12:10:04 +0000
historical daily data won't load
View Count: 2169
| [2013-11-04 17:11:28] |
| plaforte - Posts: 13 |
|
Hello, I try to load data from an excel sheet csv file. The data loads to the chart but the bars stop at the 12th of the month for every month and restarts at the first day of next month so the chart is missing the second half of every month. To check myself, I saved a SC .dly file in excel csv format and I reopened that csv file and I had the same problem as above, the chart is missing the second half of every month, although I can see all the data correctly when looking in excel. Can you orient me ? Thank you |
| [2013-11-04 17:57:20] |
| |
|
There must be a problem with the data format and in particular the Date field. Refer to the documentation here: http://www.sierrachart.com/index.php?l=doc/doc_TextCSVDataFormat.html 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 |
| [2013-11-04 21:18:51] |
| plaforte - Posts: 13 |
|
Hi, I had used this page. Even with the SC .dly file that I converted to excel csv, I have the problem, it should be in the right format since it is from a .dly file. Here is a short strip of my data file and it displays only the first half of every month. Can you pls tell me if this data is right format. Thank you |
 test coffee one year.csv - Attached On 2013-11-04 21:17:34 UTC - Size: 2.94 KB - 602 views |
| [2013-11-04 21:30:23] |
| |
|
The date format is not correct: 17/8/1973 It needs to be like what is documented here: http://www.sierrachart.com/index.php?l=doc/doc_TextCSVDataFormat.html#DateFormat 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 |
| [2013-11-04 21:40:55] |
| plaforte - Posts: 13 |
|
Thank you for your quick answer, I was confused with something else and could not see any more this error right in my face. Thank you |
To post a message in this thread, you need to log in with your Sierra Chart account: