Support Board
Date/Time: Sun, 24 Nov 2024 20:39:08 +0000
Post From: Study sub graph difference MA
| [2013-11-28 20:59:39] |
| TastyRisk - Posts: 119 |
|
I think you can do this in spreadsheet using the function COUNTIF and SUMIF. see; http://office.microsoft.com/en-gb/excel-help/countif-HP005209029.aspx & http://office.microsoft.com/en-gb/excel-help/sumif-HP005209292.aspx Make a cell either a 1, or 0, depending on if last is > or < vwap. You will use COUNTIF to find how many of the above cells it takes to find 5000 instances of positive values. You will make the SUMIF range dynamic depending on the value arrived at from the COUNIF. Specifically; The COUNTIF result will be referenced by - and used to construct - your SUMIF formula. Date Time Of Last Edit: 2013-11-28 21:11:16
|