Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 19:14:13 +0000



[User Discussion] - Create horizontal Grid Lines from excel or text file

View Count: 1183

[2022-01-25 17:14:13]
User202227 - Posts: 12
Hello team,
i had like to leverage a file similar which has some levels information on ES and i had like to draw horizontal lines on the chart is there way to automate this ? i am not sure how do it as i can have the text file in a excel format as well if that provides more options.. thank you so much for the support

Thanks
sai yeluri
[2022-01-25 19:03:13]
John - SC Support - Posts: 30973
There is not an automated directly available within Sierra Chart.

You can create a custom study that does this for you. Refer to the information on custom studies starting here:
Advanced Custom Study Interface and Language (ACSIL): Introduction

Or, if you want someone to develop it for you, then here is a list of potential programmers:
https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2022-05-20 16:05:55]
Zorin - Posts: 18
Just for fun - here is how you do it [cpp file + levels]
Note: it's very draft + done from the default ACSIL study, really slow [as it uses subgraphs instead of drawings], but main problem - how to read the data - you'll get an idea from that

If I'll have some free time - I'll try to re-code it using actual "horizontal lines" objects [instead of subgraphs]
attachmentzHorLines.cpp - Attached On 2022-05-20 16:01:57 UTC - Size: 4.12 KB - 146 views
attachmentzLevels.csv - Attached On 2022-05-20 16:02:47 UTC - Size: 630 B - 136 views
[2022-05-29 14:57:50]
Zorin - Posts: 18
Added another version - using drawings instead of sub-graphs [much faster]
attachmentzHorLines.cpp - Attached On 2022-05-29 14:57:11 UTC - Size: 4.94 KB - 207 views
attachmentzLevels.csv - Attached On 2022-05-29 14:57:32 UTC - Size: 829 B - 190 views
[2023-08-19 14:27:55]
Ed C. - Posts: 98
Thanks very much for posting this! I've been trying to find time to write this myself...
[2023-08-19 15:42:24]
gcUserStudies - Posts: 89
This may also help as a reference. Copies from google sheets.

https://github.com/FrozenTundraTrader/sierrachart/blob/main/google_sheets_importer.cpp

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

Login

Login Page - Create Account