Support Board
Date/Time: Sun, 07 Sep 2025 14:38:40 +0000
Importing levels to Sierra
View Count: 183
| [2025-09-03 06:29:50] |
| kremat0r - Posts: 50 |
|
Hello, I need to do one job, I have autoupdating excel file with levels which I want to import to sierra as horizontal lines. I cannot convert this file to .csv because it's updating realtime. I got lost. Can spreadsheet do this? I read manual but cannot get it. I have this file open 24h and now I'm reading levels manually and moving lines manually which takes a lot of effort. Thank you in advance |
| [2025-09-03 15:15:00] |
| John - SC Support - Posts: 41652 |
|
You would need to create a custom study to do this. Refer to the following: Advanced Custom Study Interface and Language (ACSIL): Introduction 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 |
| [2025-09-03 15:26:08] |
| kremat0r - Posts: 50 |
|
hmm but direct reading of xlsx is not supported in ACSIL
|
| [2025-09-03 16:12:42] |
| John - SC Support - Posts: 41652 |
|
ACSIL uses standard C++, so you need to work out how to get the data from Excel in order for it to be used in Sierra Chart.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-09-03 17:23:26] |
| User719512 - Posts: 321 |
|
@kremat0r, how is your excel autoupdating? from within excel itself (macros, vb, etc), or some other process?
|
| [2025-09-04 04:18:40] |
| kremat0r - Posts: 50 |
|
@User719512 There are formulas inside excel, levels are calculated based on data feed and outcome is around 10 levels to plot on chart.
|
| [2025-09-04 16:29:20] |
| User719512 - Posts: 321 |
|
I would investigate using OpenXLSX from your Sierra study to read the excel file and keep track of the next time to read from the file based on a hard-coded or input to your study. Since OpenXLSX is as header only solution you can still build with Sierra build systems or using Visual Studio or similar. // pseudocode // init using whatever logic you prefer for study reload // you could also store the last read time in the sc.StorageBlock for better experience if (sc.Index == 0) { persistentLastRead = now() } ... if (persistentLastRead >= now()) { readFromFileAndUpdateLevels(); persistentLastRead.AddSeconds(15); } else { // do nothing; } You get the idea... Happy coding! |
To post a message in this thread, you need to log in with your Sierra Chart account: