quantproject-developers

[Quantproject-developers] QuantProject/b2_DataAccess b2_DataAccess.csproj,1.9,1.10

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21080/b2_DataAccess

Modified Files:
	b2_DataAccess.csproj 
Log Message:
Added class to access Ticker_tickerGroups table

Index: b2_DataAccess.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/b2_DataAccess.csproj,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** b2_DataAccess.csproj	25 Apr 2004 17:37:52 -0000	1.9
--- b2_DataAccess.csproj	11 May 2004 22:00:34 -0000	1.10
***************
*** 143,146 ****
--- 143,151 ----
                  />
                  <File
+                     RelPath = "Tables\Tickers_tickerGroups.cs"
+                     SubType = "Code"
+                     BuildAction = "Compile"
+                 />
+                 <File
                      RelPath = "Tables\ValidatedTickers.cs"
                      SubType = "Code"

[Quantproject-developers] QuantProject/b2_DataAccess OleDbSingleTableAdapter.cs,1.1,1.2

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20706/b2_DataAccess

Modified Files:
	OleDbSingleTableAdapter.cs 
Log Message:
Added new constructor for the class

Index: OleDbSingleTableAdapter.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/OleDbSingleTableAdapter.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** OleDbSingleTableAdapter.cs	21 Mar 2004 16:11:11 -0000	1.1
--- OleDbSingleTableAdapter.cs	11 May 2004 21:59:10 -0000	1.2
***************
*** 50,53 ****
--- 50,77 ----
  			}
  		}
+     
+     public OleDbSingleTableAdapter(string selectStatement, DataTable table )
+     {
+       try
+       {
+         
+         //				string selectStatement =
+         //					"select * from " + tableName + " where 1=2";
+         this.oleDbDataAdapter =
+           new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection );
+         OleDbCommandBuilder oleDbCommandBuilder = new OleDbCommandBuilder( oleDbDataAdapter );
+         this.oleDbDataAdapter.InsertCommand = oleDbCommandBuilder.GetInsertCommand();
+         this.oleDbDataAdapter.UpdateCommand = oleDbCommandBuilder.GetUpdateCommand();
+         this.oleDbDataAdapter.DeleteCommand = oleDbCommandBuilder.GetDeleteCommand();
+         this.dataTable = table;
+         this.oleDbDataAdapter.Fill( this.dataTable );
+       }
+       catch ( Exception ex )
+       {
+         string exceptionMessage = ex.Message + "\n" + ex.StackTrace;
+         Console.WriteLine( exceptionMessage );
+       }
+     }
+ 
  
  //		public void SetAdapterAndDataTable( string tableName )

[Quantproject-developers] QuantProject/b1_ADT ConstantsProvider.cs,1.2,1.3

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

Update of /cvsroot/quantproject/QuantProject/b1_ADT
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20579/b1_ADT

Modified Files:
	ConstantsProvider.cs 
Log Message:
Added new static constants

Index: ConstantsProvider.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b1_ADT/ConstantsProvider.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** ConstantsProvider.cs	17 Apr 2004 13:49:24 -0000	1.2
--- ConstantsProvider.cs	11 May 2004 21:58:19 -0000	1.3
***************
*** 20,23 ****
--- 20,25 ----
      public static int NumberOfCheckToPerformOnAdjustedValues = 3;
      public static double MaxRelativeDifferenceForAdjustedValues = 0.0005;
+     public static double MaxRelativeDifferenceForCloseToCloseRatios = 0.0001;
+     public static double MaxNumDaysDownloadedAtEachConnection = 200;
  	}
  }

[Quantproject-developers] QuantProject/b2_DataAccess/Tables Quotes.cs,1.5,1.6

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20416/b2_DataAccess/Tables

Modified Files:
	Quotes.cs 
Log Message:
Added new methods to the class

Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** Quotes.cs	8 May 2004 17:10:33 -0000	1.5
--- Quotes.cs	11 May 2004 21:57:27 -0000	1.6
***************
*** 2,5 ****
--- 2,6 ----
  using System.Data;
  using System.Text;
+ using System.Windows.Forms;
  using QuantProject.ADT;
  using QuantProject.ADT.Histories;
***************
*** 12,16 ****
  	public class Quotes
  	{
! 		private DataTable quotes;
       
  		// these static fields provide field name in the database table
--- 13,18 ----
  	public class Quotes
  	{
!        
!     private DataTable quotes;
       
  		// these static fields provide field name in the database table
***************
*** 86,91 ****
--- 88,151 ----
        return dataTable.Rows.Count;
      }
+     
+     /// <summary>
+     /// It provides updating the database for each closeToCloseRatio contained in the given table
+     /// (the table refers to the ticker passed as the first parameter)
+     /// </summary>
+     private static void commitAllCloseToCloseRatios(string ticker,
+                                                     DataTable tableContainingCloseToCloseRatios )
+     {
+       string notUsed = ticker;
+       OleDbSingleTableAdapter adapter = 
+                       new OleDbSingleTableAdapter("SELECT * FROM quotes WHERE 1=2",
+                                                   tableContainingCloseToCloseRatios);
+       adapter.OleDbDataAdapter.Update(tableContainingCloseToCloseRatios);
+       
+       /*
+       foreach(DataRow row in tableContainingCloseToCloseRatios.Rows)
+       {
+         Quotes.UpdateCloseToCloseRatio(ticker, (DateTime)row[Quotes.Date],
+                                        (double)row[Quotes.AdjustedCloseToCloseRatio]);
+       }
+       */
+       
+     }
  
      /// <summary>
+     /// It provides computation of the adjustedCloseToCloseRatios for the given ticker
+     /// </summary>
+     public static void ComputeAndCommitCloseToCloseRatios( string ticker)
+     {
+       DateTime start = DateTime.Now;
+       DataTable tickerQuotes = Quotes.GetTickerQuotes(ticker);
+       DateTime tickerQuotesTime = DateTime.Now;
+       Quotes.ComputeCloseToCloseValues(tickerQuotes);
+       DateTime computation = DateTime.Now;
+       Quotes.commitAllCloseToCloseRatios(ticker, tickerQuotes);
+       DateTime commit = DateTime.Now;
+       MessageBox.Show("start : " + start.ToString() + "\n" +
+                       "loading quotes - finished : " + tickerQuotesTime.ToString() + "\n" +
+                       "computation - finished: " + computation.ToString() + "\n" +
+                       "commit - finished: " + commit.ToString());
+     }
+     
+     /// <summary>
+     /// It provides deletion of all quotes from the table "quotes" for
+     /// the given ticker
+     /// </summary>
+     public static void Delete( string ticker)
+     {
+       try
+       {
+         SqlExecutor.ExecuteNonQuery("DELETE * FROM quotes " +
+                                     "WHERE quTicker ='" +
+                                     ticker + "'");
+       }
+       catch(Exception ex)
+       {
+         string notUsed = ex.ToString();
+       }
+     }
+     /// <summary>
      /// It provides deletion of the quote from the table "quotes" for
      /// the given ticker for a specified date
***************
*** 105,109 ****
        }
      }
! 
      /// <summary>
      /// It provides addition of the given quote's values into table "quotes" 
--- 165,188 ----
        }
      }
