Support Board
Date/Time: Thu, 16 Jan 2025 19:46:00 +0000
Chart from own data
View Count: 1245
| [2017-11-21 08:10:16] |
| User843867 - Posts: 18 |
|
Hello, I would like to ask whether it is possible to create a daily chart in your Sierra chart from my own data? Let's say the data is ready for excellence and I'd like to render it. For example: Date, Open, High, Low, Close, Volume, open interest Where do I find the format in which I want my data to be displayed? (Columns, column names, etc.) Thank you. Roman Roman |
| [2017-11-21 08:19:17] |
| |
|
Yes this is possible. Just follow through the specifications and instructions on this page: Text/CSV Data Format 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 |
| [2017-11-21 11:07:48] |
| User843867 - Posts: 18 |
|
Thank you for your answer. Unfortunately, my excel saves csv by placing a semicolon instead of a dots, and instead of dots in decimal places, we use commas. Do you know what program to use best to achieve your photo? Thank you Roman Date;Open;High;Low;Close;Volume;Open Interest 2017-09-27;1293,3;1295;1280,9;1285,6;400717;539401 2017-09-28;1285,1;1291,6;1280,4;1289,9;289366;532683 2017-09-29;1290,1;1293,2;1278,2;1282,5;295902;530883 2017-10-02;1282,2;1282,8;1272;1273,5;273089;530731 2017-10-03;1273,1;1277,4;1271;1274,1;207754;525127 2017-10-04;1274,5;1285;1273,1;1277,5;270845;521101 2017-10-05;1277,5;1281,6;1268,5;1270,6;225217;516742 2017-10-06;1270,6;1262,8;1278,9;1279,2;383994;514151 2017-10-09;1278,9;1287,7;1277,7;1286,4;206720;513815 2017-10-10;1286,4;1296,7;1284,6;1290,3;337230;520005 2017-10-11;1290,7;1295,9;1287,9;1293,9;265663;518389 2017-10-12;1294,6;1299,8;1291,8;1295,9;257852;521247 2017-10-13;1296;1306,4;1292,9;1306,1;302070;528142 2017-10-16;1306;1308,4;1292,5;1297,5;350000;533134 |
| [2017-11-21 11:56:48] |
| User843867 - Posts: 18 |
|
Hello, I have solved the problem with CSV. But Sierra does not see this file because it is looking for an update on the Web. I set up the NO SERVICE setting in the Data, but still try to download the data and the chart itself will not appear. Can you test if it works for you? Thank you Roman Pilisek |
Private File |
| [2017-11-21 17:45:35] |
| |
|
Make sure you put this file in the Sierra Chart Data folder which is specified through Global Settings >> General Settings >> Data Files Folder.
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 |
| [2017-11-21 18:55:11] |
| User843867 - Posts: 18 |
|
Hi, yes, all ok. This error from log: Error opening or reading chart data file. File: C:\SierraChart\Data\Roman_Gold.csv | 2017-11-21 12:53:33 * |
| [2017-11-21 18:59:51] |
| |
|
Provide a copy of the Message Log by following these instructions: Support Board Posting Information: How to Post Your Message Log (Required In Some Cases) 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 |
| [2017-11-21 19:15:43] |
| User843867 - Posts: 18 |
|
Reading Internal Order ID file. | 2017-11-21 12:48:54 Reading Trade Orders file. | 2017-11-21 12:48:54 Reading Trade Positions file. | 2017-11-21 12:48:54 Listening on UDP port 22903. | 2017-11-21 12:48:54 Software version: 1635 | 2017-11-21 12:48:54 Usage end date: 2018-06-05 | 2017-11-21 12:48:54 Enabled for: Advanced Features. | 2017-11-21 12:48:54 Enabled for: Advanced Features 2. | 2017-11-21 12:48:54 Enabled for: Sierra Chart Historical Data Service. | 2017-11-21 12:48:54 Enabled for: Sierra Chart Real-Time Exchange Data Feed. | 2017-11-21 12:48:54 Enabled for: INDEXES_DATA_BARCHART | 2017-11-21 12:48:54 Enabled for: CME (Trading Account Required) | 2017-11-21 12:48:54 Enabled for: CBOT (Trading Account Required) | 2017-11-21 12:48:54 Enabled for: COMEX (Trading Account Required) | 2017-11-21 12:48:54 Enabled for: NYMEX (Trading Account Required) | 2017-11-21 12:48:54 Received 2 data feed usernames. | 2017-11-21 12:48:54 Allow Support for Sierra Chart Data Feeds is enabled. | 2017-11-21 12:48:54 Current selected Data/Trading service: No Service | 2017-11-21 12:48:54 Chart Update Interval: 200 | 2017-11-21 12:48:54 Time Zone: -06:00:00 (CST-06CDT+01,M3.2.0/02:00,M11.1.0/02:00) | 2017-11-21 12:48:54 2017-11-21 19:49:11 Local computer time | 2017-11-21 12:48:54 2017-11-21 18:49:11 Local computer time in UTC | 2017-11-21 12:48:54 2017-11-21 12:49:11 Local computer time in SC Time Zone | 2017-11-21 12:48:54 Program path: C:\SierraChart\ | 2017-11-21 12:48:54 Data Files path: C:\SierraChart\Data\ | 2017-11-21 12:48:54 OS Version Number: 10.0 | 2017-11-21 12:48:54 Locale Setting: C | 2017-11-21 12:48:54 Checking for new symbol settings for service code 0 | 2017-11-21 12:48:54 Error getting address info for www.sierrachart.com. Windows error code 11001: Není znám žádný takový hostitel. | 2017-11-21 12:48:54 * HTTPS connection to www.sierrachart.com:443 (2) | Initiating close of socket by core. | 2017-11-21 12:48:54 HTTPS connection to www.sierrachart.com:443 (4) | Initiating close of socket by core. | 2017-11-21 12:48:54 HTTP request 1 for symbol settings MD5 for 0 Connection for request failed. Error connecting to HTTP server. | 2017-11-21 12:48:54 Roman_21_11_2017 Daily #1 | Reloading chart. | 2017-11-21 12:49:27 Error opening or reading chart data file. File: C:\SierraChart\Data\Roman_21_11_2017.csv | 2017-11-21 12:49:27 * No Service | Connected to data server. | 2017-11-21 12:49:27 No historical data client is currently set to download historical Daily data for Roman_21_11_2017. | 2017-11-21 12:49:27 No Service | Starting real-time market data updates for: Roman_21_11_2017. ID: 1 | 2017-11-21 12:49:27 No Service | Subscribing to streaming market data in the service client is not supported. Symbol: Roman_21_11_2017 | 2017-11-21 12:49:27 No Service | Requesting security definition data for: Roman_21_11_2017. ID: 1 | 2017-11-21 12:49:27 Roman_Gold Daily #2 | Reloading chart. | 2017-11-21 12:51:42 Error opening or reading chart data file. File: C:\SierraChart\Data\Roman_Gold.csv | 2017-11-21 12:51:42 * No historical data client is currently set to download historical Daily data for Roman_Gold. | 2017-11-21 12:51:43 No Service | Starting real-time market data updates for: Roman_Gold. ID: 2 | 2017-11-21 12:51:43 No Service | Subscribing to streaming market data in the service client is not supported. Symbol: Roman_Gold | 2017-11-21 12:51:43 No Service | Requesting security definition data for: Roman_Gold. ID: 2 | 2017-11-21 12:51:43 Roman_Gold Daily #1 | Reloading chart. | 2017-11-21 12:53:33 Error opening or reading chart data file. File: C:\SierraChart\Data\Roman_Gold.csv | 2017-11-21 12:53:33 * No historical data client is currently set to download historical Daily data for Roman_Gold. | 2017-11-21 12:53:33 Real-time Intraday chart data file updates started for Roman_Gold | 2017-11-21 12:53:33 Intraday chart data file opened for Roman_Gold | 2017-11-21 12:53:33 Roman_Gold Daily #1 | Reloading chart. | 2017-11-21 13:01:11 Error opening or reading chart data file. File: C:\SierraChart\Data\Roman_Gold.csv | 2017-11-21 13:01:11 * Roman_Gold Daily #2 | Reloading chart. | 2017-11-21 13:01:11 Error opening or reading chart data file. File: C:\SierraChart\Data\Roman_Gold.csv | 2017-11-21 13:01:11 * No historical data client is currently set to download historical Daily data for Roman_Gold. | 2017-11-21 13:01:11 Roman_Gold Daily #3 | Reloading chart. | 2017-11-21 13:15:15 Error opening or reading chart data file. File: C:\SierraChart\Data\Roman_Gold.csv | 2017-11-21 13:15:15 * No historical data client is currently set to download historical Daily data for Roman_Gold. | 2017-11-21 13:15:16 |
| [2017-11-21 21:44:15] |
| |
|
The encoding of the file is not ANSI and that is the problem.
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 |
| [2017-11-23 17:59:19] |
| User843867 - Posts: 18 |
|
Thank you, in the end, I chose to copy the data into a Sierra Chart spreadsheet. I would like to take advantage of our communications and asked you if there is an option to see the OPEN INTEREST indicator for all futures contracts. For example, Gold is GC, and if I want to show Open Interest under the current contract, I'll only show up on this contract. But for a successful analysis, it is important to display the total Open INterest to GC for all open contract months. Thank you DP |
| [2017-11-24 03:29:49] |
| |
|
Refer to the instructions here: https://www.sierrachart.com/index.php?page=doc/SierraChart_RealTime_And_Historical_Symbols.php#ChartingTotalVolOpenInterest 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: