|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "Ken Close" <ken45140@xxx> 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
>
|