Support Board
Date/Time: Mon, 25 Nov 2024 16:52:32 +0000
Spreadsheet Formula
View Count: 169
| [2024-02-23 14:23:54] |
| ssangha84 - Posts: 122 |
|
I'm trying to use the spreadsheet formula to show a certain number of ticks above the current bars "last" price. So I am using the spreadsheet formula and I put in "=C[0]+5" It works fine, but for some reason whenever I have it on, with every tick the whole chart shifts. As in the whole screen itself moves up and down with every tick. Is there a way to change that? |
| [2024-02-23 16:36:08] |
| John - SC Support - Posts: 36249 |
|
Two things. 1. The formula you have is setting a marker 5 points above the Close of the bar, not 5 ticks. If you want 5 ticks, then your formula would need to be the following: =C + 5 * TICKSIZE Note that you do not need the [0], as that is the default. 2. Make sure the Spreadsheet Formula is set to a scaling of "Same as Region". Refer to the following: Chart Scale and Scale Adjusting: Basing Scale Only on Price Bars For the most reliable, advanced, and zero cost futures order routing, use 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: