quantproject-developers

[Quantproject-developers] QuantDownloader/Downloader/Validate IValidator.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv6092/Downloader/Validate

Added Files:
	IValidator.cs 
Log Message:
It will contain the interface for quotes validators.
Not defined yet.

--- NEW FILE: IValidator.cs ---
using System;

namespace QuantProject.Applications.Downloader.Validate
{
	/// <summary>
	/// Interface to be implemented by quotes validators
	/// </summary>
	public interface IValidator
	{
		//event SuspiciousDataRow
	}
}

[Quantproject-developers] QuantDownloader/Downloader/Validate SospiciousDataRowEventArgs.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv5826/Downloader/Validate

Added Files:
	SospiciousDataRowEventArgs.cs 
Log Message:
Derived from EventArgs, contains the suspicious
DataRow for the SuspiciousDataRow event.

--- NEW FILE: SospiciousDataRowEventArgs.cs ---
using System;
using System.Data;

namespace QuantProject.Applications.Downloader.Validate
{
	/// <summary>
	/// EventArgs for the SuspiciousDataRow event
	/// </summary>
	public class SuspiciousDataRowEventArgs : EventArgs
	{
    private DataRow dataRow;

    /// <summary>
    /// The suspicious DataRow
    /// </summary>
    public DataRow DataRow
    {
      get
      {
        return this.dataRow;
      }
      set
      {
        value = this.dataRow;
      }
    }

		public SuspiciousDataRowEventArgs( DataRow dataRow )
		{
			this.dataRow = dataRow;
		}
	}
}

[Quantproject-developers] QuantDownloader/Downloader/Validate QuotesToBeValidated.cs,1.1,1.2

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv5122/Downloader/Validate

Modified Files:
	QuotesToBeValidated.cs 
Log Message:
Data validation has been moved to this object.
Every suspicious data rows fires the event SuspiciousDataRow.

Index: QuotesToBeValidated.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/QuotesToBeValidated.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** QuotesToBeValidated.cs	9 Dec 2003 22:20:10 -0000	1.1
--- QuotesToBeValidated.cs	12 Dec 2003 00:16:14 -0000	1.2
***************
*** 29,32 ****
--- 29,82 ----
        }
      }
+ 
+     public delegate void SuspiciousDataRowEventHandler(
+       Object sender , SuspiciousDataRowEventArgs eventArgs );
+ 
+     public event SuspiciousDataRowEventHandler SuspiciousDataRow;
+ 
+     #region "Validate"
+     #region "validate_currentQuotesRow_checkLogicalErrors"
+     /// <summary>
+     /// Adds a row if not ((Low <= Open) and (Open <= High) and (Low <= Close) and (Close <= High))
+     /// </summary>
+     /// <param name="quotesRow">Row of quotes to be checked</param>
+     private void validate_currentQuotesRow_checkLogicalErrors_checkOHLC( DataRow quotesRow )
+     {
+       if (!
+         ( ( Convert.ToDouble( quotesRow[ "quLow" ] ) <=
+         ( Convert.ToDouble( quotesRow[ "quOpen" ] ) ) ) &&
+         ( Convert.ToDouble( quotesRow[ "quOpen" ] ) <=
+         ( Convert.ToDouble( quotesRow[ "quHigh" ] ) ) ) &&
+         ( Convert.ToDouble( quotesRow[ "quLow" ] ) <=
+         ( Convert.ToDouble( quotesRow[ "quClose" ] ) ) ) &&
+         ( Convert.ToDouble( quotesRow[ "quClose" ] ) <=
+         ( Convert.ToDouble( quotesRow[ "quHigh" ] ) ) )
+         )
+         ) 
+         SuspiciousDataRow( this , new SuspiciousDataRowEventArgs( quotesRow ) );
+     }
+     /// <summary>
+     /// Adds an error row if quotesRow doesn't respect logical constraints
+     /// </summary>
+     /// <param name="quotesRow">Row of quotes to be checked</param>
+     private void validate_currentQuotesRow_checkLogicalErrors( DataRow quotesRow )
+     {
+       validate_currentQuotesRow_checkLogicalErrors_checkOHLC( quotesRow );
+     }
+     #endregion
+     /// <summary>
+     /// Adds errors for the current quotesRow (if any)
+     /// </summary>
+     /// <param name="quotesRow">Row of quotes to be checked</param>
+     private void validate_currentQuotesRow( DataRow quotesRow )
+     {
+       validate_currentQuotesRow_checkLogicalErrors( quotesRow );
+     }
+     public void Validate()
+     {
+       foreach ( DataRow quotesRow in this.Rows )
+         this.validate_currentQuotesRow( quotesRow );
+     }
  	}
+   #endregion
  }

[Quantproject-developers] QuantDownloader/Downloader/Validate ValidateDataTable.cs,1.1,1.2

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv4618/Downloader/Validate

Modified Files:
	ValidateDataTable.cs 
Log Message:
Data validation has been moved to the
QuotesToBeValidated object.
Suspicious data rows now fire an event in
the QuotesToBeValidated object: this event is
handled by ValidateDataTable.

Index: ValidateDataTable.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/ValidateDataTable.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** ValidateDataTable.cs	9 Dec 2003 22:17:59 -0000	1.1
--- ValidateDataTable.cs	12 Dec 2003 00:14:39 -0000	1.2
***************
*** 26,36 ****
      }
  
-     #region "addRows_forCurrentQuotesRow"
      /// <summary>
      /// Adds quotesRow to the ValidateDataTable
      /// </summary>
      /// <param name="quotesRow">Row of quotes to added</param>
!     private void addRow( DataRow quotesRow )
      {
        DataRow dataRow = this.NewRow();
        foreach (DataColumn dataColumn in quotesRow.Table.Columns )
--- 26,37 ----
      }
  
      /// <summary>
      /// Adds quotesRow to the ValidateDataTable
      /// </summary>
      /// <param name="quotesRow">Row of quotes to added</param>
!     private void suspiciousDataRowEventHandler( Object sender ,
!       SuspiciousDataRowEventArgs eventArgs )
      {
+       DataRow quotesRow = eventArgs.DataRow;
        DataRow dataRow = this.NewRow();
        foreach (DataColumn dataColumn in quotesRow.Table.Columns )
***************
*** 39,91 ****
        //this.Rows.Add( quotesRow );
      }
-     #region "addRows_forCurrentQuotesRow_checkLogicalErrors"
-     /// <summary>
-     /// Adds a row if not ((Low <= Open) and (Open <= High) and (Low <= Close) and (Close <= High))
-     /// </summary>
-     /// <param name="quotesRow">Row of quotes to be checked</param>
-     private void checkOHLC( DataRow quotesRow )
-     {
-       if (!
-           ( ( Convert.ToDouble( quotesRow[ "quLow" ] ) <=
-               ( Convert.ToDouble( quotesRow[ "quOpen" ] ) ) ) &&
-             ( Convert.ToDouble( quotesRow[ "quOpen" ] ) <=
-               ( Convert.ToDouble( quotesRow[ "quHigh" ] ) ) ) &&
-             ( Convert.ToDouble( quotesRow[ "quLow" ] ) <=
-               ( Convert.ToDouble( quotesRow[ "quClose" ] ) ) ) &&
-             ( Convert.ToDouble( quotesRow[ "quClose" ] ) <=
-               ( Convert.ToDouble( quotesRow[ "quHigh" ] ) ) )
-           )
-          ) 
-         addRow( quotesRow );
-     }
-     /// <summary>
-     /// Adds an error row if quotesRow doesn't respect logical constraints
-     /// </summary>
-     /// <param name="quotesRow">Row of quotes to be checked</param>
-     private void addRows_forCurrentQuotesRow_checkLogicalErrors( DataRow quotesRow )
-     {
-       checkOHLC( quotesRow );
-     }
-     #endregion
-     /// <summary>
-     /// Adds errors for the current quotesRow (if any)
-     /// </summary>
-     /// <param name="quotesRow">Row of quotes to be checked</param>
-     private void addRows_forCurrentQuotesRow( DataRow quotesRow )
-     {
-       addRows_forCurrentQuotesRow_checkLogicalErrors( quotesRow );
-     }
-     #endregion
- 
-     /// <summary>
-     /// Adds all the probably wrong data quotes rows
-     /// </summary>
-     /// <param name="tickerIsLike">Contains the is like clause to fetch the tickers
-     /// whose quotes are to be checked</param>
      public void AddRows( string tickerIsLike )
      {
        QuotesToBeValidated quotesToBeValidated = new QuotesToBeValidated( tickerIsLike );
!       foreach ( DataRow quotesRow in quotesToBeValidated.Rows )
!         this.addRows_forCurrentQuotesRow( quotesRow );
        this.AcceptChanges();
      }
