|
Just adding to d's detailed instruction
once you have carried out the backtest as per 4. you have
available to you all the stats via COM objects within your script. Therefore you
can save them directly to a file. I haven't tried it myself
though.
cheers
Paul
I really don't see the problem. If I were doing
this I would have a _vbscript_ (or JScript) that would:
1. Run AB
2. Open AA
3. Load the settings file for AA
4. Have a for loop that varies the watchlist numer from a
to b and within the loop:
Sets the
filter (watchlist number)
Load the
formula
Runs the
backtest
opens
the backtest statistics report and extracts all of the info I need by parsing
it
open the
watchlist file that was processed and read the tickers
format
the data for the current watchlist number
5. After all of the watchlists have been backtested
format my report and save it as a file
6. email the report file.
If you're trying to do it manually after all of the
backtesting is done THEN I see your problem. If you do this every day
then by all means you should automate it to the extent I described
above. If you need help on this .. well.. I offer my assistance
once again.
d
Hi,
I am testing the same code at 5
different watchlists and when my script has finished all the backtests I
have 5 reports open, but I don’t see the tested/selected watchlist until I
go to the Settings page.
Than I have to switch back to the
Statistics page and scroll down to my custom stats, which I have to
copy/paste to a email. The same procedure follows for the other 4 reports.
Mostly I have to test multiple
strategies/variations every day and all at the 5 watchlists. So it is
time consuming and uncomfortable.
Therefore I am trying to simplify it
as good as possible.
From: amibroker@xxxxxxxxxps.com
[mailto:amibroker@yahoogroups.com] On Behalf Of
dingo
Sent: Wednesday, May 30, 2007 7:28 PM
To:
amibroker@xxxxxxxxxps.com
Subject: RE: [amibroker] Re: OLE:
How to save reports ?
Sorry, but I'm
not understanding what you're trying to do.. Are you wanting to retrieve the
watchlist number being backtested in the backtest AFL so that you can
retrieve the tickers?
d
From: amibroker@xxxxxxxxxps.com
[mailto:amibroker@yahoogroups.com] On Behalf Of Thomas
Z.
Sent: Wednesday, May 30, 2007 12:39 PM
To:
amibroker@xxxxxxxxxps.com
Subject: RE: [amibroker] Re: OLE:
How to save reports ?
Dingo,
thanks, but this wouldn’t make it
easier, because i have to sent only my own custom stats through email and
have to put my stats into a table in my email for good
readability.
See my attached
snapshot.
I have tried right now the
following in the custom backtester:
List =
CategoryGetSymbols(
categoryWatchlist, 1);
bo.AddCustomMetric
("Tickers
under test =", List
);
Basically it is a good idea,
however instead the fixed number 1 I should receive somehow the selected
watchlist, because I test 5 different watchlists.
Thomas
www.patternexplorer.com
From: amibroker@xxxxxxxxxps.com
[mailto:amibroker@yahoogroups.com] On Behalf Of
dingo
Sent: Wednesday, May 30, 2007 4:43 PM
To:
amibroker@xxxxxxxxxps.com
Subject: RE: [amibroker] Re: OLE:
How to save reports ?
Look in the
reports folder - there you'll find everything you want/need
(almost). Here's an idea - open the results.rlst file in the reports
folder. After each backtest the results will be summarized in the last
record in that file. By combining the Name and Created columns
you'll find that you have the id of the folder the reports are stored
in. This will give you access to Stats.html, trades.html etc.
that you can email or parse to your heat's content.
d
From: amibroker@xxxxxxxxxps.com
[mailto:amibroker@yahoogroups.com] On Behalf Of Thomas
Zmuck
Sent: Wednesday, May 30, 2007 5:04 AM
To:
amibroker@xxxxxxxxxps.com
Subject: Re: [amibroker] Re:
OLE: How to save reports ?
Yes, i know, but i always want to open the same 5
reports automatically or in other words i want to load it in firefox and
just click "refresh all" to get all my 5 reports
updated.
I test 5 watchlists through my OLE script and
thereafter i need to copy/paste my custom backtest
statistics of all 5 reports into a email. I have to do this
procedure multiple times per day, therefore i am trying to simplify
it as good as possible.
2007/5/30, Tomasz Janeczko
<groups@xxxxxxxxxxcom>:
You can - simply double click on .html file
inside report folder.
----- Original Message -----
Sent:
Wednesday, May 30, 2007 10:31 AM
Subject: Re: [amibroker] Re: OLE: How to save reports
?
It's a shame because i
have to copy my custom backtest statistics from 5 different reports
that i receive for my 5 portfolios. AmiBroker saves all the reports in
a folder which includes date, etc.. in the folder name and which is
therefore different at every backtest. Hmm, it seems that this means
that i can't open my reports in the web browser.
However it would also be
helpful if i could display the tested watchlist (my portfolios) in the
report. Do you know if there is any way to retrieve the selected
watchlist ?
bo.AddCustomMetric("Watchlist",
Watchlist);
2007/5/30, vlanschot <vlanschot@xxxxxxcom>:
FWIW, below is the reply I got from
Marcin on a similar question I
asked support:
"This is
because REPORT method works with the old backtester. The new
(portfolio) backtest creates the report automatically and there is
no
need
to call Report method at all.
Best
regards
Marcin Gorzynski
Amibroker.com Technical Support"
My intitial
question was:
> Marcin, I just send you a mail asking
whether you can explain why my
> html-report is not saved in my
y-drive as the code in the j-script
> requests. Turns out that
AB does save reports of the tested system,
but
> under the
name of the afl-file, and under the c-drive. Why???
>
>
Thanks,
As a result, I've put a request in the feedback centre
to be able to
assign the drive where the report should be saved.
PS
--- In amibroker@xxxxxxxxxps.com, "Thomas Zmuck"
<tzmuck@xxx> wrote:
>
> Hello Dingo,
>
> I have tried different possible solutions, also the one you
mentioned, but i
> don't get it to work. I test 5 portfolios
multiple times every day
and would
> like to open all the 5
reports in the browser. Than, after the
backtest, i
> could
simply click refresh all to get all reports updated in the
browser.
>
> Regards
> Thomas
>
>
>
> 2007/5/30, dingo <dingo@xxx>:
>
>
> > Since the report is automatically saved in the
Reports folder
I haven't
> > used the Report method so I
don't know if it still works or not.
Try
> > omitting the
.html and see if that works. Also try putting in the
complete
> > path.
> >
> > d
>
>
> > ------------------------------
>
> *From:* amibroker@xxxxxxxxxps.com
[mailto:
amibroker@xxxxxxxxxps.com] *On
> > Behalf Of *Thomas
Zmuck
> > *Sent:* Tuesday, May 29, 2007 4:43 AM
> >
*To:* amibroker@xxxxxxxxxps.com
> > *Subject:*
[amibroker] OLE: How to save reports ?
> >
>
>
> > Hello,
> >
> > i have tried to use
the following line to save reports as .html
file,
> >
however it seems to be not correct, because i get no files.
>
> Can someone help ?
> >
> >
AA.Report("Formulas\\myReport.html"); // empty file name
means
display
> > report
> >
>
>
> > AA.ClearFilters();
> > AA.Filter( 0,
"watchlist" ) = 0;
> > AA.Backtest(0);
> >
//AA.Report("Formulas\myReport.html"); // empty file
name means
display
> > report
> >
AA.Report(""); // empty file name means display report
>
>
> > --
> > Kind regards
> >
Thomas
> >
> >
> >
>
>
>
> --
> Kind regards
>
Thomas
>
--
Kind regards
Thomas
--
Kind regards
Thomas
__._,_.___
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 NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/
For other support material please check also:
http://www.amibroker.com/support.html
![]()
SPONSORED LINKS
__,_._,___
|