[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Position Size calculations



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
>