quantproject-developers Mailing List for QuantProject (Page 138)
Brought to you by:
glauco_1
Menu
▾
▴
quantproject-developers
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(7) |
Nov
(103) |
Dec
(67) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(52) |
Feb
(9) |
Mar
(69) |
Apr
(53) |
May
(80) |
Jun
(23) |
Jul
(24) |
Aug
(112) |
Sep
(9) |
Oct
|
Nov
(58) |
Dec
(93) |
| 2005 |
Jan
(90) |
Feb
(93) |
Mar
(61) |
Apr
(56) |
May
(37) |
Jun
(61) |
Jul
(55) |
Aug
(68) |
Sep
(25) |
Oct
(46) |
Nov
(41) |
Dec
(37) |
| 2006 |
Jan
(33) |
Feb
(7) |
Mar
(19) |
Apr
(27) |
May
(73) |
Jun
(49) |
Jul
(83) |
Aug
(66) |
Sep
(45) |
Oct
(16) |
Nov
(15) |
Dec
(7) |
| 2007 |
Jan
(14) |
Feb
(33) |
Mar
|
Apr
(21) |
May
|
Jun
(34) |
Jul
(18) |
Aug
(100) |
Sep
(39) |
Oct
(55) |
Nov
(12) |
Dec
(2) |
| 2008 |
Jan
(120) |
Feb
(133) |
Mar
(129) |
Apr
(104) |
May
(42) |
Jun
(2) |
Jul
(52) |
Aug
(99) |
Sep
(134) |
Oct
|
Nov
(137) |
Dec
(48) |
| 2009 |
Jan
(48) |
Feb
(55) |
Mar
(61) |
Apr
(3) |
May
(2) |
Jun
(1) |
Jul
|
Aug
(51) |
Sep
|
Oct
(7) |
Nov
|
Dec
|
| 2010 |
Jan
(7) |
Feb
(1) |
Mar
(145) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(8) |
Dec
|
| 2011 |
Jan
(78) |
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(88) |
Sep
(6) |
Oct
(1) |
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
(1) |
Mar
|
Apr
(6) |
May
(5) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(2) |
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Glauco S. <gla...@us...> - 2004-04-29 12:12:45
|
Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11338/Validators Log Message: Directory /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators added to the repository |
|
From: Glauco S. <gla...@us...> - 2004-04-29 12:11:39
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate/Validators In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11205/b4_Business/a0_Validation/Validators Modified Files: CloseToCloseValidator.cs Log Message: Force commit again Index: CloseToCloseValidator.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/Validators/CloseToCloseValidator.cs,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** CloseToCloseValidator.cs 26 Apr 2004 15:38:54 -0000 1.3 --- CloseToCloseValidator.cs 29 Apr 2004 12:11:31 -0000 1.4 *************** *** 1,3 **** ! using System; using System.Data; using QuantProject.ADT.Histories; --- 1,3 ---- ! using System; using System.Data; using QuantProject.ADT.Histories; |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:57:49
|
Update of /cvsroot/quantproject/QuantProject In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11331 Modified Files: QuantProject.suo Log Message: Validation has been moved from the QuantDownloader project to the QuantProject project Index: QuantProject.suo =================================================================== RCS file: /cvsroot/quantproject/QuantProject/QuantProject.suo,v retrieving revision 1.27 retrieving revision 1.28 diff -C2 -d -r1.27 -r1.28 Binary files /tmp/cvs0OpYrU and /tmp/cvsxdDLlm differ |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:54:13
|
Update of /cvsroot/quantproject/QuantProject/b4_Business In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10723/b4_Business Modified Files: b4_Business.csproj Log Message: Validation has been moved from the QuantDownloader project to the QuantProject project Index: b4_Business.csproj =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b4_Business/b4_Business.csproj,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** b4_Business.csproj 24 Nov 2003 19:51:35 -0000 1.7 --- b4_Business.csproj 26 Apr 2004 15:54:04 -0000 1.8 *************** *** 117,120 **** --- 117,125 ---- WrapperTool = "tlbimp" /> + <Reference + Name = "b2_DataAccess" + Project = "{8CF7C0D8-A8CB-43DC-B406-77DE62729487}" + Package = "{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}" + /> </References> </Build> *************** *** 127,130 **** --- 132,190 ---- /> <File + RelPath = "a0_Validation\IValidator.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\QuotesToBeValidated.cs" + SubType = "Component" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\SospiciousDataRowEventArgs.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\ValidateDataTable.cs" + SubType = "Component" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\ValidateDataTable.resx" + DependentUpon = "ValidateDataTable.cs" + BuildAction = "EmbeddedResource" + /> + <File + RelPath = "a0_Validation\ValidationWarnings.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\Validator.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\Validators\CloseToCloseValidator.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\Validators\MultiValidator.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\Validators\OHLCvalidator.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "a0_Validation\Validators\RangeToRangeValidator.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File RelPath = "a1_Financial\a1_Instruments\Instrument.cs" SubType = "Code" |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:51:57
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10205/Downloader Modified Files: Downloader.csproj Downloader.csproj.user Log Message: Validation has been moved from the QuantDownloader project to the QuantProject project Index: Downloader.csproj.user =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj.user,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** Downloader.csproj.user 25 Jan 2004 15:50:27 -0000 1.3 --- Downloader.csproj.user 26 Apr 2004 15:51:48 -0000 1.4 *************** *** 2,6 **** <CSHARP> <Build> ! <Settings ReferencePath = "c:\windows\assembly\gac\crystaldecisions.windows.forms\9.1.3300.0__692fbea5521e1304\;C:\Documents and Settings\Glauco\Desktop\QuantProject\lib\" > <Config Name = "Debug" --- 2,6 ---- <CSHARP> <Build> ! <Settings ReferencePath = "c:\windows\assembly\gac\crystaldecisions.windows.forms\9.1.3300.0__692fbea5521e1304\;C:\Documents and Settings\Glauco\Desktop\QuantProject\lib\;C:\Documents and Settings\Glauco\Desktop\QuantProject\QuantDownloader\Downloader\bin\Debug\" > <Config Name = "Debug" Index: Downloader.csproj =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj,v retrieving revision 1.17 retrieving revision 1.18 diff -C2 -d -r1.17 -r1.18 *** Downloader.csproj 25 Apr 2004 17:24:48 -0000 1.17 --- Downloader.csproj 26 Apr 2004 15:51:48 -0000 1.18 *************** *** 94,102 **** /> <Reference - Name = "scpl" - AssemblyName = "scpl" - HintPath = "..\..\lib\scpl.dll" - /> - <Reference Name = "b3_Data" Project = "{6AC0A2C1-B926-4921-A685-F5AA80E81C94}" --- 94,97 ---- *************** *** 133,136 **** --- 128,136 ---- HintPath = "..\..\..\..\..\..\WINDOWS\Microsoft.NET\Framework\v1.0.3705\System.Web.Services.dll" /> + <Reference + Name = "scpl" + AssemblyName = "scpl" + HintPath = "bin\Debug\scpl.dll" + /> </References> </Build> *************** *** 247,251 **** <File RelPath = "QuotesEditor\VisualValidationChart.cs" ! SubType = "UserControl" BuildAction = "Compile" /> --- 247,251 ---- <File RelPath = "QuotesEditor\VisualValidationChart.cs" ! SubType = "Code" BuildAction = "Compile" /> *************** *** 307,311 **** <File RelPath = "QuotesEditor\RangeToRange\RangeToRangeChart.cs" ! SubType = "UserControl" BuildAction = "Compile" /> --- 307,311 ---- <File RelPath = "QuotesEditor\RangeToRange\RangeToRangeChart.cs" ! SubType = "Code" BuildAction = "Compile" /> *************** *** 351,359 **** /> <File - RelPath = "TickerSelectors\TickerSelectorForm.resx" - DependentUpon = "TickerSelectorForm.cs" - BuildAction = "EmbeddedResource" - /> - <File RelPath = "TickerSelectors\TickerViewer.cs" SubType = "Form" --- 351,354 ---- *************** *** 371,389 **** /> <File - RelPath = "Validate\IValidator.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File - RelPath = "Validate\QuotesToBeValidated.cs" - SubType = "Component" - BuildAction = "Compile" - /> - <File - RelPath = "Validate\SospiciousDataRowEventArgs.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File RelPath = "Validate\ValidateDataGrid.cs" SubType = "Component" --- 366,369 ---- *************** *** 391,404 **** /> <File - RelPath = "Validate\ValidateDataTable.cs" - SubType = "Component" - BuildAction = "Compile" - /> - <File - RelPath = "Validate\ValidateDataTable.resx" - DependentUpon = "ValidateDataTable.cs" - BuildAction = "EmbeddedResource" - /> - <File RelPath = "Validate\ValidateForm.cs" SubType = "Form" --- 371,374 ---- *************** *** 410,438 **** BuildAction = "EmbeddedResource" /> - <File - RelPath = "Validate\ValidationWarnings.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File - RelPath = "Validate\Validators\CloseToCloseValidator.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File - RelPath = "Validate\Validators\MultiValidator.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File - RelPath = "Validate\Validators\OHLCvalidator.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File - RelPath = "Validate\Validators\RangeToRangeValidator.cs" - SubType = "Code" - BuildAction = "Compile" - /> </Include> </Files> --- 380,383 ---- |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:51:57
|
Update of /cvsroot/quantproject/QuantDownloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10205 Modified Files: QuantDownloader.suo Log Message: Validation has been moved from the QuantDownloader project to the QuantProject project Index: QuantDownloader.suo =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/QuantDownloader.suo,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 Binary files /tmp/cvsfLMvqe and /tmp/cvsnwffXl differ |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:48:16
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/OHLC In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9396/Downloader/QuotesEditor/OHLC Modified Files: OHLCdataGrid.cs OHLCuserControl.cs Log Message: Now using the new QuantProject.Business.Validation namespace Index: OHLCuserControl.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/OHLC/OHLCuserControl.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** OHLCuserControl.cs 21 Mar 2004 16:32:31 -0000 1.2 --- OHLCuserControl.cs 26 Apr 2004 15:48:04 -0000 1.3 *************** *** 28,31 **** --- 28,32 ---- using System.Windows.Forms; using QuantProject.Applications.Downloader.Validate; + using QuantProject.Business.Validation; namespace QuantProject.Applications.Downloader Index: OHLCdataGrid.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/OHLC/OHLCdataGrid.cs,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** OHLCdataGrid.cs 21 Mar 2004 16:35:50 -0000 1.3 --- OHLCdataGrid.cs 26 Apr 2004 15:48:04 -0000 1.4 *************** *** 25,28 **** --- 25,29 ---- using System.Windows.Forms; using QuantProject.Applications.Downloader.Validate; + using QuantProject.Business.Validation; namespace QuantProject.Applications.Downloader |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:48:15
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9396/Downloader/QuotesEditor Modified Files: QuotesEditor.cs ValidationTabPage.cs VisualValidationDataGrid.cs Log Message: Now using the new QuantProject.Business.Validation namespace Index: VisualValidationDataGrid.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/VisualValidationDataGrid.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** VisualValidationDataGrid.cs 28 Mar 2004 22:01:05 -0000 1.2 --- VisualValidationDataGrid.cs 26 Apr 2004 15:48:04 -0000 1.3 *************** *** 25,28 **** --- 25,29 ---- using System.Windows.Forms; using QuantProject.Applications.Downloader.Validate; + using QuantProject.Business.Validation; using QuantProject.DataAccess.Tables; Index: ValidationTabPage.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/ValidationTabPage.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** ValidationTabPage.cs 21 Mar 2004 16:50:16 -0000 1.1 --- ValidationTabPage.cs 26 Apr 2004 15:48:04 -0000 1.2 *************** *** 2,5 **** --- 2,6 ---- using System.Windows.Forms; using QuantProject.Applications.Downloader.Validate; + using QuantProject.Business.Validation; namespace QuantProject.Applications.Downloader Index: QuotesEditor.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/QuotesEditor.cs,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** QuotesEditor.cs 28 Mar 2004 20:30:00 -0000 1.5 --- QuotesEditor.cs 26 Apr 2004 15:48:04 -0000 1.6 *************** *** 8,11 **** --- 8,12 ---- using QuantProject.ADT; using QuantProject.ADT.Histories; + using QuantProject.Business.Validation; using QuantProject.Data; using QuantProject.Applications.Downloader.Validate; |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:48:15
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9396/Downloader/Validate Modified Files: ValidateDataGrid.cs ValidateForm.cs Log Message: Now using the new QuantProject.Business.Validation namespace Index: ValidateDataGrid.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/ValidateDataGrid.cs,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** ValidateDataGrid.cs 25 Jan 2004 15:05:19 -0000 1.4 --- ValidateDataGrid.cs 26 Apr 2004 15:48:05 -0000 1.5 *************** *** 2,5 **** --- 2,6 ---- using System.Windows.Forms; using System.Data; + using QuantProject.Business.Validation; namespace QuantProject.Applications.Downloader.Validate Index: ValidateForm.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/ValidateForm.cs,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** ValidateForm.cs 21 Mar 2004 16:21:20 -0000 1.9 --- ValidateForm.cs 26 Apr 2004 15:48:05 -0000 1.10 *************** *** 6,9 **** --- 6,11 ---- using System.Windows.Forms; + using QuantProject.Business.Validation; + namespace QuantProject.Applications.Downloader.Validate { |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:48:15
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9396/Downloader/QuotesEditor/CloseToClose Modified Files: CloseToCloseDataGrid.cs Log Message: Now using the new QuantProject.Business.Validation namespace Index: CloseToCloseDataGrid.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/CloseToClose/CloseToCloseDataGrid.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** CloseToCloseDataGrid.cs 21 Mar 2004 17:00:02 -0000 1.2 --- CloseToCloseDataGrid.cs 26 Apr 2004 15:48:03 -0000 1.3 *************** *** 26,29 **** --- 26,30 ---- using QuantProject.DataAccess.Tables; using QuantProject.Applications.Downloader.Validate; + using QuantProject.Business.Validation; namespace QuantProject.Applications.Downloader |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:48:14
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/RangeToRange In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9396/Downloader/QuotesEditor/RangeToRange Modified Files: RangeToRangeDataGrid.cs Log Message: Now using the new QuantProject.Business.Validation namespace Index: RangeToRangeDataGrid.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/RangeToRange/RangeToRangeDataGrid.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** RangeToRangeDataGrid.cs 28 Mar 2004 20:36:42 -0000 1.2 --- RangeToRangeDataGrid.cs 26 Apr 2004 15:48:04 -0000 1.3 *************** *** 1,4 **** --- 1,5 ---- using System; using QuantProject.Applications.Downloader.Validate; + using QuantProject.Business.Validation; using QuantProject.DataAccess.Tables; |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:41:55
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8041/b2_DataAccess/Tables Modified Files: ValidatedTickers.cs Log Message: - GetHashValue is a public method now - IsValid method has been moved to the Validator class Index: ValidatedTickers.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/ValidatedTickers.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** ValidatedTickers.cs 21 Apr 2004 11:58:34 -0000 1.1 --- ValidatedTickers.cs 26 Apr 2004 15:41:41 -0000 1.2 *************** *** 30,53 **** /// <param name="endDate">Ending instrument quote's date, for hash value computation</param> /// <returns></returns> ! private static string getHashValue( string ticker , DateTime startDate , DateTime endDate ) { Quotes quotes = new Quotes( ticker ); return quotes.GetHashValue( startDate , endDate ); } - - /// <summary> - /// Checks if the instrument is valid (since the first date to the last date in the quotes table) - /// </summary> - /// <param name="ticker">Instrument's ticker</param> - /// <returns></returns> - public static bool IsValid( string ticker ) - { - DataTable validatedTicker = - SqlExecutor.GetDataTable( "select * from validatedTickers where vvTicker='" + ticker + "'" ); - return ( ( validatedTicker.Rows.Count > 0 ) && - ( (string)validatedTicker.Rows[ 0 ][ ValidatedTickers.HashValue ] == - getHashValue( ticker , (DateTime)validatedTicker.Rows[ 0 ][ ValidatedTickers.StartDate ] , - (DateTime)validatedTicker.Rows[ 0 ][ ValidatedTickers.EndDate ] ) ) ); - } } } --- 30,38 ---- /// <param name="endDate">Ending instrument quote's date, for hash value computation</param> /// <returns></returns> ! public static string GetHashValue( string ticker , DateTime startDate , DateTime endDate ) { Quotes quotes = new Quotes( ticker ); return quotes.GetHashValue( startDate , endDate ); } } } |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:39:04
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/Validate/Validators In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7364/Validators Modified Files: CloseToCloseValidator.cs MultiValidator.cs OHLCvalidator.cs RangeToRangeValidator.cs Log Message: Moved from the QuantDownloader project to the QuantProject project Index: MultiValidator.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/Validators/MultiValidator.cs,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** MultiValidator.cs 21 Apr 2004 12:04:56 -0000 1.3 --- MultiValidator.cs 26 Apr 2004 15:38:55 -0000 1.4 *************** *** 1,8 **** using System; using System.Data; ! using QuantProject.Applications.Downloader.Validate; ! using QuantProject.Applications.Downloader.Validate.Validators; ! namespace QuantProject.Applications.Downloader.Validate.Validators { /// <summary> --- 1,7 ---- using System; using System.Data; ! using QuantProject.Business.Validation; ! namespace QuantProject.Business.Validation.Validators { /// <summary> Index: CloseToCloseValidator.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/Validators/CloseToCloseValidator.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** CloseToCloseValidator.cs 25 Jan 2004 15:47:36 -0000 1.2 --- CloseToCloseValidator.cs 26 Apr 2004 15:38:54 -0000 1.3 *************** *** 2,8 **** using System.Data; using QuantProject.ADT.Histories; ! using QuantProject.Applications.Downloader.Validate; ! namespace QuantProject.Applications.Downloader.Validate.Validators { /// <summary> --- 2,8 ---- using System.Data; using QuantProject.ADT.Histories; ! using QuantProject.Business.Validation; ! namespace QuantProject.Business.Validation.Validators { /// <summary> Index: OHLCvalidator.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/Validators/OHLCvalidator.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** OHLCvalidator.cs 25 Jan 2004 15:45:01 -0000 1.2 --- OHLCvalidator.cs 26 Apr 2004 15:38:55 -0000 1.3 *************** *** 1,7 **** using System; using System.Data; ! using QuantProject.Applications.Downloader.Validate; ! namespace QuantProject.Applications.Downloader.Validate.Validators { /// <summary> --- 1,7 ---- using System; using System.Data; ! using QuantProject.Business.Validation; ! namespace QuantProject.Business.Validation.Validators { /// <summary> Index: RangeToRangeValidator.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Validate/Validators/RangeToRangeValidator.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** RangeToRangeValidator.cs 1 Apr 2004 15:56:18 -0000 1.2 --- RangeToRangeValidator.cs 26 Apr 2004 15:38:55 -0000 1.3 *************** *** 4,10 **** using QuantProject.ADT.Histories; using QuantProject.DataAccess.Tables; ! using QuantProject.Applications.Downloader.Validate; ! namespace QuantProject.Applications.Downloader.Validate.Validators { /// <summary> --- 4,10 ---- using QuantProject.ADT.Histories; using QuantProject.DataAccess.Tables; ! using QuantProject.Business.Validation; ! namespace QuantProject.Business.Validation.Validators { /// <summary> |
Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7168 Added Files: IValidator.cs QuotesToBeValidated.cs SospiciousDataRowEventArgs.cs ValidateDataTable.cs ValidationWarnings.cs Validator.cs Log Message: Moved from the QuantDownloader project to the QuantProject project --- NEW FILE: ValidationWarnings.cs --- /* QuantProject - Quantitative Finance Library BarComponent.cs Copyright (C) 2003 Glauco Siliprandi 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.Business.Validation { /// <summary> /// Types of warnings that can be arisen when quotes are validated /// </summary> public enum ValidationWarning { OpenHighLowCloseLogicalInconsistency, SuspiciousCloseToCloseRatio, SuspiciousRangeToRangeRatio } } --- NEW FILE: Validator.cs --- using System; using System.Data; using QuantProject.DataAccess; using QuantProject.DataAccess.Tables; namespace QuantProject.Business.Validation { /// <summary> /// Validates tickers and checks for valid tickers /// </summary> public class Validator { public Validator() { // // TODO: Add constructor logic here // } #region IsValid private static bool isValid_withoutNewBeguinningQuotes( string ticker , DataTable validatedTicker ) { bool returnValue = ( ( validatedTicker.Rows.Count > 0 ) && ( (string)validatedTicker.Rows[ 0 ][ ValidatedTickers.HashValue ] == ValidatedTickers.GetHashValue( ticker , (DateTime)validatedTicker.Rows[ 0 ][ ValidatedTickers.StartDate ] , (DateTime)validatedTicker.Rows[ 0 ][ ValidatedTickers.EndDate ] ) ) ); if ( returnValue ) // the validated period is st qui!!!! returnValue = returnValue; return returnValue; } /// <summary> /// Checks if the instrument is valid (since the first date to the last date in the quotes table) /// </summary> /// <param name="ticker">Instrument's ticker</param> /// <returns></returns> public static bool IsValid( string ticker ) { DataTable validatedTicker = SqlExecutor.GetDataTable( "select * from validatedTickers where vvTicker='" + ticker + "'" ); // if ( ( validatedTicker.Rows.Count > 0 ) && // ( (DateTime)validatedTicker.Rows[ 0 ][ ValidatedTickers.StartDate ] < // Quotes.GetStartDate( ticker ) ) ) // // new quotes have been added at the beguinning of the ticker quotes, since when it was validated // ValidatedTickers.RemoveValidation( ticker ); return isValid_withoutNewBeguinningQuotes( ticker , validatedTicker ); } #endregion } } --- NEW FILE: SospiciousDataRowEventArgs.cs --- using System; using System.Data; namespace QuantProject.Business.Validation { /// <summary> /// EventArgs for the SuspiciousDataRow event /// </summary> public class SuspiciousDataRowEventArgs : EventArgs { private DataRow dataRow; private ValidationWarning validationWarning; /// <summary> /// The suspicious DataRow /// </summary> public DataRow DataRow { get { return this.dataRow; } set { value = this.dataRow; } } /// <summary> /// The suspicious DataRow /// </summary> public ValidationWarning ValidationWarning { get { return this.validationWarning; } set { value = this.validationWarning; } } public SuspiciousDataRowEventArgs( DataRow dataRow ) { this.dataRow = dataRow; } public SuspiciousDataRowEventArgs( DataRow dataRow , ValidationWarning validationWarning ) { this.dataRow = dataRow; this.validationWarning = validationWarning; } } } --- NEW FILE: ValidateDataTable.cs --- using System; using System.Data; using System.Data.OleDb; using QuantProject.DataAccess; namespace QuantProject.Business.Validation { /// <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; private DataTable tableOfTickersToBeValidated; 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 } public ValidateDataTable(DataTable tableOfTickers) { initializeValidateDataTable(); // specific code used by this constructor // the table member is used when the validation procedure // is called by the tickerViewer object this.tableOfTickersToBeValidated = tableOfTickers; } #region initializeValidateDataTable private void initializeValidateDataTable() { 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 ); DataColumn dataColumn = new DataColumn( "CloseToCloseHasBeenVisuallyValidated" , System.Type.GetType( "System.Boolean" ) ); dataColumn.DefaultValue = false; this.Columns.Add( dataColumn ); this.TableName = "quotes"; //<<<<<<< ValidateDataTable.cs this.Columns.Add( "ValidationWarning" , ValidationWarning.OpenHighLowCloseLogicalInconsistency.GetType() ); //======= // //>>>>>>> 1.6 } #endregion /// <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 ) dataRow[ dataColumn.ColumnName ] = quotesRow[ dataColumn ]; dataRow[ "ValidationWarning" ] = eventArgs.ValidationWarning; this.Rows.Add( dataRow ); //this.Rows.Add( quotesRow ); } public void AddRows( string tickerIsLike , double suspiciousRatio ) { QuotesToBeValidated quotesToBeValidated = new QuotesToBeValidated( tickerIsLike ); quotesToBeValidated.SuspiciousRatio = suspiciousRatio; quotesToBeValidated.SuspiciousDataRow += new SuspiciousDataRowEventHandler( suspiciousDataRowEventHandler ); // new QuotesToBeValidated.SuspiciousDataRowEventHandler( suspiciousDataRowEventHandler ); quotesToBeValidated.Validate(); this.AcceptChanges(); } public void AddRows(double suspiciousRatio ) { QuotesToBeValidated quotesToBeValidated = new QuotesToBeValidated(this.tableOfTickersToBeValidated); quotesToBeValidated.SuspiciousRatio = suspiciousRatio; quotesToBeValidated.SuspiciousDataRow += new SuspiciousDataRowEventHandler( suspiciousDataRowEventHandler ); // new QuotesToBeValidated.SuspiciousDataRowEventHandler( suspiciousDataRowEventHandler ); quotesToBeValidated.Validate(); 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() ); } } } } --- NEW FILE: QuotesToBeValidated.cs --- using System; using System.Data; using System.Data.OleDb; using QuantProject.DataAccess; using QuantProject.Business.Validation.Validators; namespace QuantProject.Business.Validation { /// <summary> /// Summary description for QuotesToBeValidated. /// </summary> public class QuotesToBeValidated : DataTable { private string selectStatement; private OleDbDataAdapter oleDbDataAdapter; private double suspiciousRatio; public double SuspiciousRatio { get { return this.suspiciousRatio; } set { this.suspiciousRatio = value; } } 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 , ConnectionProvider.OleDbConnection ); try { this.oleDbDataAdapter.Fill( this ); } catch (Exception exception) { Console.WriteLine( exception.ToString() ); } } public QuotesToBeValidated(DataTable tableOfTickersToBeValidated) { this.oleDbDataAdapter = new OleDbDataAdapter( "" , ConnectionProvider.OleDbConnection ); foreach(DataRow row in tableOfTickersToBeValidated.Rows) { this.oleDbDataAdapter.SelectCommand.CommandText = "select * from quotes where quTicker = '" + (string)row[0] + "'"; try { this.oleDbDataAdapter.Fill( this ); } catch (Exception exception) { Console.WriteLine( exception.ToString() ); } } } // public delegate void SuspiciousDataRowEventHandler( // Object sender , SuspiciousDataRowEventArgs eventArgs ); public event SuspiciousDataRowEventHandler SuspiciousDataRow; #region "Validate" private void suspiciousDataRowHandler( Object sender , SuspiciousDataRowEventArgs eventArgs ) { SuspiciousDataRow( this , eventArgs ); } public void Validate() { // QuantProject.Applications.Downloader.Validate.Validators.OHLCvalidator oHLCvalidator = // new QuantProject.Applications.Downloader.Validate.Validators.OHLCvalidator(); // oHLCvalidator.SuspiciousDataRow += // new SuspiciousDataRowEventHandler( suspiciousDataRowHandler ); // oHLCvalidator.Validate( this ); MultiValidator multiValidator = new MultiValidator(); multiValidator.SuspiciousRatio = this.suspiciousRatio; multiValidator.SuspiciousDataRow += new SuspiciousDataRowEventHandler( this.suspiciousDataRowHandler ); multiValidator.Validate( this ); } } #endregion } --- NEW FILE: IValidator.cs --- using System; using System.Data; namespace QuantProject.Business.Validation { public delegate void SuspiciousDataRowEventHandler( Object sender , SuspiciousDataRowEventArgs eventArgs ); /// <summary> /// Interface to be implemented by quotes validators /// </summary> public interface IValidator { event SuspiciousDataRowEventHandler SuspiciousDataRow; void Validate( DataTable dataTable ); } } |
|
From: Glauco S. <gla...@us...> - 2004-04-26 15:36:43
|
Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6879/a0_Validation Log Message: Directory /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation added to the repository |
|
From: Marco M. <mi...@us...> - 2004-04-26 14:28:38
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24131/b2_DataAccess Modified Files: DataBaseVersionManager.cs Log Message: Added code to add new columns in validateTickers table Index: DataBaseVersionManager.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBaseVersionManager.cs,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** DataBaseVersionManager.cs 21 Apr 2004 12:00:55 -0000 1.11 --- DataBaseVersionManager.cs 26 Apr 2004 14:28:29 -0000 1.12 *************** *** 92,96 **** private void createDatabase() { ! //TODO code to create an empty DB if user doesn't select the QuantProject.mdb; } private void createTables() --- 92,96 ---- private void createDatabase() { ! //TODO: code to create an empty DB if user doesn't select the QuantProject.mdb; } private void createTables() *************** *** 169,174 **** private void alterTablesAddColumns() { ! this.executeCommand("ALTER TABLE tickers " + "ADD COLUMN tiCompanyName TEXT(100)"); } private void alterTablesAddIndexes() --- 169,180 ---- private void alterTablesAddColumns() { ! // add code here for adding new columns to existing tables; ! ! this.executeCommand("ALTER TABLE tickers " + "ADD COLUMN tiCompanyName TEXT(100)"); + this.executeCommand("ALTER TABLE validatedTickers " + + "ADD COLUMN vtHashValue TEXT(50)"); + this.executeCommand("ALTER TABLE validatedTickers " + + "ADD COLUMN vtEditDate DATETIME"); } private void alterTablesAddIndexes() |
|
From: Marco M. <mi...@us...> - 2004-04-26 12:59:08
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5513/Downloader/TickerSelectors Added Files: TickerSelectorForm.cs Log Message: Added user interface for the TickerSelector class --- NEW FILE: TickerSelectorForm.cs --- /* QuantDownloader - Quantitative Finance Library TickerSelectorForm.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.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.OleDb; using QuantProject.ADT; using QuantProject.DataAccess.Tables; using QuantProject.Data.DataTables; using QuantProject.Data.Selectors; namespace QuantProject.Applications.Downloader.TickerSelectors { /// <summary> /// It is the user interface for the TickerSelector class /// </summary> public class TickerSelectorForm : System.Windows.Forms.Form, ITickerSelector { private System.Windows.Forms.ToolTip toolTip1; private System.Windows.Forms.DataGrid dataGrid1; private System.ComponentModel.IContainer components; private System.Windows.Forms.Panel panel2; private System.Windows.Forms.Splitter splitter1; private System.Windows.Forms.DateTimePicker dateTimePickerFirstDate; private System.Windows.Forms.DateTimePicker dateTimePickerLastDate; private System.Windows.Forms.Label label5; private System.Windows.Forms.Label label7; private System.Windows.Forms.Button buttonSelectTickers; private System.Windows.Forms.GroupBox groupBoxSelectionRule; private System.Windows.Forms.TextBox textBoxGroupID; private System.Windows.Forms.Label label1; private System.Windows.Forms.Label label2; private System.Windows.Forms.ComboBox comboBoxAvailableSelectionRules; private System.Windows.Forms.TextBox textBoxMaxNumOfReturnedTickers; private System.Windows.Forms.Label label3; public TickerSelectorForm() { InitializeComponent(); this.dateTimePickerFirstDate.Value = ConstantsProvider.InitialDateTimeForDownload; this.dateTimePickerLastDate.Value = DateTime.Now; this.dataGrid1.ContextMenu = new TickerViewerMenu(this); //TODO: complete comboBox's code with all possible types of selections this.comboBoxAvailableSelectionRules.Text = "Most liquid instrument"; this.comboBoxAvailableSelectionRules.Items.Add("Most liquid instrument"); } public TickerSelectorForm(string groupID) : this() { this.textBoxGroupID.Text = groupID; } /// <summary> /// clean up /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// <summary> /// do not modify the content with the editor /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.toolTip1 = new System.Windows.Forms.ToolTip(this.components); this.dataGrid1 = new System.Windows.Forms.DataGrid(); this.buttonSelectTickers = new System.Windows.Forms.Button(); this.panel2 = new System.Windows.Forms.Panel(); this.groupBoxSelectionRule = new System.Windows.Forms.GroupBox(); this.label3 = new System.Windows.Forms.Label(); this.comboBoxAvailableSelectionRules = new System.Windows.Forms.ComboBox(); this.label2 = new System.Windows.Forms.Label(); this.textBoxMaxNumOfReturnedTickers = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.textBoxGroupID = new System.Windows.Forms.TextBox(); this.label7 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.dateTimePickerLastDate = new System.Windows.Forms.DateTimePicker(); this.dateTimePickerFirstDate = new System.Windows.Forms.DateTimePicker(); this.splitter1 = new System.Windows.Forms.Splitter(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.panel2.SuspendLayout(); this.groupBoxSelectionRule.SuspendLayout(); this.SuspendLayout(); // // dataGrid1 // this.dataGrid1.BorderStyle = System.Windows.Forms.BorderStyle.None; this.dataGrid1.DataMember = ""; this.dataGrid1.Dock = System.Windows.Forms.DockStyle.Left; this.dataGrid1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Name = "dataGrid1"; this.dataGrid1.Size = new System.Drawing.Size(432, 478); this.dataGrid1.TabIndex = 2; // // buttonSelectTickers // this.buttonSelectTickers.Location = new System.Drawing.Point(136, 256); this.buttonSelectTickers.Name = "buttonSelectTickers"; this.buttonSelectTickers.Size = new System.Drawing.Size(104, 24); this.buttonSelectTickers.TabIndex = 3; this.buttonSelectTickers.Text = "Select Tickers"; this.buttonSelectTickers.Click += new System.EventHandler(this.buttonSelectTickers_Click); // // panel2 // this.panel2.Controls.AddRange(new System.Windows.Forms.Control[] { this.groupBoxSelectionRule, this.buttonSelectTickers}); this.panel2.Dock = System.Windows.Forms.DockStyle.Fill; this.panel2.ForeColor = System.Drawing.SystemColors.ControlText; this.panel2.Location = new System.Drawing.Point(432, 0); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(392, 478); this.panel2.TabIndex = 7; // // groupBoxSelectionRule // this.groupBoxSelectionRule.Controls.AddRange(new System.Windows.Forms.Control[] { this.label3, this.comboBoxAvailableSelectionRules, this.label2, this.textBoxMaxNumOfReturnedTickers, this.label1, this.textBoxGroupID, this.label7, this.label5, this.dateTimePickerLastDate, this.dateTimePickerFirstDate}); this.groupBoxSelectionRule.Location = new System.Drawing.Point(8, 16); this.groupBoxSelectionRule.Name = "groupBoxSelectionRule"; this.groupBoxSelectionRule.Size = new System.Drawing.Size(376, 144); this.groupBoxSelectionRule.TabIndex = 14; this.groupBoxSelectionRule.TabStop = false; this.groupBoxSelectionRule.Text = "Single Selection rule"; // // label3 // this.label3.Location = new System.Drawing.Point(48, 112); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(120, 16); this.label3.TabIndex = 26; this.label3.Text = "Choose selection rule"; // // comboBoxAvailableSelectionRules // this.comboBoxAvailableSelectionRules.Location = new System.Drawing.Point(176, 112); this.comboBoxAvailableSelectionRules.Name = "comboBoxAvailableSelectionRules"; this.comboBoxAvailableSelectionRules.Size = new System.Drawing.Size(176, 21); this.comboBoxAvailableSelectionRules.TabIndex = 25; this.comboBoxAvailableSelectionRules.Text = "comboBox1"; // // label2 // this.label2.Location = new System.Drawing.Point(160, 64); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(152, 24); this.label2.TabIndex = 24; this.label2.Text = "Max Num of returned tickers"; // // textBoxMaxNumOfReturnedTickers // this.textBoxMaxNumOfReturnedTickers.Location = new System.Drawing.Point(312, 64); this.textBoxMaxNumOfReturnedTickers.Name = "textBoxMaxNumOfReturnedTickers"; this.textBoxMaxNumOfReturnedTickers.Size = new System.Drawing.Size(48, 20); this.textBoxMaxNumOfReturnedTickers.TabIndex = 23; this.textBoxMaxNumOfReturnedTickers.Text = ""; // // label1 // this.label1.Location = new System.Drawing.Point(8, 64); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(64, 16); this.label1.TabIndex = 22; this.label1.Text = "GroupID"; // // textBoxGroupID // this.textBoxGroupID.Location = new System.Drawing.Point(72, 64); this.textBoxGroupID.Name = "textBoxGroupID"; this.textBoxGroupID.Size = new System.Drawing.Size(88, 20); this.textBoxGroupID.TabIndex = 21; this.textBoxGroupID.Text = ""; // // label7 // this.label7.Location = new System.Drawing.Point(168, 24); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(64, 16); this.label7.TabIndex = 20; this.label7.Text = "Last Date"; // // label5 // this.label5.Location = new System.Drawing.Point(8, 24); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(64, 16); this.label5.TabIndex = 18; this.label5.Text = "First Date"; // // dateTimePickerLastDate // this.dateTimePickerLastDate.Format = System.Windows.Forms.DateTimePickerFormat.Short; this.dateTimePickerLastDate.Location = new System.Drawing.Point(240, 24); this.dateTimePickerLastDate.Name = "dateTimePickerLastDate"; this.dateTimePickerLastDate.Size = new System.Drawing.Size(88, 20); this.dateTimePickerLastDate.TabIndex = 15; // // dateTimePickerFirstDate // this.dateTimePickerFirstDate.Format = System.Windows.Forms.DateTimePickerFormat.Short; this.dateTimePickerFirstDate.Location = new System.Drawing.Point(72, 24); this.dateTimePickerFirstDate.Name = "dateTimePickerFirstDate"; this.dateTimePickerFirstDate.Size = new System.Drawing.Size(88, 20); this.dateTimePickerFirstDate.TabIndex = 13; // // splitter1 // this.splitter1.BackColor = System.Drawing.SystemColors.Highlight; this.splitter1.Location = new System.Drawing.Point(432, 0); this.splitter1.Name = "splitter1"; this.splitter1.Size = new System.Drawing.Size(3, 478); this.splitter1.TabIndex = 8; this.splitter1.TabStop = false; // // TickerSelectorForm // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(824, 478); this.Controls.AddRange(new System.Windows.Forms.Control[] { this.splitter1, this.panel2, this.dataGrid1}); this.Name = "TickerSelectorForm"; this.Text = "Ticker Selector"; ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.panel2.ResumeLayout(false); this.groupBoxSelectionRule.ResumeLayout(false); this.ResumeLayout(false); } #endregion // implementation of ITickerSelector interface public TickerDataTable GetTableOfSelectedTickers() { DataTable dataTableOfDataGrid1 = (DataTable)this.dataGrid1.DataSource; TickerDataTable tableOfSelectedTickers = new TickerDataTable(); int indexOfRow = 0; while(indexOfRow != dataTableOfDataGrid1.Rows.Count) { if(this.dataGrid1.IsSelected(indexOfRow)) { DataRow dataRow = tableOfSelectedTickers.NewRow(); dataRow[0] = (string)dataTableOfDataGrid1.Rows[indexOfRow][0]; dataRow[1] = (string)dataTableOfDataGrid1.Rows[indexOfRow][1]; tableOfSelectedTickers.Rows.Add(dataRow); } indexOfRow++; } return tableOfSelectedTickers; } public void SelectAllTickers() { DataTable dataTableOfDataGrid1 = (DataTable)this.dataGrid1.DataSource; int indexOfRow = 0; while(indexOfRow != dataTableOfDataGrid1.Rows.Count) { this.dataGrid1.Select(indexOfRow); indexOfRow++; } } private void buttonSelectTickers_Click(object sender, System.EventArgs e) { //TODO: complete code ... SelectionRule rule = new SelectionRule(SelectionType.MostLiquid, this.textBoxGroupID.Text, this.dateTimePickerFirstDate.Value, this.dateTimePickerLastDate.Value, Int32.Parse(this.textBoxMaxNumOfReturnedTickers.Text)); TickerSelector selector = new TickerSelector(rule); this.dataGrid1.DataSource = selector.GetTableOfSelectedTickers(); this.dataGrid1.Refresh(); } } } |
|
From: Marco M. <mi...@us...> - 2004-04-25 19:22:13
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6945/Downloader/TickerSelectors Modified Files: TickerGroupsListViewMenu.cs TickerGroupsViewer.cs TickerViewer.cs TickerViewerMenu.cs Log Message: Updated code due to change in namespace for the TickerDataTable Index: TickerGroupsViewer.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerGroupsViewer.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** TickerGroupsViewer.cs 17 Apr 2004 14:12:29 -0000 1.1 --- TickerGroupsViewer.cs 25 Apr 2004 17:24:50 -0000 1.2 *************** *** 30,33 **** --- 30,35 ---- using QuantProject.DataAccess; using QuantProject.DataAccess.Tables; + using QuantProject.Data.DataTables; + using QuantProject.Data.Selectors; namespace QuantProject.Applications.Downloader.TickerSelectors *************** *** 56,68 **** private const string FIRST_COLUMN_NAME = "Element Name"; private const string SECOND_COLUMN_NAME = "Element Type"; private const string THIRD_COLUMN_NAME = "Element Description"; public TickerGroupsViewer() { - InitializeComponent(); // ! this.listViewGroupsAndTickers.ContextMenu = new TickerGroupsListViewMenu(this); this.listViewGroupsAndTickers.Columns.Add(FIRST_COLUMN_NAME, this.listViewGroupsAndTickers.Width - 30, --- 58,71 ---- private const string FIRST_COLUMN_NAME = "Element Name"; private const string SECOND_COLUMN_NAME = "Element Type"; + private System.Windows.Forms.MenuItem menuItemTickerSelector; private const string THIRD_COLUMN_NAME = "Element Description"; public TickerGroupsViewer() { InitializeComponent(); // ! this.loadImagesInImageListGroupAndTickers(); ! this.listViewGroupsAndTickers.ContextMenu = new TickerGroupsListViewMenu(this); this.listViewGroupsAndTickers.Columns.Add(FIRST_COLUMN_NAME, this.listViewGroupsAndTickers.Width - 30, *************** *** 76,79 **** --- 79,104 ---- // } + private void loadImagesInImageListGroupAndTickers() + { + try + { + string fileName = Application.ExecutablePath.Substring(0, Application.ExecutablePath.LastIndexOf('\\')) + + @"\Group.bmp"; + Image image = Image.FromFile(fileName); + this.imageListGroupsAndTickers.Images.Add(image); + + fileName = Application.ExecutablePath.Substring(0, Application.ExecutablePath.LastIndexOf('\\')) + + @"\Ticker.bmp"; + image = Image.FromFile(fileName); + this.imageListGroupsAndTickers.Images.Add(image); + + } + catch(Exception ex) + { + MessageBox.Show("Put all the bmp files in the dir <<TickerGroupsViewerImages>> inside the bin directory! ", "Files not found"); + string notUsed = ex.ToString(); + } + + } /// <summary> *************** *** 165,169 **** // so it stands for a group of tickers { ! MessageBox.Show("NOT IMPLEMENTED YET"); } } --- 190,195 ---- // so it stands for a group of tickers { ! //TODO: add method to retrieve ! MessageBox.Show("NOT IMPLEMENTED YET"); } } *************** *** 178,182 **** { this.components = new System.ComponentModel.Container(); - System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(TickerGroupsViewer)); this.treeViewGroups = new System.Windows.Forms.TreeView(); this.contextMenuTickerGroupsTreeView = new System.Windows.Forms.ContextMenu(); --- 204,207 ---- *************** *** 187,190 **** --- 212,216 ---- this.splitter1 = new System.Windows.Forms.Splitter(); this.listViewGroupsAndTickers = new System.Windows.Forms.ListView(); + this.menuItemTickerSelector = new System.Windows.Forms.MenuItem(); this.SuspendLayout(); // *************** *** 205,209 **** this.menuItemAddNewGroup, this.menuItemRemoveGroup, ! this.menuItemRenameGroup}); // // menuItemAddNewGroup --- 231,236 ---- this.menuItemAddNewGroup, this.menuItemRemoveGroup, ! this.menuItemRenameGroup, ! this.menuItemTickerSelector}); // // menuItemAddNewGroup *************** *** 229,233 **** this.imageListGroupsAndTickers.ColorDepth = System.Windows.Forms.ColorDepth.Depth8Bit; this.imageListGroupsAndTickers.ImageSize = new System.Drawing.Size(16, 16); - this.imageListGroupsAndTickers.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageListGroupsAndTickers.ImageStream"))); this.imageListGroupsAndTickers.TransparentColor = System.Drawing.Color.Transparent; // --- 256,259 ---- *************** *** 253,256 **** --- 279,288 ---- this.listViewGroupsAndTickers.ItemActivate += new System.EventHandler(this.listViewGroupsAndTickers_ItemActivate); // + // menuItemTickerSelector + // + this.menuItemTickerSelector.Index = 3; + this.menuItemTickerSelector.Text = "&Ticker Selector"; + this.menuItemTickerSelector.Click += new System.EventHandler(this.menuItemTickerSelector_Click); + // // TickerGroupsViewer // *************** *** 281,285 **** this.table = new DataTable(); this.oleDbDataAdapter.Fill(this.table); ! TreeNode rootNode = new TreeNode("GROUPS"); rootNode.Tag = ""; this.treeViewGroups.Nodes.Add(rootNode); --- 313,317 ---- this.table = new DataTable(); this.oleDbDataAdapter.Fill(this.table); ! TreeNode rootNode = new TreeNode("GROUPS", GROUP_IMAGE, GROUP_IMAGE); rootNode.Tag = ""; this.treeViewGroups.Nodes.Add(rootNode); *************** *** 287,291 **** { ! TreeNode node = new TreeNode((string)row["tgDescription"]); node.Tag = (string)row["tgId"]; rootNode.Nodes.Add(node); --- 319,323 ---- { ! TreeNode node = new TreeNode((string)row["tgDescription"], GROUP_IMAGE, GROUP_IMAGE); node.Tag = (string)row["tgId"]; rootNode.Nodes.Add(node); *************** *** 306,310 **** foreach (DataRow row in groupsChild.Rows) { ! TreeNode node = new TreeNode((string)row["tgDescription"]); node.Tag = (string)row["tgId"]; currentNode.Nodes.Add(node); --- 338,342 ---- foreach (DataRow row in groupsChild.Rows) { ! TreeNode node = new TreeNode((string)row["tgDescription"], GROUP_IMAGE, GROUP_IMAGE); node.Tag = (string)row["tgId"]; currentNode.Nodes.Add(node); *************** *** 722,725 **** --- 754,770 ---- } } + + private void menuItemTickerSelector_Click(object sender, System.EventArgs e) + { + if((string)this.treeViewGroups.SelectedNode.Tag == "") + // it is the root node + { + MessageBox.Show("Choose a group containing some tickers!"); + return; + } + TickerSelectorForm tickerSelectorForm = + new TickerSelectorForm((string)this.treeViewGroups.SelectedNode.Tag); + tickerSelectorForm.Show(); + } Index: TickerViewer.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerViewer.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** TickerViewer.cs 17 Apr 2004 14:12:29 -0000 1.1 --- TickerViewer.cs 25 Apr 2004 17:24:50 -0000 1.2 *************** *** 28,33 **** using System.Data; using System.Data.OleDb; - using QuantProject.DataAccess; using QuantProject.DataAccess.Tables; namespace QuantProject.Applications.Downloader.TickerSelectors --- 28,34 ---- using System.Data; using System.Data.OleDb; using QuantProject.DataAccess.Tables; + using QuantProject.Data.DataTables; + using QuantProject.Data.Selectors; namespace QuantProject.Applications.Downloader.TickerSelectors Index: TickerViewerMenu.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerViewerMenu.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** TickerViewerMenu.cs 17 Apr 2004 14:12:29 -0000 1.1 --- TickerViewerMenu.cs 25 Apr 2004 17:24:50 -0000 1.2 *************** *** 24,28 **** using System.Data; using System.Windows.Forms; ! using QuantProject.DataAccess.Tables; namespace QuantProject.Applications.Downloader.TickerSelectors --- 24,29 ---- using System.Data; using System.Windows.Forms; ! using QuantProject.Data.DataTables; ! using QuantProject.Data.Selectors; namespace QuantProject.Applications.Downloader.TickerSelectors *************** *** 70,74 **** { ITickerSelector iTickerSelector = (ITickerSelector)this.parentForm; ! Tickers.Clipboard = iTickerSelector.GetTableOfSelectedTickers(); } --- 71,75 ---- { ITickerSelector iTickerSelector = (ITickerSelector)this.parentForm; ! TickerDataTable.Clipboard = iTickerSelector.GetTableOfSelectedTickers(); } Index: TickerGroupsListViewMenu.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerGroupsListViewMenu.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** TickerGroupsListViewMenu.cs 17 Apr 2004 14:12:29 -0000 1.1 --- TickerGroupsListViewMenu.cs 25 Apr 2004 17:24:49 -0000 1.2 *************** *** 25,28 **** --- 25,30 ---- using System.Windows.Forms; using QuantProject.DataAccess.Tables; + using QuantProject.Data.DataTables; + using QuantProject.Data.Selectors; namespace QuantProject.Applications.Downloader.TickerSelectors *************** *** 48,52 **** { ITickerReceiver iTickerReceiver = (ITickerReceiver)this.parentForm; ! iTickerReceiver.ReceiveTickers(Tickers.Clipboard); } private void removeSelectedItems(object sender, System.EventArgs e) --- 50,54 ---- { ITickerReceiver iTickerReceiver = (ITickerReceiver)this.parentForm; ! iTickerReceiver.ReceiveTickers(TickerDataTable.Clipboard); } private void removeSelectedItems(object sender, System.EventArgs e) |
|
From: Marco M. <mi...@us...> - 2004-04-25 19:21:07
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6945/Downloader Modified Files: Downloader.csproj WebDownloader.cs Log Message: Updated code due to change in namespace for the TickerDataTable Index: WebDownloader.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/WebDownloader.cs,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** WebDownloader.cs 17 Apr 2004 14:14:41 -0000 1.10 --- WebDownloader.cs 25 Apr 2004 17:24:49 -0000 1.11 *************** *** 12,15 **** --- 12,17 ---- using QuantProject.DataAccess.Tables; using QuantProject.Applications.Downloader.TickerSelectors; + using QuantProject.Data.DataTables; + using QuantProject.Data.Selectors; namespace QuantProject.Applications.Downloader Index: Downloader.csproj =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj,v retrieving revision 1.16 retrieving revision 1.17 diff -C2 -d -r1.16 -r1.17 *** Downloader.csproj 17 Apr 2004 14:16:29 -0000 1.16 --- Downloader.csproj 25 Apr 2004 17:24:48 -0000 1.17 *************** *** 326,339 **** /> <File - RelPath = "TickerSelectors\ITickerReceiver.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File - RelPath = "TickerSelectors\ITickerSelector.cs" - SubType = "Code" - BuildAction = "Compile" - /> - <File RelPath = "TickerSelectors\TickerGroupsListViewMenu.cs" SubType = "Component" --- 326,329 ---- *************** *** 351,354 **** --- 341,359 ---- /> <File + RelPath = "TickerSelectors\TickerGroupsViewer.resx" + DependentUpon = "TickerGroupsViewer.cs" + BuildAction = "EmbeddedResource" + /> + <File + RelPath = "TickerSelectors\TickerSelectorForm.cs" + SubType = "Form" + BuildAction = "Compile" + /> + <File + RelPath = "TickerSelectors\TickerSelectorForm.resx" + DependentUpon = "TickerSelectorForm.cs" + BuildAction = "EmbeddedResource" + /> + <File RelPath = "TickerSelectors\TickerViewer.cs" SubType = "Form" |
|
From: Marco M. <mi...@us...> - 2004-04-25 18:10:56
|
Update of /cvsroot/quantproject/QuantProject/b3_Data/Selectors In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8183/b3_Data/Selectors Added Files: ITickerReceiver.cs ITickerSelector.cs Log Message: ITickerSelector and ITickerReceiver interfaces moved to the Selectors folder in the Data layer --- NEW FILE: ITickerReceiver.cs --- /* QuantProject - Quantitative Finance Library ITickerReceiver.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.Data.DataTables; namespace QuantProject.Data.Selectors { /// <summary> /// Interface to be implemented by objects that can receive tickers /// </summary> public interface ITickerReceiver { void ReceiveTickers(TickerDataTable tickersToReceive); } } --- NEW FILE: ITickerSelector.cs --- /* QuantProject - Quantitative Finance Library ITickerSelector.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 QuantProject.Data.DataTables; namespace QuantProject.Data.Selectors { /// <summary> /// Interface to be implemented by tickers' selectors /// </summary> public interface ITickerSelector { void SelectAllTickers(); TickerDataTable GetTableOfSelectedTickers(); } } |
|
From: Marco M. <mi...@us...> - 2004-04-25 17:40:08
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9708/b2_DataAccess/Tables Modified Files: Quotes.cs Tickers.cs Log Message: Added new methods to the class (also cleaned code in Tickers class) Index: Tickers.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Tickers.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** Tickers.cs 17 Apr 2004 13:59:28 -0000 1.1 --- Tickers.cs 25 Apr 2004 17:37:52 -0000 1.2 *************** *** 33,72 **** public class Tickers { ! private TickerDataTable tickerDataTable; ! private static TickerDataTable clipboard; private int count; public Tickers() { ! this.tickerDataTable = (TickerDataTable)SqlExecutor.GetDataTable("SELECT * FROM tickers"); ! this.count = this.Table.Rows.Count; ! } ! ! /// <summary> ! /// Ticker Table containing tickers to use like a clipboard ! /// </summary> ! public static TickerDataTable Clipboard ! { ! get ! { ! return Tickers.clipboard; ! } ! set ! { ! Tickers.clipboard = value; ! } } - - /// <summary> - /// Table containing all records of the DB table "tickers" - /// </summary> - public TickerDataTable Table - { - get - { - return this.tickerDataTable; - } - } /// <summary> /// Number of tickers in tickers table --- 33,51 ---- public class Tickers { ! ! // these static fields provide field name in the database table ! // They are intended to be used through intellisense when necessary ! public static string Ticker = "tiTicker"; ! public static string CompanyName = "tiCompanyName"; ! ! private DataTable tickers; private int count; public Tickers() { ! this.tickers = SqlExecutor.GetDataTable("SELECT * FROM tickers"); ! this.count = this.tickers.Rows.Count; } /// <summary> /// Number of tickers in tickers table *************** *** 80,83 **** --- 59,63 ---- } + public static DataTable GetTableOfFilteredTickers(string tickerSymbolIsLike, string tickerCompanyNameIsLike) Index: Quotes.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** Quotes.cs 17 Apr 2004 14:01:17 -0000 1.3 --- Quotes.cs 25 Apr 2004 17:37:52 -0000 1.4 *************** *** 129,132 **** --- 129,156 ---- } } + /// <summary> + /// returns most liquid tickers with the given features + /// </summary> + + public static DataTable GetMostLiquidTickers( string groupID, + DateTime firstQuoteDate, + DateTime lastQuoteDate, + long maxNumOfReturnedTickers) + { + string sql = "SELECT TOP " + maxNumOfReturnedTickers + " tickers.tiTicker, tickers.tiCompanyName, " + + "Avg([quVolume]*[quAdjustedClose]) AS AverageTradedValue " + + "FROM quotes INNER JOIN (tickers INNER JOIN tickers_tickerGroups " + + "ON tickers.tiTicker = tickers_tickerGroups.ttTiId) " + + "ON quotes.quTicker = tickers_tickerGroups.ttTiId " + + "WHERE tickers_tickerGroups.ttTgId='" + groupID + "' " + + "AND quotes.quDate BETWEEN " + + SQLBuilder.GetDateConstant(firstQuoteDate) + " AND " + + SQLBuilder.GetDateConstant(lastQuoteDate) + + "GROUP BY tickers.tiTicker, tickers.tiCompanyName " + + "ORDER BY Avg([quVolume]*[quAdjustedClose]) DESC"; + + return SqlExecutor.GetDataTable( sql ); + } + #region GetHashValue |
|
From: Marco M. <mi...@us...> - 2004-04-25 17:39:44
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9708/b2_DataAccess Modified Files: b2_DataAccess.csproj Log Message: Added new methods to the class (also cleaned code in Tickers class) Index: b2_DataAccess.csproj =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/b2_DataAccess.csproj,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** b2_DataAccess.csproj 21 Apr 2004 12:07:52 -0000 1.8 --- b2_DataAccess.csproj 25 Apr 2004 17:37:52 -0000 1.9 *************** *** 138,157 **** /> <File ! RelPath = "Tables\ValidatedTickers.cs" SubType = "Code" BuildAction = "Compile" /> <File ! RelPath = "Tables\TickerDataTable.cs" ! SubType = "Component" ! BuildAction = "Compile" ! /> ! <File ! RelPath = "Tables\TickerDataTable.resx" ! DependentUpon = "TickerDataTable.cs" ! BuildAction = "EmbeddedResource" ! /> ! <File ! RelPath = "Tables\Tickers.cs" SubType = "Code" BuildAction = "Compile" --- 138,147 ---- /> <File ! RelPath = "Tables\Tickers.cs" SubType = "Code" BuildAction = "Compile" /> <File ! RelPath = "Tables\ValidatedTickers.cs" SubType = "Code" BuildAction = "Compile" |
|
From: Marco M. <mi...@us...> - 2004-04-25 17:39:27
|
Update of /cvsroot/quantproject/QuantProject/b3_Data/DataTables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5938/DataTables Log Message: Directory /cvsroot/quantproject/QuantProject/b3_Data/DataTables added to the repository |
|
From: Marco M. <mi...@us...> - 2004-04-25 17:37:40
|
Update of /cvsroot/quantproject/QuantProject/b3_Data In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9434/b3_Data Modified Files: b3_Data.csproj Log Message: Added new folders (DataTables and Selectors in Data layer) Index: b3_Data.csproj =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b3_Data/b3_Data.csproj,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** b3_Data.csproj 11 Oct 2003 20:05:18 -0000 1.1.1.1 --- b3_Data.csproj 25 Apr 2004 17:36:20 -0000 1.2 *************** *** 131,134 **** --- 131,164 ---- BuildAction = "Compile" /> + <File + RelPath = "DataTables\TickerDataTable.cs" + SubType = "Component" + BuildAction = "Compile" + /> + <File + RelPath = "Selectors\ITickerReceiver.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "Selectors\ITickerSelector.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "Selectors\SelectionRule.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "Selectors\SelectionType.cs" + SubType = "Code" + BuildAction = "Compile" + /> + <File + RelPath = "Selectors\TickerSelector.cs" + SubType = "Code" + BuildAction = "Compile" + /> </Include> </Files> |
|
From: Marco M. <mi...@us...> - 2004-04-25 17:36:55
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7753/b2_DataAccess/Tables Removed Files: TickerDataTable.cs Log Message: TickerDataTable moved to the new DataTables folder in the Data layer --- TickerDataTable.cs DELETED --- |
