Support Board
Date/Time: Sat, 01 Mar 2025 05:24:22 +0000
Post From: Help with spreadsheet study. Did not find similar question on the boards
| [2021-09-10 12:45:10] |
| Sawtooth - Posts: 4177 |
|
Note: I'm not SC Support. I am only a user. Try this: - Set 'Use Price Graph Style' to Yes. This plots OHLC candlestick bars from values in columns K-N where: Column K is the Open Column L is the High Column M is the Low Column N is the Close - Set Subgraph colors: K/SG1: Green L/SG2: Light Green M/SG3: Red N/SG4: Light Red - Formulas on the spreadsheet: K3: =OFFSET(N3,9,0) L3: =MAX(N3:N12) M3: =MIN(N3:N12) N3: =(SUM(BE3:BE12)-SUM(BC3:BC12))/(SUM(BE3:BE12)+SUM(BC3:BC12)) K3 is the Open of the 10 bar array because it is the first bar of the 10 bar offset of the Close. (The OFFSET function is not inclusive, so 9 gets the 10th bar.) L3 is the High of the 10 bar array because it is the max of the array. M3 is the Low of the 10 bar array because it is the min of the array. N3 is the Close of the 10 bar array because it is the current bar. Date Time Of Last Edit: 2021-09-10 14:36:35
|