Re: [Metastockusers] 3D charting macro to verify robustnes

["Lionel Issen" <lissen@xxxxxxxxxxxxxx>]

Bill:
Since Office 2000 is being phased out, you might be 
able to get a copy fairly cheaply. Try Computer's Worth Inc 1 800 838 7884. They 
are in Garland TX.  I've dealt with them in the past, service and prices 
were good.
 
Excel 2000 is easier to use and better  than 
older versions.
Lionel Issen<A 
href="mailto:lissen@xxxxxxxxxxxxxx";>lissen@xxxxxxxxxxxxxx
<BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  wavemechanic 
  
  To: <A 
  title=Metastockusers@xxxxxxxxxxxxxxx 
  href="mailto:Metastockusers@xxxxxxxxxxxxxxx";>Metastockusers@xxxxxxxxxxxxxxx 
  ; <A title=metastock@xxxxxxxxxxxxx 
  href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx 
  Sent: Sunday, October 28, 2001 5:08 
  PM
  Subject: Re: [Metastockusers] 3D charting 
  macro to verify robustnes
  
  Herman:
   
  Just what the doctor ordered.  However, I 
  suspect that you are using a later version of Excel than my 97.  As a 
  result, Excel doesn't like to save the worksheet.  Would it be possible 
  to send a file that is saved as Excel 97?  
   
  Bill
  <BLOCKQUOTE 
  style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    ----- Original Message ----- 
    <DIV 
    style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
    Herman van den 
    Bergen 
    To: <A 
    title=Metastockusers@xxxxxxxxxxxxxxx 
    href="mailto:Metastockusers@xxxxxxxxxxxxxxx";>Metastockusers@xxxxxxxxxxxxxxx 
    ; <A title=metastock@xxxxxxxxxxxxx 
    href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx 
    Sent: Sunday, October 28, 2001 1:54 
    PM
    Subject: [Metastockusers] 3D charting 
    macro to verify robustnes
    Hi,Charting the opt results produced by the MS System 
    tester is an excellentway to verify the robustnes of your trading 
    system. The attached Excelmacro makes 2D and 3D charts. It is a 
    bare-minimum quicky and I didn'tspend much time polishing it 
    up.If you can improve it please share your improvements with the 
    list. To use it:1) This macro only charts opt1 and opt2 and you'll 
    have to keep the numberof tests to less than 1000 - MS only retains the 
    best 1000 tests, so if youuse more the opt data will be non-contiguous. 
    Copy the data from the MSSystems Tester's Summary Report window to your 
    clip board using Ctl-C.2) To chart your data, open up sheet1 in the 
    workbook. Delete all data on(ONLY) this sheet. Paste the data from your 
    clip board at cell "A1". PressCtrl-t and the program will update the 3D 
    Table, 2D Chart, and 3D Chart toreflect your data. The macro will ask 
    you to confirm four page deletes - Icouldn't be bothered to figure out 
    how to skip this window (if anybodyknows please tell me).A 
    robust system will give you a smooth surface with a gradual peaking 
    atthe highest profit. If you have lots of peaks or if they are very 
    sharp youhave a problem ... if you ahave lots of negative areas you're 
    at high risk.Unless you know what you are doing don't mess with the 
    code or renamesheets, I did not put any safeguards in to prevent crashes 
    or error messages.Have 
    fun!Herman.------------------------ 
    Yahoo! Groups Sponsor ---------------------~-->Protect your servers 
    with 128-bit SSL encryption! Grab your copy of VeriSign's FREE guide: 
    "Securing Your Website for business" Get it Now!<A 
    href="http://us.click.yahoo.com/M.WTOC/m1FDAA/cosFAA/zMEolB/TM";>http://us.click.yahoo.com/M.WTOC/m1FDAA/cosFAA/zMEolB/TM---------------------------------------------------------------------~->To 
    unsubscribe from this group, send an email to:<A 
    href="mailto:Metastockusers-unsubscribe@xxxxxxxxxxx";>Metastockusers-unsubscribe@xxxxxxxxxxx Your 
    use of Yahoo! Groups is subject to <A 
    href="http://docs.yahoo.com/info/terms/";>http://docs.yahoo.com/info/terms/ 
    
  
    
    
      Yahoo! Groups 
        Sponsor
    
      <A 
        href="http://rd.yahoo.com/M=212180.1660615.3195488.1269404/D=egroupweb/S=1705001779:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b153340270003000";><IMG 
        height=60 
        src="http://us.a1.yimg.com/us.yimg.com/a/ve/verisign/vsopen24.gif"; 
        width=468 border=0>
    
      <IMG height=1 alt="" 
        src="http://us.adserver.yahoo.com/l?M=212180.1660615.3195488.1269404/D=egroupmail/S=1705001779:HM/A=812074/rand=982043938"; 
        width=1>To 
  unsubscribe from this group, send an email 
  to:Metastockusers-unsubscribe@xxxxxxxxxxxYour use 
  of Yahoo! Groups is subject to the <A 
  href="http://docs.yahoo.com/info/terms/";>Yahoo! Terms of Service.