Chris: thanks for getting back....replies are below in
CAPS:
Ken, I think you are asking whether you
can add information to the Amibroker database that is not related to
O,H,L,C,V, OI from a source that is different from Amiquote, right?
YES, THIS IS WHAT I WANT TO DO. THE SOURCE WOULD BE
AN EXTERNAL CSV FILE OR PERHAPS A TABLE(S) FROM
A MYSQL DATABASE.
If so, I'm afraid that ASCII import is
probably your best bet. The way I've done that is to create a dummy
ticker like QQQQa and then put information into the O array of QQQQa that
relates to, say, bids and information into the H array of QQQQa for, say,
asks.
AT FIRST, I SHY AWAY FROM CREATING A DUMMY TICKER
BECAUSE I NEED TO DO MY PROCESS ON A LOT OF SYMBOLS, ALMOST ALL OF THE
SYMBOLS IN THE FASTTRACK DATABASE (9500+). BUT MAYBE THIS IS THE ONLY
WAY.
Then, in order to operate on this
information, one relatively straightforward way is to use the Foreign
command, like Foreign ("QQQQa","O") when you need to retrieve
bids. Or you could have amibroker retrieve these fields on demand (in
your code) using fopen commands from a .csv format. or you could
retrieve from ..csv and put into static variables. Or you could use
the sql retrieval process made available by Amibroker.
NOW ALL OF THESE APPROACHES ARE SEPARATE FROM THE
ASCII IMPORT THAT YOU SAID "IS PROBABLY MY BEST BET". I NEED TO
RETRIEVE THE KEY PARAMETER I WANT TO SAVE FOR EVERY SYMBOL FOR EVERY
DATE THERE IS A QUANTITY AVAILABLE (MONTHLY DATA) BECAUSE THAT QUANTITY
WILL BECOME A RANKING VARIABLE FOR BACKTESTING PURPOSES, PROBABLY USING
IT, IN SOME MODIFIED FORM, AS THE POSITIONSCORE FOR A ROTATIONAL
BACKTEST.
CAN YOU SHARE (OR EMAIL ME DIRECTLY) SOME SAMPLE CODE FOR THE
RETRIEVAL PART USING FOPEN. THE SQL RETRIEVAL PROCESS IS ALSO VERY
INTERESTING BECAUSE THE RANKING VARIABLE I WANT TO USE IS NOW ENSCONCED IN
MYSQL DATA TABLES, ONE TABLE FOR EACH DATE (MONTHLY) THAT THE RANKING
PARAMETER WAS CREATED FOR.
THIS WOULD HELP ME TREMENDOUSLY IN UNDERSTANDING THE STEPS AND
FORMATS NEEDED FOR THE CODE FOR SUCH OPERATIONS. EXAMPLES I HAVE FOUND
IN HELP FILES AND OTHER MESSAGES ARE JUST TOO SPARSE OR NOT RELEVANT FOR
LEARNING ABOUT MY PROBLEM (RECENT EXAMPLE SUGGESTED IN MSG 121755 BEING A
NOTABLE EXCEPTION).
MANY THANKS.
KEN
Personally, I've done all four of these with
success. Each has their place. But, before I go any further,
perhaps you could confirm that this is what you are trying to
accomplish....
----- Original Message -----
Sent: Monday, June 02, 2008 9:19
AM
Subject: RE: [amibroker] Adding data
to field in existing symbol database.
Well, thanks, but I need to add many symbols
read automatically from a spreadsheet file into the database. The Quote
Editor will not do it automatically as far as I know.
Ken
Have a look at Symbol > Quote
Editor …
Henry
From:
amibroker@xxxxxxxxxps.com
[mailto:amibroker@yahoogroups.com] On Behalf Of Ken Close
Sent: Monday, June 02, 2008 4:37
PM
To:
amibroker@xxxxxxxxxps.com
Subject: [amibroker] Adding data to
field in existing symbol database.
Amiquote and Import from ASQII are
both aimed towards helping people import quotes from services like
Yahoo.
No where that I can find does the Help file (or
the Knowledgebase, or the Users Knowledgebase, nor past archived messages)
talk about how to ADD a value to an
existing field (say an empty volume or OI
field) in an existing
database.
Experimenting with the above mentioned tools does
not produce the result I need.
I
have nowhere else to turn as all of the above resources are
silent.
As someone else said: "can someone toss me a bone"
on this subject.