public void AppendOneToFile()
{
engine = new FileHelperEngine(typeof (SampleType));
SampleType[] res = new SampleType[2];
res[0] = new SampleType();
res[1] = new SampleType();
res[0].Field1 = DateTime.Now.AddDays(1).Date;
res[0].Field2 = "je";
res[0].Field3 = 0;
res[1].Field1 = DateTime.Now.Date;
res[1].Field2 = "ho";
res[1].Field3 = 2;
engine.WriteFile(@"test.txt", res);
SampleType record = new SampleType();
record.Field1 = DateTime.Now.Date;
record.Field2 = "h2";
record.Field3 = 2;
engine.AppendToFile(@"test.txt", record);
SampleType[] res2 = (SampleType[]) engine.ReadFile(@"test.txt");
Assert.AreEqual(3, res2.Length);
Assert.AreEqual(res[0].Field1, res2[0].Field1);
Assert.AreEqual(res[1].Field1, res2[1].Field1);
Assert.AreEqual(DateTime.Now.Date, res2[2].Field1);
}
public void AppendOneToFile()
{
var engine = new FileHelperEngine <SampleType>();
var res = new SampleType[2];
res[0] = new SampleType();
res[1] = new SampleType();
res[0].Field1 = DateTime.Now.AddDays(1).Date;
res[0].Field2 = "je";
res[0].Field3 = 0;
res[1].Field1 = DateTime.Now.Date;
res[1].Field2 = "ho";
res[1].Field3 = 2;
engine.WriteFile(@"test.txt", res);
var record = new SampleType();
record.Field1 = DateTime.Now.Date;
record.Field2 = "h2";
record.Field3 = 2;
engine.AppendToFile(@"test.txt", record);
var res2 = (SampleType[])engine.ReadFile(@"test.txt");
Assert.AreEqual(3, res2.Length);
Assert.AreEqual(res[0].Field1, res2[0].Field1);
Assert.AreEqual(res[1].Field1, res2[1].Field1);
Assert.AreEqual(DateTime.Now.Date, res2[2].Field1);
}
public void AppendToFile()
{
var engine = new FileHelperEngine<SampleType>();
var res = new SampleType[2];
res[0] = new SampleType();
res[1] = new SampleType();
res[0].Field1 = DateTime.Now.AddDays(1).Date;
res[0].Field2 = "je";
res[0].Field3 = 0;
res[1].Field1 = DateTime.Now.Date;
res[1].Field2 = "ho";
res[1].Field3 = 2;
engine.WriteFile(@"test.txt", res);
engine.AppendToFile(@"test.txt", res);
var res2 = (SampleType[]) engine.ReadFile(@"test.txt");
Assert.AreEqual(4, res2.Length);
Assert.AreEqual(res[0].Field1, res2[0].Field1);
Assert.AreEqual(res[1].Field1, res2[1].Field1);
Assert.AreEqual(res[0].Field1, res2[2].Field1);
Assert.AreEqual(res[1].Field1, res2[3].Field1);
}
public void AppendToEmpty()
{
File.Copy(TestCommon.GetPath("Good", "TestEmpty.txt"), "tempEmpty.txt", true);
var engine = new FileHelperEngine <SampleType>();
var res = new SampleType[1];
res[0] = new SampleType();
res[0].Field1 = DateTime.Now.AddDays(1).Date;
res[0].Field2 = "je";
res[0].Field3 = 0;
engine.AppendToFile(@"tempEmpty.txt", res);
var res2 = (SampleType[])engine.ReadFile(@"tempEmpty.txt");
Assert.AreEqual(1, res2.Length);
Assert.AreEqual(res[0].Field1, res2[0].Field1);
if (File.Exists("tempEmpty.txt"))
{
File.Delete("tempEmpty.txt");
}
}
public void PredictionToFile(string webRootPath, string lotteryCode)
{
if (string.IsNullOrEmpty(lotteryCode))
{
lotteryCode = GetLotteryCode();
}
try
{
Dictionary <string, TrainingData> dicPredictionData = GetPredictionData(lotteryCode);
_logger.LogInformation("Start Prediction :" + lotteryCode);
int i = 0, j = 0;
IList <LotteryPredictionResult> resultList = new List <LotteryPredictionResult>();
for (i = 0; i < noSite.Count; i++)
{
for (j = 0; j < noType.Count; j++)
{
resultList.Add(PredictionOneToFile(webRootPath, noSite[i], noType[j], dicPredictionData[noSite[i]], lotteryCode));
}
}
var engine = new FileHelperEngine <LotteryPredictionResult>();
engine.AppendToFile(webRootPath + "/PredictionResult/" + DateTime.Now.ToString("yyyyMMddHH") + ".Txt", resultList);
}
catch (Exception ex)
{
_logger.LogError("预测出错 :" + ex.ToString());
}
}
public void AppendToFile()
{
engine = new FileHelperEngine(typeof(SampleType));
SampleType[] res = new SampleType[2];
res[0] = new SampleType();
res[1] = new SampleType();
res[0].Field1 = DateTime.Now.AddDays(1).Date;
res[0].Field2 = "je";
res[0].Field3 = 0;
res[1].Field1 = DateTime.Now.Date;
res[1].Field2 = "ho";
res[1].Field3 = 2;
engine.WriteFile(@"test.txt", res);
engine.AppendToFile(@"test.txt", res);
SampleType[] res2 = (SampleType[])engine.ReadFile(@"test.txt");
Assert.AreEqual(4, res2.Length);
Assert.AreEqual(res[0].Field1, res2[0].Field1);
Assert.AreEqual(res[1].Field1, res2[1].Field1);
Assert.AreEqual(res[0].Field1, res2[2].Field1);
Assert.AreEqual(res[1].Field1, res2[3].Field1);
}
private static void AppendAllPaymentsDump(string path, List <FHB_Payment> rcds)
{
// Write emulated CPWFHBP1 database. Append records to History File
string newXlsName2 = (Path.Combine(Path.GetDirectoryName(path), "Logs_n_Data", Path.GetFileName(path).Substring(0, 12) + "_All_Payment_History_tab.txt"));
FileHelperEngine <FHB_Payment> engine = new FileHelperEngine <FHB_Payment>();
engine.AppendToFile(newXlsName2, rcds);
}
public static void AddMoreUsersToCsvFile(User user)
{
var filePath = AppDomain.CurrentDomain.BaseDirectory.Substring(0,
AppDomain.CurrentDomain.BaseDirectory.Length - 9) + "/Assets/userData.csv";
var engine = new FileHelperEngine <User>();
engine.AppendToFile(filePath, user);
}
public override void AddEntry(string eventType)
{
var entry = new LogEntry(eventType);
var filename = string.Format("{0:MMddyyHH}.csv", DateTime.Now);
var writeEngine = new FileHelperEngine <LogEntry> ();
writeEngine.AppendToFile(Path.Combine(_currentFilePath, filename), entry);
CallEventLogEntryAddedHandlers(entry);
}
public static void Save(Idea idea)
{
var engine = new FileHelperEngine(typeof(Idea));
try
{
idea.Id = Guid.NewGuid().ToString();
engine.AppendToFile(HttpRuntime.AppDomainAppPath + "/app_data/ideas.csv", idea);
}
catch
{
}
}
public static void Save(Vote vote)
{
var engine = new FileHelperEngine(typeof(Vote));
try
{
vote.Id = Guid.NewGuid().ToString();
engine.AppendToFile(HttpRuntime.AppDomainAppPath + "/app_data/votes.csv", vote);
}
catch
{
}
}
public void SaveMagentoFile(string MagentoFilePath, string HeaderRow, List <iMagentoRecord> mList)
{
try
{
List <MagentoRecord> newlist = mList.Cast <MagentoRecord>().ToList();
FileHelperEngine <MagentoRecord> magentoEngine = new FileHelperEngine <MagentoRecord>();
File.WriteAllText(MagentoFilePath, HeaderRow);
magentoEngine.AppendToFile(MagentoFilePath, newlist);
}
catch
{
List <MagentoRecordSB> newlist = mList.Cast <MagentoRecordSB>().ToList();
FileHelperEngine <MagentoRecordSB> magentoEngine = new FileHelperEngine <MagentoRecordSB>();
File.WriteAllText(MagentoFilePath, HeaderRow);
magentoEngine.AppendToFile(MagentoFilePath, newlist);
}
}
public static void SampleToFile(string path, Triangle sample)
{
var engine = new FileHelperEngine(typeof(Triangle));
if (File.Exists(path))
{
engine.AppendToFile(path, sample);
}
else
{
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, new List <Triangle>()
{
sample
});
}
}
public void BadAppend2()
{
var engine = new FileHelperEngine <SampleType>();
File.Copy(TestCommon.GetPath("Bad", "BadAdd2.txt"), "BadAddTemp2.txt", true);
SampleType record = new SampleType();
record.Field1 = DateTime.Now.Date;
record.Field2 = "AS";
record.Field3 = 66;
engine.AppendToFile(@"BadAddTemp2.txt", record);
SampleType[] res2 = (SampleType[])engine.ReadFile(@"BadAddTemp2.txt");
Assert.AreEqual(4, res2.Length);
Assert.AreEqual("AS", res2[3].Field2);
Assert.AreEqual(66, res2[3].Field3);
}
static void Main(string[] args)
{
// dummy test data
var originalAllPersonRecords = new Person[]
{
new Person {
FirstName = "John", LastName = "Lee", Optional2 = "title"
},
}; //This will only get the FirstName,LastName,Optional2. No result for Optional1 and Optional3
var allPersonRecords = from p in originalAllPersonRecords select new OutputPerson {
FirstName = p.FirstName, LastName = p.LastName, Optional2 = p.Optional2
};
FileHelperEngine enginePerson = new FileHelperEngine(typeof(OutputPerson));
string fileName = "Wherever you want the file to go";
enginePerson.AppendToFile(fileName, allPersonRecords); //Write the records to the file
//Current Output looks like this:John Lee title
//The output which I want is:John Lee title
}
public void BadAppend2()
{
engine = new FileHelperEngine(typeof(SampleType));
File.Copy(@"..\data\Bad\BadAdd2.txt", "BadAddTemp2.txt", true);
SampleType record = new SampleType();
record.Field1 = DateTime.Now.Date;
record.Field2 = "AS";
record.Field3 = 66;
engine.AppendToFile(@"BadAddTemp2.txt", record);
SampleType[] res2 = (SampleType[])engine.ReadFile(@"BadAddTemp2.txt");
Assert.AreEqual(4, res2.Length);
Assert.AreEqual("AS", res2[3].Field2);
Assert.AreEqual(66, res2[3].Field3);
}
private void writeLogEntry()
{
string logPath = Path.Combine(@"C:\Users\wwestlake\AppData\Roaming\LagDaemon\GameEngine\logs", "ServerLog.txt");
var engine = new FileHelperEngine <ServerLogEntry>();
var log = new List <ServerLogEntry>();
log.Add(new ServerLogEntry()
{
Date = DateTime.Now,
PlayerID = "LagDaemon",
EntryType = LogEntryType.Information,
EntrySeverity = LogEntrySeverity.Low,
Entry = "This is a test log entry"
});
engine.AppendToFile(logPath, log);
}
public static void SampleToFile(string path, ShearTriangle2D sample)
{
var engine = new FileHelperEngine(typeof(ShearTriangle2D));
var samples = new List <ShearTriangle2D>()
{
sample
};
if (File.Exists(path))
{
engine.AppendToFile(path, sample);
}
else
{
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile("C:\\Users\\bergerd\\simplices.csv", new List <ShearTriangle2D>()
{
sample
});
}
}
public static void SampleToFile(string path, Simplex3D sample)
{
var engine = new FileHelperEngine(typeof(Simplex3D));
var samples = new List <Simplex3D>()
{
sample
};
if (File.Exists(path))
{
engine.AppendToFile(path, sample);
}
else
{
engine.HeaderText = engine.GetFileHeader();
engine.WriteFile(path, new List <Simplex3D>()
{
sample
});
}
}
public void AppendToEmpty()
{
File.Copy(TestCommon.GetPath("Good", "TestEmpty.txt"), "tempEmpty.txt", true);
engine = new FileHelperEngine(typeof (SampleType));
SampleType[] res = new SampleType[1];
res[0] = new SampleType();
res[0].Field1 = DateTime.Now.AddDays(1).Date;
res[0].Field2 = "je";
res[0].Field3 = 0;
engine.AppendToFile(@"tempEmpty.txt", res);
SampleType[] res2 = (SampleType[]) engine.ReadFile(@"tempEmpty.txt");
Assert.AreEqual(1, res2.Length);
Assert.AreEqual(res[0].Field1, res2[0].Field1);
if (File.Exists("tempEmpty.txt")) File.Delete("tempEmpty.txt");
}
//add and validates new products to the file.
public void add_product(TextBox tb1, TextBox tb2, ComboBox cb)
{
//using FileHelpers package to read and write to file.
var engine = new FileHelperEngine <products>();
var product = new List <products>();
var x = new products();
if (x.validate_record(tb1, cb) == true)
{
MessageBox.Show("Product is already stocked.");
}
else
{
product.Add(new products()
{
product_name = tb1.Text.ToUpper(),
supplier_name = cb.Text.ToUpper(),
quantity = tb2.Text.ToUpper(),
}
);
engine.AppendToFile(@"D:\RSMS\Files\Stock\Product_Details.txt", product);
MessageBox.Show("Successfully Added");
}
}
static void combineCSV()
{
if (File.Exists(@"C:\Users\Jiahai\Documents\Visual Studio 2012\Projects\UpdateEarning2\UpdateEarning2\bin\Debug\Earingdate.n.csv"))
{
File.Delete(@"C:\Users\Jiahai\Documents\Visual Studio 2012\Projects\UpdateEarning2\UpdateEarning2\bin\Debug\Earingdate.n.csv");
}
string[] files = Directory.GetFiles(@"C:\Users\Jiahai\Documents\Visual Studio 2012\Projects\UpdateEarning2\UpdateEarning2\bin\Debug\symbol\");
for (int i = 0; i < (int)files.Length; i++)
{
string str = files[i];
FileHelperEngine fileHelperEngine = new FileHelperEngine(typeof(symbollistCombine));
symbollistCombine[] symbollistCombineArray = (symbollistCombine[])fileHelperEngine.ReadFile(str);
IEnumerable<symbollistCombine> symbollistCombines = ((IEnumerable<symbollistCombine>)symbollistCombineArray).Where<symbollistCombine>((symbollistCombine d) => d.Earingdate != DateTime.Parse("1999/01/01"));
fileHelperEngine.AppendToFile(@"C:\Users\Jiahai\Documents\Visual Studio 2012\Projects\UpdateEarning2\UpdateEarning2\bin\Debug\Earingdate.n.csv", symbollistCombines);
}
if (File.Exists("C:\\Users\\Jiahai\\Documents\\Visual Studio 2012\\Projects\\earingdataProj\\earingdataProj\\bin\\Debug\\updateEarning.csv"))
{
File.Delete("C:\\Users\\Jiahai\\Documents\\Visual Studio 2012\\Projects\\earingdataProj\\earingdataProj\\bin\\Debug\\updateEarning.csv");
File.Copy(@"C:\Users\Jiahai\Documents\Visual Studio 2012\Projects\UpdateEarning2\UpdateEarning2\bin\Debug\Earingdate.n.csv", "C:\\Users\\Jiahai\\Documents\\Visual Studio 2012\\Projects\\earingdataProj\\earingdataProj\\bin\\Debug\\updateEarning.csv");
}
else
{
File.Copy(@"C:\Users\Jiahai\Documents\Visual Studio 2012\Projects\UpdateEarning2\UpdateEarning2\bin\Debug\Earingdate.n.csv", "C:\\Users\\Jiahai\\Documents\\Visual Studio 2012\\Projects\\earingdataProj\\earingdataProj\\bin\\Debug\\updateEarning.csv");
}
}
private void move_Rectangle(object sender, MouseButtonEventArgs e)
{
int[,] pozice = new int[100, 2];
/*while (true)
* {*/
if (_isRectDragInProg == false)
{
_isRectDragInProg = true;
obj = sender as Rectangle;
Panel.SetZIndex(obj, 100);
//Console.WriteLine(obj.Name);
obj.CaptureMouse();
//Console.WriteLine(pocetradky);
//Console.WriteLine(pocetsloupce);
}
else if (_isRectDragInProg == true)
{
List <Pozice> fill = new List <Pozice>();
List <Pozice> akt = new List <Pozice>();
foreach (UIElement cell in grid.Children)
{
int x = Grid.GetColumn(cell);
int y = Grid.GetRow(cell);
int xa = Grid.GetColumnSpan(cell);
int ya = Grid.GetRowSpan(cell);
if (cell.GetValue(NameProperty).ToString() == obj.Name)
{
Console.WriteLine(cell.GetValue(NameProperty));
Console.WriteLine(obj.Name);
if (xa == 0)
{
akt.Add(new Pozice(x + 1, y));
akt.Add(new Pozice(x, y));
}
else
{
akt.Add(new Pozice(x, y));
}
if (ya == 0)
{
akt.Add(new Pozice(x, y + 1));
akt.Add(new Pozice(x, y));
}
else
{
akt.Add(new Pozice(x, y));
}
}
else
{
Console.WriteLine(cell.GetValue(NameProperty));
if (xa == 0)
{
fill.Add(new Pozice(x + 1, y));
fill.Add(new Pozice(x, y));
}
else
{
fill.Add(new Pozice(x, y));
}
if (ya == 0)
{
fill.Add(new Pozice(x, y + 1));
fill.Add(new Pozice(x, y));
}
else
{
fill.Add(new Pozice(x, y));
}
}
}
foreach (var o in fill)
{
Console.WriteLine(o.x + ", " + o.y);
}
foreach (var d in akt)
{
Console.WriteLine(d.x + ", " + d.y);
}
foreach (var o in akt)
{
foreach (var d in fill)
{
if (d.x == o.x && d.y == o.y)
{
isFilled = true;
Console.WriteLine(isFilled);
}
}
}
if (isFilled == true)
{
_isRectDragInProg = true;
}
else
{
obj.ReleaseMouseCapture();
Panel.SetZIndex(obj, 0);
_isRectDragInProg = false;
var engine = new FileHelperEngine <Position>();
var orders = new List <Position>();
orders.Add(new Position()
{
Name = obj.Name,
xpos = Grid.GetColumn(obj),
ypos = Grid.GetRow(obj)
});
engine.AppendToFile("position.txt", orders);
}
isFilled = false;
/*{
* //break;
* }
* else
* {
* obj.ReleaseMouseCapture();
* _isRectDragInProg = false;
* _isRectDragInProg = true;
* }*/
}
//}
}
public void BadAppend2()
{
engine = new FileHelperEngine(typeof (SampleType));
File.Copy(TestCommon.GetPath("Bad", "BadAdd2.txt"), "BadAddTemp2.txt", true);
SampleType record = new SampleType();
record.Field1 = DateTime.Now.Date;
record.Field2 = "AS";
record.Field3 = 66;
engine.AppendToFile(@"BadAddTemp2.txt", record);
SampleType[] res2 = (SampleType[]) engine.ReadFile(@"BadAddTemp2.txt");
Assert.AreEqual(4, res2.Length);
Assert.AreEqual("AS", res2[3].Field2);
Assert.AreEqual(66, res2[3].Field3);
}
private static void backtest(int quarter,decimal threshold, int buyinpower)
{
TimeSpan st = DateTime.Now.TimeOfDay;
#region hoilday dictionary
bool flag3;
Dictionary<string, DateTime> strs3 = new Dictionary<string, DateTime>();
List<EarningData> earningDatas = new List<EarningData>();
FileStream fileStream1 = new FileStream("holiday.txt", FileMode.Open);
StreamReader streamReader1 = new StreamReader(fileStream1);
do
{
string str1 = streamReader1.ReadLine();
if (!(str1 == ""))
{
strs3[str1] = DateTime.ParseExact(str1, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);
flag3 = (str1 == null ? false : str1 != "");
}
else
{
break;
}
} while (flag3);
streamReader1.Close();
streamReader1.Dispose();
fileStream1.Close();
fileStream1.Dispose();
#endregion
#region get the quarter
int year = quarter / 10;
string begindate = year.ToString();
string enddate = year.ToString();
if (quarter % 10 == 1)
{
begindate = string.Concat(begindate, "0101");
enddate = string.Concat(enddate, "0315");
}
if (quarter % 10 == 2)
{
begindate = string.Concat(begindate, "0401");
enddate = string.Concat(enddate, "0615");
}
if (quarter % 10 == 3)
{
begindate = string.Concat(begindate, "0701");
enddate = string.Concat(enddate, "0915");
}
if (quarter % 10 == 4)
{
begindate = string.Concat(begindate, "1001");
enddate = string.Concat(enddate, "1215");
}
#endregion
#region create bio tech symbols Dic
bool flag2;
Dictionary<string, string> bioArry = new Dictionary<string, string>();
FileStream fileStream = new FileStream("bio.csv", FileMode.Open);
StreamReader streamReader = new StreamReader(fileStream);
streamReader.BaseStream.Seek((long)0, SeekOrigin.Begin);
string str2 = streamReader.ReadLine();
while (true)
{
flag2 = (str2 == null ? false : str2 != "");
if (!flag2)
{
break;
}
bioArry[str2] = str2;
str2 = streamReader.ReadLine();
}
streamReader.Close();
streamReader.Dispose();
fileStream.Close();
fileStream.Dispose();
#endregion
#region get right the earingdata
FileHelperEngine EngineDBq = new FileHelperEngine(typeof(DailyData1));
DailyData1[] resDB = (DailyData1[])EngineDBq.ReadFile(string.Format("Daily\\DailyQua\\{0}.csv", quarter));
FileHelperEngine EngineEarning = new FileHelperEngine(typeof(unionearingdate));
unionearingdate[] unionearingdateArray = (unionearingdate[])EngineEarning.ReadFile("Daily\\final.csv");
var selectEarningdata = unionearingdateArray.Where(d =>
d.date >= DateTime.ParseExact(begindate, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None) &&
d.date <= DateTime.ParseExact(enddate, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None)).
Where(d => Math.Abs(d.threshold) >= threshold).
Where(d => (d.high >= d.maxhigh && d.threshold > 0) || (d.low <= d.minlow && d.threshold < 0)).
Where(d => {
bool symbolExit;
symbolExit = !bioArry.ContainsKey(d.symbol);
return symbolExit;
}).
Where(d=>d.high>=5)
;
EngineEarning.WriteFile("Daily\\temp.csv", selectEarningdata);
unionearingdate[] earningdata = (unionearingdate[])EngineEarning.ReadFile("Daily\\temp.csv");
#endregion
#region combin earning and spy in daily report
#region select data from DB
var spy=resDB.Where(d=>d.symbol=="SPY");
var selectDB = from db in resDB
from e in earningdata
where (db.symbol == e.symbol) && (db.date >= e.date)
select new DailyDataout
{
symbol=db.symbol,
open=db.open,
high=db.high,
low=db.low,
close=db.close,
volume=db.volume,
adv=db.adv,
threshold=e.threshold,
date=db.date
};
selectDB = selectDB.Where(dd => dd.date <= DateTime.ParseExact(enddate, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None));
FileHelperEngine EngineOut = new FileHelperEngine(typeof(DailyDataout));
EngineOut.HeaderText = "symbol,date,open,high,low,close,volume,Exist signal price,pricein,priceout,threshold,spy close,spy open,spy high, spy low,adv,win10,lose10,overnight pnl,day pnl,pnl,spy overnight pnl,spy day pnl, spy pnl,bp,beta";
EngineOut.WriteFile("Daily\\temp.csv", selectDB);
#endregion
#region combine spy
DailyDataout[] selectD = (DailyDataout[])EngineOut.ReadFile("Daily\\temp.csv");
var combinspy = from db in selectD
join e in spy on db.date equals e.date
select new DailyDataout
{
symbol = db.symbol,
open = db.open,
high = db.high,
low = db.low,
close = db.close,
volume = db.volume,
adv = db.adv,
threshold = db.threshold,
date = db.date,
spyclose=e.close,
spyopen=e.open,
spylow=e.low,
spyhigh=e.high
};
#endregion
bool yc2tc = false;
#region add beta
if (yc2tc)
{
#region get beta close to close
List<DailyDataout> newcombinspy = new List<DailyDataout>();
string symbol = "";
decimal beta = 0;
decimal yesterdayClose = 0;
decimal yesterdaySPYClose = 0;
foreach (var data in combinspy)
{
DailyDataout tempdailyout = new DailyDataout();
tempdailyout = data;
if (tempdailyout.symbol == symbol)
{
beta = ((tempdailyout.close / yesterdayClose) / (tempdailyout.spyclose / yesterdaySPYClose) - 1) * 100;
tempdailyout.beta = beta;
yesterdayClose = tempdailyout.close;
yesterdaySPYClose = tempdailyout.spyclose;
}
else
{
symbol = tempdailyout.symbol;
yesterdayClose = tempdailyout.close;
yesterdaySPYClose = tempdailyout.spyclose;
}
newcombinspy.Add(tempdailyout);
}
#endregion
EngineOut.WriteFile("Daily\\temp.csv", newcombinspy);
}
else
{
#region get beta close to open
List<DailyDataout> newcombinspy = new List<DailyDataout>();
string symbol = "";
decimal beta = 0;
foreach (var data in combinspy)
{
DailyDataout tempdailyout = new DailyDataout();
tempdailyout = data;
if (tempdailyout.symbol == symbol)
{
beta = ((tempdailyout.close / tempdailyout.open) / (tempdailyout.spyclose / tempdailyout.spyopen) - 1) * 100;
tempdailyout.beta = beta;
}
else
{
symbol = tempdailyout.symbol;
beta = ((tempdailyout.close / tempdailyout.open) / (tempdailyout.spyclose / tempdailyout.spyopen) - 1) * 100;
}
newcombinspy.Add(tempdailyout);
}
#endregion
EngineOut.WriteFile("Daily\\temp.csv", newcombinspy);
}
#endregion
#endregion
#region date thrshold
DateTime lastDate = DateTime.ParseExact(enddate, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);
if (lastDate.DayOfWeek == DayOfWeek.Sunday)
{
if (strs3.ContainsKey(lastDate.AddDays(-2).ToString("yyyyMMdd")) || strs3.ContainsKey(lastDate.AddDays(-3).ToString("yyyyMMdd")))
{
lastDate = lastDate.AddDays(-4);
}
else
lastDate = lastDate.AddDays(-3);
}
else if (lastDate.DayOfWeek == DayOfWeek.Saturday)
{
if (strs3.ContainsKey(lastDate.AddDays(-1).ToString("yyyyMMdd")) || strs3.ContainsKey(lastDate.AddDays(-2).ToString("yyyyMMdd")))
{
lastDate = lastDate.AddDays(-3);
}
else
lastDate = lastDate.AddDays(-2);
}
else if (lastDate.DayOfWeek == DayOfWeek.Monday)
{
if (strs3.ContainsKey(lastDate.ToString("yyyyMMdd")) || strs3.ContainsKey(lastDate.AddDays(-3).ToString("yyyyMMdd")))
{
lastDate = lastDate.AddDays(-4);
}
else
lastDate = lastDate.AddDays(-3);
}
else if (lastDate.DayOfWeek == DayOfWeek.Tuesday)
{
if (strs3.ContainsKey(lastDate.ToString("yyyyMMdd")) || strs3.ContainsKey(lastDate.AddDays(-1).ToString("yyyyMMdd")))
{
lastDate = lastDate.AddDays(-4);
}
else
lastDate = lastDate.AddDays(-1);
}
else
{
if (strs3.ContainsKey(lastDate.ToString("yyyyMMdd")) || strs3.ContainsKey(lastDate.AddDays(-1).ToString("yyyyMMdd")))
{
lastDate = lastDate.AddDays(-2);
}
else
lastDate = lastDate.AddDays(-1);
}
#endregion
strategy2ExitbySumBeta(quarter, threshold, buyinpower, (decimal)5, lastDate);
DailyGroupbysymbol(quarter, threshold);
#region create daily report
//FileHelperEngine enginDR = new FileHelperEngine(typeof(DailyDataout));
//enginDR.WriteFile(string.Format("DailyReport\\{0}.{1}.D.csv", quarter, Convert.ToInt32(threshold * new decimal(100))), ReportEaring);
DailyDataout[] ReportEaring = (DailyDataout[])EngineOut.ReadFile(string.Format("DailyReport\\{0}.{1}.D.csv", quarter, Convert.ToInt32(threshold * new decimal(100))));
var DailyReport = ReportEaring.GroupBy(d => d.date).Select(d => new DailyReport
{
date=d.Key,
pnl=d.Sum(dd=>dd.pnl)+d.Sum(dd=>dd.spypnl),
pnlovernight=d.Sum(dd=>dd.overnightpnl)+d.Sum(dd=>dd.overnightspypnl),
pnlday=d.Sum(dd=>dd.daypnl)+d.Sum(dd=>dd.dayspypnl),
longcount=d.Where(dd=>dd.threshold>0).Count(),
shortcount=d.Where(dd=>dd.threshold<0).Count(),
longpnl=d.Where(dd=>dd.threshold>0).Sum(dd=>dd.pnl),
shortpnl = d.Where(dd => dd.threshold < 0).Sum(dd => dd.pnl),
qua=quarter,
lose10=d.Sum(dd=>dd.lose10),
win10=d.Sum(dd=>dd.win10),
hspypnl = d.Sum(dd => dd.spypnl),
}).OrderBy(d=>d.date);
#endregion
#region get the bp and accpnl daily
List<DailyReport> newDailyReport = new List<DailyReport>();
decimal accPnl = 0;
foreach(var date in DailyReport)
{
DailyReport tempdailyreport = new DailyReport();
tempdailyreport = date;
accPnl = accPnl + date.pnl;
tempdailyreport.accPnl = accPnl;
tempdailyreport.bp = Math.Max(date.longcount, date.shortcount) * 2 * buyinpower;
newDailyReport.Add(tempdailyreport);
}
#endregion
#region get the dollar sharpe
decimal avgPnl = newDailyReport.Select(d => d.accPnl).Last() / newDailyReport.Where(d => d.pnl != 0).Count();
List<DailyReport> finalDailyReport = new List<DailyReport>();
decimal SD = 0;
int count = 1;
foreach(var date in newDailyReport)
{
DailyReport tempdailyreport = new DailyReport();
tempdailyreport = date;
SD = SD + (date.pnl - avgPnl) * (date.pnl - avgPnl);
if (count != 1)
date.dollarSharp = avgPnl / (decimal)(Math.Sqrt(Convert.ToDouble(SD) / ((count - 1)*252)));
finalDailyReport.Add(tempdailyreport);
count++;
}
FileHelperEngine fileHelperEngine5 = new FileHelperEngine(typeof(DailyReport));
fileHelperEngine5.HeaderText = "date,longpnl,shortpnl,longcount,shortcount,quarter,dollarsharp,bp,win10,lose10,spy hedge pnl,pnl overnight, pnl day,pnl,acc pnl";
if (!File.Exists("DailyReport\\R.csv"))
{
fileHelperEngine5.WriteFile(string.Format("DailyReport\\R.csv", quarter, Convert.ToInt32(threshold * new decimal(100))), finalDailyReport);
}
else
{
fileHelperEngine5.AppendToFile(string.Format("DailyReport\\R.csv", quarter, Convert.ToInt32(threshold * new decimal(100))), finalDailyReport);
}
#endregion
TimeSpan en = DateTime.Now.TimeOfDay;
Console.WriteLine(en-st);
}
private static void createQua()
{
IEnumerable<DailyData1> dailyData1s;
int num = 2014;
int num1 = 2014;
string[] strArrays = new string[] { "0101", "0401", "0701", "1001" };
string[] strArrays1 = strArrays;
strArrays = new string[] { "0501", "0801", "1101", "0201" };
string[] strArrays2 = strArrays;
while (num <= num1)
{
for (int i = 0; i < 4; i++)
{
if (File.Exists((string.Format("Daily\\DailyQua\\{0}{1}.csv", num, i + 1))))
{
File.Delete(string.Format("Daily\\DailyQua\\{0}{1}.csv", num, i + 1));
}
string[] files = Directory.GetFiles("Daily\\DBadv");
for (int j = 0; j < (int)files.Length; j++)
{
string str = files[j];
FileHelperEngine fileHelperEngine = new FileHelperEngine(typeof(DailyData1));
DailyData1[] dailyData1Array = (DailyData1[])fileHelperEngine.ReadFile(str);
if (i == 3)
{
DailyData1[] dailyData1Array1 = dailyData1Array;
IEnumerable<DailyData1> dailyData1s1 = ((IEnumerable<DailyData1>)dailyData1Array1).Where<DailyData1>((DailyData1 d) =>
{
bool flag = d.date >= DateTime.ParseExact(string.Format("{0}{1}", num, strArrays1[i]), "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);
return flag;
});
dailyData1s = dailyData1s1.Where<DailyData1>((DailyData1 d) =>
{
bool flag = d.date < DateTime.ParseExact(string.Format("{0}{1}", num + 1, strArrays2[i]), "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);
return flag;
});
fileHelperEngine.AppendToFile(string.Format("Daily\\DailyQua\\{0}{1}.csv", num, i + 1), dailyData1s);
}
else
{
DailyData1[] dailyData1Array2 = dailyData1Array;
IEnumerable<DailyData1> dailyData1s2 = ((IEnumerable<DailyData1>)dailyData1Array2).Where<DailyData1>((DailyData1 d) =>
{
bool flag = d.date >= DateTime.ParseExact(string.Format("{0}{1}", num, strArrays1[i]), "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);
return flag;
});
dailyData1s = dailyData1s2.Where<DailyData1>((DailyData1 d) =>
{
bool flag = d.date < DateTime.ParseExact(string.Format("{0}{1}", num, strArrays2[i]), "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);
return flag;
});
fileHelperEngine.AppendToFile(string.Format("Daily\\DailyQua\\{0}{1}.csv", num, i + 1), dailyData1s);
}
}
}
num++;
}
}
/// <summary>
/// Copies files from one directory to another recursively.
/// An existing destination-file is replaced if the respective source file is newer and kept if it isn't.
///
/// Additionally, a logfile is writen, containing the actions performed in the following format:
/// COPIED;C:\source\path\file.x;D:\destination\path\file.x
/// REPLACED;C:\source\path\file.x;D:\destination\path\file.x
/// NOT-REPLACED;C:\source\path\file.x;D:\destination\path\file.x
/// FAILED;C:\source\path\file.x;D:\destination\path\file.x
///
/// Parameters:
/// -s ... followed by space and the path of the source directory
/// -d ... followed by space and the path of the destination directory
/// -l ... followed by space and the name of the logfile
/// -nl ... create new logfile, i.e. delete the contents of an existing logfile
/// -al ... append to existing logfile, i.e. do not delete existing logfile contents
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
string sourceFolder = null;
string destinationFolder = null;
string logfileName = null;
bool? logfileCreateNew = null;
for (int i = 0; i < args.Length; ++i)
{
if (args[i] == "-s")
{
if (i + 1 >= args.Length)
{
MessageBox.Show("Invalid parameters: No source folder specified after parameter -s");
Environment.Exit(-1);
}
sourceFolder = args[++i];
}
else if (args[i] == "-d")
{
if (i + 1 >= args.Length)
{
MessageBox.Show("Invalid parameters: No destination folder specified after parameter -d");
Environment.Exit(-1);
}
destinationFolder = args[++i];
}
else if (args[i] == "-l")
{
if (i + 1 >= args.Length)
{
MessageBox.Show("Invalid parameters: No logfile name specified after parameter -l");
Environment.Exit(-1);
}
logfileName = args[++i];
}
else if (args[i] == "-nl")
{
logfileCreateNew = true;
}
else if (args[i] == "-al")
{
logfileCreateNew = false;
}
}
if (null == sourceFolder)
{
MessageBox.Show("Missing parameter: source folder");
Environment.Exit(-1);
}
if (null == destinationFolder)
{
MessageBox.Show("Missing parameter: destination folder");
Environment.Exit(-1);
}
if (null != logfileName && null == logfileCreateNew)
{
MessageBox.Show("Invalid configuration: If you specify log-file, please also state -nl or -al parameter");
Environment.Exit(-1);
}
try
{
if (null == logfileName)
{
CopyAllFilesFromSourceToDestination(sourceFolder, destinationFolder, new List <CopyFileLogEntry>());
}
else
{
var engine = new FileHelperEngine <CopyFileLogEntry>();
var logContents = new List <CopyFileLogEntry>();
CopyAllFilesFromSourceToDestination(sourceFolder, destinationFolder, logContents);
var destLogFileName = Path.Combine(destinationFolder, logfileName);
if (File.Exists(destLogFileName) && !logfileCreateNew.Value)
{
// exists and should append
engine.AppendToFile(destLogFileName, logContents);
}
else
{
// all other cases: doesn't exist or exists and should not append
engine.WriteFile(destLogFileName, logContents);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void append(String file, params Record[] records)
{
checkEngine();
engine.AppendToFile(file, records);
}
/// <summary>
/// Appends a search object to SearchData.txt file
/// </summary>
/// <param name="search"></param>
private void AddSearch(Search search)
{
FileHelperEngine fileHelper = new FileHelperEngine(typeof(SearchData));
SearchData[] result = new SearchData[1];
result[0] = new SearchData();
result[0].Term = search.Term;
result[0].Type = search.Type;
//result[0].Date = search.Date;
// TODO: Fix permissions issue
fileHelper.AppendToFile("SearchData.txt", result);
}
public static void GuardarItfTXT(out string NombreProcesado, eFact_Entidades.Lote Lote, string PreFijo, string Ruta, bool IF)
{
//Deserializar ( pasar de XML a FeaEntidades.InterFacturas.lote_comprobantes )
FeaEntidades.InterFacturas.lote_comprobantes Lc = new FeaEntidades.InterFacturas.lote_comprobantes();
eFact_RN.Lote.DeserializarLc(out Lc, Lote, IF);
//Evento de escritura de txt
List<FeaEntidades.InterFacturas.cabecera_lote> clote = new List<FeaEntidades.InterFacturas.cabecera_lote>();
clote.Add(Lc.cabecera_lote);
FileHelperEngine e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.cabecera_lote));
string nombreProcesado = "";
GenerarNombreArch(out nombreProcesado, Ruta, PreFijo, Lote, "txt");
NombreProcesado = nombreProcesado;
e.WriteFile(NombreProcesado, clote);
for (int i = 0; i < Lc.cabecera_lote.cantidad_reg; i++)
{
List<FeaEntidades.InterFacturas.informacion_comprador> icomprador = new List<FeaEntidades.InterFacturas.informacion_comprador>();
icomprador.Add(Lc.comprobante[i].cabecera.informacion_comprador);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.informacion_comprador));
e.AppendToFile(NombreProcesado, icomprador);
List<FeaEntidades.InterFacturas.informacion_comprobante> icomprobante = new List<FeaEntidades.InterFacturas.informacion_comprobante>();
icomprobante.Add(Lc.comprobante[i].cabecera.informacion_comprobante);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.informacion_comprobante));
e.AppendToFile(NombreProcesado, icomprobante);
List<FeaEntidades.InterFacturas.informacion_vendedor> ivendedor = new List<FeaEntidades.InterFacturas.informacion_vendedor>();
ivendedor.Add(Lc.comprobante[i].cabecera.informacion_vendedor);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.informacion_vendedor));
e.AppendToFile(NombreProcesado, ivendedor);
if (Lc.comprobante[i].cabecera.informacion_comprobante.referencias != null)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.informacion_comprobanteReferencias));
e.AppendToFile(NombreProcesado, Lc.comprobante[i].cabecera.informacion_comprobante.referencias);
}
List<FeaEntidades.InterFacturas.detalle> idetalle = new List<FeaEntidades.InterFacturas.detalle>();
idetalle.Add(Lc.comprobante[i].detalle);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.detalle));
e.AppendToFile(NombreProcesado, idetalle);
foreach (FeaEntidades.InterFacturas.linea linea in Lc.comprobante[i].detalle.linea)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.linea));
List<FeaEntidades.InterFacturas.linea> ilinea = new List<FeaEntidades.InterFacturas.linea>();
ilinea.Add(linea);
e.AppendToFile(NombreProcesado, ilinea);
if (linea.importes_moneda_origen != null)
{
List<FeaEntidades.InterFacturas.lineaImportes_moneda_origen> ilineaImportesMonedaOrigen = new List<FeaEntidades.InterFacturas.lineaImportes_moneda_origen>();
ilineaImportesMonedaOrigen.Add(linea.importes_moneda_origen);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.lineaImportes_moneda_origen));
e.AppendToFile(NombreProcesado, ilineaImportesMonedaOrigen);
}
if (linea.informacion_adicional != null)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.lineaInformacion_adicional));
e.AppendToFile(NombreProcesado, linea.informacion_adicional);
}
}
if (Lc.comprobante[i].cabecera.informacion_comprobante.informacion_exportacion != null)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.informacion_exportacion));
e.AppendToFile(NombreProcesado, Lc.comprobante[i].cabecera.informacion_comprobante.informacion_exportacion);
if (Lc.comprobante[i].cabecera.informacion_comprobante.informacion_exportacion.permisos != null)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.permisos));
e.AppendToFile(NombreProcesado, Lc.comprobante[i].cabecera.informacion_comprobante.informacion_exportacion.permisos);
}
}
if (Lc.comprobante[i].extensiones != null)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.extensiones));
e.AppendToFile(NombreProcesado, Lc.comprobante[i].extensiones);
if (Lc.comprobante[i].extensiones.extensiones_camara_facturas != null)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.extensionesExtensiones_camara_facturas));
e.AppendToFile(NombreProcesado, Lc.comprobante[i].extensiones.extensiones_camara_facturas);
}
if (Lc.comprobante[i].extensiones.extensiones_destinatarios != null)
{
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.extensionesExtensiones_destinatarios));
e.AppendToFile(NombreProcesado, Lc.comprobante[i].extensiones.extensiones_destinatarios);
}
}
if (Lc.comprobante[i].resumen.descuentos != null)
{
foreach (FeaEntidades.InterFacturas.resumenDescuentos descuento in Lc.comprobante[i].resumen.descuentos)
{
List<FeaEntidades.InterFacturas.resumenDescuentos> iresumenDescuentos = new List<FeaEntidades.InterFacturas.resumenDescuentos>();
iresumenDescuentos.Add(descuento);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.resumenDescuentos));
e.AppendToFile(NombreProcesado, iresumenDescuentos);
}
}
if (Lc.comprobante[i].resumen.impuestos != null)
{
foreach (FeaEntidades.InterFacturas.resumenImpuestos impuesto in Lc.comprobante[i].resumen.impuestos)
{
List<FeaEntidades.InterFacturas.resumenImpuestos> iresumenImpuestos = new List<FeaEntidades.InterFacturas.resumenImpuestos>();
iresumenImpuestos.Add(impuesto);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.resumenImpuestos));
e.AppendToFile(NombreProcesado, iresumenImpuestos);
}
}
if (Lc.comprobante[i].resumen.importes_moneda_origen != null)
{
List<FeaEntidades.InterFacturas.resumenImportes_moneda_origen> iresumenImportesMonedaOrigen = new List<FeaEntidades.InterFacturas.resumenImportes_moneda_origen>();
iresumenImportesMonedaOrigen.Add(Lc.comprobante[i].resumen.importes_moneda_origen);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.resumenImportes_moneda_origen));
e.AppendToFile(NombreProcesado, iresumenImportesMonedaOrigen);
}
List<FeaEntidades.InterFacturas.resumen> iresumen = new List<FeaEntidades.InterFacturas.resumen>();
iresumen.Add(Lc.comprobante[i].resumen);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.resumen));
e.AppendToFile(NombreProcesado, iresumen);
}
}
public static void GuardarItfTXTlr(out string NombreProcesado, eFact_Entidades.Lote Lote, string PreFijo, string Ruta, bool IF)
{
//Deserializar ( pasar de XML a FeaEntidades.InterFacturas.lote_comprobantes )
List<FeaEntidades.InterFacturas.lote_response> lLr = new List<FeaEntidades.InterFacturas.lote_response>();
FeaEntidades.InterFacturas.lote_response Lr = new FeaEntidades.InterFacturas.lote_response();
eFact_RN.Lote.DeserializarLr(out Lr, Lote.LoteXmlIF);
lLr.Add(Lr);
//Evento de escritura de txt
FileHelperEngine e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.lote_response));
string nombreProcesado = "";
GenerarNombreArch(out nombreProcesado, Ruta, PreFijo, Lote, "txt");
NombreProcesado = nombreProcesado;
e.WriteFile(NombreProcesado, lLr);
foreach (FeaEntidades.InterFacturas.error elote in Lr.errores_lote)
{
if (elote != null)
{
List<FeaEntidades.InterFacturas.error> ierrores_lote = new List<FeaEntidades.InterFacturas.error>();
ierrores_lote.Add(elote);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.error));
e.AppendToFile(NombreProcesado, ierrores_lote);
}
}
if (Lr.comprobante_response != null)
{
foreach (FeaEntidades.InterFacturas.comprobante_response comprobante in Lr.comprobante_response)
{
List<FeaEntidades.InterFacturas.comprobante_response> icr = new List<FeaEntidades.InterFacturas.comprobante_response>();
icr.Add(comprobante);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.comprobante_response));
e.AppendToFile(NombreProcesado, icr);
if (comprobante.errores_comprobante != null)
{
foreach (FeaEntidades.InterFacturas.error ecomprobante in comprobante.errores_comprobante)
{
if (ecomprobante != null)
{
List<FeaEntidades.InterFacturas.error> ierrores_comprobante = new List<FeaEntidades.InterFacturas.error>();
ierrores_comprobante.Add(ecomprobante);
e = new FileHelperEngine(typeof(FeaEntidades.InterFacturas.error));
e.AppendToFile(NombreProcesado, ierrores_comprobante);
}
}
}
}
}
}
public void Append(Part part)
{
engine.AppendToFile(filePath, part);
}
