Support Board
Date/Time: Sun, 09 Mar 2025 01:29:58 +0000
[Programming Help] - Creating autimatically drawings,text from excel into chart
View Count: 665
| [2022-02-22 19:12:35] |
| User361939 - Posts: 167 |
|
Hello, Is it possible to create automatically from excel chart drawing e.g Vertical Line with text into chart? What i mean: I ususally type into excel some data like: CL 10:15 "some text e.g bla bla" I would like to automatically draw Vertical line at 10:15 with "bla bla" to chart CL. I'd like to work it at first offline, so excel will be created during session and afterwards i'd like to update chart with data from excel. If you just show me at least which direction should i take with this i would appreciate it very much. Best Regards |
 exampleblabla.png / V - Attached On 2022-02-22 19:11:06 UTC - Size: 56.06 KB - 168 views |
| [2022-02-23 04:16:34] |
| User99735 - Posts: 234 |
|
Yes possible. for simpler implementation, save the xls file in csv format and read it from a study and plot whatever instructions are present in the csv file.
|
| [2022-02-23 09:53:06] |
| User361939 - Posts: 167 |
|
Thank you for answer. Would you be kind and show one line , how the correct expression should look like? i would really appreaciate it. Best Regards |
| [2022-02-24 14:54:26] |
| User99735 - Posts: 234 |
|
Google / search for reading/writing csv files and using Drawing Tools. You will get sufficient sample code. I have a readymade solution using which you can add notes to a chart. DM me for details. |
To post a message in this thread, you need to log in with your Sierra Chart account: