|
PureBytes Links
Trading Reference Links
|
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
>
|