|
PureBytes Links
Trading Reference Links
|
Thanks for your emails
In the workbook change the Sum of Squares formula in O16 to
"=SUMXMY2(M3:M15,N3:N15)"
That means that M3:M15 and N3:N15 are entered as an array
Go to Tools --> Solver and enter $O$16 in the top box "Set Target Cell"
Enter $M$1 in "By Changing Cells" box
Running Solver will automatically enter the best value for p in M1
"n" is another "kettle of fish" <G>
Change it manually according to inspection of historical data or use an
adaptive system, i.e., Kaufman, Chande, Stridsman, Simons etc. to set it
from 2 to 30
Best regards
Walter
|