Reply To: TimeSinceSignal formulas

Optuma Forums Optuma Scripting TimeSinceSignal formulas Reply To: TimeSinceSignal formulas

#58337
Darren
  • Topics: 67
  • Replies: 705
  • Posts: 772

Hi Dean,

I think the issue is that you may be counting since the condition was last true – not how long it has been true, hence the zeroes for those where currently true. It’s a bit confusing, but instead you need to count how long it’s been since the condition was last false. Remember that a value of 1 is true and 0 is false, so this will show how long it has been true by counting the days since it was false:

This list of FTSE100 stocks shows when the V1 condition is true in blue on the chart, with the green showing the time counts. So OCDO has been positive for 51 days, whereas the ADX False column shows how long it has been false (in other words how long since it’s been true) i.e. 28 days for NG. Hope that makes sense!

Capture

  • This reply was modified 1 year ago by Darren.
1 user thanked author for this post.

Pin It on Pinterest