Script or Custom Function? past _X_ closes less than current close

Script or Custom Function? past _X_ closes less than current close

Josh McCormick
2020-09-07 13:26:48

I want to do something incredibly easy, but after so many attempts, my brain has turned to mush. Here's a simplified version of the problem:

There are any number of examples which show how many of the past _X_ closes are greater than a fixed number.
Or how many of the past _X_ closes are greater than the closing value that was five bars before (or after) it.

What I am looking for is something a little bit different:

For each and every bar, I want to count (and graph) how many of the past 50 bars had a close which is lower than *the current bar*.

I'd use something like SumIf, but I can't find a suitable comparison which tells it to compare the closing period against the current bar:

a=SumIf (close > ???????,1,50);

I tried both of these, but they don't return anything useful:

a=SumIf (close > close[count()],1,50);
a=SumIf (close > value (close,count()),1,50);

Any thoughts? Or am I trying to do something with QS Script that I should be writing a custom (CSharp) function for?

Thanks again,
Josh McCormick

QuantShare
2020-09-08 10:37:57

Best Answer

SumIf will iterate through the "array" parameter and calculate the "condition" parameter once, so it will not work in this case.

This is the kind of functions that currently needs to be developed in CSharp.

Loop through each bar (A) then for each bar loop through each past N bars (B) and compare that bar close (A) with the bar close (B).

Josh McCormick
2020-09-08 12:03:32

Thanks! You've rescused me from a mountain of troubleshooting.

Get more messages

No more messages

Back


Trading Items NYSE Index Closes 5x5 SMA & RSI Forex Strategy How far are the close prices from the support line Stocks with an EPS Several Times Higher than the Industry Average... Moving Average Crossovers In the Past Trading Days	How-to Lessons How to add custom position-based metrics to your trading system How to create a custom trading indicator How to create a custom trendline How to run a screen or a watchlist from a script How to use a custom drawing tool
Related Forum Threads Can a Money Management script access a custom function? How do I get the date of the current bar in a custom function? Composite Tool Script Editor - Write to TXT How do I find the close price for an entry matching a custom DB Unable to use Symbols.GetSymbols() in a custom downloader URL scr...	Blog Posts How to create and backtest thousands of trading rules in less tha... How to Create a Custom Real-Time Table using QS Trading Software Trading System Analysis: Backtesting report and custom measures Create custom metrics for the statistical data analysis tool Speed Up Optimizations by Saving Ranking Data into a Custom Datab...