Support Board
Date/Time: Sun, 12 Jan 2025 14:05:23 +0000
exporting price levels from excel
View Count: 1890
| [2017-03-01 15:45:15] |
| User736519 - Posts: 26 |
|
I have price levels in an excel file with some notes about that price example: ESH7 2167.75 MCHVN Zone 7/8- ESH7 2174.75 nVPOC 11/18 ESH7 2180.75 Dec Low - Mthly TF End ESH7 2181.75 NFP Lo 12/2 ESH7 2184.75 NFP SoC 12/2 ESH7 2186.25 NFP Hi 12/2 ESH7 2187.25 nVPOC 12/2 Is it possible to import these price levels into a chart(from excel) so that I can see the lines at those price levels on the chart along with the Notes. Attaching a sample screen shot Date Time Of Last Edit: 2017-03-01 16:02:25
|
Private File |
| [2017-03-01 17:13:14] |
| |
|
No, this is not possible.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-03-01 19:06:01] |
| User736519 - Posts: 26 |
|
Is it possible to add this feature. It really helps in having key levels on the chart without have to draw lines manually.
|
| [2017-03-01 19:11:42] |
| |
|
No. Refer to: Notice: Suggestions (Currently not accepting) You could consider using the Sierra Chart Advanced Custom Study Interface and Language to accomplish what you want. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2017-03-01 19:12:13
|
| [2017-03-01 21:09:22] |
| |
|
To do what you need, you will need to use the Sierra Chart Advanced Custom Study Interface and Language. You will have to write code in the study function which reads that text file and then you can add the text drawings to the chart by using the text drawing tool which is documented here: Using Drawing Tools From an Advanced Custom Study You may also be interested in the Spreadsheet Study which you can use to draw these levels without the text: Using the Spreadsheet Study Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-03-01 22:02:51] |
| Sawtooth - Posts: 4149 |
|
If you use the Spreadsheet Study study, a text label can be placed at the right edge of the chart, or in the Locked Fill space, by checking 'Name Label' of the spreadsheet column/subgraph on the Subgraphs tab of its study settings. The Name Label is the text in row 2 of the respective column. You could also add a sheet unassociated with a chart, and use that sheet for your computations, then reference that sheet and cell from the sheet associated with the chart. Thus, you might not need to use Excel at all. |
| [2017-03-02 04:55:32] |
| |
|
You can customize the study Subgraph labels with the Spreadsheet Study so that probably can do everything you need. Refer to: Overview of Spreadsheet Studies Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: