Here is a way to do that. A method to import extra data into AmiBrokers Open Interest field using AmiQuote with Yahoo data downloads.
(this is a basic method that can be developed for wider use). a) Open AB and create a new, blank, database. b) Open AmiQuote and add a ticker e.g. PRXL Note: PRXL had a 2:1 stock split on 03-03-2008 c) Download PRXL historical WITHOUT selecting "Automatic Import" - leave AQ open. d) Go to AmiBroker/Formats folder and open the aqh.format file. Note: it is a text file and it will open in NotePad Add OpenInt to the format profile and save. e) Go to AmiBroker/AmiQuote/Downloads and rename the PRXL.aqh file to PRXL.csv then open it, add any required data to the column after the adjClose and save it. Once it is saved change the name back from .csv to .aqh f) return to AmiQuote and select Tools >> Import into AmiBroker (the data in the PRXL.aqh file, including the data in the OI field, will be imported into the open AmiBroker database. There is a temporary file with picies at the UKB: http://www.amibroker.org/userkb/2008/03/21/amiquote-ascii-importing/ note: after changing the .csv file back to a text file I had to pick some (PRXL) commas out of my teeth. Thanks to Bob for a very nice lead. brian_z --- In [email protected], "brian_z111" <[EMAIL PROTECTED]> wrote: > > FTR, > > Here are some highlights from previous discussions. > > The COM method seems to be a step-up from what has gone before? > > http://finance.groups.yahoo.com/group/amibroker/message/91622 > > http://finance.groups.yahoo.com/group/amibroker/message/118009 > > http://finance.groups.yahoo.com/group/amibroker/message/80876 > > http://finance.groups.yahoo.com/group/amibroker/message/61353 > > brian_z > > > > > > --- In [email protected], "paultsho" <paultsho@> wrote: > > > > --- In [email protected], <bjagow@> wrote: > > > > > > Although I understand that additional AB data arrays [and means > of > > populating them] are planned for the future, I'd like to store a > > weekly value into the OI field.of existing tickers. > > > > > > Any way to do this with AmiQuote? > > > If not, how about with fget, etc? > > > > > > TIA, > > > Bob > > > > > Bob > > You can't do it in Amiquote or fget, but you can do it with COM > > objects. > > The following example gives you a means > > Ranking = C; // replace this with something you want to store > > ab = createobject("broker.Application"); > > target = ab.Stocks(name()); > > qts = target.Quotations; > > for(i = 0; i < Barcount; i++) > > { > > qt = qts.Item(i); > > qt.OpenInt = Ranking[i]; > > } > > buy = sell = 0; > > > > Run scan over tickers that you want. and Remember to refresh all to > > see the changes > > It is very important to know that AB does not detect the OI field > for > > changes, so if there is no other changes in your database, pressing > > save doesnt save your changes in OI (at least that was the case in > > the past), To force save, choose save database as, or make some > sure > > there are some other changes in your database and press save. > > Otherwise, the OI fields would be blank next time you open it. > > Good luck. > > >
