|
PureBytes Links
Trading Reference Links
|
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: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
Of ajfulleton
Sent: Monday, September 04, 2006 8:14 PM
To: amibroker@xxxxxxxxxxxxxxx
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 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
>
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
|