New backtester function: DELTADAYS

Submitted by Marius Kjeldahl on Wed, 2006-03-15 00:00

DELTADAYS(date1, date2) returns the number of days between the two dates. If date2 is later than date1 the number will be positive, or else negative. The typical usage will typically be:

 Keep: DELTADAYS([SI Weekly data date], [SI Date--Current fiscal year]) > numberofdays

I am not sure how useful it is, but somebody might figure out something clever to do with it. A couple of "challenges" arose when implementing this feature. SIPRO actually stores some dates as 20051232 and similar which are not actual valid dates. Whenever such dates appear, I replace "32" with "31".

Add new comment

More information about text formats

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Syntax highlight code surrounded by the {syntaxhighlighter SPEC}...{/syntaxhighlighter} tags, where SPEC is a Syntaxhighlighter options string or class="OPTIONS" [title="the title"].
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <h2> <h3>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.