!     /// <summary>
!     /// It provides deletion of the quote from the table "quotes" for
!     /// the given ticker for the specified interval
!     /// </summary>
!     public static void Delete( string ticker, DateTime fromDate,
!                                 DateTime toDate)
!     {
!       try
!       {
!         SqlExecutor.ExecuteNonQuery("DELETE * FROM quotes " +
!           "WHERE quTicker ='" +
!           ticker + "' AND quDate >=" +
!           SQLBuilder.GetDateConstant(fromDate) + " " +
!           "AND quDate<=" + SQLBuilder.GetDateConstant(toDate));
!       }
!       catch(Exception ex)
!       {
!         string notUsed = ex.ToString();
!       }
!     }
      /// <summary>
      /// It provides addition of the given quote's values into table "quotes" 
***************
*** 152,155 ****
--- 231,344 ----
        }
      }             
+     
+     #region IsAdjustedCloseToCloseRatioChanged
+ 
+     private static bool isAtLeastOneValueChanged(DataTable tableDB, DataTable tableSource)
+                                                           
+     {
+       try
+       {
+         int numRows = tableDB.Rows.Count;
+         DateTime date;
+         double adjCTCInDatabase;
+         double adjCTCInSource;
+         double absoluteRelativeDifference;
+         DataColumn[] columnPrimaryKey = new DataColumn[0];
+         columnPrimaryKey[0]= tableSource.Columns["quDate"];
+         tableSource.PrimaryKey = columnPrimaryKey;
+         DataRow rowToCheck;
+         for(int i = 0;i != numRows;i++)
+         {
+           date = (DateTime)tableDB.Rows[i][Quotes.Date];
+           adjCTCInDatabase = (double)tableDB.Rows[i][Quotes.AdjustedCloseToCloseRatio];
+           rowToCheck = tableSource.Rows.Find(date);
+           if(rowToCheck != null)
+           {
+             adjCTCInSource = (double)rowToCheck[Quotes.AdjustedCloseToCloseRatio];
+             absoluteRelativeDifference = Math.Abs((adjCTCInDatabase - adjCTCInSource)/adjCTCInSource);
+             if(absoluteRelativeDifference > ConstantsProvider.MaxRelativeDifferenceForCloseToCloseRatios )
+                return true;
+           }
+         }
+       }
+       catch(Exception ex)
+       {
+         string notUsed = ex.ToString();
+       }
+       return false;
+ 
+     }             
+ 
+ 
+     public static void ComputeCloseToCloseValues(DataTable tableContainingNewAdjustedValues)
+                                                           
+     {
+       try
+       {
+         if(!tableContainingNewAdjustedValues.Columns.Contains(Quotes.AdjustedCloseToCloseRatio))
+         {
+           tableContainingNewAdjustedValues.Columns.Add(Quotes.AdjustedCloseToCloseRatio,
+                                                        System.Type.GetType("System.Double"));
+         }
+         int numRows = tableContainingNewAdjustedValues.Rows.Count;
+         float previousClose;
+         float currentClose;
+         for(int i = 0;i != numRows;i++)
+         {
+           if(i == 0)
+           //the first available quote has 0 as closeToClose ratio
+           {
+             tableContainingNewAdjustedValues.Rows[i][Quotes.AdjustedCloseToCloseRatio] = 0;
+           }
+           else
+           {
+             previousClose = (float)tableContainingNewAdjustedValues.Rows[i-1]["quAdjustedClose"];
+             currentClose = (float)tableContainingNewAdjustedValues.Rows[i]["quAdjustedClose"];
+             tableContainingNewAdjustedValues.Rows[i][Quotes.AdjustedCloseToCloseRatio] = 
+                                                   (currentClose - previousClose)/previousClose; 
+           }
+         }
+ 
+       }
+       catch(Exception ex)
+       {
+         MessageBox.Show(ex.ToString());
+       }
+ 
+     }             
+ 
+     /// <summary>
+     /// It returns true if the adjustedCloseToCloseRatio computed
+     /// with the adjusted values from the source is not equal to the ratio
+     /// stored in the database 
+     /// </summary>
+     public static bool IsAdjustedCloseToCloseRatioChanged(string ticker,
+                                                           DataTable tableContainingNewAdjustedValues)
+                                                           
+     {
+       bool isAdjustedCloseToCloseRatioChanged = false;
+       try
+       {
+         DataTable adjustedCloseToCloseFromDatabase = 
+           SqlExecutor.GetDataTable("SELECT " + Quotes.Date + ", " +
+                                    Quotes.AdjustedCloseToCloseRatio + " " +
+                                    "FROM quotes WHERE " + Quotes.TickerFieldName + "='" + ticker +
+                                    "' ORDER BY " + Quotes.Date);
+          Quotes.ComputeCloseToCloseValues(tableContainingNewAdjustedValues);
+          isAdjustedCloseToCloseRatioChanged = 
+               Quotes.isAtLeastOneValueChanged(adjustedCloseToCloseFromDatabase, tableContainingNewAdjustedValues);
+       }
+       catch(Exception ex)
+       {
+         string notUsed = ex.ToString();
+         return true;
+       }
+       
+       return isAdjustedCloseToCloseRatioChanged;
+ 
+     }             
+     
+     #endregion
+     
      /// <summary>
      /// returns most liquid tickers with the given features
***************
*** 317,320 ****
--- 506,540 ----
  				followingDays ) );
  		}
+     
+ 
+     /// <summary>
+     /// Provides updating the database with the closeToCloseRatio for
+     /// the given ticker at a specified date
+     /// </summary>
+     public static void UpdateCloseToCloseRatio( string ticker, DateTime date, double closeToCloseRatio )
+     {
+       string sql = "UPDATE quotes SET quotes.quAdjustedCloseToCloseRatio =" +
+                     closeToCloseRatio + " WHERE quotes.quTicker='" + ticker + "' AND " +
+                     "quotes.quDate=" + SQLBuilder.GetDateConstant(date);
+       SqlExecutor.ExecuteNonQuery (sql);
+     }
+ 
+     /* Now useless, maybe ...
+     /// <summary>
+     /// Returns a DataTable containing ticker, date and adjusted value
+     /// for the given group of tickers
+     /// </summary>
+     /// <param name="groupID">group for which the dataTable has to be returned</param>
+     /// <returns></returns>
+     public static DataTable GetTableWithAdjustedValues( string groupID )
+     {
+       string sql = "SELECT quotes.quTicker, quotes.quDate, quotes.quAdjustedClose, " +
+         "tickers_tickerGroups.ttTgId FROM quotes INNER JOIN " + 
+         "tickers_tickerGroups ON quotes.quTicker = tickers_tickerGroups.ttTiId " +
+         "WHERE tickers_tickerGroups.ttTgId='" + groupID + "' " +
+         "ORDER BY quotes.quTicker, quotes.quDate";
+       return SqlExecutor.GetDataTable( sql );
+     }
+     */
  	}
  }

[Quantproject-developers] QuantProject/b2_DataAccess/Tables Tickers_tickerGroups.cs,NONE,1.1

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20107/b2_DataAccess/Tables

Added Files:
	Tickers_tickerGroups.cs 
Log Message:
Added class to access Ticker_tickerGroups table

