|
PureBytes Links
Trading Reference Links
|
Larry,
I think, it helps you more when you take afew
minutes and read in the amiquote and amibroker help about the
import.
Here stands more, than we all can
write.
In the amibroker help you see all about formats and
import.
Here is the help from amiquote:
AmiQuote Read
Me
AmiQuote 1.47 Read Me ( June 7, 2002
)
INTRODUCTION<FONT
face="Arial, sans-serif" size=2>
AmiQuote is a companion program to AmiBroker stock charting/analysis
software.
The main purpose of AmiQuote is to simplify and automate downloading
current day and historical EOD quotation data from free Yahoo! Finance
sites and delayed intraday bar data from Quote.com servers.
AmiQuote performs downloads using multiple threads allowing you to fully
utilise your connection bandwidth.
WHAT'S NEW IN VERSION
1.47?
AmiQuote now supports 3 different intraday Quote.com servers. You can
select one in Tools->Settings "Intraday server"
WHAT'S NEW IN VERSION
1.46?
bug fix: solved problem with renaming of tickers with "COM", "AUX", "LPT"
substrings. Now only full ticker symbol is matched (not substring)
bug fix: "Number of symbols per request (current mode)" does not switch
back to 1 anymore when the settings page is opened
WHAT'S NEW IN VERSION
1.45?
rewritten downloading code - more robust - closes "dead" connections and
includes auto-retry feature
settings dialog now allows to define the number of auto-retries, delay
between retries, connection and receive timeouts used to detect not responding
connections
colon character ':' in the ticker name is automatically replaced by
underscore '_' to avoid problems with file system not allowing colon in the
file name.
WHAT'S NEW IN VERSION
1.41?
5-min and larger intervals work correctly now
daily interval added for downloads from Quote.com servers (allowing you to
get quotes of E-minis for example not supported by Yahoo)
WHAT'S NEW IN VERSION
1.4?
Download delayed intra-day bar data (1-min, 5-min, 15-min, 60-min, 120-min
bars) for US securities
Simplified download historical and daily data from 50 international
exchanges (one setting works for all exchanges)
Ability to run downloads automatically in user-defined intervals
AmiQuote is now shareware. The evaluation version is FULLY functionaland
has NO time limit, so you can use it as long as you wish, but if you likethe
program and use it often you are encouraged to purchase life-time licensefor
only $25. Click
here to buy
WHAT'S NEW IN VERSION
1.3?
Retrieving multiple symbols data in one request (current mode only) -
provides huge speed-up for download in "current" mode. Number of symbols
definable in the Settings.
WHAT'S NEW IN VERSION
1.2?
Fully automatic updates of AmiBroker database (US & Canada markets
only)
Editing and saving ticker lists
Integration with AmiBroker (retrieving ticker lists and last update date)
Better error handling and greatly improved stability
Selective downloads
Support for updating mutual fund quotes (close price only)
Support for appending data files
User-defined destination folder
Settings are preserved between sessions
added support for Argentina, Brazil, China, Denmark, Hong Kong, India,
Japan, Mexico, Norway, Sweden, Singapore, Spain, Taiwan (version
1.21)
INSTALLATION
If you have installed AmiBroker already, no special installation of
AmiQuote is required. Just unzip AmiQuote package to a separate directory(the
default is "C:\Program Files\AmiBroker\AmiQuote"). If you haven't installed
AmiBroker yet it is recommended to do so, because AmiQuote uses MFC libraries
(version 6.0) that are supplied with AmiBroker.
QUICK START
Note: this procedure works only if you have AmiBroker
installed:
Launch AmiBroker and AmiQuote
Choose Tools->Auto-update AmiBroker database (or corresponding
toolbar button)
HOW IT WORKS
AmiQuote loads (or retrieves from AmiBroker) a ticker list file (.TLS)
which is simple ASCII file with ticker symbols, then parses it and downloads
data from either Yahoo Finance or Quote.com servers. Then, when you startthe
download process, it requests the data from Yahoo and stores downloaded data
in the separate .AQD (daily) or .AQH (historical) or .AQI (intraday bar) files
for each ticker. After download, if AmiBroker is running, AmiQuote will import
the quotes into AmiBroker automaticaly.
USAGE
Below you will find some tips on using AmiQuote 1.2 with and without
AmiBroker. More detailed instructions will be provided with the upcoming
AmiBroker 3.65.
Using AmiQuote in stand-alone mode
Although AmiQuote is provided as a companion program to AmiBroker it is
however possible to use it without AmiBroker. Here is a simple procedure of
downloading quotes using stand-alone AmiQuote:
Launch AmiQuote
Open supplied example file DJIA.TLS in the directory DJIAThis will
load example ticker list (components of Dow Jones Industrial Average)
Choose between downloading current or historical or intraday interval
bar quotes (intraday interval bars are available only for US exchanges)
Click on green arrow toolbar button (Start download)now for a couple
of minutes you can watch the download operation progress
When all downloads are complete you can close the program and find
appropriate .AQD (daily quotes) or .AQH (historical) or .AQI (intraday)
files stored in the directory where TLS file is located.
Using AmiQuote with AmiBroker
Automatic
update
The easiest method to work with AmiQuote and AmiBroker is to use the
procedure given in Quick Start section of this document. 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.
AmiQuote now supports over 50 international exchanges in "historical" and
"daily" modes.
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 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: <A href=""
target=_blank>http://www.amibroker.com/docs/ab304.html . Everything
written in this document remains valid with one exception - now importingto
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 listsfor
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 MARKSall
tickers for a new download.
Tools->Import into AmiBroker
This function is useful if you want to import just downloaded quotesinto
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
|