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
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Thomas Z.
Sent: Wednesday, May 30, 2007 4:12 PM
To: [email protected]
Subject: RE: [amibroker] Re: OLE: How to save reports ?
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.
Thomas
<http://www.patternexplorer.com/> www.patternexplorer.com
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of dingo
Sent: Wednesday, May 30, 2007 7:28 PM
To: [email protected]
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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Thomas Z.
Sent: Wednesday, May 30, 2007 12:39 PM
To: [email protected]
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 <http://www.patternexplorer.com/>
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of dingo
Sent: Wednesday, May 30, 2007 4:43 PM
To: [email protected]
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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Thomas Zmuck
Sent: Wednesday, May 30, 2007 5:04 AM
To: [email protected]
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.
Regards
Thomas
2007/5/30, Tomasz Janeczko <[EMAIL PROTECTED]>:
You can - simply double click on .html file inside report folder.
Best regards,
Tomasz Janeczko
amibroker.com <http://amibroker.com/>
----- Original Message -----
From: Thomas Zmuck <mailto:[EMAIL PROTECTED]>
To: [email protected]
Sent: Wednesday, May 30, 2007 10:31 AM
Subject: Re: [amibroker] Re: OLE: How to save reports ?
Hi,
thanks.
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 ?
Watchlist = ....
bo.AddCustomMetric("Watchlist", Watchlist);
Regards
Thomas
2007/5/30, vlanschot <[EMAIL PROTECTED]>:
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 <http://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 [email protected] <mailto:amibroker%40yahoogroups.com> ,
"Thomas Zmuck" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>:
> >
> > 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:* [email protected] <mailto:amibroker%40yahoogroups.com>
[mailto: <mailto:amibroker%40yahoogroups.com> [EMAIL PROTECTED]
*On
> > Behalf Of *Thomas Zmuck
> > *Sent:* Tuesday, May 29, 2007 4:43 AM
> > *To:* [email protected] <mailto:amibroker%40yahoogroups.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
