Support Board
Date/Time: Sun, 24 Nov 2024 20:31:48 +0000
Post From: Study sub graph difference MA
| [2013-11-28 21:57:58] |
| TastyRisk - Posts: 119 |
|
If using the spreadsheet method, I suggest doing this: 1. Make a column's cell either a 1, or 0, depending on if last is > or < vwap. 2. Make a column's cell with formula like this> =IF(Last>VWAP,DIFF,0) (in english> if last above vwap then record diff from another cell else record a zero.) 3. Do the COUNTIF on the cells described in step 1. (suggest setting spreadsheet to have many more rows than needed incase bear market!). 4. Do the SUMIF on the cells described in step 2, using the single COUNTIF value to modify the SUMIF formula. 5. You only need to divide the SUMIF result by 5000 as the zeros should not add up to anything :-) note; this is all dependent on how flexible the function syntax is in SC spreadsheets. I don't know if this is doable in the new version but at least you have a path forward and perhaps a target in how you want to use the SUMIF function. |