--- NEW FILE: Tickers_tickerGroups.cs ---
/*
QuantDownloader - Quantitative Finance Library

Tickers_tickerGroups.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.Data;
using System.Windows.Forms;
using QuantProject.DataAccess;


namespace QuantProject.DataAccess.Tables
{
	/// <summary>
	/// Class to access the Tickers_tickerGroups table, where tickers are collected
	/// into groups
	/// </summary>
	public class Tickers_tickerGroups
	{

    // these static fields provide field name in the database table
    // They are intended to be used through intellisense when necessary
    public static string GroupID = "ttTgId";
    public static string Ticker = "ttTiId";

    public Tickers_tickerGroups()
    {
      
    }
    /// <summary>
    /// It provides deletion of the single ticker from the specified group
    /// </summary>
    public static void Delete( string tickerToDelete,
                               string fromGroupID)
    {
      try
      {
        SqlExecutor.ExecuteNonQuery("DELETE * FROM tickers_tickerGroups " +
          "WHERE " + Tickers_tickerGroups.Ticker + "='" +
          tickerToDelete + "' AND " + Tickers_tickerGroups.GroupID + "='" +
          fromGroupID + "'");
      }
      catch(Exception ex)
      {
        MessageBox.Show(ex.ToString());
      }
    }

    /// <summary>
    /// It provides deletion of an entire group of tickers
    /// </summary>
    public static void Delete( string groupToDelete)
    {
      try
      {
        SqlExecutor.ExecuteNonQuery("DELETE * FROM tickers_tickerGroups " +
          "WHERE " + Tickers_tickerGroups.GroupID + "='" +
          groupToDelete + "'");
      }
      catch(Exception ex)
      {
        MessageBox.Show(ex.ToString());
      }
    }
    
    
   
    

   
  }
}

[Quantproject-developers] QuantDownloader QuantDownloader.suo,1.15,1.16

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

Update of /cvsroot/quantproject/QuantDownloader
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16194

Modified Files:
	QuantDownloader.suo 
Log Message:
no message

Index: QuantDownloader.suo
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/QuantDownloader.suo,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
Binary files /tmp/cvslicQ1n and /tmp/cvsuCimqz differ

[Quantproject-developers] QuantDownloader/Downloader Downloader.csproj,1.19,1.20

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15658/Downloader

Modified Files:
	Downloader.csproj 
Log Message:
Minor changes


Index: Downloader.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** Downloader.csproj	8 May 2004 17:33:30 -0000	1.19
--- Downloader.csproj	9 May 2004 16:35:13 -0000	1.20
***************
*** 247,251 ****
                  <File
                      RelPath = "QuotesEditor\VisualValidationChart.cs"
!                     SubType = "Code"
                      BuildAction = "Compile"
                  />
--- 247,251 ----
                  <File
                      RelPath = "QuotesEditor\VisualValidationChart.cs"
!                     SubType = "UserControl"
                      BuildAction = "Compile"
                  />
***************
*** 262,266 ****
                  <File
                      RelPath = "QuotesEditor\CloseToClose\CloseToCloseChart.cs"
!                     SubType = "Code"
                      BuildAction = "Compile"
                  />
--- 262,266 ----
                  <File
                      RelPath = "QuotesEditor\CloseToClose\CloseToCloseChart.cs"
!                     SubType = "UserControl"
                      BuildAction = "Compile"
                  />
***************
*** 271,279 ****
                  />
                  <File
-                     RelPath = "QuotesEditor\CloseToClose\CloseToCloseDataGrid.resx"
-                     DependentUpon = "CloseToCloseDataGrid.cs"
-                     BuildAction = "EmbeddedResource"
-                 />
-                 <File
                      RelPath = "QuotesEditor\CloseToClose\CloseToCloseTabPage.cs"
                      SubType = "Component"
--- 271,274 ----
***************
*** 281,289 ****
                  />
                  <File
-                     RelPath = "QuotesEditor\CloseToClose\CloseToCloseTabPage.resx"
-                     DependentUpon = "CloseToCloseTabPage.cs"
-                     BuildAction = "EmbeddedResource"
-                 />
-                 <File
                      RelPath = "QuotesEditor\OHLC\OHLCdataGrid.cs"
                      SubType = "Component"
--- 276,279 ----
***************
*** 307,311 ****
                  <File
                      RelPath = "QuotesEditor\RangeToRange\RangeToRangeChart.cs"
!                     SubType = "Code"
                      BuildAction = "Compile"
                  />
--- 297,301 ----
                  <File
                      RelPath = "QuotesEditor\RangeToRange\RangeToRangeChart.cs"
!                     SubType = "UserControl"
                      BuildAction = "Compile"
                  />

[Quantproject-developers] QuantDownloader/Downloader/QuotesEditor/CloseToClose CloseToCloseTabPage.cs,1.2,1.3

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15120/Downloader/QuotesEditor/CloseToClose

Modified Files:
	CloseToCloseTabPage.cs 
Log Message:
Now it inherits the VisualValidationTabPage class

Index: CloseToCloseTabPage.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose/CloseToCloseTabPage.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** CloseToCloseTabPage.cs	8 May 2004 17:26:03 -0000	1.2
--- CloseToCloseTabPage.cs	9 May 2004 16:32:30 -0000	1.3
***************
*** 10,86 ****
  	/// Close visual validation controls
  	/// </summary>
! 	public class CloseToCloseTabPage : ValidationGridTabPage
  	{
-     private CloseToCloseDataGrid closeToCloseDataGrid;
-     private CloseToCloseChart closeToCloseChart;
-     private int closeToCloseDataGridWidth = 150;
- //    private ValidateDataTable validateDataTable;
- 
-     private string ticker;
- 
-     public string Ticker
-     {
-       get { return this.ticker; }
-       set { this.ticker = value; }
-     }
- 
  		public CloseToCloseTabPage()
  		{
!       this.Text = "Close To Close";
!       initializeCloseToCloseDataGrid();
!       initializeCloseToCloseChart();
!     }
! 
!     #region initializeCloseToCloseDataGrid
!     private void closeToCloseDataGrid_mouseUp(object sender, MouseEventArgs e)
!     {
!       Console.WriteLine( this.closeToCloseDataGrid[ this.closeToCloseDataGrid.CurrentRowIndex , 0 ] );
!       this.closeToCloseChart.SuspiciousDateTime =
!         (DateTime)this.closeToCloseDataGrid[ this.closeToCloseDataGrid.CurrentRowIndex , 0 ];
!       this.closeToCloseChart.Invalidate();
!     }
!     private void initializeCloseToCloseDataGrid()
!     {
!       this.closeToCloseDataGrid = new CloseToCloseDataGrid();
! 			this.dataGrid = this.closeToCloseDataGrid;
!       this.closeToCloseDataGrid.Location = new Point( 0 , 0 );
!       this.closeToCloseDataGrid.Width = this.closeToCloseDataGridWidth;
!       this.closeToCloseDataGrid.MouseUp +=
!         new MouseEventHandler( this.closeToCloseDataGrid_mouseUp );
!       this.Controls.Add( this.closeToCloseDataGrid );
!     }
!     #endregion
! 
!     private void initializeCloseToCloseChart()
!     {
!       this.closeToCloseChart = new CloseToCloseChart();
!       this.closeToCloseChart.Location = new Point( closeToCloseDataGridWidth + 5 , 0 );
!       this.Controls.Add( this.closeToCloseChart );
!     }
! 
! 
!     protected override void OnPaint(System.Windows.Forms.PaintEventArgs e)
!     {
! 			Console.WriteLine( "CloseToClosePageTab.OnPaint()" );
!       this.closeToCloseDataGrid.DataBind();
! 			if ( this.closeToCloseDataGrid.VisibleRowCount > 0 )
! 			{
! 				this.closeToCloseChart.Ticker = this.ticker;
! 				this.closeToCloseChart.SuspiciousDateTime =
! 					(DateTime)this.closeToCloseDataGrid[ this.closeToCloseDataGrid.CurrentRowIndex , 0 ];
! 				this.closeToCloseDataGrid.Height = this.Height - 10;
! 				this.closeToCloseChart.Width = this.Width - this.closeToCloseDataGridWidth - 5;
! 				this.closeToCloseChart.Height = this.Height - 10;
! 			}
!       base.OnPaint( e );
      }
- 
- 		/// <summary>
- 		/// clears the contained objects
- 		/// </summary>
- 		public void Clear()
- 		{
- 			this.closeToCloseDataGrid.DataSource = null;
- 		}
  	}
  }
--- 10,22 ----
  	/// Close visual validation controls
  	/// </summary>
! 	public class CloseToCloseTabPage : VisualValidationTabPage
  	{
  		public CloseToCloseTabPage()
  		{
! 			this.Text = "Close To Close";
! 			this.VisualValidationDataGrid = new CloseToCloseDataGrid();
! 			this.dataGrid = this.VisualValidationDataGrid;
! 			this.VisualValidationChart = new CloseToCloseChart();
      }
  	}
  }

[Quantproject-developers] QuantDownloader/Downloader/QuotesEditor/CloseToClose CloseToCloseDataGrid.cs,1.4,1.5

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14821/Downloader/QuotesEditor/CloseToClose

Modified Files:
	CloseToCloseDataGrid.cs 
Log Message:
Now it inherits the VisualValidationDataGrid class

Index: CloseToCloseDataGrid.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose/CloseToCloseDataGrid.cs,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** CloseToCloseDataGrid.cs	8 May 2004 17:24:23 -0000	1.4
--- CloseToCloseDataGrid.cs	9 May 2004 16:31:19 -0000	1.5
***************
*** 32,128 ****
  	/// Contains the quotes with suspicious close to close ratio
  	/// </summary>
! 	public class CloseToCloseDataGrid : ValidationDataGrid
  	{
-     private DataView dataView;
- 
-     private bool styleIsDefined = false;
  
  		public CloseToCloseDataGrid()
-     {
-     }
-     #region setStyles
-     private void setStyles_set_DataGridBoolColumn_FalseValueChanged(object sender, EventArgs e)
-     {
-       MessageBox.Show( "Prova" );
-     }
-     private void setStyles_set_DataGridBoolColumn()
-     {
-       DataGridBoolColumn dataGridBoolColumn = new DataGridBoolColumn();
-       dataGridBoolColumn.MappingName = "CloseToCloseHasBeenVisuallyValidated";
-       dataGridBoolColumn.HeaderText = "Ok?";
-       dataGridBoolColumn.Width = 30;
-       dataGridBoolColumn.AllowNull = false;
-       // quiiii!!!!!
- //      dataGridBoolColumn. +=
- //        new System.EventHandler( this.setStyles_set_DataGridBoolColumn_FalseValueChanged );
-       this.TableStyles[ "quotes" ].GridColumnStyles.Add( dataGridBoolColumn );
-       this.styleIsDefined = true;
-     }
-     public void setStyles()
-     {
- //      this.TableStyles.Clear();
-       int i=0;
-       while (i<TableStyles[ "quotes" ].GridColumnStyles.Count)
-       {
-         DataGridColumnStyle dataGridColumnStyle = this.TableStyles[ "quotes" ].GridColumnStyles[i];
-         if ( ( dataGridColumnStyle.HeaderText != "Date" ) &&
-           ( dataGridColumnStyle.HeaderText != "Adj. Close" ) )
-           this.TableStyles[ "quotes" ].GridColumnStyles.Remove( dataGridColumnStyle );
-         else
-           i++;
-       }
-       setStyles_set_DataGridBoolColumn();
-     }
-     #endregion
-     public override void DataBind()
-     {
-       ValidateDataTable validateDataTable = ((QuotesEditor)this.FindForm()).ValidateDataTable;
-       this.dataView = new DataView( validateDataTable );
-       this.dataView.RowFilter = "ValidationWarning=" +
-         Convert.ToInt16( ValidationWarning.SuspiciousCloseToCloseRatio );
-       this.DataSource = dataView;
-       this.dataView.AllowNew = false;
-       this.setStyles();
-     }
- 		private void confirmVisualValidation()
  		{
! 			VisuallyValidatedTickers.ValidateCloseToClose( ((QuotesEditor)this.FindForm()).Ticker );
  		}
-     protected override void OnClick( EventArgs e )
-     {
- 			Console.WriteLine( "CloseToCloseDataGrid.OnClick()" );
-       if (this.TableStyles[0].GridColumnStyles[this.CurrentCell.ColumnNumber] is
-         DataGridBoolColumn)
-       {
-         this[this.CurrentCell] = !System.Convert.ToBoolean(this[this.CurrentCell]);
-         this.Select( true , true );
-       }
-       DataView checkedDataView = new DataView( ((QuotesEditor)this.FindForm()).ValidateDataTable );
-       checkedDataView.RowFilter = "(" + this.dataView.RowFilter +
-         " AND (CloseToCloseHasBeenVisuallyValidated=true))";
-       int checkedItems = 0;
-       for (int rowIndex=0 ; rowIndex<this.dataView.Count ; rowIndex++)
-         if ( (bool)this[ rowIndex , 2] )
-           checkedItems++;
- 			if ( checkedItems == this.dataView.Count )
- 				// all suspicious close to close ratios have been visually validated
- 				if ( MessageBox.Show( this , "You have visually validated all the suspicious " +
- 					"quotes, with respect to the close to close ratio. Do you confirm your " +
- 					"visual validation to be permanentely stored into the database?" ,
- 					"Visual Validation Confirmation" ,
- 					MessageBoxButtons.YesNo ,
- 					MessageBoxIcon.Question ,
- 					MessageBoxDefaultButton.Button1 ) == DialogResult.Yes )
- 					// the user asked to write the visual validation to the database
- 					this.confirmVisualValidation();
-     }
-     protected override void OnPaint( PaintEventArgs e )
-     {
- 			Console.WriteLine( "CloseToCloseDataGrid.OnPaint()" );
-       if ( !this.styleIsDefined )
-         // no style has been defined yet
-         this.DataBind();
-       base.OnPaint( e );
-     }
    }
  }
--- 32,47 ----
  	/// Contains the quotes with suspicious close to close ratio
  	/// </summary>
! 	public class CloseToCloseDataGrid : VisualValidationDataGrid
  	{
  
  		public CloseToCloseDataGrid()
  		{
! 			this.validationWarning = ValidationWarning.SuspiciousCloseToCloseRatio;
! 		}
! 		override protected void confirmVisualValidation( string ticker , DateTime quoteDate )
! 		{
! 			Quotes quotes = new Quotes( ticker );
! 			VisuallyValidatedQuotes.ValidateCloseToClose( quotes , quoteDate );
  		}
    }
  }

[Quantproject-developers] QuantDownloader/Downloader/QuotesEditor/CloseToClose CloseToCloseChart.cs,1.3,1.4

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14599/Downloader/QuotesEditor/CloseToClose

Modified Files:
	CloseToCloseChart.cs 
Log Message:
Now it inherits the VisualValidationChart class

Index: CloseToCloseChart.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose/CloseToCloseChart.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** CloseToCloseChart.cs	28 Mar 2004 20:19:07 -0000	1.3
--- CloseToCloseChart.cs	9 May 2004 16:30:21 -0000	1.4
***************
*** 35,86 ****
  	/// with suspicious Close To Close ratio
  	/// </summary>
! 	public class CloseToCloseChart : Chart
  	{
-     private string ticker;
-     private DateTime suspiciousDateTime;
-     private History history;
-     private DateTime startDateTime;
-     private DateTime endDateTime;
- 
-     public string Ticker
-     {
-       get { return this.ticker; }
-       set { this.ticker = value; }
-     }
-     public DateTime SuspiciousDateTime
-     {
-       get { return this.suspiciousDateTime; }
-       set { this.suspiciousDateTime = value; }
-     }
      public CloseToCloseChart()
  		{
- 			InitializeComponent();
  		}
! 
!     private void InitializeComponent()
!     {
!       this.Name = "CloseToCloseChart";
!     }
! 
!     #region "OnPaint"
!     protected void onPaint_setTimeInterval()
!     {
!       this.startDateTime = (DateTime) this.history.GetKey( Math.Max( 0 ,
!         this.history.IndexOfKeyOrPrevious( this.suspiciousDateTime ) -
! 				ConstantsProvider.PrecedingDaysForVisualValidation ) );
!       this.endDateTime = (DateTime) this.history.GetKey( Math.Min( this.history.Count - 1 ,
!         this.history.IndexOfKeyOrPrevious( this.suspiciousDateTime ) ) +
! 				ConstantsProvider.PrecedingDaysForVisualValidation );
!     }
!     protected override void OnPaint(System.Windows.Forms.PaintEventArgs e)
!     {
!       Console.WriteLine( "CloseToCloseChart.OnPaint()" );
!       this.Clear();
!       this.history = DataProvider.GetCloseHistory( ((QuotesEditor)this.FindForm()).Ticker );
!       this.onPaint_setTimeInterval();
!       this.Add( this.history , Color.Red , this.startDateTime , this.endDateTime );
!       base.OnPaint( e );
!     }
!     #endregion
    }
  }
--- 35,48 ----
  	/// with suspicious Close To Close ratio
  	/// </summary>
! 	public class CloseToCloseChart : VisualValidationChart
  	{
      public CloseToCloseChart()
  		{
  		}
! 		protected override void addHistories()
! 		{
! 			History lowHistory = DataProvider.GetCloseHistory( ((QuotesEditor)this.FindForm()).Ticker );
! 			this.add( lowHistory , Color.Green );
! 		}
    }
  }

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

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14162/Downloader/QuotesEditor

Modified Files:
	VisualValidationChart.cs 
Log Message:
Fixed a bug for the getEndDate method

Index: VisualValidationChart.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/VisualValidationChart.cs,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** VisualValidationChart.cs	28 Mar 2004 21:57:55 -0000	1.3
--- VisualValidationChart.cs	9 May 2004 16:27:52 -0000	1.4
***************
*** 64,69 ****
  				ConstantsProvider.PrecedingDaysForVisualValidation ) );
  			this.endDateTime = (DateTime) history.GetKey( Math.Min( history.Count - 1 ,
! 				history.IndexOfKeyOrPrevious( this.suspiciousDateTime ) ) +
! 				ConstantsProvider.PrecedingDaysForVisualValidation );
  		}
  		protected override void OnPaint(System.Windows.Forms.PaintEventArgs e)
--- 64,69 ----
  				ConstantsProvider.PrecedingDaysForVisualValidation ) );
  			this.endDateTime = (DateTime) history.GetKey( Math.Min( history.Count - 1 ,
! 				history.IndexOfKeyOrPrevious( this.suspiciousDateTime ) +
! 				ConstantsProvider.PrecedingDaysForVisualValidation ) );
  		}
  		protected override void OnPaint(System.Windows.Forms.PaintEventArgs e)

[Quantproject-developers] QuantProject QuantProject.suo,1.29,1.30

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

Update of /cvsroot/quantproject/QuantProject
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13942

Modified Files:
	QuantProject.suo 
Log Message:
Minor changes

Index: QuantProject.suo
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/QuantProject.suo,v
retrieving revision 1.29
retrieving revision 1.30
diff -C2 -d -r1.29 -r1.30
Binary files /tmp/cvsoUkDXo and /tmp/cvsZQhfgS differ

[Quantproject-developers] QuantProject/b3_Data b3_Data.csproj,1.3,1.4

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

Update of /cvsroot/quantproject/QuantProject/b3_Data
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13942/b3_Data

Modified Files:
	b3_Data.csproj 
Log Message:
Minor changes

Index: b3_Data.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b3_Data/b3_Data.csproj,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** b3_Data.csproj	8 May 2004 17:35:42 -0000	1.3
--- b3_Data.csproj	9 May 2004 16:26:27 -0000	1.4
***************
*** 137,140 ****
--- 137,145 ----
                  />
                  <File
+                     RelPath = "DataTables\Quotes.resx"
+                     DependentUpon = "Quotes.cs"
+                     BuildAction = "EmbeddedResource"
+                 />
+                 <File
                      RelPath = "DataTables\TickerDataTable.cs"
                      SubType = "Component"
***************
*** 147,150 ****
--- 152,160 ----
                  />
                  <File
+                     RelPath = "DataTables\ValidatedTickers.resx"
+                     DependentUpon = "ValidatedTickers.cs"
+                     BuildAction = "EmbeddedResource"
+                 />
+                 <File
                      RelPath = "Selectors\ITickerReceiver.cs"
                      SubType = "Code"

[Quantproject-developers] QuantProject/b2_DataAccess/Tables VisuallyValidatedQuotes.cs,1.2,1.3

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

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13853/b2_DataAccess/Tables

Modified Files:
	VisuallyValidatedQuotes.cs 
Log Message:
- added properties for field names
- the ValidateCloseToClose method has been added
- the ValidateRangeToRange method has been rewritten
- the GetCloseToCloseValidated method has been added
- the GetRangeToRangeValidated method has been fixed

Index: VisuallyValidatedQuotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/VisuallyValidatedQuotes.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** VisuallyValidatedQuotes.cs	1 Apr 2004 15:43:02 -0000	1.2
--- VisuallyValidatedQuotes.cs	9 May 2004 16:25:57 -0000	1.3
***************
*** 12,15 ****
--- 12,21 ----
  	public class VisuallyValidatedQuotes
  	{
+ 		public static string Ticker = "vvTicker";
+ 		public static string Date = "vvDate";
+ 		public static string ValidationType = "vvValidationType";
+ 		public static string HashValue = "vvHashValue";
+ 		public static string EditDate = "vvEditDate";
+ 
  		public VisuallyValidatedQuotes()
  		{
***************
*** 18,23 ****
  			//
  		}
- 
- 
  		/// <summary>
  		/// Returns the hash value to be stored/read into/from the visuallyValidatedQuotes table
--- 24,27 ----
***************
*** 32,41 ****
  		}
  
! 		/// <summary>
! 		/// writes to the database the visual validation of the Close to Close suspicious ratios
! 		/// </summary>
! 		/// <param name="quotes">contains all the quotes for the ticker to be validated</param>
! 		/// <param name="quoteDate">date to be validated</param>
! 		public static void ValidateRangeToRange( Quotes quotes , DateTime quoteDate )
  		{
  			try
--- 36,40 ----
  		}
  
! 		private static void validate( Quotes quotes , DateTime quoteDate , ValidationTypes validationType )
  		{
  			try
***************
*** 50,59 ****
  				string hashValue = getHashValue( quotes , quoteDate );
  				oleDbSingleTableAdapter.DataTable.Rows.Add(	oleDbSingleTableAdapter.DataTable.NewRow() );
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvTicker" ] = quotes.Ticker;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvDate" ] = quoteDate;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvValidationType" ] =
! 					ValidationTypes.RangeToRangeRatio;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] = hashValue;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEditDate" ] = DateTime.Now;
  				oleDbSingleTableAdapter.OleDbDataAdapter.Update( oleDbSingleTableAdapter.DataTable );
  			}
--- 49,58 ----
  				string hashValue = getHashValue( quotes , quoteDate );
  				oleDbSingleTableAdapter.DataTable.Rows.Add(	oleDbSingleTableAdapter.DataTable.NewRow() );
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ VisuallyValidatedQuotes.Ticker ] = quotes.Ticker;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ VisuallyValidatedQuotes.Date ] = quoteDate;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ VisuallyValidatedQuotes.ValidationType ] =
! 					validationType;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ VisuallyValidatedQuotes.HashValue ] = hashValue;
! 				oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ VisuallyValidatedQuotes.EditDate ] = DateTime.Now;
  				oleDbSingleTableAdapter.OleDbDataAdapter.Update( oleDbSingleTableAdapter.DataTable );
  			}
***************
*** 66,86 ****
  
  		/// <summary>
! 		/// Returns the list of validated quote dates for the given ticker
  		/// </summary>
! 		/// <param name="ticker">Instrument ticker whose validated quote dates are to be found</param>
! 		/// <returns></returns>
! 		public static ArrayList GetRangeToRangeValidated( string ticker )
  		{
  			ArrayList tickers = new ArrayList();
  			Quotes quotes = new Quotes( ticker );
! 			DataTable validatedQuotes =
! 				SqlExecutor.GetDataTable( "select * from visuallyValidatedQuotes where vvTicker='" + ticker + "'" );
  			foreach ( DataRow dataRow in validatedQuotes.Rows )
  				if ( (string)dataRow[ "vvHashValue" ] == getHashValue( quotes , (DateTime)dataRow[ "vvDate" ] ) )
  					// the current quote date had been visually validated with respect to the neighborhood quotes
  					tickers.Add( dataRow[ "vvDate" ] );
! 				/// TO DO !!! add else branch to raise event 'broken hash value'
  			return tickers;
  		}
  	}
  }
--- 65,124 ----
  
  		/// <summary>
! 		/// writes to the database the visual validation of the Close to Close suspicious ratios
  		/// </summary>
! 		/// <param name="quotes">contains all the quotes for the ticker to be validated</param>
! 		/// <param name="quoteDate">date to be validated</param>
! 		public static void ValidateCloseToClose( Quotes quotes , DateTime quoteDate )
! 		{
! 			validate( quotes , quoteDate , ValidationTypes.CloseToCloseRatio );
! 		}
! 
! 		/// <summary>
! 		/// writes to the database the visual validation of the Range to Range suspicious ratios
! 		/// </summary>
! 		/// <param name="quotes">contains all the quotes for the ticker to be validated</param>
! 		/// <param name="quoteDate">date to be validated</param>
! 		public static void ValidateRangeToRange( Quotes quotes , DateTime quoteDate )
! 		{
! 			validate( quotes , quoteDate , ValidationTypes.RangeToRangeRatio );
! 		}
! 
! 		private static ArrayList getVisuallyValidatedArrayList(
! 			string ticker , ValidationTypes validationType )
  		{
  			ArrayList tickers = new ArrayList();
  			Quotes quotes = new Quotes( ticker );
! 			DataTable validatedQuotes =	SqlExecutor.GetDataTable(
! 				"select * from visuallyValidatedQuotes " +
! 				"where " + VisuallyValidatedQuotes.Ticker + "='" + ticker + "'" +
! 				"and " + VisuallyValidatedQuotes.ValidationType + "=" +
! 				System.Convert.ToInt32( validationType ) );
  			foreach ( DataRow dataRow in validatedQuotes.Rows )
  				if ( (string)dataRow[ "vvHashValue" ] == getHashValue( quotes , (DateTime)dataRow[ "vvDate" ] ) )
  					// the current quote date had been visually validated with respect to the neighborhood quotes
  					tickers.Add( dataRow[ "vvDate" ] );
! 			/// TO DO !!! add else branch to raise event 'broken hash value'
  			return tickers;
  		}
+ 		/// <summary>
+ 		/// Returns the list of visually validated quote dates for the given ticker,
+ 		/// with respect to the Close To Close ratio
+ 		/// </summary>
+ 		/// <param name="ticker">Instrument ticker whose validated quote dates are to be found</param>
+ 		/// <returns></returns>
+ 		public static ArrayList GetCloseToCloseValidated( string ticker )
+ 		{
+ 			return getVisuallyValidatedArrayList( ticker , ValidationTypes.CloseToCloseRatio );
+ 		}
+ 		/// <summary>
+ 		/// Returns the list of visually validated quote dates for the given ticker,
+ 		/// with respect to the Range To Range ratio
+ 		/// </summary>
+ 		/// <param name="ticker">Instrument ticker whose validated quote dates are to be found</param>
+ 		/// <returns></returns>
+ 		public static ArrayList GetRangeToRangeValidated( string ticker )
+ 		{
+ 			return getVisuallyValidatedArrayList( ticker , ValidationTypes.RangeToRangeRatio );
+ 		}
  	}
  }

[Quantproject-developers] QuantProject/b4_Business/a0_Validation ValidateDataTable.cs,1.2,1.3

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

Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13105/b4_Business/a0_Validation

Modified Files:
	ValidateDataTable.cs 
Log Message:
Old (remarked) code has been removed

Index: ValidateDataTable.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/ValidateDataTable.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** ValidateDataTable.cs	8 May 2004 17:21:50 -0000	1.2
--- ValidateDataTable.cs	9 May 2004 16:21:18 -0000	1.3
***************
*** 23,48 ****
  		public ValidateDataTable()
  		{
- 			//<<<<<<< ValidateDataTable.cs
- 			//      this.selectStatement =
- 			//        "select * from quotes where 1=2";
- 			//      this.oleDbDataAdapter =
- 			//        new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection );
- 			//      this.oleDbCommandBuilder = new OleDbCommandBuilder( oleDbDataAdapter );
- 			//      this.oleDbDataAdapter.UpdateCommand = this.oleDbCommandBuilder.GetUpdateCommand();
- 			//      this.oleDbDataAdapter.Fill( this );
- 			//      this.Columns.Add( new DataColumn( "CloseToCloseHasBeenVisuallyValidated" ,
- 			//        System.Type.GetType( "System.Boolean" ) ) );
- 			//
- 			//      this.TableName = "quotes";
- 			////<<<<<<< ValidateDataTable.cs
- 			//      this.Columns.Add( "ValidationWarning" ,
- 			//        ValidationWarning.OpenHighLowCloseLogicalInconsistency.GetType() );
-       
- 			//=======
- 			//      
- 			//>>>>>>> 1.6
- 			//=======
  			initializeValidateDataTable();
- 			//>>>>>>> 1.8
  		}
  
--- 23,27 ----

[Quantproject-developers] QuantProject/b4_Business/a0_Validation/Validators CloseToCloseValidator.cs,1.2,1.3

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

Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12646/b4_Business/a0_Validation/Validators

Modified Files:
	CloseToCloseValidator.cs 
Log Message:
Now quotes already visually validated are not suspicious anymore

Index: CloseToCloseValidator.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators/CloseToCloseValidator.cs,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** CloseToCloseValidator.cs	8 May 2004 17:05:55 -0000	1.2
--- CloseToCloseValidator.cs	9 May 2004 16:19:02 -0000	1.3
***************
*** 1,3 ****
! using System;  
  using System.Data;
  using QuantProject.ADT;
--- 1,4 ----
! using System;
! using System.Collections;
  using System.Data;
  using QuantProject.ADT;
***************
*** 14,17 ****
--- 15,20 ----
    {
      private DataTable dataTableToBeValidated;
+ 		private ArrayList closeToCloseVisuallyValidated;
+ 
  
      public CloseToCloseValidator()
***************
*** 47,51 ****
        DataRow quoteRow , double currentValue , double averageValue )
      {
!       if ( Math.Abs( currentValue / averageValue ) > ConstantsProvider.SuspiciousRatio )
          // the current close to close value is suspiciously larger
          // than the average close to close ratio
--- 50,55 ----
        DataRow quoteRow , double currentValue , double averageValue )
      {
! 			if ( Math.Abs( currentValue / averageValue ) > ConstantsProvider.SuspiciousRatio &&
! 				( this.closeToCloseVisuallyValidated.IndexOf( quoteRow[ "quDate" ] ) < 0 ) )
          // the current close to close value is suspiciously larger
          // than the average close to close ratio
***************
*** 78,82 ****
      private int validate_currentTicker( string currentTicker , int currentTickerStartingRowIndex )
      {
!       History closeToClose = new History();
        History closeToCloseMovingAverage;
        int nextTickerStartingRowIndex =
--- 82,88 ----
      private int validate_currentTicker( string currentTicker , int currentTickerStartingRowIndex )
      {
! 			this.closeToCloseVisuallyValidated =
! 				QuantProject.DataAccess.Tables.VisuallyValidatedQuotes.GetCloseToCloseValidated( currentTicker );
! 			History closeToClose = new History();
        History closeToCloseMovingAverage;
        int nextTickerStartingRowIndex =

[Quantproject-developers] QuantProject/b3_Data/DataTables ValidatedTickers.cs,NONE,1.1

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

Update of /cvsroot/quantproject/QuantProject/b3_Data/DataTables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14678/DataTables

Added Files:
	ValidatedTickers.cs 
Log Message:
DataTable for validatedTickers table data

--- NEW FILE: ValidatedTickers.cs ---
using System;
using System.Data;
using QuantProject.DataAccess.Tables;

namespace QuantProject.Data.DataTables
{
	/// <summary>
	/// DataTable for validatedTickers table data
	/// </summary>
	public class ValidatedTickers : DataTable
	{
		public static string Ticker = QuantProject.DataAccess.Tables.ValidatedTickers.Ticker;
		public static string StartDate = QuantProject.DataAccess.Tables.ValidatedTickers.StartDate;
		public static string EndDate = QuantProject.DataAccess.Tables.ValidatedTickers.EndDate;
		public static string HashValue = QuantProject.DataAccess.Tables.ValidatedTickers.HashValue;
		public static string EditDate = QuantProject.DataAccess.Tables.ValidatedTickers.EditDate;

		public ValidatedTickers( string ticker )
		{
			QuantProject.DataAccess.Tables.ValidatedTickers.SetDataTable( ticker , this );
		}
	}
}

[Quantproject-developers] QuantProject/b3_Data/DataTables Quotes.cs,NONE,1.1

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

Update of /cvsroot/quantproject/QuantProject/b3_Data/DataTables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14565/DataTables

Added Files:
	Quotes.cs 
Log Message:
DataTable for quotes table data

--- NEW FILE: Quotes.cs ---
using System;
using System.Data;
using QuantProject.DataAccess.Tables;

namespace QuantProject.Data.DataTables
{
	/// <summary>
	/// DataTable for quotes table data
	/// </summary>
	public class Quotes : DataTable
	{
		private void fillDataTable( string ticker , DateTime startDate , DateTime endDate )
		{
			QuantProject.DataAccess.Tables.Quotes.SetDataTable( 
				ticker , startDate , endDate , this );
		}
		public Quotes( string ticker , DateTime startDate , DateTime endDate )
		{
			this.fillDataTable( ticker , startDate , endDate );
		}
		public Quotes( string ticker )
		{
			this.fillDataTable( 
				ticker ,
				QuantProject.DataAccess.Tables.Quotes.GetStartDate( ticker ) ,
				QuantProject.DataAccess.Tables.Quotes.GetEndDate( ticker ) );
		}
	}
}

[Quantproject-developers] QuantProject/b5_Presentation b5_Presentation.csproj,1.2,1.3

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

Update of /cvsroot/quantproject/QuantProject/b5_Presentation
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10771/b5_Presentation

Modified Files:
	b5_Presentation.csproj 
Log Message:
The QuotesToBeValidated class has been removed

Index: b5_Presentation.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b5_Presentation/b5_Presentation.csproj,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** b5_Presentation.csproj	25 Jan 2004 15:53:08 -0000	1.2
--- b5_Presentation.csproj	8 May 2004 17:37:41 -0000	1.3
***************
*** 108,116 ****
                  />
                  <Reference
-                     Name = "scpl"
-                     AssemblyName = "scpl"
-                     HintPath = "..\..\lib\scpl.dll"
-                 />
-                 <Reference
                      Name = "b1_ADT"
                      Project = "{B8A01161-3698-4591-B1EF-90F5FC7D8DBA}"
--- 108,111 ----
***************
*** 122,125 ****
--- 117,125 ----
                      HintPath = "..\..\..\..\..\..\WINDOWS\Microsoft.NET\Framework\v1.0.3705\System.Drawing.dll"
                  />
+                 <Reference
+                     Name = "scpl"
+                     AssemblyName = "scpl"
+                     HintPath = "..\..\..\..\My Documents\nostri\GLAUCO\bin\scpl.dll"
+                 />
              </References>
          </Build>

[Quantproject-developers] QuantProject QuantProject.suo,1.28,1.29

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

Update of /cvsroot/quantproject/QuantProject
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10771

Modified Files:
	QuantProject.suo 
Log Message:
The QuotesToBeValidated class has been removed

Index: QuantProject.suo
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/QuantProject.suo,v
retrieving revision 1.28
retrieving revision 1.29
diff -C2 -d -r1.28 -r1.29
Binary files /tmp/cvs9cKB52 and /tmp/cvsceTY9Q differ

[Quantproject-developers] QuantProject/b4_Business b4_Business.csproj,1.8,1.9

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

Update of /cvsroot/quantproject/QuantProject/b4_Business
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10621/b4_Business

Modified Files:
	b4_Business.csproj 
Log Message:
The QuotesToBeValidated class has been removed

Index: b4_Business.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b4_Business/b4_Business.csproj,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** b4_Business.csproj	26 Apr 2004 15:54:04 -0000	1.8
--- b4_Business.csproj	8 May 2004 17:36:59 -0000	1.9
***************
*** 137,145 ****
                  />
                  <File
-                     RelPath = "a0_Validation\QuotesToBeValidated.cs"
-                     SubType = "Component"
-                     BuildAction = "Compile"
-                 />
-                 <File
                      RelPath = "a0_Validation\SospiciousDataRowEventArgs.cs"
                      SubType = "Code"
--- 137,140 ----

[Quantproject-developers] QuantProject/b3_Data b3_Data.csproj,1.2,1.3

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

Update of /cvsroot/quantproject/QuantProject/b3_Data
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10342/b3_Data

Modified Files:
	b3_Data.csproj 
Log Message:
The following classes (of DataTable type) have been added:
- Quotes
- ValidatedTickers

Index: b3_Data.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b3_Data/b3_Data.csproj,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** b3_Data.csproj	25 Apr 2004 17:36:20 -0000	1.2
--- b3_Data.csproj	8 May 2004 17:35:42 -0000	1.3
***************
*** 132,135 ****
--- 132,140 ----
                  />
                  <File
+                     RelPath = "DataTables\Quotes.cs"
+                     SubType = "Component"
+                     BuildAction = "Compile"
+                 />
+                 <File
                      RelPath = "DataTables\TickerDataTable.cs"
                      SubType = "Component"
***************
*** 137,140 ****
--- 142,150 ----
                  />
                  <File
+                     RelPath = "DataTables\ValidatedTickers.cs"
+                     SubType = "Component"
+                     BuildAction = "Compile"
+                 />
+                 <File
                      RelPath = "Selectors\ITickerReceiver.cs"
                      SubType = "Code"

[Quantproject-developers] QuantDownloader QuantDownloader.suo,1.14,1.15

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

Update of /cvsroot/quantproject/QuantDownloader
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9871

Modified Files:
	QuantDownloader.suo 
Log Message:
no message

Index: QuantDownloader.suo
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/QuantDownloader.suo,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
Binary files /tmp/cvsOvg5oe and /tmp/cvsvvcmIb differ

[Quantproject-developers] QuantDownloader/Downloader Downloader.csproj,1.18,1.19

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9830/Downloader

Modified Files:
	Downloader.csproj 
Log Message:
Minor changes

Index: Downloader.csproj
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** Downloader.csproj	26 Apr 2004 15:51:48 -0000	1.18
--- Downloader.csproj	8 May 2004 17:33:30 -0000	1.19
***************
*** 207,211 ****
                  <File
                      RelPath = "QuotesEditor\QuotesChart.cs"
!                     SubType = "UserControl"
                      BuildAction = "Compile"
                  />
--- 207,211 ----
                  <File
                      RelPath = "QuotesEditor\QuotesChart.cs"
!                     SubType = "Code"
                      BuildAction = "Compile"
                  />
***************
*** 262,266 ****
                  <File
                      RelPath = "QuotesEditor\CloseToClose\CloseToCloseChart.cs"
!                     SubType = "UserControl"
                      BuildAction = "Compile"
                  />
--- 262,266 ----
                  <File
                      RelPath = "QuotesEditor\CloseToClose\CloseToCloseChart.cs"
!                     SubType = "Code"
                      BuildAction = "Compile"
                  />

[Quantproject-developers] QuantDownloader/Downloader/QuotesEditor QuotesEditor.cs,1.6,1.7

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

Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9425/Downloader/QuotesEditor

Modified Files:
	QuotesEditor.cs 
Log Message:
Now the ConstantsProvider is used to provide the SuspiciousRatio constant

Index: QuotesEditor.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/QuotesEditor.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** QuotesEditor.cs	26 Apr 2004 15:48:04 -0000	1.6
--- QuotesEditor.cs	8 May 2004 17:31:39 -0000	1.7
***************
*** 10,14 ****
  using QuantProject.Business.Validation;
  using QuantProject.Data;
- using QuantProject.Applications.Downloader.Validate;
  
  namespace QuantProject.Applications.Downloader
--- 10,13 ----
***************
*** 51,56 ****
  			this.validateDataTable.Rows.Clear();
  //			this.validateDataTable.Clear();
! 			this.validateDataTable.AddRows( this.textBoxTicker.Text ,
! 				ConstantsProvider.SuspiciousRatio );
  		}
  
--- 50,54 ----
  			this.validateDataTable.Rows.Clear();
  //			this.validateDataTable.Clear();
! 			this.validateDataTable.AddRows( this.textBoxTicker.Text );
  		}
  
***************
*** 78,81 ****
--- 76,81 ----
  			InitializeComponent();
  
+ 			this.textBoxTicker.Text = ticker;
+ 
  			this.addQuotesChart();
  
***************
*** 87,91 ****
  			this.tabControl1.Controls.Add( this.validationTabPage );
  
- 			this.textBoxTicker.Text = ticker;
  		}
  
--- 87,90 ----
***************
*** 211,215 ****
  		{
  			this.validateDataTable.Rows.Clear();
! 			this.validateDataTable.AddRows( this.textBoxTicker.Text , ConstantsProvider.SuspiciousRatio );
  			//      this.openHighLowCloseUserControl.ValidateDataTable = this.validateDataTable;
  			//      this.closeToCloseUserControl.Ticker = this.textBoxTicker.Text;
--- 210,214 ----
  		{
  			this.validateDataTable.Rows.Clear();
! 			this.validateDataTable.AddRows( this.textBoxTicker.Text );
  			//      this.openHighLowCloseUserControl.ValidateDataTable = this.validateDataTable;
  			//      this.closeToCloseUserControl.Ticker = this.textBoxTicker.Text;
***************
*** 242,246 ****
  		{
  			this.validateDataTable.Rows.Clear();
! 			this.validateDataTable.AddRows( this.textBoxTicker.Text , ConstantsProvider.SuspiciousRatio );
  			//      this.openHighLowCloseUserControl.ValidateDataTable = this.validateDataTable;
  			//      this.closeToCloseUserControl.Ticker = this.textBoxTicker.Text;
--- 241,245 ----
  		{
  			this.validateDataTable.Rows.Clear();
! 			this.validateDataTable.AddRows( this.textBoxTicker.Text );
  			//      this.openHighLowCloseUserControl.ValidateDataTable = this.validateDataTable;
  			//      this.closeToCloseUserControl.Ticker = this.textBoxTicker.Text;