[amibroker] Import FNU files into QP3 database

[Ken Close]

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:
 
30A30% 
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










   



    


  
  
    SPONSORED LINKS
  
          
                  
            
        Software support
      
                      
        Small business finance
      
                      
        Business finance online
      
              
                        
            
        Business finance training
      
                      
        Business finance course
      
                    
           
  







  
  
  YAHOO! GROUPS LINKS



   Visit your group "amibroker" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



  






__,_._,___