Clever, Brian. Thanks for the COM urls. Bob ----- Original Message ----- From: "brian_z111" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, March 21, 2008 6:17 AM Subject: [amibroker] Re: Import Data into OI field?
> 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. >> > >> > > > > ------------------------------------ > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > For other support material please check also: > http://www.amibroker.com/support.html > Yahoo! Groups Links > > >
