|
PureBytes Links
Trading Reference Links
|
Allen:
Many thanks. I may still try this, but have another option available.
There is a Robinson script in AFL which creates a FNU which does not have
quote marks around the date. Did you know that both kinds work---with
quotes (produced by Ft4win) and without (produced by several AFL scripts).
Thus, make the constant 10A in AB, export to FNU, then use Importer back
into the QP3 db (since the quotes are gone).
I will have to study what you suggest to see which awkward way is easier.
Thanks for sharing.
Ken
-----Original Message-----
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
Of ajfulleton
Sent: Tuesday, September 05, 2006 7:41 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: Import FNU files into QP3 database
Ken,
Here is the little critter:
/*Make the 30A ticker for Phyllis
file 30A.afl
load and run a scan with 30A ticker in FT database */ //initialize
Buy=Sell=0;
AddToComposite(C , "~30A", "x" );
Filter = 1;
// end
I run this scan against the FT 30A ticker.
You will also have to run it one time in the non-FT database against any
ticker so that AB will see ~30A in this database. Then nightly over write
the ~30A ticker in the non-FT database with the new ~30A ticker from the FT
database.
The scripts I mentioned are in the Tools menu: Autoupdate, Make30A ticker,
Tango Sort, FundX Score, Export Quotes, Cleanup Database. I made up a
couple of script hacks to automate some things. The scripts run .AFLs with
filters and sorts. I usually have a couple of not-FT databases I use for
screening Closed End and ETF's for volume & rule based trading, etc. I am
not much of a programmer, I just hack at things until they work for me so I
hope this helps.
....Allen
--- In amibroker@xxxxxxxxxxxxxxx, Ken Close <ken45140@xxx> wrote:
>
> 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@> 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
|