Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 09 May 2024 02:18:00 +0000
Referencing last N bars using Spreadsheet Formula study
View Count: 1962
| [2018-02-28 09:41:44] |
| User132748 - Posts: 159 |
|
How can i reference last N bars in Spreadsheet formula study? Using Spreadsheet Study I can put something like that: =MIN(K3:K10). How can I reference such ranges in Spreasheet Formula study? Thanks |
| [2018-02-28 18:48:13] |
| |
|
The use of a range is currently not supported in the Spreadsheet Formula. This is stated in the documentation here: Spreadsheet Formula 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 |
| [2018-03-01 08:25:34] |
| User132748 - Posts: 159 |
|
OK thanks Regarding future development of Spreadsheet Formula it would be nice to have a possibility to output the result as OHLC candles. So there would be needed 4 different formulas for OHLC, or maybe you could provide some aggregate function that would reference 4 input studies and draw them as candles, so as inputs one could use 4 different Spreadsheet Formula studies. |
| [2018-03-01 21:55:42] |
| |
|
If this is what you require you really should 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 |
| [2018-03-02 00:52:15] |
| Sawtooth - Posts: 3993 |
|
You can do this with the Spreadsheet Study study: -Set 'Use Price Graph Style' to Yes. -Use only columns K,L,M,N as O,H,L,C -Enter formulas in row 3 only. -You'll need to use spreadsheet syntax, not Simple Alert syntax. Spreadsheet Study Inputs: Use Price Graph Style |
| [2018-03-02 07:08:59] |
| User132748 - Posts: 159 |
|
Thanks for reply. Sure you can thats easy, but the whole idea of spreadsheet formula study is not to use Spreadsheet study. Maybe Im wrong, but i think theres big extra load for platform when you use spreadsheet on chart that has many studies in it, because sierra has to update ALL STUDIES VALUES on that spreadsheet constantly. Even when you dont need all of them to use in your formula. Thats how I understand Spreadsheet Formula study is much lighter solution, as it doesnt have to update anything on some sheet, but just takes needed values directly. I think the easiest solution is just to write few lines of code in ASCIL, take 4 input studies as references, and just plot them. I just thought that would be a nice add on for others as native solution. |
To post a message in this thread, you need to log in with your Sierra Chart account: