|
PureBytes Links
Trading Reference Links
|
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
|
|