Support Board
Date/Time: Sat, 01 Mar 2025 05:19:07 +0000
Post From: Help with spreadsheet study. Did not find similar question on the boards
| [2021-09-10 17:53:11] |
| Sawtooth - Posts: 4177 |
|
The formulas I offered work with the Ask Volume and Bid Volume studies, because they are aligned with each chart bar. All of the Depth of Market Data study output levels are current values, displayed in rows that are not aligned with chart bars. The spreadsheet study can only calculate the ratio of 10 depth levels at the current OHLC bar. Only the values in row 3 are accurate, so only the current bar is accurate, as you note. The spreadsheet study cannot retain and plot older OHLC bars like the Bid And Ask Depth Bars study does. IOW, you can't do what you want with a spreadsheet study. You would need to create a custom ACSIL study. Date Time Of Last Edit: 2021-09-10 18:19:49
|