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