Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1539/b2_DataAccess/Tables
Modified Files:
Quotes.cs
Log Message:
GetTickersByOpenToCloseWinningDays has been moved to Quotes class in data layer.
Added new parameter to the method.
Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.26
retrieving revision 1.27
diff -C2 -d -r1.26 -r1.27
*** Quotes.cs 2 Jun 2005 18:06:17 -0000 1.26
--- Quotes.cs 18 Sep 2005 21:03:43 -0000 1.27
***************
*** 590,598 ****
return SqlExecutor.GetDataTable( sql );
}
!
/// <summary>
/// returns tickers counting how many times raw close is greater than raw open
/// for the given interval of days (within the given group of tickers).
! /// Tickers are ordered by the number of days raw open is greater than raw close
/// </summary>
public static DataTable GetTickersByOpenToCloseWinningDays( bool orderInASCMode, string groupID,
--- 590,598 ----
return SqlExecutor.GetDataTable( sql );
}
! /*moved to Quotes inside data layer
/// <summary>
/// returns tickers counting how many times raw close is greater than raw open
/// for the given interval of days (within the given group of tickers).
! /// Tickers are ordered by the number of days raw open is greater than raw close
/// </summary>
public static DataTable GetTickersByOpenToCloseWinningDays( bool orderInASCMode, string groupID,
***************
*** 601,604 ****
--- 601,605 ----
long maxNumOfReturnedTickers)
{
+
string sql = "SELECT TOP " + maxNumOfReturnedTickers + " quotes.quTicker, tickers.tiCompanyName, " +
"Count(quotes.quClose) AS CloseToOpenWinningDays " +
***************
*** 617,621 ****
return SqlExecutor.GetDataTable( sql );
}
!
/// <summary>
/// returns the average traded value for the given ticker in the specified interval
--- 618,622 ----
return SqlExecutor.GetDataTable( sql );
}
! */
/// <summary>
/// returns the average traded value for the given ticker in the specified interval
***************
*** 811,815 ****
DataTable dt;
int returnValue = 0;
! string sql = "SELECT Count(quotes.quClose) AS CloseToOpenWinningDays " +
"FROM quotes WHERE " +
"quotes.quDate Between " + SQLBuilder.GetDateConstant(firstQuoteDate) + " " +
--- 812,816 ----
DataTable dt;
int returnValue = 0;
! string sql = "SELECT Count(*) AS CloseToOpenWinningDays " +
"FROM quotes WHERE " +
"quotes.quDate Between " + SQLBuilder.GetDateConstant(firstQuoteDate) + " " +
|
