|
PureBytes Links
Trading Reference Links
|
Thanks for the procedure example.
Any ideas on speeding up the refresh? With my large
database AB takes a long time doing a refresh.
The only idea that I have come up with so far is creating a
separate AB database for equity curves. Here is how it
would work (I have yet to try this out).
1. Run the back test.
2. Do an explore with apply to set to ~~~EQUITY.
3. Use AddColumn to get data into AA results window.
4. Copy to Excel.
5. Give the ticker a new name in Excel.
6. Repeat 1 to 5.
7. Export as a csv file from Excel.
8. Switch AB database to the one just for Equity Curves
9. Import into AB.
Any one have an idea that has fewer steps?
The big appeal of the above is that it would avoid the long
refresh delay that I experience with my large research
database.
b
--- vlanschot <ecbu@xxxxxxxxxxxxxx> wrote:
>
> If it's OK to rename after each backtest (i.e. you're not
> running
> some "batch" of backtests, then the following may help.
> After each
> backtest, run this procedure via scan:
>
> // Rename ~~~Equity////
>
> procedure RenamePFEquity(Naam,Newgr)
> {
> SetForeign("~~~EQUITY", True, True );
> PFEquity=C;
> PFCash=L;
> RestorePriceArrays();
>
> AddToComposite(PFEquity,Naam,"C");
> AddToComposite(PFCash,Naam,"L");
>
> CategoryAddSymbol( Naam, categoryGroup, NewGr );
> }
>
> Basically, it saves the last ~~~Equity as "Naam" in the
> designated
> Group, called NewGr. After View->Refresh all it should
> appear there.
>
> Hope this helps.
>
> PS
>
> --- In amibroker@xxxxxxxxxxxxxxx, b <b519b@xxxx> wrote:
> > I use the renaming method to save the ~~~Equity output.
> >
> > However, with my 30,000 plus stock database, there is a
> > delay of 1 to 2 minutes each time I rename it.
> >
> > My guess is that AB has to resort various internal
> lists
> > before it can do a ticker list refresh.
> >
> > Is there a quicker way to save the results?
> >
> >
> >
> > --- Graham <kavemanperth@xxxx> wrote:
> >
> > > Have you tried renaming the ticker each time
> > >
> > >
> > > On Sun, 09 Jan 2005 05:00:09 -0000, Pat Finnegan
> > > <PFinnegan1@xxxx> wrote:
> > > >
> > > >
> > > > ~~~EQUITY is overwritten every BackTest.
> > > >
> > > > Is it possible to "copy" ~~~EQUITY as a new ticker
> > > which would
> > > > not be overwritten?
> > > >
> > > > The overall aim is to plot equity curves from a
> number
> > > of
> > > > passes in a Rotational Trading model.
> > > >
> > > > Pat.
> > > >
> > > >
> > > > Check AmiBroker web page at:
> > > > http://www.amibroker.com/
> > > >
> > > > Check group FAQ at:
> > >
> >
>
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > --
> > > Cheers
> > > Graham
> > > http://e-wire.net.au/~eb_kavan/
> > >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail - now with 250MB free storage. Learn more.
> > http://info.mail.yahoo.com/mail_250
>
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
------------------------ Yahoo! Groups Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|