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" <[EMAIL PROTECTED]> 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/
