[Quantproject-developers] QuantProject/b2_DataAccess/Tables VisuallyValidatedTickers.cs,1.1,1.2
Brought to you by:
glauco_1
|
From: Glauco S. <gla...@us...> - 2004-03-28 19:56:45
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22134/b2_DataAccess/Tables Modified Files: VisuallyValidatedTickers.cs Log Message: Updated, but it is going to be removed, because the visuallyValidatedTickers table has been removed from the database Index: VisuallyValidatedTickers.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/VisuallyValidatedTickers.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** VisuallyValidatedTickers.cs 21 Mar 2004 16:09:38 -0000 1.1 --- VisuallyValidatedTickers.cs 28 Mar 2004 19:45:23 -0000 1.2 *************** *** 1,4 **** --- 1,5 ---- using System; using System.Data; + using QuantProject.ADT; using QuantProject.DataAccess; *************** *** 31,37 **** try { OleDbSingleTableAdapter oleDbSingleTableAdapter = new OleDbSingleTableAdapter( "select * from visuallyValidatedTickers where vvTicker='" + ticker + "'" ); ! string hashValue = Quotes.GetHashValue( ticker ); if ( oleDbSingleTableAdapter.DataTable.Rows.Count == 0 ) // this ticker was not visually validated yet --- 32,39 ---- try { + Quotes quotes = new Quotes( ticker ); OleDbSingleTableAdapter oleDbSingleTableAdapter = new OleDbSingleTableAdapter( "select * from visuallyValidatedTickers where vvTicker='" + ticker + "'" ); ! string hashValue = quotes.GetHashValue(); if ( oleDbSingleTableAdapter.DataTable.Rows.Count == 0 ) // this ticker was not visually validated yet *************** *** 41,47 **** ( (string)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] != hashValue ) ) // this ticker was visually already validated, but with different values ! oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvRangeToRangeRatio" ] = true; oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvTicker" ] = ticker; ! oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvStartDate" ] = Quotes.GetStartDate( ticker ); oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] = --- 43,49 ---- ( (string)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] != hashValue ) ) // this ticker was visually already validated, but with different values ! oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvRangeToRangeRatio" ] = false; oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvTicker" ] = ticker; ! oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvStartDate" ] = Quotes.GetStartDate( ticker ); oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] = *************** *** 57,60 **** --- 59,101 ---- } } + /// <summary> + /// Writes to the database the visual validation of the Range to Range suspicious ratios + /// </summary> + /// <param name="ticker">ticker to be validated</param> + /// <param name="ticker">quoteDate to be validated</param> + public static void ValidateRangeToRange( string ticker , DateTime quoteDate) + { + try + { + Quotes quotes = new Quotes( ticker ); + OleDbSingleTableAdapter oleDbSingleTableAdapter = + new OleDbSingleTableAdapter( "select * from visuallyValidatedTickers where vvTicker='" + + ticker + "'" ); + string hashValue = quotes.GetHashValue( + quotes.GetPrecedingDate( quoteDate , ConstantsProvider.PrecedingDaysForVisualValidation ) , + quotes.GetFollowingDate( quoteDate , ConstantsProvider.PrecedingDaysForVisualValidation ) ); + if ( oleDbSingleTableAdapter.DataTable.Rows.Count == 0 ) + // this ticker was not visually validated yet + oleDbSingleTableAdapter.DataTable.Rows.Add( oleDbSingleTableAdapter.DataTable.NewRow() ); + else if ( ( (DateTime)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] != Quotes.GetEndDate( ticker ) ) || + ( (DateTime)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] != Quotes.GetEndDate( ticker ) ) || + ( (string)oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] != hashValue ) ) + // this ticker was visually already validated, but with different values + oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvCloseToCloseRatio" ] = false; + oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvTicker" ] = ticker; + oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvStartDate" ] = + Quotes.GetStartDate( ticker ); + oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvEndDate" ] = + Quotes.GetEndDate( ticker ); + oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvHashValue" ] = hashValue; + oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ "vvRangeToRangeRatio" ] = true; + oleDbSingleTableAdapter.OleDbDataAdapter.Update( oleDbSingleTableAdapter.DataTable ); + } + catch ( Exception ex ) + { + string exceptionMessage = ex.Message + "\n" + ex.StackTrace; + Console.WriteLine( exceptionMessage ); + } + } } } |