|
PureBytes Links
Trading Reference Links
|
Hi,
I got this VB error:
Run-time error '1004': ClearContents method of Range class failed.
on this line:
Worksheets("Data").Range("A1:D10000").ClearContents
when I hit the Convert Data button.
-john
----- Original Message -----
From: "gerryjoz" <gerryj@xxxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Monday, September 01, 2003 5:51 AM
Subject: [amibroker] Re: Monte Carlo Portfolio Backtester V2.15
> HB, i got it to run but there were a couple of 'oddities' i
> encountered. Firstly, thanks for the tool. I rather suspect that
> Tomasz will cover some of the same ground in the next release, so i
> am not sure how much effort shold be put into improvements until we
> see what eventuates in AB next release.
> What i found was:
> backtest button didn't do anything, you need to press "Run MCS" on
> MCS worksheet.
> "equity" column is actually available cash, but "running equity" is
> the value of interest.
> the MC simulation on one occasion returned identical values for all
> 50 iterations -- that was because i didn't follow your instructions
> precisely, i deleted the data on the first worksheet, and with that
> the cell formula for randomizing disappeared: I suggest you protect
> that formula column.
> BTW i also changed the VB formula to accept more rows, just edit/
> replace 10000 with whatever value of data rows you have.
> Since the tool does everything that the original backtester
> spreadsheet does, maybe that file can be dropped?
>
> I wasn't able to compare the results to AB drawdown because excel
> limits the rows to 65536, so i need to be less ambitious with the
> volume of data i put through.
>
> Thanks again for the tool
> Gerry
>
>
>
>
>
> --- In amibroker@xxxxxxxxxxxxxxx, "hmab1" <hossamb@xxxx> wrote:
> >
> > Just wondering if anyone else has encountered errors while using
> the
> > Monte Carlo Portfolio Backtester ?
> >
> > HB
> >
> > --- In amibroker@xxxxxxxxxxxxxxx, "walterkimble" <walter@xxxx>
> wrote:
> > > Has anyone used the Monte Carlo Portfolio Backtester V2.15 on the
> > > files section of AB yahoo?
> > >
> > > I just dont seem to be able to get it to run and was wondering if
> > > anyone else has had similar problems and how they overcame them?
> > >
> > > Walter
>
>
>
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|