public void SevenDay()
{
string fn = Path.Combine(TestData.DataPath, "sevendayavg.xls");
var s = new ExcelDataReaderSeries(fn, "Sheet1", "A", "B");
s.Read();
Assert.AreEqual(2738, s.Count);
var s7 = Math.WeeklyAverageSimple(s);
s7.WriteToConsole();
Assert.AreEqual(DateTime.Parse("2004-02-12 23:59:59.9"), s7[0].DateTime);
Assert.AreEqual(2.17, s7[0].Value, 0.01);
Assert.AreEqual(101.32, s7[1].Value, 0.01);
}
private static void Weekly(TextSeries s)
{
s.Read(DateTime.Parse("2/6/2004"), DateTime.Parse("12/31/2004"));
double mf = Point.MissingValueFlag;
Point.MissingValueFlag = -9999;
s.RemoveMissing();
Point.MissingValueFlag = mf;
s.TimeInterval = TimeInterval.Daily;
var weekly = Math.WeeklyAverageSimple(s);
Assert.AreEqual(TimeInterval.Weekly, weekly.TimeInterval);
Assert.AreEqual(DateTime.Parse("2/12/2004"), weekly[0].DateTime.Date);
Assert.AreEqual(2.172, weekly[0].Value, 0.01);
}
