Login Page - Create Account

Support Board


Date/Time: Sun, 21 Oct 2018 20:03:50 +0000



Imported files do not show UTC not local time on chart

Support Request:
[2017-11-06 02:30:47]
User953894 - Posts: 34
I'm trying to bring in external data and everything seems to have worked well except the time on the chart for the new instrument does not seem to be converting to display local time.

I brought .csv files into the /data folder (I didn't convert, just opened using the New/Open Intraday Chart command) and had no problem opening an intraday chart. The UTC time is what's used in the .csv folder, and that "raw" UTC time appears on the chart(s) for the imported instruments. My other charts show the local time. As far as I can tell, everything is fine except the UTC time is not being converted. This is especially problematic because I am overlaying the imported chart information and the time seems to prevent the overlay information from displaying properly.
[2017-11-06 18:10:00]
Sierra Chart Engineering - Posts: 65041
Whether the data is from a text file or not, the time zone settings will always have an effect on the UTC Date-Times loaded from the chart data file. It is simply an impossibility for that not to be the case. Know that there are two different Time Settings. Refer to:
https://www.sierrachart.com/index.php?page=doc/TimeZone.html

Also refer to the text/CSV data format here:
https://www.sierrachart.com/index.php?page=doc/TextCSVDataFormat.html

And make sure the Date-Times have the proper format.


In any case, this is not anything we would provide any further support for.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-11-06 20:41:32]
User953894 - Posts: 34
http://www.sierrachart.com/image.php?Image=1510000683404.png

I double-checked the format and time settings that you mention. I even did an update of the import, so I have "new" data to confirm that I continue to get the same type of result. I also confirmed that the standard charts use global time setting and the chart produced from the imported csv data also uses global time setting. But while my standard charts properly show current New York time zone time which matches my PC time, the chart for the csv data shows 5 hours ahead.

The data from the csv file seems to be represented perfectly with all data charted against the time for the record. The only problem is that the chart for imported data all so times 5 hours ahead of all my other charts.
[2017-11-06 22:20:55]
Sierra Chart Engineering - Posts: 65041
The only reasonable conclusion is that the data in the data file, is not actually in UTC time.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-11-06 22:24:42]
Sierra Chart Engineering - Posts: 65041
Actually, we see. When you are opening text data directly, the timestamps are not actually adjusted to the time zone setting and are just displayed as is.

Refer to the Notes here about this:

https://www.sierrachart.com/index.php?page=doc/TextCSVDataFormat.html#Notes
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-11-06 22:33:23
[2017-11-07 03:56:29]
User953894 - Posts: 34
Thank you for clearing that up. It certainly was frustrating to recheck my setup and not find any problems. The explanation you provided with the last message makes much more sense.

But now the question is how can I fix this to do the overlays on charts with data from my normal feed.
1) I tried changing the time zone on the text data charts to UTC, but that didn't seem to have any effect.
2) I tried changing the global time zone to UTC, which seems to work fine. It's the least preferred option, but it works.
3) Is there a "batch" process for importing data? I have a couple dozen data files to update and I'll explore a full import which would address the time conversion if it can be done with a straightforward automated process.

Thanks again for your clarifying information. I look forward to any thoughts about a better approach.
[2017-11-07 10:18:57]
Sierra Chart Engineering - Posts: 65041
The only possibility is to import the data into Sierra Chart Intraday data files.

Refer to:
https://www.sierrachart.com/index.php?page=doc/ImportExport.html

There is no way to do a batch import.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-11-07 19:55:40]
User953894 - Posts: 34
Thanks for that info.

I am curious--opening text data directly seems to work fine. What are the advantages (other than using the UTC functionality) of importing vs. opening text data directly?

Again, thanks!
[2017-11-07 20:37:19]
Sierra Chart Engineering - Posts: 65041
When importing the data, it will load much faster. But if you are fine with the current loading time, then that is OK.

We also have contemplated performing an adjustment of the timestamps to the time zone, but if we do that, it is going to cause an unexpected problem for those who have relied on it working the current way. We can always add an option, but it would be yet another option further complicating things.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-11-08 12:05:26]
User953894 - Posts: 34
I am continually amazed at the functionality you guys provide.

You can add my name as a vote to include the option to do the time conversion on directly read data.
[2017-11-27 11:21:47]
User953894 - Posts: 34
I've starting having stability issues on a Sierra Charts instance that I use against Forex data. I have about 30 .csv files that are read directly to produce charts. The system will work for hours, but then suddenly begin creating messages in the log about a timer loading issue is occurring (My apolgoies, I thought I had captured the specific and full error message but I don't have it at the time of creating this post).

I'm wondering if you have any suggestions on how to address this. Also, I'm considering having a programmer help me format the file in .scid format instead of reading .csv files. I'm wondering will this help/resolve the problem?
[2017-11-27 17:37:34]
Sierra Chart Engineering - Posts: 65041
This is probably a Windows 10 issue no doubt. We have had a few reports of this over the last month. The first thing we recommend doing is to update to the current version of Sierra Chart following these instructions:
https://www.sierrachart.com/index.php?page=doc/SoftwareDownload.php#FastUpdate

If you have a continued problem it is going to certainly be a Windows 10 issue.

Also, I'm considering having a programmer help me format the file in .scid format instead of reading .csv files. I'm wondering will this help/resolve the problem?
No, it will not make any difference.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-11-27 17:40:55

To post a message in this thread, you need to login with your Sierra Chart account:

Login


Login Page - Create Account