I think I have figured it out. The following are bits of code
that I stole from one of TJ’s scripts.
FromDate = new Date;
/* year, month-1, day, hour, min, sec (required by JScript date
constructor) */
ToDate = new Date; // current time
/* getVarDate is required to convert from JScript Date to
OLE-automation date */
AA.RangeFromDate = FromDate.getVarDate();
AA.RangeToDate = ToDate.getVarDate();
So the whole thing becomes as follows (in case somebody else
wants to use it)
AB = new ActiveXObject("Broker.Application");
AB.LoadDatabase("z:\\Amibroker\\Data");
AB.Visible = true;
/* retrieve automatic analysis object */
AA = AB.Analysis;
/* Explore over symbols and all quotes*/
AA.ClearFilters();
AA.ApplyTo = 0; // use all symbols
//AA.RangeMode = 1; // Last Day
//AA.RangeN = 1; // Last Bar
FromDate = new Date;
/* year, month-1, day, hour, min, sec (required by JScript date
constructor) */
ToDate = new Date; // current time
/* getVarDate is required to convert from JScript Date to
OLE-automation date */
AA.RangeFromDate = FromDate.getVarDate();
AA.RangeToDate = ToDate.getVarDate();
AA.LoadFormula("c:\\amibroker\\Formulas\\1Production\\O2.afl");
AA.Explore();
AA.Export("c:\\Amibroker\\CSV FILES\\O2.csv");
From: amibroker@xxxxxxxxxxxxxxx
[mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf Of ta
Sent: Thursday, September 03, 2009 3:56 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Dynamically setting RangeFromDate to todays date
Does
anybody know how to dynamically set RangeFromDate to Todays date
(computer’s current date). I am using the following code to run an
explore. The problem is that it also picks up symbols that no longer trade . TIA
/********************Amibroker
open to database***********************/
AB
= new ActiveXObject("Broker.Application");
AB.LoadDatabase("z:\\Amibroker\\Data");
AB.Visible
= true;
/*
retrieve automatic analysis object */
AA
= AB.Analysis;
/*
Explore over symbols and all quotes*/
AA.ClearFilters();
AA.ApplyTo
= 0; // use all symbols
AA.RangeN
= 1; // Last Bar
//AA.RangeFromDate
=
//AA.RangeToDate
=
AA.LoadFormula("c:\\amibroker\\Formulas\\1Production\\O2.afl");
AA.Explore();
AA.Export("c:\\Amibroker\\CSV
FILES\\O2.csv");
__._,_.___
**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.
TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com
TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)
For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
![]()
__,_._,___
