|
PureBytes Links
Trading Reference Links
|
Hi Giancarlo
I always liked the light weight version of Monte Carlo Simulation at the
site that you mentioned.
http://www.geocities.com/WallStreet/9245/
also I've been learning some of the following
http://www.analycorp.com/software.htm
Simulation, Forecasting and Optimization in Microsoft Excel
Monte Carlo simulation, decision trees, queueing simulations, Markov chains,
forecasting and numerous optimization models $44.95
and
http://www.stolaf.edu/people/mckelvey/envision.dir/stocksim.dir/stocksim.htm
l
Stock Market Simulation Using Monte Carlo Techniques with Excel
and
http://www.gsu.edu/~dscgpz/chap4/chapter4.html
Part 4 -- Monte Carlo Simulation
Class Notes and Example Excel Files
Best regards
Walter
----- Original Message -----
From: Giancarlo Gaydou
To: metastock@xxxxxxxxxxxxx
Sent: Wednesday, February 07, 2001 6:44 AM
Subject: Re: stuff
Hi,
at this link (http://www.geocities.com/WallStreet/9245/) you'll find some
free interesting works in Excel,
stats & financial, and links to VBA code
(http://www.vb-bookmark.com/vba.html).
Good trading
gg
At 10:16 PM 06/02/2001 -0500, you wrote:
Hi
In the workbook you might want to look for hidden sheets and hidden columns.
In this case there are many hidden columns filled with in-cell code and
named ranges. One sheet has over 100 hidden columns. Watch out for text that
is the same colour as the background. Use the map that you mentioned to
find and change the colour of the fonts.
The VBA code makes regular references to the named ranges in the hidden
columns. So if you want to modify the code you will need to see the in-cell
code and named ranges that you are referring to.
Delete the surface "junk" boxes and record or write your own code for the
subs/macros that are insufficient.
The modules are isolated so debugging is very easy if you comment your
changes and make notes in text boxes on each sheet that you change. You'll
learn a lot from the workbook.
An xll is different from a dll so it may not be visible in the same way. Let
me know if you have any luck.
Best regards
Walter
|