[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: How to use AmiQuote 1.2



PureBytes Links

Trading Reference Links

Hi Tomasz:

Nice improvements!

> Note that AmiQuote currently supports a new command line 
> parameter: /autoupdate. This option forces AmiQuote to perform 
> automatic update procedure without user intervention. 
> You may setup you custom tools menu in AmiBroker to call AmiQuote 
> with this argument:
>
> C:\Program Files\AmiBroker\AmiQuote\Quote.EXE /autoupdate 
>
> If you do so, you will be able to update your US database with a 
> single click.

I'm unable to get this one to work...nothing happens. Do I have to 
have amiquote running? Do you post any messages when complete? 

Also, it appears you use the last date from the 1st ticker in the 
database for the starting date of ALL tickers in the database? A 
more robust solution (although slower) would be to fetch the last 
date from the database for each ticker individually. 

If you're keeping up a large database (all NYSE/NASD/AMEX stocks) 
I've found Yahoo's data to be very unreliable w.r.t. availability. 
Depending on the day (and the moon's phase!) some tickers (they 
change by day) are NEVER available on the daily page and their 
availability from the historical page is sometimes several days 
later. So it's possible that a previous update would have updated 
the database incompletely and a fresh update, assuming a starting 
date of the 1st ticker, would leave some gaps in data for subsequent 
tickers that didn't get updated because the data wasn't available 
when the previous update occurred.

I currently use the (fast!) daily yahoo script that you wrote 
followed by my own script to evaluate the results of the download for 
each ticker that writes out a .tls file for any stale tickers after 
the update. I then use amiquote to download the missing tickers from 
the historical page which is more reliable than the daily page as far 
as availability. Even then I'm not sure that I've got them all as 
many (500+) don't trade every day.

Thanks and keep up the good work!
Jim

--- In amibroker@xxxx, "Tomasz Janeczko" <tj@xxxx> wrote:
> Hello,
> 
> Before you ask "How [...] should I use this tool?" below you will 
find the instructions
> (this is an excerpt from ReadMe2.html file supplied in AmiQuote 
archive).
> 
> Best regards,
> Tomasz Janeczko
> ===============
> AmiBroker - the comprehensive share manager.
> http://www.amibroker.com
> QUICK START
> 
> Note: this procedure works only if you have AmiBroker installed:
> 
> 1.. Launch AmiBroker and AmiQuote 
> 2.. Choose Tools->Auto-update AmiBroker database (or 
corresponding toolbar button) 
> USAGE
> 
> Automatic update
> 
> The easiest method to work with AmiQuote and AmiBroker is to use 
automatic update procedure. Just run AmiBroker and AmiQuote and 
choose Tools->Auto-update AmiBroker database. This method updates 
historical quotes from the last date present in AmiBroker upto today. 
When performing automatic update, AmiQuote performs internally 4 
steps 
> a) retrieves the ticker list from AmiBroker (all stocks loaded 
currently in AmiBroker);
> b) gets the last quotation date available in AmiBroker;
> c) performs historical download from last date upto today;
> d) instructs AmiBroker to import downloaded files.
> 
> Please note that this procedure works only for US & Canada 
markets, because Yahoo provides historical quotes only for that 
markets.
> 
> Note that AmiQuote currently supports a new command line 
parameter: /autoupdate. This option forces AmiQuote to perform 
automatic update procedure without user intervention. 
> You may setup you custom tools menu in AmiBroker to call AmiQuote 
with this argument:
> 
> C:\Program Files\AmiBroker\AmiQuote\Quote.EXE /autoupdate 
> 
> If you do so, you will be able to update your US database with a 
single click.
> 
> Manual operation
> 
> Automatic mode is nice but there are cases when you have to 
perform some tasks manually. There is a good old document describing 
that mode of operation at: http://www.amibroker.com/docs/ab304.html . 
Everything written in this document remains valid with one exception -
now importing to AmiBroker are performed automatically if you have 
Automatic import checkbox marked.
> 
> There are also several cases when you prefer to do things 
manualy, then please don't forget about some useful tools available 
at your fingertips:
> 
> File->Open, File->Save, File->Save As 
> 
> These functions enable you to load and save your edited ticker 
lists for future repeated use.
> 
> Edit->Add tickers
> 
> This function allows you to add the tickers to the list. Just 
type space separated tickers into the field that will show up when 
you choose this function.
> 
> Edit->Delete tickers
> 
> This function allows you to delete tickers from the list. Just 
select the items you want to delete from the list view (multiple 
selection possible by holding SHIFT or CTRL key while clicking on 
items), and choose this function.
> 
> Edit->Mark all, Edit->Unmark all, Edit->Toggle, Edit->Mark 
selection, Edit->Unmark selection
> 
> These functions allow you to mark the tickers for download. 
Please note that AmiQuote puts a checkmark before ticker name in the 
list view. ONLY MARKED items will be downloaded. This allows you to 
perform selective downloads/updates.
> 
> View->Refresh
> 
> Basically AmiQuote handles refreshes by itself when needed. For 
example if you changed the date range, the list will be refreshed 
before starting download. But there are some cases when you may want 
to refresh the list by yourself. For example if you downloaded and 
imported quotes once and want to do this again you would need to 
choose this function. The Refresh function simply applies all date 
and type settings to the URLs listed, and MARKS all tickers for a new 
download.
> 
> Tools->Import into AmiBroker
> 
> This function is useful if you want to import just downloaded 
quotes into AmiBroker but you have Automatic import checkbox cleared.
> 
> Tools->Get tickers from AmiBroker
> 
> This function retrieves all stocks from currently loaded 
AmiBroker database and fills the AmiQuote ticker list with them.
> 
> Tools->Get last update date
> 
> This function retrieves the date of the most recent quotation 
of the first stock present in currently loaded AmiBroker database and 
sets the From date to this date.
> 
> Tools->Settings
> 
> Displays the settings window where you can define the 
destination directory where all downloads are stored. Note that blank 
destination directory means that downloads will be stored in the 
current working directory (in most cases this is the folder from 
where current .TLS file was loaded).
> 
> In this window you can also change the mode of writing the 
files. By default historical files are overwritten while daily files 
get appended. This is recommended setup. Appending daily files simply 
allows you to create intra-day historical files when you do the 
updates daily. You may change this behaviour for your particular 
purpose.