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

Excel & VBA Code



PureBytes Links

Trading Reference Links

Bill

Description 

· Brief Summary 

o An Excel Spreadsheet designed to allow input and analysis of historical Open, High, Low, Close (OHLC) financial markets data. Uses VBA and forms to manipulate the data base on user criteria / input. 

  

· Detail Description 

o Input 

§ User can input a OHLC file of his choice for manipulation

· Analysis - using arrays to speed up calculation 

o Criteria Selection 

§ Buy Criteria x 3

· Compare OHLC data using =, >, >=, <, <=, <> operators

· Save criteria

· Load Previously saved criteria

· Choose OHLC to represent buy price

§ Take Profit

· Allows choice of start, end and increment Nos to allow for multiple scenarios

· Choose OHLC to represent price to take profit at

§ Stop Loss

· Allows choice of start, end and increment Nos to allow for multiple scenarios

· Choose OHLC to represent price to stop losses at

§ Moving Average

· Allows choice of start, end and increment Nos to allow for multiple scenarios

§ Profit Calculation

· Choice of Profit before loss or vica versa when time periods fall at the same time

· Use number of contracts or an absolute value

· Include or exclude commission

o Take Profit / Stop Loss / Moving Average / Profit Calculation savedfor each run and used as default for the next 

  

o Output 

§ Results Sheet for individual buy signals

· Shows moving average, profit lock and stop loss for each line

· Show buy line input data

· Profit or loss value shown

· Win / lose / neutral numbers and %

