Login Page - Create Account

Support Board


Date/Time: Mon, 20 May 2024 05:47:04 +0000



Post From: Referencing last N bars using Spreadsheet Formula study

[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.