Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 22:41:13 +0000



Post From: Feature request for Spreadsheet Formula Study

[2023-10-11 21:16:00]
AndyB - Posts: 101
I would like to propose a feature request for the Spreadsheet Formula Study that would allow "Number of Bars To Calculate (ln:2)" to also accept formulas.

I prefer using multiple spreadsheet formula studies as opposed to the "Spreadsheet Study" for a variety of reasons. Letting this input accept a formula would allow one to reference another study (perhaps a separate spreadsheet) the same way the formula input does, to dictate the number of bars calculated for some, or even all, spreadsheets they have working off of each other. I do my building of systems on a pretty short calculation number, and then actual analysis on longer calcs. For 1. it would be a heck of a lot quicker to change one number rather than going through all of them (could even over lay that parent study onto other charts with spreadsheet studies as well), and 2. admittedly when changing this input, sometimes I miss one or two of them.

I'm not sure if this easy to do or even possible, but I thought that would be a nice addition. Of course, a custom study is the answer here, but there's a lot of rabbit holes that lead to nothing, and hashing out ideas through the study is much more convenient, especially for those of us who aren't quick coders.

Thank you.

Side question: any tips for improving the latency of "Study/Price Overlay"? often times these are updating >500ms and it throws off some calculations on my parent chart if I'm overlaying something like the depth study from a chart with a higher number of levels to build the book. Advice is appreciated!