Login Page - Create Account

Support Board


Date/Time: Mon, 29 Apr 2024 10:59:56 +0000



How to align spreadsheet calculation with price on chart

View Count: 503

[2017-03-16 22:26:49]
gmax1mum - Posts: 4
I would like to have a value from a spreadsheet study printed as text at price levels. This is just for order flow purposes so that I can see the value Im needing right at traded price, ie. volume traded with each uptick etc.

I will attach picture of what I am referring to.

Would anyone here know how to go about doing this?

Thanks in advance.
imagewant.jpg / V - Attached On 2017-03-16 22:26:35 UTC - Size: 121.05 KB - 235 views
Attachment Deleted.
[2017-03-16 23:19:38]
Sawtooth - Posts: 3982
Try this:

- Put the price level in row 3 of Formula Columns.
- Put the value in row 2, forced to text: =TEXT(value)
- set the Draw Style to Text
- check 'Name Label'
- set Horizontal Align to Right or Right Edge.
Date Time Of Last Edit: 2017-03-16 23:28:27
[2017-03-17 10:19:06]
Sierra Chart Engineering - Posts: 104368
This is the Draw Style that you will want to use:
Chart Studies: Value of Subgraph (ACSIL: DRAWSTYLE_VALUE_OF_SUBGRAPH)

Really would be best to use ACSIL for this:
Advanced Custom Study Interface and Language (ACSIL)
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-17 10:19:39

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account