§ Summary Sheets for each scenario (combinations of moving average, profit lock and stop loss

· Pivot table shows win, lose, neutral / absolute and % data for each scenario

§ Chart individual buys

· Allows user to decide period (before and after buy) to be charted

· Charts using OHLC with MA

  

· Other sheets hold data 

o Chart data

o frmCriteriaSelectionInformation - holds form information

o timings - times each scenario for analysis purposes

o SavedCriteria - holds saved Buy Criteria data

  

------=_NextPart_001_01D1_01C104AB.38CA8640
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 5.50.4616.200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><STRONG><FONT size=2>The following&nbsp;description and open code&nbsp;are 
from www.madpommie.com and might be of 
interest to some.</FONT></STRONG></DIV>
<DIV><STRONG><FONT size=2></FONT></STRONG>&nbsp;</DIV>
<DIV><STRONG><FONT size=2>Bill</FONT></STRONG></DIV>
<DIV><STRONG><FONT size=2></FONT></STRONG>&nbsp;</DIV>
<DIV>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 150%"><FONT 
size=5><A name=Description>Description</A> </FONT>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 36pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level1 lfo3; tab-stops: list 36.0pt"><SPAN 
style="FONT-SIZE: 14pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN style="FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt">Brief 
Summary<?XML:NAMESPACE PREFIX = O /><O:P> </O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN style="FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt">An 
Excel Spreadsheet designed to allow input and analysis of historical Open, High, 
Low, Close (OHLC) financial markets data.<SPAN style="mso-spacerun: yes">&nbsp; 
</SPAN>Uses VBA and forms to manipulate the data base on user criteria / 
input.<O:P> </O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 18pt; LINE-HEIGHT: 150%">&nbsp;<O:P> 
</O:P></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 36pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level1 lfo3; tab-stops: list 36.0pt"><SPAN 
style="FONT-SIZE: 14pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN 
style="FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt">Detail Description<O:P> 
</O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN 
style="FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt">Input<O:P> 
</O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>User can input a OHLC file of his choice for manipulation</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 36pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level1 lfo3; tab-stops: list 36.0pt"><SPAN 
style="FONT-SIZE: 14pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN 
style="FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt">Analysis - using arrays to 
speed up calculation<O:P> </O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN 
style="FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt">Criteria Selection<O:P> 
</O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Buy Criteria x 3</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Compare OHLC data using<SPAN style="mso-spacerun: yes">&nbsp; 
</SPAN>=, &gt;, &gt;=, &lt;, &lt;=, &lt;&gt; operators</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Save criteria</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Load Previously saved criteria</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Choose OHLC to represent buy price</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Take Profit</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Allows choice of start, end and increment Nos to allow for 
multiple scenarios</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Choose OHLC to represent price to take profit at</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Stop Loss</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Allows choice of start, end and increment Nos to allow for 
multiple scenarios</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Choose OHLC to represent price to stop losses at</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Moving Average</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Allows choice of start, end and increment Nos to allow for 
multiple scenarios</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Profit Calculation</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Choice of Profit before loss or vica versa when time periods fall 
at the same time</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Use number of contracts or an absolute value</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Include or exclude commission</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN style="FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt">Take 
Profit / Stop Loss / Moving Average / Profit Calculation saved for each runand 
used as default for the next<O:P> </O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 54pt; LINE-HEIGHT: 150%">&nbsp;<O:P> 
</O:P></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Courier New'; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN 
style="FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt">Output<O:P> 
</O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Results Sheet for individual buy signals</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Shows moving average, profit lock and stop loss for each line</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Show buy line input data</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Profit or loss value shown</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Win / lose / neutral numbers and %</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Summary Sheets for each scenario (combinations of moving average, 
profit lock and stop loss</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Pivot table shows win, lose, neutral / absolute and % data for 
each scenario</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 108pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level3 lfo3; tab-stops: list 108.0pt"><SPAN 
style="FONT-FAMILY: Wingdings">§<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Chart individual buys</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Allows user to decide period (before and after buy) to be 
charted</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 144pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level4 lfo3; tab-stops: list 144.0pt"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Charts using OHLC with MA</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 150%">&nbsp;<O:P> 
</O:P></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 36pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level1 lfo3; tab-stops: list 36.0pt"><SPAN 
style="FONT-SIZE: 14pt; FONT-FAMILY: Symbol; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: bold">·<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN><B><SPAN style="FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt">Other 
sheets hold data<O:P> </O:P></SPAN></B></P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-FAMILY: 'Courier New'; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>Chart data</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-FAMILY: 'Courier New'; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>frmCriteriaSelectionInformation - holds form information</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-FAMILY: 'Courier New'; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>timings - times each scenario for analysis purposes</P>
<P class=MsoNormal 
style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 72pt; TEXT-INDENT: -18pt; LINE-HEIGHT: 150%; mso-list: l1 level2 lfo3; tab-stops: list 72.0pt"><SPAN 
style="FONT-FAMILY: 'Courier New'; mso-bidi-font-family: 'Times New Roman'">o<SPAN 
style="FONT: 7pt 'Times New Roman'">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
</SPAN></SPAN>SavedCriteria - holds saved Buy Criteria data</P><!-- text below generated by server. PLEASE REMOVE --></APPLET></OBJECT></LAYER>
<DIV></DIV></SPAN></STYLE></NOSCRIPT></TABLE></SCRIPT>
<SCRIPT language=JavaScript 
src="http://us.geo1.yimg.com/www.geocities.com/js_source/geov2.js";></SCRIPT>

<SCRIPT language=javascript>geovisit();</SCRIPT>
<IMG 
src="http://visit.geocities.com/visit.gif?&amp;r=http%3A//www.geocities.com/madpommie/BTNavigation.htm&amp;b=Microsoft%20Internet%20Explorer%204.0%20%28compatible%3B%20MSIE%205.5%3B%20Windows%2098%29&amp;s=1024x768&amp;o=Win32&amp;c=24&amp;j=true&amp;v=1.2"; 
border=0> <NOSCRIPT><IMG height=1 src="http://visit.geocities.com/visit.gif"; 
width=1 border=0></NOSCRIPT><IMG height=1 alt=1 
src="http://geo.yahoo.com/serv?s=76001075&amp;t=994280378"; width=1> 
</DIV></BODY></HTML>

------=_NextPart_001_01D1_01C104AB.38CA8640--

Attachment:
Description: Binary data

Attachment: Description: "Description: Binary data"

Attachment:

Attachment: Description: "Attachment:"