Login Page - Create Account

Support Board


Date/Time: Sun, 12 Jan 2025 18:40:56 +0000



exporting price levels from excel

View Count: 1891

[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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account