public void FillUserStatistic(int accountId, ShortStatistic toFill, Statistic graphModel)
{
var depositsRepository = new DepositsDataRepository();
var deposits = depositsRepository.GetDepositsDataByUserId(accountId).ToList();
var accountRepository = new AccountRepository();
var account = accountRepository.GetAccountById(accountId);
if (account != null)
{
toFill.Broker = account.Broker;
toFill.Leverage = account.Leverage;
toFill.StartedDate = account.Date ?? DateTime.Now;
toFill.System = account.System;
toFill.TimeZone = account.TimeZone ?? 0;
toFill.Trading = account.Trading;
toFill.Type = account.Type;
toFill.Views = account.Views ?? 0;
toFill.Desctiption = account.Desctiption;
}
if (deposits.Count != 0)
{
var sortedByDate = deposits.OrderBy(x => x.Date);
var sortedDepositesOnly = sortedByDate.Where(x => x.IncomeType == DataType.Deposit);
decimal startValue = sortedDepositesOnly.First().Amount;
decimal endValue = sortedDepositesOnly.Last().Amount;
toFill.Deposits = startValue;
decimal maxAmount = sortedDepositesOnly.Max(x => x.Amount);
var highestEntity = sortedDepositesOnly.FirstOrDefault(x => x.Amount == maxAmount);
if (highestEntity != null)
{
toFill.Highest = highestEntity.Amount;
toFill.HighestDate = highestEntity.Date;
}
decimal defference = endValue - startValue;
decimal value = startValue != 0 ? (defference / startValue) * 100 : 0;
toFill.AbsGain = value;
FillGraphData(sortedByDate.ToList(), graphModel, toFill);
}
}
public ActionResult Index(int accountId, string graphType)
{
StatsManager manager = new StatsManager();
GraphType type = manager.ParseStringToGrphType(graphType);
if (type == GraphType.none)
return RedirectToAction("Index", "Stats", new { accountId = accountId, graphType = "growth" });
if (accountId == 0)
ViewData["AccountError"] = true;
manager.IncrementViews(accountId);
Statistic stat = new Statistic();
stat.CurrentGraphType = type;
ShortStatistic shortStat = new ShortStatistic();
shortStat.Settings = manager.GetAccountSettings(accountId);
manager.FillUserStatistic(accountId, shortStat, stat);
stat.ShortStatisticData = shortStat;
return View("Index", stat);
}
private void FillGraphData(List<DepositsData> sortedByDate, Statistic toFill, ShortStatistic shortStat)
{
if (sortedByDate.Count == 0)
return;
var depositsByDate = sortedByDate.Where(x => x.IncomeType == DataType.Deposit).ToArray(); //.OrderBy(x => x.Date.Date);
var floatingProfitByDate = sortedByDate.Where(x => x.IncomeType == DataType.FloatingProfit).ToArray(); //.OrderBy(x => x.Date.Date);
decimal startDeposit = depositsByDate.First().Amount;
decimal startEquity = 0;
if (floatingProfitByDate.Length > 0)
startEquity = floatingProfitByDate.First().Amount + startDeposit;
for (int i = 0; i < depositsByDate.Length; i++)
{
decimal difference = depositsByDate[i].Amount - startDeposit;
toFill.ProfitData.Add(new ProfitDataValue { Date = depositsByDate[i].Date, Profit = difference });
decimal currentEquity = 0;
if (floatingProfitByDate.Length > 0)
currentEquity = depositsByDate[i].Amount + floatingProfitByDate[i].Amount;
toFill.BalanceData.Add(new BalanceDataValue
{
Date = depositsByDate[i].Date,
Balance = depositsByDate[i].Amount,
Equity = currentEquity
});
decimal growth = startDeposit != 0 ? (difference / startDeposit) * 100 : 0;
decimal equityDifference = currentEquity - startEquity;
decimal equityGrowth = startEquity != 0 ? (equityDifference / startEquity) * 100 : 0;
toFill.GrowthData.Add(new GrowthDataValue { Date = depositsByDate[i].Date, Growth = growth, EquityGrowth = equityGrowth });
}
decimal maxEquity = toFill.BalanceData.Select(x => x.Equity).Max();
foreach (var item in toFill.BalanceData)
{
decimal drawdown = maxEquity != 0 ? ((maxEquity - item.Equity) / maxEquity) * 100 : 0;
toFill.DrawdownData.Add(new DrawdownDataValue { Date = item.Date, Value = drawdown });
}
shortStat.Drawdown = toFill.DrawdownData.Sum(x => x.Value) / sortedByDate.Count;
decimal sum = toFill.ProfitData.Sum(x => x.Profit);
shortStat.Daily = sum / sortedByDate.Count;
shortStat.Monthly = sum / toFill.GrowthData.GroupBy(x => x.Date.Month).Count();
shortStat.Balance = toFill.BalanceData.Last().Balance;
shortStat.Equity = toFill.BalanceData.Last().Equity;
shortStat.Profit = toFill.ProfitData.Last().Profit;
}