public JsonResult GetTotal_PL()
{
List <History_Daily> PL_Days = new List <History_Daily>();
using (INVESTEntities histDaily = new INVESTEntities())
{
PL_Days = histDaily.History_Daily.OrderByDescending(p => p.Date).ToList();
}
var PL = PL_Days.Select(t => new { t.PL_Cum, t.Date }).ToList();
// var PL1 = PL.GroupBy(l => l.Date).Select(t=>t.Sum(s=>s.PL_Cum)).ToList();
var PL1 =
from dr in PL
group dr by dr.Date into plGroup
select new
{
Date = plGroup.Key,
TotalPL = plGroup.Sum(x => x.PL_Cum),
};
//8.15
return(new JsonResult {
Data = PL1, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
// GET: History
public ActionResult Index()
{
using (INVESTEntities histDaily = new INVESTEntities())
{
lastDays = histDaily.History_Daily.OrderByDescending(p => p.Date).ToList();
TLTDays = histDaily.History_Daily.Where(a => a.Tiker.Contains("TLT"))
.OrderBy(item => item.Date).ToList();
QQQDays = histDaily.History_Daily.Where(a => a.Tiker == "QQQ")
.OrderBy(item => item.Date).ToList();
TQQQDays = histDaily.History_Daily.Where(a => a.Tiker.Contains("TQQQ"))
.OrderBy(item => item.Date).ToList();
}
// Find Current PL and Date:
var MaxDate = (from d in lastDays select d.Date).Max();
var CurrentResult = lastDays.Where(a => a.Date == MaxDate);
var CurrentPL = CurrentResult.Sum(a => a.PL_Cum).ToString();
ViewBag.PL = CurrentPL;
ViewBag.LastDate = MaxDate.ToString("d");
//Chart
var TLTValues = TLTDays.Select(t => new { t.PL_Cum, t.Date }).ToList();
var QQQValues = QQQDays.Select(t => new { t.PL_Cum, t.Date }).ToList();
var TQQQValues = TQQQDays.Select(t => new { t.PL_Cum, t.Date }).ToList();
//List<LineSeriesData> Days = new List<LineSeriesData>();
//List<LineSeriesData> TLTData = new List<LineSeriesData>();
//List<LineSeriesData> QQQData = new List<LineSeriesData>();
//List<LineSeriesData> TQQQData = new List<LineSeriesData>();
var epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
////AllDays.ForEach(p => Days.Add(new LineSeriesData {X = DateTime.Parse(p.Ticks)}));
//TLTValues.ForEach(p => TLTData.Add(new LineSeriesData { Y = p.PL_Cum, X = (p.Date - epoch).TotalMilliseconds }));
//QQQValues.ForEach(p => QQQData.Add(new LineSeriesData { Y = p.PL_Cum, X = (p.Date - epoch).TotalMilliseconds }));
//TQQQValues.ForEach(p => TQQQData.Add(new LineSeriesData { Y = p.PL_Cum, X = (p.Date - epoch).TotalMilliseconds }));
//ViewData["TLT"] = TLTData;
//ViewData["QQQ"] = QQQData;
//ViewData["TQQQ"] = TQQQData;
//ViewData["Days"] = Days;
// return View(lastDays);
return(View("~/Views/Account/Register.cshtml"));
}
public JsonResult GetAllDaysWithParameters(string prefix)
{
List <History_Daily> allDays = new List <History_Daily>();
using (INVESTEntities histDaily = new INVESTEntities())
{
allDays = histDaily.History_Daily.Where(a => a.Tiker.Contains(prefix)).ToList();
}
//8.15
return(new JsonResult {
Data = allDays, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetAllDays()
{
List <History_Daily> allDays = new List <History_Daily>();
using (INVESTEntities histDaily = new INVESTEntities())
{
allDays = histDaily.History_Daily.ToList();
}
//8.15
return(new JsonResult {
Data = allDays, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}