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

2008/5/22 Louis Préfontaine <rockprog80@xxxxxxxxx>:

Hi again,

Ok, I think that I understand a bit more how it works. The file.js will open Amiquote, who will then save the files to a .adq file, which is Yahoo daily. But this file is only good for one day (until the next time I run the script), so if for whatever reason I can't manuallu import the ASCII to the database then I am in trouble.

Would it be possible with the same type of script to run Amiquote, to download the quotes AND to save them to the database (current, or chosen one) directly so that whatever happens the quotes will always be there when I come back?

Thanks,

Louis

2008/5/22 Louis Préfontaine <rockprog80@xxxxxxxxx>:
Ok I ran an exploration with phony parameter (C>1) and saved the result to a watchlist and then exported the watchlist to a .tsl file.

Now I ran the script; it said "No tickers found in Amibroker" but then it began downloading the information as I wanted it to do.

But then, my question is: how to take that information back to the Database I am using? If I understand correctly (I did some research on the site) the .tls is simply a ticker list with no more information, so where is going the information and how to make sure that that information will go straight back to the database?

Thanks,

Louis

2008/5/22 Louis Préfontaine <rockprog80@xxxxxxxxx>:

Hi Chris,

Thanks for your help.

The problem I have is that... I am not sure how to use the .tls files! In fact, I never used them; instead I would simply use the "Auto-updated quotes" from the "Tools" menu in AB to automatically download the quotes from Amibroker.   So, I see in the code that you posted that I need to have the .tls files setted, and I am not sure how to do this.

1) How to take the tickers in my current database and put them in the .tls;
2) How to be sure that the next morning when I will open AB it will open the good database and that the database will contain the new information from the .tls file.

I guess this must be a really simple thing, but I still didn't get it... yet!

Thanks,

Louis

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
>>
>>
>>