Re: [amibroker] amiquote lack of control, AmiBroker Email List Archive

2008/5/22 Chris DePuy <cdepuy@xxxxxxxxx>:

You could try this.. (where big = your database name). If you have questions about detailing this, then you might want to do a "site:www.amibroker.com AB.LoadDatabase" search and see what is on the ami site.

Good luck

/********************Amibroker open to database***********************/
AB = new ActiveXObject("Broker.Application");
AB.LoadDatabase("C:\\Program Files\\Amibroker\\Big");
AB.Visible = true;

/* retrieve automatic analysis object */
AA = AB.Analysis;

/********************Amiquote retrieve current***********************/

AQ = new ActiveXObject("AmiQuote.Document");
AQ.Open("C:\\Program files\\Amibroker\\amiquote\\Big.tls");
AQ.GetSymbolsFromAmiBroker();
FromDate = new Date(2006,7,1,0,0,0);

/* 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 */
AQ.From = FromDate.getVarDate();
AQ.To = ToDate.getVarDate();
AQ.AutoImport = true; // import automatically
AQ.Source = 1; // Yahoo Current

AQ.Download(); // starts download
// wait until download and import is finished
while( AQ.DownloadInProgress || AQ.ImportInProgress )
{
    WScript.sleep(5000); // wait 5 seconds before querying status again
}

/********************Amiquote retrieve current (end)***********************/

----- Original Message -----

From: Louis Préfontaine

To: amibroker@xxxxxxxxxxxxxxx

Sent: Thursday, May 22, 2008 8:33 AM

Subject: Re: [amibroker] amiquote lack of control

Thanks,

This is what I was looking for...

Unfortunately, I know nothing (nada, niet, rien) of this language.   I don't use any .tls folder; is it possible to build such script that would automatically look into AB and update the quotes in the selected database? Or would it be better to save my current databse in .tls?

Thanks,

Louis

2008/5/22 Chris DePuy <cdepuy@xxxxxxxxx>:

Yuki had asked in "Re: [amibroker] amiquote lack of control" now Louis has asked in "Is it possible to run Amiquote automatically". Here is how to get Amiquote to run by itself from "outside" of Amibroker.

Amibroker and its related programs are easy to make work from other programs, like DOS boxes, or by double clicking in windows.

1)   http://www.google.com/search?hl=en&q=site%3Awww.amibroker.com+OLE+amiquote&btnG=Google+Search

2) Now, here's some code to try (copy this into notepad).

AQ = new ActiveXObject("AmiQuote.Document"); AQ.Open("C:\\mysymbols.tls");

FromDate = new Date(1995,5,1,0,0,0);/* 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 */ AQ.From = FromDate.getVarDate(); AQ.To = ToDate.getVarDate(); AQ.AutoImport = true; // import automatically AQ.Source = 0; // Yahoo Historical

AQ.Download(); // starts download

// wait until download and import is finishedwhile( AQ.DownloadInProgress || AQ.ImportInProgress ) {     WScript.sleep(5000); // wait 5 seconds before querying status again } WScript.echo("Download and import complete");

3) Keep in mind, that you have to use notepad to create this. And call it, yuki.js and then save it. Then, double click yuki.js and it'll run a bunch of stuff in amiquote automatically.

4) If you are interested, you can use "Scheduled Tasks" to run yuki.js at scheduled times (See ramvilas 's email from 5/22/08)

----- Original Message -----

From: Yuki Taga

To: Tomasz Janeczko

Sent: Sunday, May 11, 2008 5:35 PM

Subject: Re: [amibroker] amiquote lack of control

Is there anything for "normal" people? I mean people who look at the
link you have provided and say, "Gee, that looks like it should be
useful, somehow, but what now?" People who think OLE is something you
shout in Spain, at a bullfight?

Yuki

Saturday, May 10, 2008, 5:29:13 AM, you wrote:

TJ> Hello,

TJ> Automation via "keyboard simulation" is not reliable.
TJ> Reliable way to automate is to use OLE interface
TJ> and that is proper way to automate AmiQuote

TJ> http://www.amibroker.com/guide/aqobjects.html

TJ> Best regards,
TJ> Tomasz Janeczko
TJ> amibroker.com
TJ> ----- Original Message -----
TJ> From: "Yuki Taga" <yukitaga@xxxxxxxxxxxxx>
TJ> To: <amibroker@xxxxxxxxxxxxxxx>
TJ> Sent: Friday, May 09, 2008 1:37 PM
TJ> Subject: [amibroker] amiquote lack of control

>>I use a keyboard automation program (Automate) to do a lot of routine
>> tasks, including tasks that must get done when I'm on vacation.
>> (When I'm on vacation, it means I don't even log into a computer for
>> *any* reason -- in fact, I don't even want to *see* a computer when
>> I'm on vacation.)
>>
>> I also keep a database of selected US indices and symbols (not
>> large), that I update with Yahoo (dead-on accuracy is not necessary).
>> But with Amiquote, I cannot toggle between 'Current' and
>> 'Historical', because there is no way to do this via the keyboard.
>>
>> Unfortunately, some Yahoo symbols have daily data, but no historical
>> data. I like to run 'Current' in the morning (my time), and
>> 'Historical' in the afternoon. Then I'm covered.
>>
>> I have asked on more than one occasion that keyboard control be added
>> to Amiquote, but it is apparently a very low priority. However, my
>> next paid Amibroker upgrade will be an equally low priority unless
>> there is a way to accomplish what I feel I need to do.
>>
>> Anyone?
>>
>> Yuki
>>
>>
>> ------------------------------------
>>
>> Please note that this group is for discussion between users only.
>>
>> To get support from AmiBroker please send an e-mail directly to
>> SUPPORT {at} amibroker.com
>>
>> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
>> http://www.amibroker.com/devlog/
>>
>> For other support material please check also:
>> http://www.amibroker.com/support.html
>> Yahoo! Groups Links
>>
>>
>>