Ken, Here is the little critter: /*Make the 30A ticker for Phyllis file 30A.afl load and run a scan with 30A ticker in FT database */ //initialize
Buy=Sell=0; AddToComposite(C , "~30A", "x" ); Filter = 1; // end I run this scan against the FT 30A ticker. You will also have to run it one time in the non-FT database against any ticker so that AB will see ~30A in this database. Then nightly over write the ~30A ticker in the non-FT database with the new ~30A ticker from the FT database. The scripts I mentioned are in the Tools menu: Autoupdate, Make30A ticker, Tango Sort, FundX Score, Export Quotes, Cleanup Database. I made up a couple of script hacks to automate some things. The scripts run .AFLs with filters and sorts. I usually have a couple of not-FT databases I use for screening Closed End and ETF's for volume & rule based trading, etc. I am not much of a programmer, I just hack at things until they work for me so I hope this helps. ...Allen --- In [email protected], Ken Close <[EMAIL PROTECTED]> wrote: > > Allen...thanks for the concept. Any change of copying the lines from the 3 > line AFL you mention and post here. Is the "script" you refer to something > else? > > More specifics might be useful to me. I also take it that I will find it > hard to use the ASCII importer to convert it, which really seems odd seeing > as how there are all sorts of formatting commands in the Importer. I just > can not get anything to work because of inexperience with the importer. > > Maybe support would help me..... > > Ken > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of ajfulleton > Sent: Monday, September 04, 2006 8:14 PM > To: [email protected] > Subject: [amibroker] Re: Import FNU files into QP3 database > > Ken, > Years ago I set up a hack to put a FT 30A (30%) ticker into a non- FT > database. I wrote a 3 line .AFL that makes an AddToComposite ~30A ticker in > the FT database from 30A. I then run the same .AFL against any ticker in > the non-FT database. Then I copy the FT ~30A to my non-FT databases, over > writing the previous ticker. This is scripted and under my AB>Tools window. > I had to initally run the .AFL in the non-AB databases bacause just moving > over the ticker from FT would not work. Now I just run my script in the FT > database and then copy the ticker. I am sure some of the real programmers > can do much better than my quick and dirty hack. One of these days I'll > revisit this since I use ~30A (30%)as a reference in AB. > Hope this helps..... > ...Allen > > --- In [email protected], "Ken Close" <ken45140@> wrote: > > > > Now that I have switched over to QP3, I am trying to mix some > ticker info > > from FastTrack with the QP db so I can calculate some things with > the QP db > > active. > > > > A FNU file is one especially prepared by a variety of FastTrack > related > > programs, including Ftrack itself. > > > > The format of an FNU file looks like this: > > > > 30A > > 30% Interest > > "09/01/88",100,0 > > "09/02/1988",100.0719,0 > > "09/06/1988",100.36,0 > > "09/07/1988",100.4322,0 > > "09/08/1988",100.5044,0 > > "09/09/1988",100.5767,0 > > "09/12/1988",100.7938,0 > > "09/13/1988",100.8663,0 > > "09/14/1988",100.9388,0 > > > > This shows a constant interest ticker starting on 9/1/1988 and > increasing > > with ann interest = 30%. > > > > First, retrieve symbols does not seem to work because I can not put > the > > newly created FNU files into the QP database files. (As an aside, > the FT > > API that TJ designed automatically recognizes FNU symbols and > Retrieve will > > get them when using the FastTrack database---seemingly not so with > the QP3 > > database.) > > > > So, I thought I would use the ASCII Importer in AB to import the > 30A file > > (shown above partially). > > > > I specified the file and the columns and did not get any error > messages, but > > nothing came in. I do have a symbol named 30A in the QP3 tree but > it is > > empty. > > > > I suspect it is because of the quote marks around the date (which > is an > > unchageable feature of the FNU format). I do not want to have to > go thru > > Excel to strip out the quote marks. > > > > Can someone guide me on this, in general, or in specifics, like how > do I > > tell the importer to ignore the quote marks? > > > > Thanks for any help. > > > > Ken > > > > > > > > > > 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 other support material please check also: > http://www.amibroker.com/support.html > > > Yahoo! Groups Links > 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 other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
