Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 12:12:18 +0000



Post From: Spreadsheet

[2019-07-03 22:19:14]
Sawtooth - Posts: 3976
Trying to find a formula for calculating the volume above and below after the trigger of the Large Volume Trades trigger
Volume at price in not output by the Large Volume Trades Indicator study, and not directly available to the Spreadsheet System for Trading study.

It is output by the Spreadsheet Study study by setting 'Output Volume At Price Data' to Yes, but you cannot use more than 42 Formula Columns because the outputs are in column BA and above. Also the output is horizontal, not vertical, and starts with the volume at the low in column BC.

It would be challenging to do what you want with a spreadsheet study because every bar's low is at a different price.