--- 40,49 ----
        //this.Rows.Add( quotesRow );
      }
      public void AddRows( string tickerIsLike )
      {
        QuotesToBeValidated quotesToBeValidated = new QuotesToBeValidated( tickerIsLike );
!       quotesToBeValidated.SuspiciousDataRow +=
!         new QuotesToBeValidated.SuspiciousDataRowEventHandler( suspiciousDataRowEventHandler );
!       quotesToBeValidated.Validate();
        this.AcceptChanges();
      }

[Quantproject-developers] QuantDownloader QuantDownloader.suo,1.6,1.7

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader
In directory sc8-pr-cvs1:/tmp/cvs-serv5614

Modified Files:
	QuantDownloader.suo 
Log Message:
Added the first version for the ValidateForm.

Index: QuantDownloader.suo
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/QuantDownloader.suo,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
Binary files /tmp/cvsgQhCEa and /tmp/cvsGQEt3a differ

[Quantproject-developers] QuantDownloader/Downloader Downloader.csproj,1.4,1.5

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1:/tmp/cvs-serv5467/Downloader

Modified Files:
	Downloader.csproj 
Log Message:
- Removed Validate.cs and Validate.resx
- Removed ValidateDataset.xsd and ValidateDataset.cs and ValidateDataset.xsx
- Added QuotesToBeValidated.cs
- Added ValidateDataTable.cs
- Added ValidateForm.cs

Index: Downloader.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** Downloader.csproj	30 Nov 2003 22:58:24 -0000	1.4
--- Downloader.csproj	9 Dec 2003 22:35:06 -0000	1.5
***************
*** 156,186 ****
                  />
                  <File
!                     RelPath = "Validate\Validate.cs"
!                     SubType = "Form"
                      BuildAction = "Compile"
                  />
                  <File
!                     RelPath = "Validate\Validate.resx"
!                     DependentUpon = "Validate.cs"
!                     BuildAction = "EmbeddedResource"
!                 />
!                 <File
!                     RelPath = "Validate\ValidateDataset.xsd"
!                     BuildAction = "Content"
!                     Generator = "MSDataSetGenerator"
!                     LastGenOutput = "ValidateDataset.cs"
                  />
                  <File
!                     RelPath = "Validate\ValidateDataset.cs"
!                     DependentUpon = "ValidateDataset.xsd"
!                     SubType = "code"
                      BuildAction = "Compile"
-                     DesignTime = "True"
-                     AutoGen = "True"
                  />
                  <File
!                     RelPath = "Validate\ValidateDataset.xsx"
!                     DependentUpon = "ValidateDataset.xsd"
!                     BuildAction = "None"
                  />
              </Include>
--- 156,177 ----
                  />
                  <File
!                     RelPath = "Validate\QuotesToBeValidated.cs"
!                     SubType = "Component"
                      BuildAction = "Compile"
                  />
                  <File
!                     RelPath = "Validate\ValidateDataTable.cs"
!                     SubType = "Component"
!                     BuildAction = "Compile"
                  />
                  <File
!                     RelPath = "Validate\ValidateForm.cs"
!                     SubType = "Form"
                      BuildAction = "Compile"
                  />
                  <File
!                     RelPath = "Validate\ValidateForm.resx"
!                     DependentUpon = "ValidateForm.cs"
!                     BuildAction = "EmbeddedResource"
                  />
              </Include>

[Quantproject-developers] QuantDownloader/Downloader Main.cs,1.3,1.4

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1:/tmp/cvs-serv4395/Downloader

Modified Files:
	Main.cs 
Log Message:
The ValidateForm call has been fixed

Index: Main.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Main.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** Main.cs	30 Nov 2003 22:49:40 -0000	1.3
--- Main.cs	9 Dec 2003 22:30:12 -0000	1.4
***************
*** 195,201 ****
      private void subMenuValidateGo_Click(object sender, System.EventArgs e)
      {
!       QuantProject.Applications.Downloader.Validate validate =
!         new QuantProject.Applications.Downloader.Validate();
!       validate.ShowDialog();
      }
  
--- 195,201 ----
      private void subMenuValidateGo_Click(object sender, System.EventArgs e)
      {
!       QuantProject.Applications.Downloader.Validate.ValidateForm validateForm =
!         new QuantProject.Applications.Downloader.Validate.ValidateForm();
!       validateForm.ShowDialog();
      }
  

[Quantproject-developers] QuantDownloader/Downloader/Validate QuotesToBeValidated.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv2034/Downloader/Validate

Added Files:
	QuotesToBeValidated.cs 
Log Message:
DataTable used to fetch all the quotes rows
to be validated against several different rules.

--- NEW FILE: QuotesToBeValidated.cs ---
using System;
using System.Data;
using System.Data.OleDb;

namespace QuantProject.Applications.Downloader.Validate
{
	/// <summary>
	/// Summary description for QuotesToBeValidated.
	/// </summary>
	public class QuotesToBeValidated : DataTable
	{
    private string selectStatement;
    private OleDbDataAdapter oleDbDataAdapter;
    
    public QuotesToBeValidated( string tickerIsLike )
		{
//      this.selectStatement =
//        "select * from quotes where quTicker like '" + tickerIsLike + "'";
      this.selectStatement =
        "select * from quotes where quTicker = '" + tickerIsLike + "'";
      this.oleDbDataAdapter = new OleDbDataAdapter( selectStatement , AdoNetTools.OleDbConnection );
      try
      {
        this.oleDbDataAdapter.Fill( this );
      }
      catch (Exception exception)
      {
        Console.WriteLine( exception.ToString() );
      }
    }
	}
}

[Quantproject-developers] QuantDownloader/Downloader/Validate ValidateDataTable.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv1606/Downloader/Validate

Added Files:
	ValidateDataTable.cs 
Log Message:
DataTable to be bound to the Validate form DataGrid.
It will contain all data validation errors with descriptions
(descriptions are not yet handled in this revision)
and it will be used to fetch user input data
fixing and to apply updates to the database.

--- NEW FILE: ValidateDataTable.cs ---
using System;
using System.Data;
using System.Data.OleDb;

namespace QuantProject.Applications.Downloader.Validate
{
  /// <summary>
  /// DataTable to be bound to the Validate form DataGrid. It will
  /// contain all data validation errors with descriptions and it will
  /// be used to fetch user input data fixing and to apply updates to the database.
  /// </summary>
  public class ValidateDataTable : DataTable
  {
    private string selectStatement;
    private OleDbCommandBuilder oleDbCommandBuilder;
    private OleDbDataAdapter oleDbDataAdapter;

    public ValidateDataTable()
    {
      this.selectStatement =
        "select * from quotes where 1=2";
      this.oleDbDataAdapter = new OleDbDataAdapter( selectStatement , AdoNetTools.OleDbConnection );
      this.oleDbCommandBuilder = new OleDbCommandBuilder( oleDbDataAdapter );
      this.oleDbDataAdapter.UpdateCommand = this.oleDbCommandBuilder.GetUpdateCommand();
      this.oleDbDataAdapter.Fill( this );
    }

