Re: Position Size calculations

["Walter Lake" <wlake@xxxxxxxxx>]

Thanks Ton

I've enjoyed the "explanatory" style that you've been using for the last few
months. Very clear and easy to "check off" while using.

Best regards

Walter

----- Original Message -----
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, May 25, 2000 6:41 PM
Subject: Re: Position Size calculations


| The way you've described and explained it, is a course in Excel by
itselve.
| Congrats.......(and good work by Pflugl too).
|
| Regards,
| Ton Maas
| ms-irb@xxxxxxxxxxxxxxxx
| Dismiss the ".nospam" bit (including the dot) when replying.
| Homepage  http://home.planet.nl/~anthmaas
|
|
| ----- Original Message -----
| From: "Walter Lake" <wlake@xxxxxxxxx>
| To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
| Sent: donderdag 25 mei 2000 20:53
| Subject: Position Size calculations
|
|
| >
| > I'm sorry that you had trouble opening the XL workbook.
| >
| > Those message boxes are not there to stop you ... you can click right
past
| > them.
| >
| >  http://keplerweb.oeh.uni-linz.ac.at/trading/download.htm
| >
| > On opening in Excel:
| >
| > - enable the macros when the message box appears
| > - click "no" on the links update message box
| > - the curser will update the chart
| > when finished ... click "end" on the VB error message box
| > - click on the "Regression Trendlines" tab at the bottom to see the
data,
| > formulas and calculation worksheet
| >
| > Pflugl's workbook has several things that you may not have seen before.
| >
| > Column's J and K: "Position size" and "% Invested"
| > - click on a cell in col J
| > - click on the formula in the formula bar at the top .. notice that the
| > different references are colour coded so that you can trace them down.
| > - click on the "=" sign in grey beside the formula bar for an
explanation of
| > the functions used
| >
| > You can change the position size and increments etc. at the top of the
| > workbook.
| >
| > This workbook also has an interesting use of Rand()
| >
| > While you are exploring the workbook or the formula bar it's easy to
mess up
| > the formulas etc. so press cancel when the automatic save appears.
| >
| > "Ctrl + ~" will expose all of the formulas. Press it again to return to
| > normal.
| >
| > Best regards
| >
| > Walter
| >
|