[Quantproject-developers] QuantProject/b3_Data/DataTables Quotes.cs,1.12,1.13

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

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

Modified Files:
	Quotes.cs 
Log Message:
Added new methods used by SelectorByAverageRawOpenPrice object.
Some work has to be done yet ...

Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b3_Data/DataTables/Quotes.cs,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** Quotes.cs	4 Feb 2005 00:12:25 -0000	1.12
--- Quotes.cs	23 Mar 2005 21:28:46 -0000	1.13
***************
*** 286,291 ****
--- 286,331 ----
      }
  
+     /// <summary>
+     /// returns tickers with the average raw open price
+     /// belonging to the specified range within the given set of tickers
+     /// </summary>
  
+     public static DataTable GetTickersByAverageRawOpenPrice( bool orderByASC,
+                                                   DataTable setOfTickers,
+                                                   DateTime firstQuoteDate,
+                                                   DateTime lastQuoteDate,
+                                                   long maxNumOfReturnedTickers,
+                                                   double minPrice, double maxPrice)
+     {
+       if(!setOfTickers.Columns.Contains("AverageRawOpenPrice"))
+         setOfTickers.Columns.Add("AverageRawOpenPrice", System.Type.GetType("System.Double"));
+       if(!setOfTickers.Columns.Contains("RawOpenPriceStdDev"))
+       	setOfTickers.Columns.Add("RawOpenPriceStdDev",System.Type.GetType("System.Double"));
+       foreach(DataRow row in setOfTickers.Rows)
+       {
+         row["AverageRawOpenPrice"] = 
+             QuantProject.DataAccess.Tables.Quotes.GetAverageRawOpenPrice((string)row[0],
+                                                                         firstQuoteDate,
+                                                                         lastQuoteDate);
+         row["RawOpenPriceStdDev"] = 
+             QuantProject.DataAccess.Tables.Quotes.GetRawOpenPriceStdDeviation((string)row[0],
+                                                                         firstQuoteDate,
+                                                                         lastQuoteDate);
+       }
+       getTickersByAverageRawOpenPrice_deleteRows(setOfTickers);
+       DataTable returnValue = ExtendedDataTable.CopyAndSort(setOfTickers,"AverageRawOpenPrice", orderByASC);
+       ExtendedDataTable.DeleteRows(returnValue, maxNumOfReturnedTickers);
+       return returnValue;
+     }
  
+ 	private static void getTickersByAverageRawOpenPrice_deleteRows( DataTable tempTicker)
+     {
+       int numRows = tempTicker.Rows.Count;
+       for(int i = 0; i<numRows; i++)
+       {
+       	;
+       	///TODO:
+       }
+     }
  		private History history;