Support Board
Date/Time: Tue, 26 Nov 2024 19:52:59 +0000
Post From: TPO Value area lines
| [2014-05-29 23:44:06] |
| Sawtooth - Posts: 4120 |
|
You can do this with the Spreadsheet Study study. Check Hide Study on the TPO study. Add the Spreadsheet Study study. -give it a name in the Spreadsheet Name field -set the colors and draw styles as follows: K(SG1) as TPO POC L(SG2) as TPO VAH M(SG3) as TPO VAL put these formulas in the respective cells: K3: =IF(O3=$O$1,AA3,0) L3: =IF(O3=$O$1,AB3,0) M3: =IF(O3=$O$1,AC3,0) O3: =IF(INT(A3)>INT(A4),O4+1,O4) O1: =MAX(O3:O1002) this assumes the TPO Value Area Lines study's outputs appear in columns AA, AB, AC. Edit the formulas as needed, or move the TPO study to the top of the Studies to Graph list. Date Time Of Last Edit: 2014-05-29 23:53:16
|