    #region "addRows_forCurrentQuotesRow"
    /// <summary>
    /// Adds quotesRow to the ValidateDataTable
    /// </summary>
    /// <param name="quotesRow">Row of quotes to added</param>
    private void addRow( DataRow quotesRow )
    {
      DataRow dataRow = this.NewRow();
      foreach (DataColumn dataColumn in quotesRow.Table.Columns )
        dataRow[ dataColumn.ColumnName ] = quotesRow[ dataColumn ];
      this.Rows.Add( dataRow );
      //this.Rows.Add( quotesRow );
    }
    #region "addRows_forCurrentQuotesRow_checkLogicalErrors"
    /// <summary>
    /// Adds a row if not ((Low <= Open) and (Open <= High) and (Low <= Close) and (Close <= High))
    /// </summary>
    /// <param name="quotesRow">Row of quotes to be checked</param>
    private void checkOHLC( DataRow quotesRow )
    {
      if (!
          ( ( Convert.ToDouble( quotesRow[ "quLow" ] ) <=
              ( Convert.ToDouble( quotesRow[ "quOpen" ] ) ) ) &&
            ( Convert.ToDouble( quotesRow[ "quOpen" ] ) <=
              ( Convert.ToDouble( quotesRow[ "quHigh" ] ) ) ) &&
            ( Convert.ToDouble( quotesRow[ "quLow" ] ) <=
              ( Convert.ToDouble( quotesRow[ "quClose" ] ) ) ) &&
            ( Convert.ToDouble( quotesRow[ "quClose" ] ) <=
              ( Convert.ToDouble( quotesRow[ "quHigh" ] ) ) )
          )
         ) 
        addRow( quotesRow );
    }
    /// <summary>
    /// Adds an error row if quotesRow doesn't respect logical constraints
    /// </summary>
    /// <param name="quotesRow">Row of quotes to be checked</param>
    private void addRows_forCurrentQuotesRow_checkLogicalErrors( DataRow quotesRow )
    {
      checkOHLC( quotesRow );
    }
    #endregion
    /// <summary>
    /// Adds errors for the current quotesRow (if any)
    /// </summary>
    /// <param name="quotesRow">Row of quotes to be checked</param>
    private void addRows_forCurrentQuotesRow( DataRow quotesRow )
    {
      addRows_forCurrentQuotesRow_checkLogicalErrors( quotesRow );
    }
    #endregion

    /// <summary>
    /// Adds all the probably wrong data quotes rows
    /// </summary>
    /// <param name="tickerIsLike">Contains the is like clause to fetch the tickers
    /// whose quotes are to be checked</param>
    public void AddRows( string tickerIsLike )
    {
      QuotesToBeValidated quotesToBeValidated = new QuotesToBeValidated( tickerIsLike );
      foreach ( DataRow quotesRow in quotesToBeValidated.Rows )
        this.addRows_forCurrentQuotesRow( quotesRow );
      this.AcceptChanges();
    }

    /// <summary>
    /// Commits the ValidateDataTable changes to the database
    /// </summary>
    public void Update()
    {
      try
      {
        this.oleDbDataAdapter.Update( this );
        this.AcceptChanges();
      }
      catch (Exception exception)
      {
        Console.WriteLine( exception.ToString() );
      }
    }
  }
}

[Quantproject-developers] QuantDownloader/Downloader/Validate ValidateForm.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv1282/Downloader/Validate

Added Files:
	ValidateForm.cs 
Log Message:
Form to perform:
- data validation
- data correction

--- NEW FILE: ValidateForm.cs ---
using System;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;

namespace QuantProject.Applications.Downloader.Validate
{
	/// <summary>
	/// Summary description for Validate.
	/// </summary>
	public class ValidateForm : System.Windows.Forms.Form
	{
    private System.Windows.Forms.Label labelTickerIsLike;
    private System.Windows.Forms.Button buttonGo;
    private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
    private System.Windows.Forms.DataGrid dataGrid1;
    private ValidateDataTable validateDataTable;
    private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
    private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
    private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
    private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
    private System.Windows.Forms.TextBox textBoxTickerIsLike;
    private System.Windows.Forms.Button buttonCommitAndRefresh;
		/// <summary>
		/// Required designer variable.
		/// </summary>
		private System.ComponentModel.Container components = null;

		public ValidateForm()
		{
			//
			// Required for Windows Form Designer support
			//
			InitializeComponent();
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows Form Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
      this.textBoxTickerIsLike = new System.Windows.Forms.TextBox();
      this.labelTickerIsLike = new System.Windows.Forms.Label();
      this.buttonGo = new System.Windows.Forms.Button();
      this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
      this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
      this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
      this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
      this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
      this.dataGrid1 = new System.Windows.Forms.DataGrid();
      this.buttonCommitAndRefresh = new System.Windows.Forms.Button();
      ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
      this.SuspendLayout();
      // 
      // textBoxTickerIsLike
      // 
      this.textBoxTickerIsLike.Location = new System.Drawing.Point(120, 16);
      this.textBoxTickerIsLike.Name = "textBoxTickerIsLike";
      this.textBoxTickerIsLike.TabIndex = 0;
      this.textBoxTickerIsLike.Text = "CCE";
      // 
      // labelTickerIsLike
      // 
      this.labelTickerIsLike.Location = new System.Drawing.Point(24, 16);
      this.labelTickerIsLike.Name = "labelTickerIsLike";
      this.labelTickerIsLike.Size = new System.Drawing.Size(80, 16);
      this.labelTickerIsLike.TabIndex = 1;
      this.labelTickerIsLike.Text = "Ticker is Like:";
      this.labelTickerIsLike.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
      // 
      // buttonGo
      // 
      this.buttonGo.Location = new System.Drawing.Point(368, 16);
      this.buttonGo.Name = "buttonGo";
      this.buttonGo.TabIndex = 2;
      this.buttonGo.Text = "Go";
      this.buttonGo.Click += new System.EventHandler(this.buttonGo_Click);
      // 
      // oleDbDataAdapter1
      // 
      this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
      this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
      this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
      this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                new System.Data.Common.DataTableMapping("Table", "quotes", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("Ticker", "Ticker"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("TheDate", "TheDate"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("TheOpen", "TheOpen"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("High", "High"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("Low", "Low"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("TheClose", "TheClose"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("Volume", "Volume"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjOpen", "AdjOpen"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjHigh", "AdjHigh"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjLow", "AdjLow"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjClose", "AdjClose"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjVolume", "AdjVolume"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("ErrorDescription", "ErrorDescription")})});
      this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
      // 
      // oleDbDeleteCommand1
      // 
      this.oleDbDeleteCommand1.CommandText = @"DELETE FROM quotes WHERE (quDate = ?) AND (quTicker = ?) AND (quAdjustedClose = ? OR ? IS NULL AND quAdjustedClose IS NULL) AND (quAdjustedHigh = ? OR ? IS NULL AND quAdjustedHigh IS NULL) AND (quAdjustedLow = ? OR ? IS NULL AND quAdjustedLow IS NULL) AND (quAdjustedOpen = ? OR ? IS NULL AND quAdjustedOpen IS NULL) AND (quAdjustedVolume = ? OR ? IS NULL AND quAdjustedVolume IS NULL) AND (quClose = ? OR ? IS NULL AND quClose IS NULL) AND (quHigh = ? OR ? IS NULL AND quHigh IS NULL) AND (quLow = ? OR ? IS NULL AND quLow IS NULL) AND (quOpen = ? OR ? IS NULL AND quOpen IS NULL)";
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quDate", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TheDate", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Ticker", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      // 
      // oleDbInsertCommand1
      // 
      this.oleDbInsertCommand1.CommandText = "INSERT INTO quotes(quTicker, quDate, quOpen, quHigh, quLow, quClose, quVolume, qu" +
        "AdjustedOpen, quAdjustedHigh, quAdjustedLow, quAdjustedClose, quAdjustedVolume) " +
        "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, "Ticker"));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quDate", System.Data.OleDb.OleDbType.DBDate, 0, "TheDate"));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quVolume", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Volume", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Current, null));
      // 
      // oleDbSelectCommand1
      // 
      this.oleDbSelectCommand1.CommandText = @"SELECT quTicker AS Ticker, quDate AS TheDate, quOpen AS TheOpen, quHigh AS High, quLow AS Low, quClose AS TheClose, quVolume AS Volume, quAdjustedOpen AS AdjOpen, quAdjustedHigh AS AdjHigh, quAdjustedLow AS AdjLow, quAdjustedClose AS AdjClose, quAdjustedVolume AS AdjVolume, '' AS ErrorDescription FROM quotes ORDER BY quTicker, quDate";
      // 
      // oleDbUpdateCommand1
      // 
      this.oleDbUpdateCommand1.CommandText = @"UPDATE quotes SET quTicker = ?, quDate = ?, quOpen = ?, quHigh = ?, quLow = ?, quClose = ?, quVolume = ?, quAdjustedOpen = ?, quAdjustedHigh = ?, quAdjustedLow = ?, quAdjustedClose = ?, quAdjustedVolume = ? WHERE (quDate = ?) AND (quTicker = ?) AND (quAdjustedClose = ? OR ? IS NULL AND quAdjustedClose IS NULL) AND (quAdjustedHigh = ? OR ? IS NULL AND quAdjustedHigh IS NULL) AND (quAdjustedLow = ? OR ? IS NULL AND quAdjustedLow IS NULL) AND (quAdjustedOpen = ? OR ? IS NULL AND quAdjustedOpen IS NULL) AND (quAdjustedVolume = ? OR ? IS NULL AND quAdjustedVolume IS NULL) AND (quClose = ? OR ? IS NULL AND quClose IS NULL) AND (quHigh = ? OR ? IS NULL AND quHigh IS NULL) AND (quLow = ? OR ? IS NULL AND quLow IS NULL) AND (quOpen = ? OR ? IS NULL AND quOpen IS NULL)";
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, "Ticker"));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quDate", System.Data.OleDb.OleDbType.DBDate, 0, "TheDate"));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quVolume", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Volume", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quDate", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TheDate", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Ticker", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      // 
      // dataGrid1
      // 
      this.dataGrid1.DataMember = "";
      this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
      this.dataGrid1.Location = new System.Drawing.Point(16, 56);
      this.dataGrid1.Name = "dataGrid1";
      this.dataGrid1.PreferredColumnWidth = 50;
      this.dataGrid1.Size = new System.Drawing.Size(696, 224);
      this.dataGrid1.TabIndex = 3;
      // 
      // buttonCommitAndRefresh
      // 
      this.buttonCommitAndRefresh.Location = new System.Drawing.Point(272, 296);
      this.buttonCommitAndRefresh.Name = "buttonCommitAndRefresh";
      this.buttonCommitAndRefresh.Size = new System.Drawing.Size(152, 23);
      this.buttonCommitAndRefresh.TabIndex = 4;
      this.buttonCommitAndRefresh.Text = "Commit && Refresh";
      this.buttonCommitAndRefresh.Click += new System.EventHandler(this.buttonCommitAndRefresh_Click);
      // 
      // ValidateForm
      // 
      this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
      this.ClientSize = new System.Drawing.Size(720, 341);
      this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                                                  this.buttonCommitAndRefresh,
                                                                  this.dataGrid1,
                                                                  this.buttonGo,
                                                                  this.labelTickerIsLike,
                                                                  this.textBoxTickerIsLike});
      this.Name = "ValidateForm";
      this.Text = "Validate";
      ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
      this.ResumeLayout(false);

    }
		#endregion

