Support Board
Date/Time: Sun, 02 Nov 2025 02:56:45 +0000
[Programming Help] - ACSIL help with reading a spreadsheet
View Count: 144
| [2025-09-25 17:16:22] |
| TriStar Trading - Posts: 184 |
|
I am looking for help in reading a spreadsheet I receive each day that has levels in it. I want to plot these levels as horizontal lines on a chart. The spreadsheet arrives in XLSM format. It would be great not to have to do anything with the spreadsheet of course. It seems CSV is the preferred format? Has anyone done this before? Any guidance would be appreciated. Thanks! Mike
|
| [2025-09-26 01:57:54] |
| ForgivingComputers.com - Posts: 1150 |
|
Mike, The XLSM file format is a Macro-enabled XLSX file, which is in Open XML format. You could read the text files and parse it to import the lines, but that is not as easy as reading a flat CSV file. Brad |
| [2025-09-26 03:10:34] |
| TriStar Trading - Posts: 184 |
|
Thanks Brad. That's right along with the guidance I got from Grok and ChatGPT. Doing XML parsing. I'm willing to give it go and try it. I'm wondering if anyone has any code to get a guy started?? The AI stuff says convert to CSV first. And then a bunch of other steps of course. It's not Visual Basic that's for sure. lol
Date Time Of Last Edit: 2025-09-26 03:12:52
|
| [2025-09-26 03:38:48] |
| ondafringe - Posts: 328 |
|
From Claude AI: If Mike reaches out directly, I can help him with:
Parsing his XLSM file to extract the trading levels Creating ACSIL code to read the data and plot horizontal lines Setting up an automated workflow for his daily files Providing starter code examples Having the actual XLSM file structure will make it much easier to give him specific, working code rather than generic examples. Thanks for connecting us - feel free to send him my way whenever he's ready! Might be worth a try. |
To post a message in this thread, you need to log in with your Sierra Chart account: