quantproject-developers Mailing List for QuantProject (Page 133)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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

Added Files:
	GroupQuotes.cs 
Log Message:
Added GroupQuotes to the project.

--- NEW FILE: GroupQuotes.cs ---
/*
QuantDownloader - Quantitative Finance Library

GroupQuotes.cs
Copyright (C) 2004 
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 System.Text;
using QuantProject.ADT;
using QuantProject.ADT.Histories;
using QuantProject.DataAccess;
using QuantProject.DataAccess.Tables;

namespace QuantProject.Data.DataTables
{
	/// <summary>
	/// DataTable for quotes of the tickers inside a given group
	/// </summary>
	public class GroupQuotes : DataTable
	{
    private string groupID;

    public GroupQuotes( string groupID, DateTime startDate, DateTime endDate)
    {
      this.groupID = groupID;
      this.fillDataTable( 
        groupID ,startDate, endDate);

    }

    private void setPrimaryKeys()
    {
      DataColumn[] columnPrimaryKeys = new DataColumn[2];
      columnPrimaryKeys[0] = this.Columns[Quotes.TickerFieldName];
      columnPrimaryKeys[1] = this.Columns[Quotes.Date];
      this.PrimaryKey = columnPrimaryKeys;
    }

    private void fillDataTable( string groupID , DateTime startDate , DateTime endDate )
    {
      QuantProject.DataAccess.Tables.Quotes.SetDataTable( 
        groupID , startDate , endDate , this );
      this.setPrimaryKeys(); 
    }

		/// <summary>
		/// Gets the groupID whose quotes are contained into the GroupQuotes object
		/// </summary>
		/// <returns></returns>
		public string GroupID
		{
			get{ return groupID; }
		}

    /// <summary>
    /// Gets the adjusted close for the given ticker at the given date
    /// </summary>
    /// <returns></returns>
    public float GetAdjustedClose( string ticker, DateTime date )
    {
      object[] keys = new object[2];
      keys[0] = ticker;
      keys[1] = date.Date;
      DataRow foundRow = this.Rows.Find(keys);
      if(foundRow==null)
        throw new Exception("No quote for such ticker and date!");
      return (float)foundRow[Quotes.AdjustedClose]; 
    }

    /// <summary>
    /// Gets the date of the first quote for the given ticker 
    /// </summary>
    /// <returns></returns>
    public DateTime GetStartDate(string ticker)
    {
      //if (!this.HasTicker(ticker))
        //throw new Exception("There's no such a ticker in the given group!");
      DataRow[] rows = this.Select(Quotes.TickerFieldName + "='" + ticker + "'", Quotes.Date);
      return (DateTime) rows[0][Quotes.Date];
    }

    /// <summary>
    /// Gets the date of the last quote for the given ticker
    /// </summary>
    /// <returns></returns>
    public DateTime GetEndDate(string ticker)
    {
      //if (!this.HasTicker(ticker))
          //throw new Exception("There's no such a ticker in the given group!");
      DataRow[] rows = this.Select(Quotes.TickerFieldName + "='" + ticker + "'", Quotes.Date);
      return (DateTime) rows[rows.Length - 1][Quotes.Date];
    }

    /// <summary>
    /// Returns true if a quote is available at the given date for a specific ticker
    /// </summary>
    /// <param name="ticker">ticker inside the group</param>
    /// <param name="date">date</param>
    /// <returns></returns>
    public bool HasDate( string ticker, DateTime date )
    {
      bool hasDate;
      object[] keys = new object[2];
      keys[0] = ticker;
      keys[1] = date.Date;
      hasDate = this.Rows.Contains(keys);
      return hasDate;
    }

    /// <summary>
    /// Returns true if the given ticker is contained into the groupQuotes object
    /// </summary>
    /// <param name="ticker">ticker inside the group</param>
    /// <param name="date">date</param>
    /// <returns></returns>
    public bool HasTicker(string ticker)
    {
      DataRow[] rows = this.Select(Quotes.TickerFieldName + "='" + ticker + "'");
      return rows.Length>0;
    }

    /// <summary>
    /// If the given ticker has a quote at the given date, then it returns the given date,
    /// else it returns the immediate following date at which a quote is available
    /// </summary>
    /// <param name="date">date</param>
    /// <returns></returns>
    public DateTime GetQuoteDateOrFollowing(string ticker, DateTime date )
    {
      if(this.HasDate(ticker, date))
      {
        return date;
      }
      else
      {
        return GetQuoteDateOrFollowing(ticker, date.AddDays(1));
      }
    }

    /// <summary>
    /// If the given ticker has a quote at the given date, then it returns the given date,
    /// else it returns the immediate preceding date at which a quote is available
    /// </summary>
    /// <param name="date">date</param>
    /// <returns></returns>
    public DateTime GetQuoteDateOrPreceding( string ticker, DateTime date )
    {
      if(this.HasDate(ticker, date))
      {
        return date;
      }
      else
      {
        return GetQuoteDateOrPreceding(ticker, date.AddDays(-1));
      }
    }

    /// <summary>
    /// Returns the number of quotes for the given ticker contained into the GroupQuotes object 
    /// </summary>
    /// <param name="ticker">ticker for which the number of quotes has to be returned</param>
    /// <returns></returns>
    public int GetNumberOfQuotes( string ticker )
    {
      DataRow[] rows = this.Select(Quotes.TickerFieldName + "='" + ticker + "'");
      return rows.Length;
    }

    /// <summary>
    /// If the given ticker has a quote at the given date, then it returns the given date,
    /// else it returns the first valid following date at which a quote is available
    /// (or the first valid preceding date, in case date is >= the last available quote) 
    /// </summary>
    /// <param name="date">date</param>
    /// <returns></returns>
    public DateTime GetFirstValidQuoteDate(string ticker, DateTime date)
    {
      DateTime startDate =  this.GetStartDate(ticker);
      DateTime endDate = this.GetEndDate(ticker);
      if(date<startDate || (date>=startDate && date<=endDate))
      {
        return this.GetQuoteDateOrFollowing(ticker, date);
      }
      else
      {
        return this.GetQuoteDateOrPreceding(ticker, date);
      }
    }

	}
}

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