    private void buttonGo_Click(object sender, System.EventArgs e)
    {
      this.validateDataTable = new ValidateDataTable();
      this.dataGrid1.DataSource = validateDataTable;
      validateDataTable.AddRows( textBoxTickerIsLike.Text );
    }

    private void buttonCommitAndRefresh_Click(object sender, System.EventArgs e)
    {
      validateDataTable.Update();
      buttonGo_Click( sender , e );
    }

	}
}

[Quantproject-developers] QuantDownloader/Downloader AdoNetTools.cs,1.1,1.2

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1:/tmp/cvs-serv950/Downloader

Modified Files:
	AdoNetTools.cs 
Log Message:
The code has been slightly cleaned up.

Index: AdoNetTools.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/AdoNetTools.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** AdoNetTools.cs	30 Nov 2003 22:52:13 -0000	1.1
--- AdoNetTools.cs	9 Dec 2003 22:15:17 -0000	1.2
***************
*** 24,29 ****
        {
          if ( oleDbConnection == null )
-           return oleDbConnection;
-         else
          {
            DataBaseLocator dataBaseLocator = new DataBaseLocator("MDB"); 
--- 24,27 ----
***************
*** 34,39 ****
              @";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
            oleDbConnection = new OleDbConnection( connectionString );
-           return oleDbConnection;
          }
        }
      }
--- 32,37 ----
              @";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
            oleDbConnection = new OleDbConnection( connectionString );
          }
+         return oleDbConnection;
        }
      }

[Quantproject-developers] QuantProject QuantProject.suo,1.18,1.19

[<mi...@us...>]

Update of /cvsroot/quantproject/QuantProject
In directory sc8-pr-cvs1:/tmp/cvs-serv19756

Modified Files:
	QuantProject.suo 
Log Message:
Added new library for statistical function, added new method to History class, added script for simple testing

Index: QuantProject.suo
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/QuantProject.suo,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
Binary files /tmp/cvs4yiiAY and /tmp/cvsa42bbP differ

[Quantproject-developers] QuantProject/b7_Scripts/SimpleTesting/MSFTsimpleTest RunMSFTsimpleTest_2.cs,NONE,1.1 TsMSFTsimpleTest_2.cs,NONE,1.1

[<mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b7_Scripts/SimpleTesting/MSFTsimpleTest
In directory sc8-pr-cvs1:/tmp/cvs-serv19480/b7_Scripts/SimpleTesting/MSFTsimpleTest

Added Files:
	RunMSFTsimpleTest_2.cs TsMSFTsimpleTest_2.cs 
Log Message:
Added script for simple testing

--- NEW FILE: RunMSFTsimpleTest_2.cs ---
/*
QuantProject - Quantitative Finance Library

RunMSFTsimpleTest_2.cs
Copyright (C) 2003 
Marco Milletti

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
*/

using System;
using QuantProject.ADT;
using QuantProject.ADT.Histories;
using QuantProject.ADT.Optimizing;
using QuantProject.Business.Financial.Accounting;
using QuantProject.Business.Financial.Accounting.Reporting;
using QuantProject.Business.Financial.Instruments;
using QuantProject.Business.Testing;
using QuantProject.Business.Strategies;
using QuantProject.Business.Scripting;
using QuantProject.Presentation.MicrosoftExcel;

namespace QuantProject.Scripts
{
	/// <summary>
	/// Summary description for runMSFTsimpleTest_2.
	/// </summary>
	public class RunMSFTsimpleTest_2 : Script
	{
    public RunMSFTsimpleTest_2()
  	{
			//
			// TODO: Add constructor logic here
			//
		}

    public override void Run()
    {
      DateTime startDateTime = new DateTime( 2000 , 1 , 1 );
      DateTime endDateTime = new DateTime( 2000 , 12 , 31 );
      QuoteCache.Add( new Instrument( "MSFT" ) , BarComponent.Open );
      QuoteCache.Add( new Instrument( "MSFT" ) , BarComponent.Close );
      QuoteCache.SetCache( startDateTime , endDateTime );

      TradingSystems tradingSystems = new TradingSystems();
     
      tradingSystems.Add( new TsMSFTsimpleTest_2() );

      Tester tester = new Tester(
        new TestWindow( startDateTime , endDateTime ) ,
        tradingSystems ,
        10000 );

      //tester.Parameters.Add( new Parameter( "SMAdays" , 10 , 10 , 2 ) );

      //tester.Optimize();

      //tester.OptimalParameters.ReportToConsole();

      //tester.Parameters = tester.OptimalParameters;

      //tester.Objective();
	  
      //tester.Account.ReportToConsole( endDateTime );
		tester.Test();
      ((History)tester.Account.GetProfitNetLossHistory(
        new ExtendedDateTime( endDateTime , BarComponent.Close ) ) ).ReportToConsole();

//      tester.Account.AccountReport.ReportToExcel( "MSFT" ,
//        new ExtendedDateTime( endDateTime , BarComponent.Close ) );

      AccountReport accountReport = tester.Account.CreateReport( "MSFT" , 7 ,
        new ExtendedDateTime( endDateTime , BarComponent.Close ) , "MSFT" );
      ExcelManager.Add( accountReport );
      ExcelManager.ShowReport();
    }
	}
}

--- NEW FILE: TsMSFTsimpleTest_2.cs ---
/*
QuantProject - Quantitative Finance Library

TsMSFTsimpleTest_2.cs
Copyright (C) 2003 
Marco Milletti

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
*/

using System;
using System.Collections;
using QuantProject.ADT;
using QuantProject.ADT.Histories;
using QuantProject.ADT.Optimizing;
using QuantProject.Business.Financial.Instruments;
using QuantProject.Business.Financial.Ordering;
using QuantProject.Business.Strategies;

namespace QuantProject.Scripts
{
	/// <summary>
	/// Summary description for tsMSFTsimpleTest_2.
	/// </summary>
	public class TsMSFTsimpleTest_2 : TradingSystem
	{
		public TsMSFTsimpleTest_2()
		{
			//
			// TODO: Add constructor logic here
			//
		}

    private History microsoftCloseHistory;
    private History microsoftCloseHistorySimpleAverage;
	private History microsoftCloseHistoryStandardDeviation;

    public override void InitializeData()
    {
      microsoftCloseHistory = QuoteCache.GetCloseHistory( "MSFT" );
      microsoftCloseHistorySimpleAverage = 
		  microsoftCloseHistory.GetSimpleAverage(5, new DateTime(2000,1,1),new DateTime(2000,12,31));
	  microsoftCloseHistoryStandardDeviation = 
		  microsoftCloseHistory.GetStandardDeviation(5, new DateTime(2000,1,1),new DateTime(2000,12,31));
	}

    public override Signals GetSignals( ExtendedDateTime extendedDateTime )
    {
		Signals signals = new Signals();
		if ( extendedDateTime.BarComponent == BarComponent.Close &&
			microsoftCloseHistoryStandardDeviation.IsDecreased(extendedDateTime.DateTime))
		{
			Signal signal = new Signal();
			if ( this.microsoftCloseHistorySimpleAverage.IsDecreased(extendedDateTime.DateTime) )
			{
				
				signal.Add( new Order( OrderType.MarketSell , new Instrument( "MSFT" ) , 1 ,
					new ExtendedDateTime(
					new Instrument( "MSFT" ).GetNextMarketDay( extendedDateTime.DateTime ) ,
					BarComponent.Open ) ) );
				signals.Add( signal );
			}
			else
			{
				signal.Add( new Order( OrderType.MarketBuy , new Instrument( "MSFT" ) , 1 ,
					new ExtendedDateTime( new Instrument( "MSFT" ).GetNextMarketDay( extendedDateTime.DateTime ) ,
					BarComponent.Open ) ) );
				signals.Add( signal );
			}

		}
		
		return signals;
    }
    }	
}

[Quantproject-developers] QuantProject/b7_Scripts b7_Scripts.csproj,1.6,1.7

[<mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b7_Scripts
In directory sc8-pr-cvs1:/tmp/cvs-serv19480/b7_Scripts

Modified Files:
	b7_Scripts.csproj 
Log Message:
Added script for simple testing

Index: b7_Scripts.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b7_Scripts/b7_Scripts.csproj,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** b7_Scripts.csproj	28 Nov 2003 16:38:04 -0000	1.6
--- b7_Scripts.csproj	2 Dec 2003 19:11:16 -0000	1.7
***************
*** 113,117 ****
--- 113,127 ----
                  />
                  <File
+                     RelPath = "SimpleTesting\MSFTsimpleTest\RunMSFTsimpleTest_2.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
                      RelPath = "SimpleTesting\MSFTsimpleTest\TsMSFTsimpleTest.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
+                     RelPath = "SimpleTesting\MSFTsimpleTest\TsMSFTsimpleTest_2.cs"
                      SubType = "Code"
                      BuildAction = "Compile"

[Quantproject-developers] QuantProject/b1_ADT/Histories Stat.cs,NONE,1.1

[<mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b1_ADT/Histories
In directory sc8-pr-cvs1:/tmp/cvs-serv19019/b1_ADT/Histories

Added Files:
	Stat.cs 
Log Message:
Added a simple library for some basic statistical function

--- NEW FILE: Stat.cs ---
/*
QuantProject - Quantitative Finance Library

History.cs
Copyright (C) 2003 
Marco Milletti

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
*/

using System;

namespace QuantProject.ADT.Histories
{
	/// <summary>
	/// Implements some basic statistical functions
	/// </summary>
	public class Stat
	{
		
		static public  double Sum( double[] data ) 
		{
			double sum = 0;
			for( int i = 0; i < data.Length ; i ++ ) 
			{
				sum += data[ i ];
			}
			return	sum;
		}
		static public  double SumOfSquares( double[] data ) 
		{
			double sumOfSquares = 0;
			for( int i = 0; i < data.Length ; i ++ ) 
			{
				sumOfSquares += data[ i ]*data[ i ];
			}
			return	sumOfSquares;
		}
		
		static public double SimpleAverage( double[] data ) 
		{
			return	Stat.Sum(data)/data.Length;
		}

		static public double Variance( double[] data ) 
		{
			double sum = Stat.Sum(data);
			double sumOfSquares = Stat.SumOfSquares(data);
			return	(sumOfSquares - sum*sum/data.Length)/data.Length;
		}

		static public double StdDev( double[] data ) 
		{
			return	System.Math.Sqrt(Stat.Variance(data));
		}
	}	
}		

		

[Quantproject-developers] QuantProject/b1_ADT b1_ADT.csproj,1.1.1.1,1.2

[<mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b1_ADT
In directory sc8-pr-cvs1:/tmp/cvs-serv18518/b1_ADT

Modified Files:
	b1_ADT.csproj 
Log Message:
Added GetSimpleAverage and GetStandardDeviation methods to History Class

Index: b1_ADT.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b1_ADT/b1_ADT.csproj,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** b1_ADT.csproj	13 Oct 2003 21:57:21 -0000	1.1.1.1
--- b1_ADT.csproj	2 Dec 2003 19:07:44 -0000	1.2
***************
*** 113,116 ****
--- 113,121 ----
                  />
                  <File
+                     RelPath = "Histories\Stat.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
                      RelPath = "Optimizing\Optimizable.cs"
                      SubType = "Code"

[Quantproject-developers] QuantProject/b1_ADT/Histories History.cs,1.1.1.1,1.2

[<mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b1_ADT/Histories
In directory sc8-pr-cvs1:/tmp/cvs-serv18518/b1_ADT/Histories

Modified Files:
	History.cs 
Log Message:
Added GetSimpleAverage and GetStandardDeviation methods to History Class

Index: History.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b1_ADT/Histories/History.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** History.cs	13 Oct 2003 21:57:45 -0000	1.1.1.1
--- History.cs	2 Dec 2003 19:07:43 -0000	1.2
***************
*** 25,28 ****
--- 25,29 ----
  using QuantProject.ADT;
  
+ 
  namespace QuantProject.ADT.Histories
  {
***************
*** 75,78 ****
--- 76,163 ----
          return (DateTime) this.GetKey( this.IndexOfKeyOrPrevious( dateTime ) + 1 );
      }
+ 
+ 	  #region "Millo_1 - SimpleAverage and StandardDeviation"
+ 
+ 	  public History GetSimpleAverage( int onEachPeriodOf , DateTime startDateTime , DateTime endDateTime )
+ 	  {
+ 		  History simpleAverage = new History();
+ 		  int index = this.IndexOfKeyOrPrevious(startDateTime); 
+ 		  double[] data = new double[onEachPeriodOf];
+ 		  double checkValue = 0;
+ 		  int i = 0;
+ 		  while (
+ 			  ( index < this.Count ) &&
+ 			  ( ((IComparable)this.GetKey( index )).CompareTo( endDateTime ) <= 0 ) )
+ 		  {
+ 			  DateTime dateTime = (DateTime)this.GetKey( index );
+ 			  if (Math.Floor(index/onEachPeriodOf) == checkValue &&
+ 					i < onEachPeriodOf)
+ 			  {	
+ 				  data[i] = Convert.ToDouble(this.GetByIndex(index));
+ 				  i++;
+ 				  //simpleAverage.Add(this.GetKey( index ), null);
+ 			  }
+ 			  else //Changes the period
+ 			  {	
+ 				  i = 0;
+ 				  simpleAverage.Add( dateTime , Stat.SimpleAverage(data) );
+ 			  }
+ 			  index++;
+ 			  checkValue = Math.Floor(index/onEachPeriodOf);//update checkValue
+ 		  }
+ 
+ 		  return simpleAverage;
+ 	  }
+ 
+ 	  public History GetStandardDeviation( int onEachPeriodOf , DateTime startDateTime , DateTime endDateTime )
+ 	  {
+ 		  History stdDev = new History();
+ 		  int index = this.IndexOfKeyOrPrevious(startDateTime); 
+ 		  double[] data = new double[onEachPeriodOf];
+ 		  double checkValue = 0;
+ 		  int i = 0;
+ 		  while (
+ 			  ( index < this.Count ) &&
+ 			  ( ((IComparable)this.GetKey( index )).CompareTo( endDateTime ) <= 0 ) )
+ 		  {
+ 			  DateTime dateTime = (DateTime)this.GetKey( index );
+ 			  if (Math.Floor(index/onEachPeriodOf) == checkValue &&
+ 					i < onEachPeriodOf)
+ 			  {	
+ 				  data[i] = Convert.ToDouble(this.GetByIndex(index));
+ 				  i++;
+ 				  //stdDev.Add(this.GetKey( index ), null);
+ 			  }
+ 			  else //Changes the period
+ 			  {	
+ 				  i = 0;
+ 				  stdDev.Add( dateTime , Stat.StdDev (data) );
+ 			  }
+ 			  index++;
+ 			  checkValue = Math.Floor(index/onEachPeriodOf);//update checkValue
+ 		  }
+ 
+ 		  return stdDev ;
+ 	  }
+ 	  public bool IsDecreased(DateTime dateTime)
+ 	  {	
+ 		  bool isDecreased;
+ 		  int index = this.IndexOfKey(dateTime);
+ 		  if ( index <= 0 )
+ 			  isDecreased = false;
+ 		  else
+ 		  {
+ 			  isDecreased = Convert.ToDouble( this[ dateTime ]) <
+ 				  Convert.ToDouble( this.GetByIndex(index - 1) );
+ 		  }
+ 		  return isDecreased;
+ 		  
+ 			  
+ 	  }
+ 
+ 
+ #endregion
+ 
+ 
  
      #region "GetSimpleMovingAverage( int , DateTime , int )"

[Quantproject-developers] QuantDownloader QuantDownloader.suo,1.5,1.6

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader
In directory sc8-pr-cvs1:/tmp/cvs-serv21436

Modified Files:
	QuantDownloader.suo 
Log Message:
no message

Index: QuantDownloader.suo
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/QuantDownloader.suo,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
Binary files /tmp/cvsplfjSf and /tmp/cvscWmr4g differ

[Quantproject-developers] QuantProject/b1_ADT AdvancedSortedList.cs,1.1.1.1,1.2

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantProject/b1_ADT
In directory sc8-pr-cvs1:/tmp/cvs-serv21073/b1_ADT

Modified Files:
	AdvancedSortedList.cs 
Log Message:
Fixed the GetKeyOrPrevious

Index: AdvancedSortedList.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b1_ADT/AdvancedSortedList.cs,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** AdvancedSortedList.cs	13 Oct 2003 21:57:15 -0000	1.1.1.1
--- AdvancedSortedList.cs	1 Dec 2003 15:23:08 -0000	1.2
***************
*** 81,85 ****
      public Object GetKeyOrPrevious( Object key )
      {
!       return this.GetKey( this.IndexOfKey( key ) );
      }
      public bool IsLastKey( Object key )
--- 81,85 ----
      public Object GetKeyOrPrevious( Object key )
      {
!       return this.GetKey( this.IndexOfKeyOrPrevious( key ) );
      }
      public bool IsLastKey( Object key )

[Quantproject-developers] QuantDownloader/Downloader Downloader.csproj,1.3,1.4

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1:/tmp/cvs-serv24896

Modified Files:
	Downloader.csproj 
Log Message:
- Some useless forms have been removed from the project
- The Validate form has been added to the project

Index: Downloader.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** Downloader.csproj	30 Nov 2003 18:31:45 -0000	1.3
--- Downloader.csproj	30 Nov 2003 22:58:24 -0000	1.4
***************
*** 17,21 ****
                  DelaySign = "false"
                  OutputType = "WinExe"
!                 RootNamespace = "QuantProject.Downloader"
                  StartupObject = ""
              >
--- 17,21 ----
                  DelaySign = "false"
                  OutputType = "WinExe"
!                 RootNamespace = "QuantProject.Applications.Downloader"
                  StartupObject = ""
              >
***************
*** 93,96 ****
--- 93,101 ----
              <Include>
                  <File
+                     RelPath = "AdoNetTools.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
                      RelPath = "App.ico"
                      BuildAction = "Content"
***************
*** 136,144 ****
                  />
                  <File
-                     RelPath = "TestDownloadedData.resx"
-                     DependentUpon = "TestDownloadedData.cs"
-                     BuildAction = "EmbeddedResource"
-                 />
-                 <File
                      RelPath = "TickerDownloader.cs"
                      SubType = "Code"
--- 141,144 ----
***************
*** 154,157 ****
--- 154,186 ----
                      DependentUpon = "WebDownloader.cs"
                      BuildAction = "EmbeddedResource"
+                 />
+                 <File
+                     RelPath = "Validate\Validate.cs"
+                     SubType = "Form"
+                     BuildAction = "Compile"
+                 />
+                 <File
+                     RelPath = "Validate\Validate.resx"
+                     DependentUpon = "Validate.cs"
+                     BuildAction = "EmbeddedResource"
+                 />
+                 <File
+                     RelPath = "Validate\ValidateDataset.xsd"
+                     BuildAction = "Content"
+                     Generator = "MSDataSetGenerator"
+                     LastGenOutput = "ValidateDataset.cs"
+                 />
+                 <File
+                     RelPath = "Validate\ValidateDataset.cs"
+                     DependentUpon = "ValidateDataset.xsd"
+                     SubType = "code"
+                     BuildAction = "Compile"
+                     DesignTime = "True"
+                     AutoGen = "True"
+                 />
+                 <File
+                     RelPath = "Validate\ValidateDataset.xsx"
+                     DependentUpon = "ValidateDataset.xsd"
+                     BuildAction = "None"
                  />
              </Include>

[Quantproject-developers] QuantDownloader/Downloader/Validate ValidateDataset.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv24489/Validate

Added Files:
	ValidateDataset.cs 
Log Message:
DataSet class for the validate form datagrid DataSource

--- NEW FILE: ValidateDataset.cs ---
(This appears to be a binary file; contents omitted.)

[Quantproject-developers] QuantDownloader/Downloader/Validate Validate.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv23893/Validate

Added Files:
	Validate.cs 
Log Message:
Form for quotes validation

--- NEW FILE: Validate.cs ---
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;

namespace QuantProject.Applications.Downloader
{
	/// <summary>
	/// Summary description for Validate.
	/// </summary>
	public class Validate : System.Windows.Forms.Form
	{
    private System.Windows.Forms.TextBox textBox1;
    private System.Windows.Forms.Label labelTickerIsLike;
    private System.Windows.Forms.Button buttonGo;
    private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
    private QuantProject.Applications.Downloader.ValidateDataset validateDataset1;
    private System.Data.OleDb.OleDbConnection oleDbConnection2;
    private System.Windows.Forms.DataGrid dataGrid1;
    private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
    private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
    private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
    private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
		/// <summary>
		/// Required designer variable.
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Validate()
		{
			//
			// Required for Windows Form Designer support
			//
			InitializeComponent();
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows Form Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
      this.textBox1 = new System.Windows.Forms.TextBox();
      this.labelTickerIsLike = new System.Windows.Forms.Label();
      this.buttonGo = new System.Windows.Forms.Button();
      this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
      this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
      this.oleDbConnection2 = AdoNetTools.OleDbConnection;
      this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
      this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
      this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
      this.validateDataset1 = new QuantProject.Applications.Downloader.ValidateDataset();
      this.dataGrid1 = new System.Windows.Forms.DataGrid();
      ((System.ComponentModel.ISupportInitialize)(this.validateDataset1)).BeginInit();
      ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
      this.SuspendLayout();
      // 
      // textBox1
      // 
      this.textBox1.Location = new System.Drawing.Point(120, 16);
      this.textBox1.Name = "textBox1";
      this.textBox1.TabIndex = 0;
      this.textBox1.Text = "MS?T";
      // 
      // labelTickerIsLike
      // 
      this.labelTickerIsLike.Location = new System.Drawing.Point(24, 16);
      this.labelTickerIsLike.Name = "labelTickerIsLike";
      this.labelTickerIsLike.Size = new System.Drawing.Size(80, 16);
      this.labelTickerIsLike.TabIndex = 1;
      this.labelTickerIsLike.Text = "Ticker is Like:";
      this.labelTickerIsLike.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
      // 
      // buttonGo
      // 
      this.buttonGo.Location = new System.Drawing.Point(368, 16);
      this.buttonGo.Name = "buttonGo";
      this.buttonGo.TabIndex = 2;
      this.buttonGo.Text = "Go";
      // 
      // oleDbDataAdapter1
      // 
      this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
      this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
      this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
      this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                new System.Data.Common.DataTableMapping("Table", "quotes", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("Ticker", "Ticker"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("TheDate", "TheDate"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("TheOpen", "TheOpen"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("High", "High"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("Low", "Low"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("TheClose", "TheClose"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("Volume", "Volume"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjOpen", "AdjOpen"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjHigh", "AdjHigh"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjLow", "AdjLow"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjClose", "AdjClose"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("AdjVolume", "AdjVolume"),
                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("ErrorDescription", "ErrorDescription")})});
      this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
      // 
      // oleDbDeleteCommand1
      // 
      this.oleDbDeleteCommand1.CommandText = @"DELETE FROM quotes WHERE (quDate = ?) AND (quTicker = ?) AND (quAdjustedClose = ? OR ? IS NULL AND quAdjustedClose IS NULL) AND (quAdjustedHigh = ? OR ? IS NULL AND quAdjustedHigh IS NULL) AND (quAdjustedLow = ? OR ? IS NULL AND quAdjustedLow IS NULL) AND (quAdjustedOpen = ? OR ? IS NULL AND quAdjustedOpen IS NULL) AND (quAdjustedVolume = ? OR ? IS NULL AND quAdjustedVolume IS NULL) AND (quClose = ? OR ? IS NULL AND quClose IS NULL) AND (quHigh = ? OR ? IS NULL AND quHigh IS NULL) AND (quLow = ? OR ? IS NULL AND quLow IS NULL) AND (quOpen = ? OR ? IS NULL AND quOpen IS NULL)";
      this.oleDbDeleteCommand1.Connection = this.oleDbConnection2;
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quDate", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TheDate", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Ticker", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      // oleDbInsertCommand1
      // 
      this.oleDbInsertCommand1.CommandText = "INSERT INTO quotes(quTicker, quDate, quOpen, quHigh, quLow, quClose, quVolume, qu" +
        "AdjustedOpen, quAdjustedHigh, quAdjustedLow, quAdjustedClose, quAdjustedVolume) " +
        "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
      this.oleDbInsertCommand1.Connection = this.oleDbConnection2;
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, "Ticker"));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quDate", System.Data.OleDb.OleDbType.DBDate, 0, "TheDate"));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quVolume", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Volume", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Current, null));
      this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Current, null));
      // 
      // oleDbSelectCommand1
      // 
      this.oleDbSelectCommand1.CommandText = @"SELECT quTicker AS Ticker, quDate AS TheDate, quOpen AS TheOpen, quHigh AS High, quLow AS Low, quClose AS TheClose, quVolume AS Volume, quAdjustedOpen AS AdjOpen, quAdjustedHigh AS AdjHigh, quAdjustedLow AS AdjLow, quAdjustedClose AS AdjClose, quAdjustedVolume AS AdjVolume, '' AS ErrorDescription FROM quotes ORDER BY quTicker, quDate";
      this.oleDbSelectCommand1.Connection = this.oleDbConnection2;
      // 
      // oleDbUpdateCommand1
      // 
      this.oleDbUpdateCommand1.CommandText = @"UPDATE quotes SET quTicker = ?, quDate = ?, quOpen = ?, quHigh = ?, quLow = ?, quClose = ?, quVolume = ?, quAdjustedOpen = ?, quAdjustedHigh = ?, quAdjustedLow = ?, quAdjustedClose = ?, quAdjustedVolume = ? WHERE (quDate = ?) AND (quTicker = ?) AND (quAdjustedClose = ? OR ? IS NULL AND quAdjustedClose IS NULL) AND (quAdjustedHigh = ? OR ? IS NULL AND quAdjustedHigh IS NULL) AND (quAdjustedLow = ? OR ? IS NULL AND quAdjustedLow IS NULL) AND (quAdjustedOpen = ? OR ? IS NULL AND quAdjustedOpen IS NULL) AND (quAdjustedVolume = ? OR ? IS NULL AND quAdjustedVolume IS NULL) AND (quClose = ? OR ? IS NULL AND quClose IS NULL) AND (quHigh = ? OR ? IS NULL AND quHigh IS NULL) AND (quLow = ? OR ? IS NULL AND quLow IS NULL) AND (quOpen = ? OR ? IS NULL AND quOpen IS NULL)";
      this.oleDbUpdateCommand1.Connection = this.oleDbConnection2;
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, "Ticker"));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quDate", System.Data.OleDb.OleDbType.DBDate, 0, "TheDate"));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quVolume", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Volume", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Current, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quDate", System.Data.OleDb.OleDbType.DBDate, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TheDate", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quTicker", System.Data.OleDb.OleDbType.VarWChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Ticker", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjHigh", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjLow", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quAdjustedVolume1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "AdjVolume", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quClose1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheClose", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quHigh1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "High", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quLow1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "Low", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_quOpen1", System.Data.OleDb.OleDbType.Single, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(7)), ((System.Byte)(0)), "TheOpen", System.Data.DataRowVersion.Original, null));
      // 
      // validateDataset1
      // 
      this.validateDataset1.DataSetName = "ValidateDataset";
      this.validateDataset1.Locale = new System.Globalization.CultureInfo("en-US");
      this.validateDataset1.Namespace = "http://www.tempuri.org/ValidateDataset.xsd";
      // 
      // dataGrid1
      // 
      this.dataGrid1.DataMember = "";
      this.dataGrid1.DataSource = this.validateDataset1.quotes;
      this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
      this.dataGrid1.Location = new System.Drawing.Point(16, 56);
      this.dataGrid1.Name = "dataGrid1";
      this.dataGrid1.PreferredColumnWidth = 50;
      this.dataGrid1.Size = new System.Drawing.Size(696, 224);
      this.dataGrid1.TabIndex = 3;
      // 
      // Validate
      // 
      this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
      this.ClientSize = new System.Drawing.Size(720, 341);
      this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                                                  this.dataGrid1,
                                                                  this.buttonGo,
                                                                  this.labelTickerIsLike,
                                                                  this.textBox1});
      this.Name = "Validate";
      this.Text = "Validate";
      ((System.ComponentModel.ISupportInitialize)(this.validateDataset1)).EndInit();
      ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
      this.ResumeLayout(false);

    }
		#endregion

	}
}

[Quantproject-developers] QuantDownloader/Downloader AdoNetTools.cs,NONE,1.1

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1:/tmp/cvs-serv23682

Added Files:
	AdoNetTools.cs 
Log Message:
This new class contains some database
related static properties and methods.

--- NEW FILE: AdoNetTools.cs ---
using System;
using System.Data.OleDb;
using QuantProject.DataAccess;

namespace QuantProject.Applications.Downloader
{
	/// <summary>
	/// Summary description for AdoNetTools.
	/// </summary>
	public class AdoNetTools
	{
		public AdoNetTools()
		{
			//
			// TODO: Add constructor logic here
			//
		}

    private static OleDbConnection oleDbConnection;

    public static OleDbConnection OleDbConnection
    {
      get
      {
        if ( oleDbConnection == null )
          return oleDbConnection;
        else
        {
          DataBaseLocator dataBaseLocator = new DataBaseLocator("MDB"); 
          string mdbPath = dataBaseLocator.Path;
          string connectionString =
            @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=" +
            mdbPath +
            @";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
          oleDbConnection = new OleDbConnection( connectionString );
          return oleDbConnection;
        }
      }
    }
	}
}

[Quantproject-developers] QuantDownloader/Downloader/Validate - New directory

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate
In directory sc8-pr-cvs1:/tmp/cvs-serv23353/Validate

Log Message:
Directory /cvsroot/quantproject/QuantDownloader/Downloader/Validate added to the repository

[Quantproject-developers] QuantDownloader/Downloader Main.cs,1.2,1.3

[<gla...@us...>]

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1:/tmp/cvs-serv23185/Downloader

Modified Files:
	Main.cs 
Log Message:
- The namespace has been changed from QuantDownloader
to QuantProject.Applications.Downloader
- Added the Validate menu' (cleaned up old menus)

Index: Main.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Main.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** Main.cs	20 Nov 2003 22:38:48 -0000	1.2
--- Main.cs	30 Nov 2003 22:49:40 -0000	1.3
***************
*** 5,9 ****
  using System.Windows.Forms;
  
! namespace QuantDownloader
  {
  	/// <summary>
--- 5,9 ----
  using System.Windows.Forms;
  
! namespace QuantProject.Applications.Downloader
  {
  	/// <summary>
***************
*** 20,30 ****
      private System.Windows.Forms.MenuItem menuItem6;
      private System.Windows.Forms.MenuItem menuItem7;
!     private System.Windows.Forms.MenuItem menuItem8;
!     private System.Windows.Forms.MenuItem menuItem10;
!     private System.Windows.Forms.MenuItem menuItem11;
!     private System.Windows.Forms.MenuItem menuItem12;
!     private System.Windows.Forms.MenuItem menuItem13;
!     private System.Windows.Forms.MenuItem menuItem14;
!     private System.Windows.Forms.MenuItem menuItem9;
  		/// <summary>
  		/// Required designer variable.
--- 20,27 ----
      private System.Windows.Forms.MenuItem menuItem6;
      private System.Windows.Forms.MenuItem menuItem7;
!     private System.Windows.Forms.MenuItem menuImport;
!     private System.Windows.Forms.MenuItem subMenuFromTheWeb;
!     private System.Windows.Forms.MenuItem menuValidate;
!     private System.Windows.Forms.MenuItem subMenuValidateGo;
  		/// <summary>
  		/// Required designer variable.
***************
*** 67,77 ****
  		{
        this.mainMenu1 = new System.Windows.Forms.MainMenu();
!       this.menuItem8 = new System.Windows.Forms.MenuItem();
!       this.menuItem10 = new System.Windows.Forms.MenuItem();
!       this.menuItem9 = new System.Windows.Forms.MenuItem();
!       this.menuItem11 = new System.Windows.Forms.MenuItem();
!       this.menuItem12 = new System.Windows.Forms.MenuItem();
!       this.menuItem13 = new System.Windows.Forms.MenuItem();
!       this.menuItem14 = new System.Windows.Forms.MenuItem();
        this.menuItem1 = new System.Windows.Forms.MenuItem();
        this.menuItem2 = new System.Windows.Forms.MenuItem();
--- 64,71 ----
  		{
        this.mainMenu1 = new System.Windows.Forms.MainMenu();
!       this.menuImport = new System.Windows.Forms.MenuItem();
!       this.subMenuFromTheWeb = new System.Windows.Forms.MenuItem();
!       this.menuValidate = new System.Windows.Forms.MenuItem();
!       this.subMenuValidateGo = new System.Windows.Forms.MenuItem();
        this.menuItem1 = new System.Windows.Forms.MenuItem();
        this.menuItem2 = new System.Windows.Forms.MenuItem();
***************
*** 85,137 ****
        // 
        this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
!                                                                               this.menuItem8,
!                                                                               this.menuItem11,
!                                                                               this.menuItem13});
!       // 
!       // menuItem8
!       // 
!       this.menuItem8.Index = 0;
!       this.menuItem8.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
!                                                                               this.menuItem10,
!                                                                               this.menuItem9});
!       this.menuItem8.Text = "Data";
!       // 
!       // menuItem10
!       // 
!       this.menuItem10.Index = 0;
!       this.menuItem10.Text = "Download";
!       this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
!       // 
!       // menuItem9
!       // 
!       this.menuItem9.Index = 1;
!       this.menuItem9.Text = "Test";
!       this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
        // 
!       // menuItem11
        // 
!       this.menuItem11.Index = 1;
!       this.menuItem11.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
!                                                                                this.menuItem12});
!       this.menuItem11.Text = "BackTest";
        // 
!       // menuItem12
        // 
!       this.menuItem12.Index = 0;
!       this.menuItem12.Text = "Go";
!       this.menuItem12.Click += new System.EventHandler(this.menuItem12_Click);
        // 
!       // menuItem13
        // 
!       this.menuItem13.Index = 2;
!       this.menuItem13.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
!                                                                                this.menuItem14});
!       this.menuItem13.Text = "Trade";
        // 
!       // menuItem14
        // 
!       this.menuItem14.Index = 0;
!       this.menuItem14.Text = "Go";
!       this.menuItem14.Click += new System.EventHandler(this.menuItem14_Click);
        // 
        // menuItem1
--- 79,110 ----
        // 
        this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
!                                                                               this.menuImport,
!                                                                               this.menuValidate});
        // 
!       // menuImport
        // 
!       this.menuImport.Index = 0;
!       this.menuImport.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
!                                                                                this.subMenuFromTheWeb});
!       this.menuImport.Text = "Import";
        // 
!       // subMenuFromTheWeb
        // 
!       this.subMenuFromTheWeb.Index = 0;
!       this.subMenuFromTheWeb.Text = "From the Web";
!       this.subMenuFromTheWeb.Click += new System.EventHandler(this.menuItem10_Click);
        // 
!       // menuValidate
        // 
!       this.menuValidate.Index = 1;
!       this.menuValidate.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
!                                                                                  this.subMenuValidateGo});
!       this.menuValidate.Text = "Validate";
        // 
!       // subMenuValidateGo
        // 
!       this.subMenuValidateGo.Index = 0;
!       this.subMenuValidateGo.Text = "Go";
!       this.subMenuValidateGo.Click += new System.EventHandler(this.subMenuValidateGo_Click);
        // 
        // menuItem1
***************
*** 218,221 ****
--- 191,201 ----
  //      BackTestForm form1 = new BackTestForm();
  //      form1.ShowDialog( this );
+     }
+ 
+     private void subMenuValidateGo_Click(object sender, System.EventArgs e)
+     {
+       QuantProject.Applications.Downloader.Validate validate =
+         new QuantProject.Applications.Downloader.Validate();
+       validate.ShowDialog();
      }