Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 11:22:19 +0000
Line Chart for User Imported Data
View Count: 608
| [2018-06-06 20:05:19] |
| EthanTPMT - Posts: 1 |
|
Hi Sierra Support Board, Is there a way to chart data with no aggregation as a point and line graph? I have my own market data, and I want to chart this data that I have aggregated via a custom approach and not have the charting tool do any aggregations. I have been using MS Excel in my analysis (attached screenshot); however, this tool is very cumbersome in doing annotations. Additional, annotations can easily lose their placement. Currently testing Sierra Charts to see if the graphing tool can address such annotation gaps of MS Excel along with some other limitations with MS Excel. Here is an example of the imported data subset: Symbol, Date, Time, Open, High, Low, Close, Volume, Number of Trades, Bid Volume, Ask Volume ESH10,2010-01-03,23:00:01.000,1113.75,1113.75,1113.75,1113.75,1162,123,1162,0 ESH10,2010-01-03,23:00:01.001,1113.50,1113.50,1113.50,1113.50,5,4,0,5 ESH10,2010-01-03,23:00:01.002,1113.75,1113.75,1113.75,1113.75,14,5,14,0 ESH10,2010-01-03,23:00:01.003,1113.50,1113.50,1113.50,1113.50,54,6,0,54 ESH10,2010-01-03,23:00:02.000,1113.75,1113.75,1113.75,1113.75,2,2,2,0 Data appears to import correctly (attached log) but difficult to verify until presentation format matches expectations as it is currently presented. Tried to make the following changes to support this goal: Chart -> Chart Setting ->Main Settings Days To Load: 100 Bar Period Type: Range per Bar - True (in ticks) | Point and Figure Bar (BoxSize in ticks) Graph Draw Type: Line on Close None of the above seem to get me to where I'd like to be... I have searched SierraChart.com documentation and did some Google searches with no success. I hope you can let me know if this is possible and if so, direct me to the correct documentation to get there. Thanks, Ethan |
 log.txt - Attached On 2018-06-06 20:01:14 UTC - Size: 2.5 KB - 257 views |
Chart.png| [2018-06-07 06:03:24] |
| |
|
You need to remove the symbol column from this data: Symbol, Date, Time, Open, High, Low, Close, Volume, Number of Trades, Bid Volume, Ask Volume
ESH10,2010-01-03,23:00:01.000,1113.75,1113.75,1113.75,1113.75,1162,123,1162,0 ESH10,2010-01-03,23:00:01.001,1113.50,1113.50,1113.50,1113.50,5,4,0,5 ESH10,2010-01-03,23:00:01.002,1113.75,1113.75,1113.75,1113.75,14,5,14,0 ESH10,2010-01-03,23:00:01.003,1113.50,1113.50,1113.50,1113.50,54,6,0,54 ESH10,2010-01-03,23:00:02.000,1113.75,1113.75,1113.75,1113.75,2,2,2,0 You then would want to import this data following the instructions here: Exporting and Importing Intraday Data Files You then need to open the imported file through File >> Open Intraday Chart. And then you will want to set the chart bars to Number of Trades per Bar with a setting of 1.: Chart Settings: Intraday Chart Bar Period >> Bar Period Type >> Number of Trades Per Bar (Chart >> Chart Settings 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 Date Time Of Last Edit: 2018-06-07 06:04:35
|
To post a message in this thread, you need to log in with your Sierra Chart account: