|
PureBytes Links
Trading Reference Links
|
john,
i didn't have that problem with the convertdata.xls spreadsheet.
i just did another run with 30000 input rows.
i would only be guessing as to the cause of the problem.
i suggest that you re-install the spreadsheet, and ensure that you
are running explore not scan, and that you use the the provided AFL
member with your backtest code inserted as described in the readme.
check that the data you paste to "rawdata" worksheet is exactly the
same format as the original.
regards gerry
--- In amibroker@xxxxxxxxxxxxxxx, "john gibb" <jgibb1@xxxx> wrote:
> 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@xxxx>
> 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@xxxx
> > Send SUGGESTIONS to suggest@xxxx
> > -----------------------------------------
> > 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/
|