quantproject-developers Mailing List for QuantProject (Page 134)
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-06-25 14:09:38
|
Update of /cvsroot/quantproject/QuantProject/b3_Data In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30345/b3_Data Added Files: ExtendeDataTable.cs Log Message: Extended DataTable --- NEW FILE: ExtendeDataTable.cs --- using System; using QuantProject.DataAccess; namespace QuantProject.Data { /// <summary> /// Extended DataTable /// </summary> public class ExtendedDataTable : QuantProject.ADT.ExtendedDataTable { private OleDbSingleTableAdapter oleDbSingleTableAdapter; public ExtendedDataTable( string sql ) { this.oleDbSingleTableAdapter = new OleDbSingleTableAdapter( sql , this ); } public void Update() { this.oleDbSingleTableAdapter.OleDbDataAdapter.Update( this ); } } } |
|
From: Glauco S. <gla...@us...> - 2004-06-20 19:09:19
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10529/b2_DataAccess Modified Files: OleDbSingleTableAdapter.cs Log Message: Fixed minor bug: one costructor was forgetting to initialize the private DataTable Index: OleDbSingleTableAdapter.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/OleDbSingleTableAdapter.cs,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** OleDbSingleTableAdapter.cs 12 Jun 2004 23:03:00 -0000 1.5 --- OleDbSingleTableAdapter.cs 20 Jun 2004 19:09:10 -0000 1.6 *************** *** 55,60 **** try { - //this.dataTable = new DataTable(); - //the member is already set by the constructor this.oleDbDataAdapter = new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection ); --- 55,58 ---- *************** *** 86,89 **** --- 84,88 ---- public OleDbSingleTableAdapter() { + this.dataTable = new DataTable(); } |
|
From: Marco M. <mi...@us...> - 2004-06-20 10:18:11
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13534/Downloader/TickerSelectors Modified Files: TickerViewerMenu.cs Log Message: Fixed a minor bug Index: TickerViewerMenu.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerViewerMenu.cs,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** TickerViewerMenu.cs 22 May 2004 07:06:39 -0000 1.3 --- TickerViewerMenu.cs 20 Jun 2004 10:18:00 -0000 1.4 *************** *** 27,30 **** --- 27,31 ---- using QuantProject.Data.DataTables; using QuantProject.Data.Selectors; + //using QuantProject.Applications.Downloader.TickerSelectors; namespace QuantProject.Applications.Downloader.TickerSelectors *************** *** 46,49 **** --- 47,51 ---- new MenuItem("C&ompute Close to Close ratios"); private MenuItem menuItemQuotesEditor = new MenuItem("&Open Quotes Editor"); + private MenuItem menuItemTickerSelectorForm = new MenuItem("&Open Ticker Selector"); public TickerViewerMenu(Form ITickerSelectorForm) *************** *** 57,61 **** this.menuItemQuotesEditor.Click += new System.EventHandler(this.openQuotesEditor); this.menuItemComputeCloseToCloseRatios.Click += new System.EventHandler(this.computeCloseToCloseRatios); ! this.MenuItems.Add(this.menuItemSelectAll); this.MenuItems.Add(this.menuItemDownload); --- 59,64 ---- this.menuItemQuotesEditor.Click += new System.EventHandler(this.openQuotesEditor); this.menuItemComputeCloseToCloseRatios.Click += new System.EventHandler(this.computeCloseToCloseRatios); ! this.menuItemTickerSelectorForm.Click += new System.EventHandler(this.openTickerSelectorForm); ! this.MenuItems.Add(this.menuItemSelectAll); this.MenuItems.Add(this.menuItemDownload); *************** *** 63,66 **** --- 66,70 ---- this.MenuItems.Add(this.menuItemCopy); this.MenuItems.Add(this.menuItemQuotesEditor); + this.MenuItems.Add(this.menuItemTickerSelectorForm); this.MenuItems.Add(this.menuItemComputeCloseToCloseRatios); *************** *** 143,147 **** } ! } } --- 147,159 ---- } ! private void openTickerSelectorForm(object sender, System.EventArgs e) ! { ! ITickerSelector iTickerSelector = (ITickerSelector)this.parentForm; ! TickerDataTable tableOfSelectedTickers = iTickerSelector.GetTableOfSelectedTickers(); ! TickerSelectorForm selectorForm = new TickerSelectorForm(tableOfSelectedTickers); ! selectorForm.Show(); ! } ! ! } } |
|
From: Marco M. <mi...@us...> - 2004-06-20 10:16:22
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12428/Downloader/TickerSelectors Modified Files: TickerSelectorForm.cs Log Message: Added an overloaded constructor, necessary for the application of a rule upon a set of tickers selected manually by the user with a form implementing ITickerSelector (tickerViewer or tickerGroupsViewer) Index: TickerSelectorForm.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerSelectorForm.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** TickerSelectorForm.cs 19 Jun 2004 01:04:56 -0000 1.2 --- TickerSelectorForm.cs 20 Jun 2004 10:16:09 -0000 1.3 *************** *** 57,60 **** --- 57,61 ---- private System.Windows.Forms.TextBox textBoxMaxNumOfReturnedTickers; private System.Windows.Forms.Label label3; + private DataTable tableOfSelectedTickers; public TickerSelectorForm() *************** *** 71,76 **** --- 72,86 ---- public TickerSelectorForm(string groupID) : this() { + this.Text = "Apply rule to all tickers of the selected group"; this.textBoxGroupID.Text = groupID; } + + public TickerSelectorForm(DataTable tableOfSelectedTickers) : this() + { + this.Text = "Apply rule to the selected tickers"; + this.tableOfSelectedTickers = tableOfSelectedTickers; + this.textBoxGroupID.Enabled = false; + } + /// <summary> /// clean up *************** *** 317,321 **** private void buttonSelectTickers_Click(object sender, System.EventArgs e) { ! //TODO: complete code ... SelectionRule rule = new SelectionRule(SelectionType.MostLiquid, this.textBoxGroupID.Text, this.dateTimePickerFirstDate.Value, --- 327,332 ---- private void buttonSelectTickers_Click(object sender, System.EventArgs e) { ! //TODO: complete code finding a way to construct the right ! // selection rule on the base of what selected by the user SelectionRule rule = new SelectionRule(SelectionType.MostLiquid, this.textBoxGroupID.Text, this.dateTimePickerFirstDate.Value, *************** *** 326,330 **** selector= new TickerSelector(rule); else ! selector= new TickerSelector(QuantProject.Data.DataTables.TickerDataTable.Clipboard,rule); this.dataGrid1.DataSource = selector.GetTableOfSelectedTickers(); this.dataGrid1.Refresh(); --- 337,341 ---- selector= new TickerSelector(rule); else ! selector= new TickerSelector(this.tableOfSelectedTickers,rule); this.dataGrid1.DataSource = selector.GetTableOfSelectedTickers(); this.dataGrid1.Refresh(); |
|
From: Marco M. <mi...@us...> - 2004-06-19 01:13:09
|
Update of /cvsroot/quantproject/QuantProject/b3_Data/Selectors In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14115/b3_Data/Selectors Modified Files: TickerSelector.cs Log Message: Implemented part of the method that retrieves tickers according to a specified rule and a given set of tickers to be filtered Index: TickerSelector.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b3_Data/Selectors/TickerSelector.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** TickerSelector.cs 8 May 2004 17:19:41 -0000 1.2 --- TickerSelector.cs 19 Jun 2004 01:13:00 -0000 1.3 *************** *** 38,43 **** public class TickerSelector : ITickerSelector { private SelectionRule selectionRule; ! public TickerSelector(SelectionRule selectionRule) { --- 38,50 ---- public class TickerSelector : ITickerSelector { + private DataTable setOfTickersToBeSelected = null; private SelectionRule selectionRule; ! ! public TickerSelector(DataTable setOfTickersToBeSelected, SelectionRule selectionRule) ! { ! this.setOfTickersToBeSelected = setOfTickersToBeSelected; ! this.selectionRule = selectionRule; ! } ! public TickerSelector(SelectionRule selectionRule) { *************** *** 47,55 **** public DataTable GetSelectedTickers() { ! //TODO: implement switching code to the proper method of selection ! return QuantProject.DataAccess.Tables.Quotes.GetMostLiquidTickers(this.selectionRule.GroupID, this.selectionRule.FirstQuoteDate, this.selectionRule.LastQuoteDate, this.selectionRule.MaxNumOfReturnedTickers); } --- 54,76 ---- public DataTable GetSelectedTickers() { ! if(this.setOfTickersToBeSelected == null && ! this.selectionRule.TypeOfSelection == SelectionType.MostLiquid) ! { ! return QuantProject.DataAccess.Tables.Quotes.GetMostLiquidTickers(this.selectionRule.GroupID, this.selectionRule.FirstQuoteDate, this.selectionRule.LastQuoteDate, this.selectionRule.MaxNumOfReturnedTickers); + } + else if(this.setOfTickersToBeSelected != null && + this.selectionRule.TypeOfSelection == SelectionType.MostLiquid) + { + return QuantProject.DataAccess.Tables.Quotes.GetMostLiquidTickers(this.setOfTickersToBeSelected, + this.selectionRule.FirstQuoteDate, + this.selectionRule.LastQuoteDate, + this.selectionRule.MaxNumOfReturnedTickers); + } + else + return new DataTable(); + //this line should never be reached!! } |
|
From: Marco M. <mi...@us...> - 2004-06-19 01:07:42
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11155/b2_DataAccess/Tables Modified Files: Quotes.cs Log Message: Added new method on overload that retrieves most liquid tickers from a given set of tickers Index: Quotes.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** Quotes.cs 17 Jun 2004 19:54:42 -0000 1.10 --- Quotes.cs 19 Jun 2004 01:07:32 -0000 1.11 *************** *** 358,362 **** return SqlExecutor.GetDataTable( sql ); } ! #region GetHashValue --- 358,396 ---- return SqlExecutor.GetDataTable( sql ); } ! /// <summary> ! /// returns most liquid tickers within the given set of tickers ! /// </summary> ! ! public static DataTable GetMostLiquidTickers( DataTable setOfTickers, ! DateTime firstQuoteDate, ! DateTime lastQuoteDate, ! long maxNumOfReturnedTickers) ! { ! setOfTickers.Columns.Add("IndexOfLiquidity", System.Type.GetType("System.Double")); ! DataTable getMostLiquidTicker = setOfTickers.Clone(); ! DataTable dt; ! foreach(DataRow row in setOfTickers.Rows) ! { ! string sql = "SELECT quotes.quTicker, " + ! "Avg([quVolume]*[quAdjustedClose]) AS AverageTradedValue " + ! "FROM quotes WHERE quTicker ='" + ! (string)row[0] + "' " + ! "AND quotes.quDate BETWEEN " + SQLBuilder.GetDateConstant(firstQuoteDate) + ! " AND " + SQLBuilder.GetDateConstant(lastQuoteDate) + ! " GROUP BY quotes.quTicker"; ! dt = SqlExecutor.GetDataTable( sql ); ! row["IndexOfLiquidity"] = (double)dt.Rows[0]["AverageTradedValue"]; ! } ! DataRow[] orderedRows = setOfTickers.Select("", "IndexOfLiquidity DESC"); ! object[] valuesToAdd = new object[3]; ! for(long i = 0;i<maxNumOfReturnedTickers && i<setOfTickers.Rows.Count;i++) ! { ! valuesToAdd[0]=orderedRows[i][0]; ! valuesToAdd[1]=orderedRows[i][1]; ! valuesToAdd[2]=orderedRows[i][2]; ! getMostLiquidTicker.Rows.Add(valuesToAdd); ! } ! return getMostLiquidTicker; ! } #region GetHashValue |
|
From: Marco M. <mi...@us...> - 2004-06-19 01:05:05
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9748/Downloader/TickerSelectors Modified Files: TickerSelectorForm.cs Log Message: The ticker selector form now can apply the selected rule to the single tickers chosen by the user Index: TickerSelectorForm.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerSelectors/TickerSelectorForm.cs,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** TickerSelectorForm.cs 26 Apr 2004 12:58:59 -0000 1.1 --- TickerSelectorForm.cs 19 Jun 2004 01:04:56 -0000 1.2 *************** *** 319,326 **** //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(); --- 319,330 ---- //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; ! if(this.textBoxGroupID.Text != "") ! selector= new TickerSelector(rule); ! else ! selector= new TickerSelector(QuantProject.Data.DataTables.TickerDataTable.Clipboard,rule); this.dataGrid1.DataSource = selector.GetTableOfSelectedTickers(); this.dataGrid1.Refresh(); |
|
From: Marco M. <mi...@us...> - 2004-06-17 19:54:51
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18154/b2_DataAccess/Tables Modified Files: Quotes.cs Log Message: Added method to update adjusted close Index: Quotes.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** Quotes.cs 13 Jun 2004 11:10:03 -0000 1.9 --- Quotes.cs 17 Jun 2004 19:54:42 -0000 1.10 *************** *** 482,485 **** --- 482,497 ---- SqlExecutor.ExecuteNonQuery (sql); } + + /// <summary> + /// Provides updating the database with a new adjusted close for + /// the given ticker at a specified date + /// </summary> + public static void UpdateAdjustedClose( string ticker, DateTime date, double adjustedClose ) + { + string sql = "UPDATE quotes SET quotes.quAdjustedClose=" + + adjustedClose + " WHERE quotes.quTicker='" + ticker + "' AND " + + "quotes.quDate=" + SQLBuilder.GetDateConstant(date); + SqlExecutor.ExecuteNonQuery (sql); + } /* Now useless |
|
From: Marco M. <mi...@us...> - 2004-06-17 19:53:47
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17166/Downloader Modified Files: TickerDownloader.cs Log Message: The ticker downloader now is able to update adjusted close automatically (all quotes are downloaded unless the close to close ratio has changed). The downloader is complete for the two options available in the web downloader Index: TickerDownloader.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerDownloader.cs,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** TickerDownloader.cs 12 Jun 2004 23:03:50 -0000 1.8 --- TickerDownloader.cs 17 Jun 2004 19:53:31 -0000 1.9 *************** *** 346,353 **** --- 346,359 ---- this.updateCurrentStatusAdjustedCloseToCloseRatio("Changed at " + Quotes.DateWithDifferentCloseToClose); + //stop } else { this.updateCurrentStatusAdjustedCloseToCloseRatio("OK"); + this.updateAdjustedClose(); + this.updateCurrentStatusAdjustedClose("Updated!"); + this.downloadedValuesFromSource = this.getTableOfDownloadedValues(Quotes.GetEndDate(this.p_quTicker), + DateTime.Now); + this.commitDownloadedValuesToDatabase(); } } *************** *** 366,369 **** --- 372,382 ---- } + private void updateAdjustedClose() + { + foreach(DataRow row in this.downloadedValuesFromSource.Rows) + { + Quotes.UpdateAdjustedClose(this.p_quTicker, (DateTime)row[Quotes.Date], (float)row[Quotes.AdjustedClose]); + } + } |
|
From: Marco M. <mi...@us...> - 2004-06-17 19:50:11
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13855/Downloader Modified Files: WebDownloader.cs Log Message: Temporarily enabled two options in web downloader (to be tested yet) Index: WebDownloader.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/WebDownloader.cs,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** WebDownloader.cs 12 Jun 2004 23:03:50 -0000 1.14 --- WebDownloader.cs 17 Jun 2004 19:50:00 -0000 1.15 *************** *** 295,301 **** // radioButtonAllAvailableUntilNowSinceStartingDate // ! this.radioButtonAllAvailableUntilNowSinceStartingDate.Location = new System.Drawing.Point(8, 56); this.radioButtonAllAvailableUntilNowSinceStartingDate.Name = "radioButtonAllAvailableUntilNowSinceStartingDate"; ! this.radioButtonAllAvailableUntilNowSinceStartingDate.Size = new System.Drawing.Size(272, 24); this.radioButtonAllAvailableUntilNowSinceStartingDate.TabIndex = 12; this.radioButtonAllAvailableUntilNowSinceStartingDate.Text = "All available quotes until now, changing starting date"; --- 295,301 ---- // radioButtonAllAvailableUntilNowSinceStartingDate // ! this.radioButtonAllAvailableUntilNowSinceStartingDate.Location = new System.Drawing.Point(8, 48); this.radioButtonAllAvailableUntilNowSinceStartingDate.Name = "radioButtonAllAvailableUntilNowSinceStartingDate"; ! this.radioButtonAllAvailableUntilNowSinceStartingDate.Size = new System.Drawing.Size(272, 32); this.radioButtonAllAvailableUntilNowSinceStartingDate.TabIndex = 12; this.radioButtonAllAvailableUntilNowSinceStartingDate.Text = "All available quotes until now, changing starting date"; *************** *** 349,365 **** // radioButtonDownloadBeforeMinAndAfterMax // this.radioButtonDownloadBeforeMinAndAfterMax.Location = new System.Drawing.Point(16, 56); this.radioButtonDownloadBeforeMinAndAfterMax.Name = "radioButtonDownloadBeforeMinAndAfterMax"; this.radioButtonDownloadBeforeMinAndAfterMax.Size = new System.Drawing.Size(256, 32); this.radioButtonDownloadBeforeMinAndAfterMax.TabIndex = 2; ! this.radioButtonDownloadBeforeMinAndAfterMax.Text = "Download only quotes before first quote and after last quote"; // // radioButtonOverWriteNo // this.radioButtonOverWriteNo.Location = new System.Drawing.Point(16, 96); this.radioButtonOverWriteNo.Name = "radioButtonOverWriteNo"; this.radioButtonOverWriteNo.Size = new System.Drawing.Size(256, 32); this.radioButtonOverWriteNo.TabIndex = 1; ! this.radioButtonOverWriteNo.Text = "Download all quotes, adding to database only the missing ones"; // // radioButtonOverWriteYes --- 349,367 ---- // radioButtonDownloadBeforeMinAndAfterMax // + this.radioButtonDownloadBeforeMinAndAfterMax.Enabled = false; this.radioButtonDownloadBeforeMinAndAfterMax.Location = new System.Drawing.Point(16, 56); this.radioButtonDownloadBeforeMinAndAfterMax.Name = "radioButtonDownloadBeforeMinAndAfterMax"; this.radioButtonDownloadBeforeMinAndAfterMax.Size = new System.Drawing.Size(256, 32); this.radioButtonDownloadBeforeMinAndAfterMax.TabIndex = 2; ! this.radioButtonDownloadBeforeMinAndAfterMax.Text = "Download only quotes before first quote and after last quote (TO BE TESTED)"; // // radioButtonOverWriteNo // + this.radioButtonOverWriteNo.Enabled = false; this.radioButtonOverWriteNo.Location = new System.Drawing.Point(16, 96); this.radioButtonOverWriteNo.Name = "radioButtonOverWriteNo"; this.radioButtonOverWriteNo.Size = new System.Drawing.Size(256, 32); this.radioButtonOverWriteNo.TabIndex = 1; ! this.radioButtonOverWriteNo.Text = "Download all quotes, adding to database only the missing ones (TO BE TESTED)"; // // radioButtonOverWriteYes *************** *** 564,568 **** private void downloadQuotes_withTickerDataSet( DataSet ds ) { - Cursor.Current = Cursors.WaitCursor; downloadQuotes_withTickerDataSet_create_dsTickerCurrentlyDownloaded( ds.Tables[0] ); foreach (DataRow myRow in ds.Tables[0].Rows) --- 566,569 ---- *************** *** 581,585 **** qd.DownloadTicker(); } - Cursor.Current = Cursors.Default; //newThread.Join(); --- 582,585 ---- |
|
From: Marco M. <mi...@us...> - 2004-06-13 11:10:13
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19367/b2_DataAccess/Tables Modified Files: Quotes.cs Log Message: Changed max differences tolerated for new adjusted values and simplified computation Index: Quotes.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** Quotes.cs 26 May 2004 15:30:09 -0000 1.8 --- Quotes.cs 13 Jun 2004 11:10:03 -0000 1.9 *************** *** 207,211 **** { float adjustedCloseInDatabase; ! double absoluteRelativeDifference; DataTable tableOfSingleRow = SqlExecutor.GetDataTable("SELECT * FROM quotes WHERE quTicker='" + --- 207,211 ---- { float adjustedCloseInDatabase; ! double absoluteDifference; DataTable tableOfSingleRow = SqlExecutor.GetDataTable("SELECT * FROM quotes WHERE quTicker='" + *************** *** 213,219 **** SQLBuilder.GetDateConstant(dateToCheck)); adjustedCloseInDatabase = (float)(tableOfSingleRow.Rows[0]["quAdjustedClose"]); ! absoluteRelativeDifference = ! Math.Abs((currentAdjustedValueFromSource - adjustedCloseInDatabase)/currentAdjustedValueFromSource); ! if(absoluteRelativeDifference>ConstantsProvider.MaxRelativeDifferenceForAdjustedValues) isAdjustedCloseChanged = true; return isAdjustedCloseChanged; --- 213,218 ---- SQLBuilder.GetDateConstant(dateToCheck)); adjustedCloseInDatabase = (float)(tableOfSingleRow.Rows[0]["quAdjustedClose"]); ! absoluteDifference = Math.Abs(currentAdjustedValueFromSource - adjustedCloseInDatabase); ! if(absoluteDifference>ConstantsProvider.MaxDifferenceForAdjustedValues) isAdjustedCloseChanged = true; return isAdjustedCloseChanged; *************** *** 237,241 **** double adjCTCInDatabase; double adjCTCInSource; ! double absoluteRelativeDifference; DataRow rowToCheck; for(int i = 0;i != numRows;i++) --- 236,240 ---- double adjCTCInDatabase; double adjCTCInSource; ! double absoluteDifference; DataRow rowToCheck; for(int i = 0;i != numRows;i++) *************** *** 247,269 **** { adjCTCInSource = (double)rowToCheck[Quotes.AdjustedCloseToCloseRatio]; ! if(adjCTCInSource != 0) ! { ! absoluteRelativeDifference = Math.Abs((adjCTCInDatabase - adjCTCInSource)/adjCTCInSource); ! if(absoluteRelativeDifference > ConstantsProvider.MaxRelativeDifferenceForCloseToCloseRatios ) ! { ! Quotes.DateWithDifferentCloseToClose = date; ! return true; ! } ! } ! else if(adjCTCInSource == 0) ! { ! absoluteRelativeDifference = Math.Abs(adjCTCInDatabase - adjCTCInSource); ! if(absoluteRelativeDifference > ConstantsProvider.MaxRelativeDifferenceForCloseToCloseRatios ) ! { ! Quotes.DateWithDifferentCloseToClose = date; ! return true; ! } ! ! } } } --- 246,255 ---- { adjCTCInSource = (double)rowToCheck[Quotes.AdjustedCloseToCloseRatio]; ! absoluteDifference = Math.Abs(adjCTCInDatabase - adjCTCInSource); ! if(absoluteDifference > ConstantsProvider.MaxDifferenceForCloseToCloseRatios ) ! { ! Quotes.DateWithDifferentCloseToClose = date; ! return true; ! } } } *************** *** 274,278 **** } return false; - } --- 260,263 ---- *************** *** 290,294 **** float previousClose; float currentClose; - double currentCloseToCloseRatio; DateTime date; DataRow rowToBeChanged; --- 275,278 ---- *************** *** 298,317 **** rowToBeChanged = tableOfAllQuotesOfAGivenTicker.Rows.Find(date); if(i == 0) ! //the first available quote has 0 as closeToClose ratio { rowToBeChanged[Quotes.AdjustedCloseToCloseRatio] = 0; } else { previousClose = (float)orderedDyDate[i-1].Row[Quotes.AdjustedClose]; currentClose = (float)orderedDyDate[i].Row[Quotes.AdjustedClose]; ! currentCloseToCloseRatio = (double)orderedDyDate[i].Row[Quotes.AdjustedCloseToCloseRatio]; ! ! if(previousClose != 0 && (currentCloseToCloseRatio == 0 && ! (previousClose != currentClose))) ! // if the previouse adj close is not 0 and the current CTC should not be 0 ! // because previous and current are not equal ! rowToBeChanged[Quotes.AdjustedCloseToCloseRatio] = ! (currentClose - previousClose)/previousClose; } --- 282,300 ---- rowToBeChanged = tableOfAllQuotesOfAGivenTicker.Rows.Find(date); if(i == 0) ! //the first available quote ... ! { + // ... has no closeToClose valid ratio rowToBeChanged[Quotes.AdjustedCloseToCloseRatio] = 0; } else { + //the other quotes have a previous and a current close previousClose = (float)orderedDyDate[i-1].Row[Quotes.AdjustedClose]; currentClose = (float)orderedDyDate[i].Row[Quotes.AdjustedClose]; ! ! if(previousClose != 0) ! // if the previouse adj close is not 0 the CTC value has to be computed ! rowToBeChanged[Quotes.AdjustedCloseToCloseRatio] = currentClose/previousClose; } |
|
From: Marco M. <mi...@us...> - 2004-06-13 11:10:13
|
Update of /cvsroot/quantproject/QuantProject/b1_ADT In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19367/b1_ADT Modified Files: ConstantsProvider.cs Log Message: Changed max differences tolerated for new adjusted values and simplified computation Index: ConstantsProvider.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b1_ADT/ConstantsProvider.cs,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** ConstantsProvider.cs 27 May 2004 16:41:37 -0000 1.5 --- ConstantsProvider.cs 13 Jun 2004 11:10:01 -0000 1.6 *************** *** 20,25 **** public static int TimeOutValue = 15000; public static int NumberOfCheckToPerformOnAdjustedValues = 3; ! public static double MaxRelativeDifferenceForAdjustedValues = 0.0005; ! public static double MaxRelativeDifferenceForCloseToCloseRatios = 0.0001; // max num days allowed by the data source (yahoo) public static double MaxNumDaysDownloadedAtEachConnection = 200; --- 20,25 ---- public static int TimeOutValue = 15000; public static int NumberOfCheckToPerformOnAdjustedValues = 3; ! public static double MaxDifferenceForAdjustedValues = 0.01; ! public static double MaxDifferenceForCloseToCloseRatios = 0.005; // max num days allowed by the data source (yahoo) public static double MaxNumDaysDownloadedAtEachConnection = 200; |
|
From: Marco M. <mi...@us...> - 2004-06-12 23:04:13
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10019/Downloader Modified Files: TickerDownloader.cs WebDownloader.cs Log Message: Fixed minor bug Index: WebDownloader.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/WebDownloader.cs,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** WebDownloader.cs 22 May 2004 07:04:59 -0000 1.13 --- WebDownloader.cs 12 Jun 2004 23:03:50 -0000 1.14 *************** *** 639,647 **** private void button1_Click(object sender, System.EventArgs e) { ! Cursor.Current = Cursors.WaitCursor; this.openDbAndSetOleDbCommand(); this.downloadQuotesOfAllTickers(); this.button1.Enabled = false; ! Cursor.Current = Cursors.Default; } --- 639,647 ---- private void button1_Click(object sender, System.EventArgs e) { ! //Cursor.Current = Cursors.WaitCursor; this.openDbAndSetOleDbCommand(); this.downloadQuotesOfAllTickers(); this.button1.Enabled = false; ! //Cursor.Current = Cursors.Default; } *************** *** 649,657 **** private void buttonDownloadQuotesOfSelectedTickers_Click(object sender, System.EventArgs e) { ! Cursor.Current = Cursors.WaitCursor; this.openDbAndSetOleDbCommand(); this.downloadQuotesOfSelectedTickers(); this.buttonDownloadQuotesOfSelectedTickers.Enabled = false; ! Cursor.Current = Cursors.Default; } --- 649,657 ---- private void buttonDownloadQuotesOfSelectedTickers_Click(object sender, System.EventArgs e) { ! //Cursor.Current = Cursors.WaitCursor; this.openDbAndSetOleDbCommand(); this.downloadQuotesOfSelectedTickers(); this.buttonDownloadQuotesOfSelectedTickers.Enabled = false; ! //Cursor.Current = Cursors.Default; } Index: TickerDownloader.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/TickerDownloader.cs,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** TickerDownloader.cs 26 May 2004 15:42:09 -0000 1.7 --- TickerDownloader.cs 12 Jun 2004 23:03:50 -0000 1.8 *************** *** 411,414 **** --- 411,415 ---- { // update grid in webdownloader form + Cursor.Current = Cursors.WaitCursor; addTickerTo_gridDataSet(); this.numberOfQuotesInDatabase = Quotes.GetNumberOfQuotes(this.p_quTicker); *************** *** 442,445 **** --- 443,448 ---- this.resetAndImportTicker(); } + Cursor.Current = Cursors.Default; + // ticker's quotes are downloaded for the first time or // the user has chosen to download all quotes |
|
From: Marco M. <mi...@us...> - 2004-06-12 23:03:09
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9672/b2_DataAccess Modified Files: OleDbSingleTableAdapter.cs Log Message: Fixed minor bug Index: OleDbSingleTableAdapter.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/OleDbSingleTableAdapter.cs,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** OleDbSingleTableAdapter.cs 27 May 2004 16:43:09 -0000 1.4 --- OleDbSingleTableAdapter.cs 12 Jun 2004 23:03:00 -0000 1.5 *************** *** 55,59 **** try { ! this.dataTable = new DataTable(); this.oleDbDataAdapter = new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection ); --- 55,60 ---- try { ! //this.dataTable = new DataTable(); ! //the member is already set by the constructor this.oleDbDataAdapter = new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection ); |
|
From: Glauco S. <gla...@us...> - 2004-05-28 13:44:29
|
Update of /cvsroot/quantproject/QuantDownloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25549 Modified Files: QuantDownloader.suo Log Message: no message Index: QuantDownloader.suo =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/QuantDownloader.suo,v retrieving revision 1.18 retrieving revision 1.19 diff -C2 -d -r1.18 -r1.19 Binary files /tmp/cvsX04jYr and /tmp/cvsEMDqQ3 differ |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:48:37
|
Update of /cvsroot/quantproject/QuantProject In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4924 Modified Files: QuantProject.suo Log Message: Added validatedTickers support Index: QuantProject.suo =================================================================== RCS file: /cvsroot/quantproject/QuantProject/QuantProject.suo,v retrieving revision 1.31 retrieving revision 1.32 diff -C2 -d -r1.31 -r1.32 Binary files /tmp/cvs0Q7aIg and /tmp/cvsMgwTRq differ |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:47:59
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4840/b2_DataAccess/Tables Modified Files: ValidatedTickers.cs Log Message: Fixed a bug (the end date was written into the StartDate field) Index: ValidatedTickers.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/ValidatedTickers.cs,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** ValidatedTickers.cs 26 May 2004 15:30:09 -0000 1.4 --- ValidatedTickers.cs 27 May 2004 16:47:49 -0000 1.5 *************** *** 64,68 **** oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.Ticker ] = ticker; oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.StartDate ] = startDate; ! oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.StartDate ] = endDate; oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.HashValue ] = hashValue; oleDbSingleTableAdapter.OleDbDataAdapter.Update( oleDbSingleTableAdapter.DataTable ); --- 64,68 ---- oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.Ticker ] = ticker; oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.StartDate ] = startDate; ! oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.EndDate ] = endDate; oleDbSingleTableAdapter.DataTable.Rows[ 0 ][ ValidatedTickers.HashValue ] = hashValue; oleDbSingleTableAdapter.OleDbDataAdapter.Update( oleDbSingleTableAdapter.DataTable ); |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:46:44
|
Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4688/b4_Business/a0_Validation/Validators Modified Files: RangeToRangeValidator.cs Log Message: The ConstantsProvider.DaysForMovingAverageForSuspiciousRatioValidation constant is used, now. Index: RangeToRangeValidator.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators/RangeToRangeValidator.cs,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** RangeToRangeValidator.cs 26 May 2004 15:30:08 -0000 1.3 --- RangeToRangeValidator.cs 27 May 2004 16:46:34 -0000 1.4 *************** *** 87,91 **** validate_currentTicker_set_rangeToRange( currentTicker , currentTickerStartingRowIndex , rangeToRange ); ! rangeToRangeMovingAverage = rangeToRange.GetSimpleMovingAverage( 20 ); validate_currentTicker_withHistories( rangeToRange , rangeToRangeMovingAverage , currentTickerStartingRowIndex , nextTickerStartingRowIndex ); --- 87,92 ---- validate_currentTicker_set_rangeToRange( currentTicker , currentTickerStartingRowIndex , rangeToRange ); ! rangeToRangeMovingAverage = ! rangeToRange.GetSimpleMovingAverage( ConstantsProvider.DaysForMovingAverageForSuspiciousRatioValidation ); validate_currentTicker_withHistories( rangeToRange , rangeToRangeMovingAverage , currentTickerStartingRowIndex , nextTickerStartingRowIndex ); |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:45:57
|
Update of /cvsroot/quantproject/QuantProject/b3_Data/DataTables In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4563/b3_Data/DataTables Modified Files: Quotes.cs Log Message: Performance optimization: the private setHistory variable is introduced and the the setHistory method (to create such new private variable) is introduced. Index: Quotes.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b3_Data/DataTables/Quotes.cs,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** Quotes.cs 26 May 2004 15:30:10 -0000 1.2 --- Quotes.cs 27 May 2004 16:45:38 -0000 1.3 *************** *** 25,28 **** --- 25,30 ---- public static string AdjustedCloseToCloseRatio = "quAdjustedCloseToCloseRatio"; + private History history; + /// <summary> /// Gets the ticker whose quotes are contained into the Quotes object *************** *** 120,123 **** --- 122,134 ---- #endregion + private void setHistory() + { + if ( this.history == null ) + // history has not been set, yet + { + this.history = new History(); + this.history.Import( this , "quDate" , "quAdjustedClose" ); + } + } /// <summary> /// returns the Date for the quote that is precedingDays before *************** *** 129,134 **** public DateTime GetPrecedingDate( DateTime quoteDate , int precedingDays ) { ! History history = new History(); ! history.Import( this , "quDate" , "quAdjustedClose" ); return (DateTime) history.GetKey( Math.Max( 0 , history.IndexOfKeyOrPrevious( quoteDate ) - --- 140,144 ---- public DateTime GetPrecedingDate( DateTime quoteDate , int precedingDays ) { ! setHistory(); return (DateTime) history.GetKey( Math.Max( 0 , history.IndexOfKeyOrPrevious( quoteDate ) - *************** *** 146,151 **** public DateTime GetFollowingDate( DateTime quoteDate , int followingDays ) { ! History history = new History(); ! history.Import( this , "quDate" , "quAdjustedClose" ); return (DateTime) history.GetKey( Math.Max( 0 , history.IndexOfKeyOrPrevious( quoteDate ) - --- 156,160 ---- public DateTime GetFollowingDate( DateTime quoteDate , int followingDays ) { ! setHistory(); return (DateTime) history.GetKey( Math.Max( 0 , history.IndexOfKeyOrPrevious( quoteDate ) - |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:43:19
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4198/b2_DataAccess Modified Files: OleDbSingleTableAdapter.cs Log Message: The dataTable private variable was not created in a particular method. Fixed Index: OleDbSingleTableAdapter.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/OleDbSingleTableAdapter.cs,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** OleDbSingleTableAdapter.cs 26 May 2004 15:38:50 -0000 1.3 --- OleDbSingleTableAdapter.cs 27 May 2004 16:43:09 -0000 1.4 *************** *** 55,58 **** --- 55,59 ---- try { + this.dataTable = new DataTable(); this.oleDbDataAdapter = new OleDbDataAdapter( selectStatement , ConnectionProvider.OleDbConnection ); |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:41:46
|
Update of /cvsroot/quantproject/QuantProject/b1_ADT In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3926/b1_ADT Modified Files: ConstantsProvider.cs Log Message: - Changed the SuspiciousRatio value to a more realistic value ( 7 ) - Added the DaysForMovingAverageForSuspiciousRatioValidation constant Index: ConstantsProvider.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b1_ADT/ConstantsProvider.cs,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** ConstantsProvider.cs 22 May 2004 07:07:51 -0000 1.4 --- ConstantsProvider.cs 27 May 2004 16:41:37 -0000 1.5 *************** *** 14,20 **** // } ! public static int SuspiciousRatio = 3; public static int PrecedingDaysForVisualValidation = 20; ! public static DateTime InitialDateTimeForDownload = new DateTime(1985,1,1); public static int TimeOutValue = 15000; public static int NumberOfCheckToPerformOnAdjustedValues = 3; --- 14,21 ---- // } ! public static int SuspiciousRatio = 7; public static int PrecedingDaysForVisualValidation = 20; ! public static int DaysForMovingAverageForSuspiciousRatioValidation = 20; ! public static DateTime InitialDateTimeForDownload = new DateTime(1985,1,1); public static int TimeOutValue = 15000; public static int NumberOfCheckToPerformOnAdjustedValues = 3; |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:39:16
|
Update of /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3363/b4_Business/a0_Validation/Validators Modified Files: CloseToCloseValidator.cs Log Message: Improved algorithm to check for suspicious close to close ratio (now small changes are not considered suspicious) Index: CloseToCloseValidator.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b4_Business/a0_Validation/Validators/CloseToCloseValidator.cs,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** CloseToCloseValidator.cs 26 May 2004 15:30:08 -0000 1.4 --- CloseToCloseValidator.cs 27 May 2004 16:39:04 -0000 1.5 *************** *** 50,54 **** 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 --- 50,56 ---- DataRow quoteRow , double currentValue , double averageValue ) { ! if ( ! ( currentValue > 0.011 ) && ! ( Math.Abs( currentValue / averageValue ) > ConstantsProvider.SuspiciousRatio ) && ( this.closeToCloseVisuallyValidated.IndexOf( quoteRow[ "quDate" ] ) < 0 ) ) // the current close to close value is suspiciously larger *************** *** 88,92 **** validate_currentTicker_set_closeToClose( currentTicker , currentTickerStartingRowIndex , closeToClose ); ! closeToCloseMovingAverage = closeToClose.GetSimpleMovingAverage( 20 ); validate_currentTicker_withHistories( closeToClose , closeToCloseMovingAverage , currentTickerStartingRowIndex , nextTickerStartingRowIndex ); --- 90,95 ---- validate_currentTicker_set_closeToClose( currentTicker , currentTickerStartingRowIndex , closeToClose ); ! closeToCloseMovingAverage = ! closeToClose.GetSimpleMovingAverage( ConstantsProvider.DaysForMovingAverageForSuspiciousRatioValidation ); validate_currentTicker_withHistories( closeToClose , closeToCloseMovingAverage , currentTickerStartingRowIndex , nextTickerStartingRowIndex ); |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:28:25
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1286/Downloader/QuotesEditor Modified Files: QuotesEditor.cs Log Message: Added a message box that allows the user to validate the full ticker (when the validation process returns no suspicious row) Index: QuotesEditor.cs =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/QuotesEditor/QuotesEditor.cs,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** QuotesEditor.cs 8 May 2004 17:31:39 -0000 1.7 --- QuotesEditor.cs 27 May 2004 16:28:04 -0000 1.8 *************** *** 10,13 **** --- 10,14 ---- using QuantProject.Business.Validation; using QuantProject.Data; + using QuantProject.Data.DataTables; namespace QuantProject.Applications.Downloader *************** *** 42,45 **** --- 43,57 ---- private System.ComponentModel.Container components = null; + private void updateValidateDataTable_validateTicker() + { + if ( MessageBox.Show( this , "This ticker's quotes are ok, with respect to the current " + + "validation process. Do you want to sign current ticker's quotes as valid quotes?" , + "Ticker's quotes validation" , + MessageBoxButtons.YesNo , + MessageBoxIcon.Question , + MessageBoxDefaultButton.Button1 ) == DialogResult.Yes ) + // the user asked to write the visual validation to the database + ValidatedTickers.Validate( this.validateDataTable.Quotes ); // TO DO: remove the beguinning ConstantsProvider.DaysForMovingAverageForSuspiciousRatioValidation rows + } private void updateValidateDataTable() { *************** *** 51,54 **** --- 63,69 ---- // this.validateDataTable.Clear(); this.validateDataTable.AddRows( this.textBoxTicker.Text ); + if ( this.validateDataTable.Rows.Count == 0 ) + // the ticker's quotes have been completely validated + updateValidateDataTable_validateTicker(); } |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:24:51
|
Update of /cvsroot/quantproject/QuantDownloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv520 Modified Files: QuantDownloader.suo Log Message: Minor automatic changes to the project file Index: QuantDownloader.suo =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/QuantDownloader.suo,v retrieving revision 1.17 retrieving revision 1.18 diff -C2 -d -r1.17 -r1.18 Binary files /tmp/cvsv9fz5c and /tmp/cvsT3r7qP differ |
|
From: Glauco S. <gla...@us...> - 2004-05-27 16:24:51
|
Update of /cvsroot/quantproject/QuantDownloader/Downloader In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv520/Downloader Modified Files: Downloader.csproj Log Message: Minor automatic changes to the project file Index: Downloader.csproj =================================================================== RCS file: /cvsroot/quantproject/QuantDownloader/Downloader/Downloader.csproj,v retrieving revision 1.22 retrieving revision 1.23 diff -C2 -d -r1.22 -r1.23 *** Downloader.csproj 26 May 2004 15:44:29 -0000 1.22 --- Downloader.csproj 27 May 2004 16:24:34 -0000 1.23 *************** *** 247,251 **** <File RelPath = "QuotesEditor\VisualValidationChart.cs" ! SubType = "UserControl" BuildAction = "Compile" /> --- 247,251 ---- <File RelPath = "QuotesEditor\VisualValidationChart.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" /> *************** *** 297,301 **** <File RelPath = "QuotesEditor\RangeToRange\RangeToRangeChart.cs" ! SubType = "UserControl" BuildAction = "Compile" /> --- 297,301 ---- <File RelPath = "QuotesEditor\RangeToRange\RangeToRangeChart.cs" ! SubType = "Code" BuildAction = "Compile" /> |
