Support Board
Date/Time: Tue, 04 Mar 2025 03:12:58 +0000
How to create lines using prices in a spreadsheet or text file
View Count: 754
| [2021-11-19 21:21:01] |
| 12VMan - Posts: 45 |
|
I have a list of prices and I want Sierra to automatically create lines at each of them. If I put the prices in a spreadsheet, .csv, .txt, etc file, how would I get Sierra to read the file and create the lines. I thought Spreadsheet Study might work, but the documentation is not clear.
|
| [2021-11-19 22:13:36] |
| John - SC Support - Posts: 38341 |
|
There is not a built-in method to read data from a spreadsheet or file in order to create lines. It can only be done for data. In general, you would need to create a custom study to do what you want. Refer to the following: Advanced Custom Study Interface and Language (ACSIL): Introduction Although you should look around the Internet to see if someone may have already created something to do this. There is also the following study that could be used, but it would require that you have a website that you can connect to in order to get the data: Trading Levels For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-11-20 04:35:48] |
| Sawtooth - Posts: 4179 |
|
I have a list of prices and I want Sierra to automatically create lines at each of them.
If copy/paste would work for you, it could probably be done with the Spreadsheet Study study.Limitations: - Max of 60 lines. - List is static, until overwritten. - Not dynamic so extending until future intersection is impractical. - Cannot be drawn on future bars. - Many 1000s of bars back can cause lag. - There might be other limitation depending on what you are doing. |
| [2021-11-20 13:19:58] |
| 12VMan - Posts: 45 |
|
If copy/paste would work for you, it could probably be done with the Spreadsheet Study study.
That would work fine as there are less than 60 price points and I replace them daily. I’ve read the Spreadsheet Study documentation and can’t even figure out where to start though |
| [2021-11-20 13:58:13] |
| Sawtooth - Posts: 4179 |
|
Add the Spreadsheet Study study. - Give it a name in the Spreadsheet Name field. - Set the Chart Region to 1. - Set the 'Number of Formula Columns' to 60. - On the Subgraphs tab, set the Draw Style of all SGs to Dash or Line. If the price list is a single column, paste it in Column H, an open blank column. Then in row 3 of columns K-BR, use an absolute reference of each Column H cell, e.g.: K3: =$H$1 L3: =$H$2 M3: =$H$3 ...etc |
To post a message in this thread, you need to log in with your Sierra Chart account: