Login Page - Create Account

Support Board


Date/Time: Mon, 20 May 2024 23:18:07 +0000



Offsetting arrows from bar High/Low

View Count: 1032

[2018-05-01 15:16:06]
User606491 - Posts: 164
On the spreadsheet system for trading and the spreadsheet study, I would like to use "arrow up" and "arrow down" on columns other than K-N.

However, when I do so, the arrows appear on the chart at value = 1. This dramatically skews the chart.

What setting should I change to have up arrows offset from the bar low and down arrows offset from the bar high?

Said differently, I would like the up/down arrows to appear on the chart exactly as they do for columns K-N.

thank you,
[2018-05-01 17:20:37]
Sawtooth - Posts: 4001
Use a formula like this to place the Arrow Up at the low of the bar:
=IF(YourUpFormula,D3,0)
And one like this to place the Arrow Down at the high of the bar:
=IF(YourDownFormula,C3,0)
[2018-05-01 17:49:16]
User606491 - Posts: 164
Can't thank you enough, Tom.

Best,

Eric
[2018-05-01 19:50:58]
Sierra Chart Engineering - Posts: 104368
This is explained here:
http://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#ControllingTheLocationOfArrowsOrSubgraphValues
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