Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 06 May 2024 01:57:05 +0000

How to Post a Message for Support

Post From: Study sub graph difference MA

[2013-11-28 20:59:39]
[Go To First Post]
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