[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Import FNU files into QP3 database



PureBytes Links

Trading Reference Links

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