--- In [email protected], Ken Close <[EMAIL PROTECTED]> wrote:
If you want to use an empty field such as OI, then you could use a script to parse the CSV and then use the OLE interface to set the OpenInt Property on the Quotation object. Tuzo > Chris: thanks for getting back....replies are below in CAPS: > > _____ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Chris DePuy > Sent: Monday, June 02, 2008 12:39 PM > To: [email protected] > Subject: Re: [amibroker] Adding data to field in existing symbol database. > > > 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 ----- > From: Ken Close <mailto:[EMAIL PROTECTED]> > To: [email protected] > 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 > > _____ > > From: [EMAIL PROTECTED] <mailto:[email protected]> ps.com > [mailto:[EMAIL PROTECTED] On Behalf Of Jindrich Kostalek > Sent: Monday, June 02, 2008 11:04 AM > To: [EMAIL PROTECTED] <mailto:[email protected]> ps.com > Subject: RE: [amibroker] Adding data to field in existing symbol database. > > > > Have a look at Symbol > Quote Editor . > > Henry > > > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Ken Close > Sent: Monday, June 02, 2008 4:37 PM > To: [email protected] > 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. > > > > Thanks for any help. > > > > Ken >
