|
PureBytes Links
Trading Reference Links
|
Hi Angel
You could stack up the trade sheets that you import from "System Tester" in
Metastock. In the System Tester / Analysis workbook that you sent to me you
could easily have separate data sheets for each system test.
The other thing that I do is to separate the different parts of my analysis
page into different analysis sheets, i.e., move the equity curve charts etc.
onto separate sheets from the tables.
The analysis sheets in the workbook that tests breakout hypothesis runs
about 10 sheets plus chart sheets plus data sheets. Two other VBA based
Trading System test books run about 24 analysis sheets each plus charts plus
data sheets.
Even though they are large, the breakout book takes about 12 to 14 seconds
to do the calculations, create the charts and create the report sheets. So,
they are fast even on a old P166 machine.
Best regards
Walter
----- Original Message -----
From: "Walter Lake" <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Tuesday, November 30, 1999 10:29 AM
Subject: Re: TASC article
| No problem
|
| The two sheets, "analysis" and "data" are linked together in your in-cell
| code. You write your code in the "analysis" sheet, i.e. =(A4-A3) then you
go
| through your code and paste in the linking reference "Data!" ... "Data" is
| the name of the sheet and "!" joins or links the code to the data sheet.
The
| code now looks like =(Data!A4-Data!A3).
|
| Turn off your automatic calculation mode. Go to Options -->
Calculation -->
| set to Manual
| When you want to calculate or re-calulate your sheet press "Ctrl+Shift+F9"
|
| To test a group of stocks, i.e., the DJ stocks ... import the price data
or
| trades data to sheets in your analysis workbook. Label each sheet tab with
| the stock symbol. For the DJ you would have 30+ data sheets.
|
| To test a stock change the symbol name on the sheet tab to "Data" then
press
| "Ctrl+Shift+F9".
|
| Print your trades results sheet
|
| Change the name on the tab back to the stock symbol and proceed through
the
| rest of your stocks.
|
| It's a little "kludgy", but it works for me.
|
| Best regards
|
| Walter
|
|
|
| ----- Original Message -----
| From: "Walter Lake" <wlake@xxxxxxxxx>
| To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
| Sent: Saturday, November 27, 1999 10:37 PM
| Subject: TASC article
|
|
| | Thanks for your email.
| |
| | To test an indicator based system or event based system use your
Metastock
| | System Tester
| |
| | Set up your code in System Tester
| | Run a System Test on a Security
| | go to "Reports"
| | go to "Trades" tab
| | select/highlight all the trades
| | right click --> "Save to File"
| |
| | Find the file with the Excel
| | Click on the file to open it in Excel (using the "Text Import Wizard")
| | (the file is saved by Metastock as a "tab delimited" .txt file)
| | just keep clicking "next"
| | the name of the test is already on the tab of your worksheet (down at
the
| | bottom)
| |
| | Open Downloader
| | select/highlight the data for the security
| | copy & paste into a new sheet in Excel
| |
| | That's it ... you're in business
| | One sheet has the trades, i.e., results of indicator trigger or event
| | happening
| | The other sheet has the data
| |
| | Let me know if you have any problems.
| | The article uses nice standard analysis, nothing fancy.
| |
| | Best regards
| |
| | Walter
| |
|
|