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