Re: [amibroker] Re: OLE: How to save reports ?, AmiBroker Email List Archive

2007/5/30, dingo <dingo@xxxxxxxxxxx>:

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: amibroker@xxxxxxxxxps.com [mailto: amibroker@yahoogroups.com] On Behalf Of Thomas Z.
Sent: Wednesday, May 30, 2007 4:12 PM

To: amibroker@xxxxxxxxxps.com
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

www.patternexplorer.com

From: amibroker@xxxxxxxxxps.com [mailto:amibroker@ yahoogroups.com] On Behalf Of dingo
Sent: Wednesday, May 30, 2007 7:28 PM
To: amibroker@xxxxxxxxx ps.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@xxxxxxxxx ps.com [mailto:amibroker@ yahoogroups.com] On Behalf Of Thomas Z.
Sent: Wednesday, May 30, 2007 12:39 PM
To: amibroker@xxxxxxxxx ps.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@xxxxxxxxx ps.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@xxxxxxxxx ps.com [mailto:amibroker@ yahoogroups.com] On Behalf Of Thomas Zmuck
Sent: Wednesday, May 30, 2007 5:04 AM
To: amibroker@xxxxxxxxx ps.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.

Regards

Thomas

2007/5/30, Tomasz Janeczko <groups@xxxxxxxxxxxxx>:

You can - simply double click on .html file inside report folder.

Best regards,
Tomasz Janeczko
amibroker.com

----- Original Message -----

From: Thomas Zmuck

To: amibroker@xxxxxxxxxxxxxxx

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 <vlanschot@xxxxxxxxx>:

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@xxxxxxxxxxxxxxx, "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@xxxxxxxxxxxxxxx
[mailto: amibroker@xxxxxxxxxxxxxxx] *On
> > Behalf Of *Thomas Zmuck
> > *Sent:* Tuesday, May 29, 2007 4:43 AM
> > *To:* amibroker@xxxxxxxxxxxxxxx

> > *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