Support Board
Date/Time: Mon, 23 Dec 2024 15:50:49 +0000
The last bar
View Count: 1051
| [2015-10-05 16:51:46] |
| Forward - Posts: 65 |
|
Hello to everyone, i have a problem with some indicators , ( exemple Bid Ask Volume Ratio) where the LAST BAR continue to move with the market and just when the new bar is formed then it stop the movement. So how can i eliminate the last bar ? Thank you |
| [2015-10-05 18:13:18] |
| |
|
This is not supported in Sierra Chart.
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 |
| [2015-10-05 19:45:31] |
| Sawtooth - Posts: 4141 |
|
You can do this with the Spreadsheet Study study. Here are the steps: 1) Hide the Bid Ask Volume Ratio study, and move it to the top of the Studies to Graph list. 2) Add the Spreadsheet Study study, set the Chart Region to the same as the Bid Ask Volume Ratio study, give it a name in the Spreadsheet Name field. 3) On the spreadsheet, put this in cell K3: =IF(ROW()=3,0,AA3) put this in cell L3: =0.000000000001 |
| [2015-10-08 06:25:36] |
| Forward - Posts: 65 |
|
i used your method tomgilb and it works perfectly. Thanks a lot. Just a question : why do you use 0.000000000001 ? Now if i want to built another indicator without the last bar , can i use the same parameter I suppose that i have to modify something... |
| [2015-10-08 12:34:12] |
| Sawtooth - Posts: 4141 |
|
why do you use 0.000000000001 ?
This creates a 'zero' line. If you use 0, the spreadsheet will ignore it.You can use the same non-zero 'zero' value in other 'zero' line formulas. You don't need to use this value if your other indicators don't need a zero line. If your other indicators have several subgraphs, you'll need to use a Formula Column for each. FYI, you must use another instance of the spreadsheet study for each Chart Region. You could use the same spreadsheet study for all indicators in the same Chart Region. Just use Formulas Columns to the right. |
To post a message in this thread, you need to log in with your Sierra Chart account: