private void updateProfitsPerMonth()
{
ProfitsPerMonth = StatsCalculator.GetProfitsByMonths(Profits, Data);
double sum = 0;
int n = 0;
var means = new List <double>();
foreach (var p in ProfitsPerMonth)
{
sum += p.Percent;
n++;
means.Add(Math.Round(sum / n, 2));
}
MeanProfitsPerMonth = means;
}
public AccountData(User user,
IEnumerable <BalancesRow> balances,
IEnumerable <FlowRow> flows)
{
UserName = user.Name;
Flows = flows.Where(o => o.User.Id == user.Id).ToArray();
var startDate = Flows.Min(o => o.DateTimeStamp);
var ratios = new Dictionary <DateTime, double>();
var dbs = balances.OrderBy(o => o.DateTimeStamp).ToDictionary(o => o.DateTimeStamp, o => o.Balance);
Balances = new Dictionary <DateTime, double>();
double ownMoney = 0;
double othersMoney = 0;
DateTime date = DateTime.MinValue;
foreach (var d in dbs.Keys)
{
var currFlows = flows.Where(o => o.DateTimeStamp <= d && o.DateTimeStamp > date);
var currBal = dbs[d] - currFlows.Sum(o => o.Payment);
var profit = d == dbs.Min(o => o.Key) ? 0 : currBal - (othersMoney + ownMoney);
var currRatio = d == dbs.Min(o => o.Key) ? 0 : ownMoney / (othersMoney + ownMoney);
ownMoney += profit * currRatio;
othersMoney += profit * (1 - currRatio);
foreach (var f in currFlows)
{
if (f.User.Id == user.Id)
{
ownMoney += f.Payment;
}
else
{
othersMoney += f.Payment;
}
}
ratios.Add(d, ownMoney / (othersMoney + ownMoney));
if (startDate <= d)
{
Balances.Add(d, ownMoney);
}
date = d;
}
var ownFlowsSum = Flows.Where(o => o.Payment > 0).Sum(o => o.Payment);
SharedRatio = Math.Round(ratios[balances.Last().DateTimeStamp] * 100, 2);
Money = Math.Round(ownMoney, 2);
OthersMoney = Math.Round(othersMoney, 2);
var lastMonthBalance = dbs.LastOrDefault(o => o.Key < date && o.Key.Month != date.Month);
var lastMonthInOut = Flows.Where(o => o.DateTimeStamp > lastMonthBalance.Key).Sum(o => o.Payment);
TotalProfit = Math.Round(Money - ownFlowsSum, 2);
if (TotalProfit > 0)
{
Money -= Math.Round(TotalProfit * (Benefit / 100), 2);
}
TotalProfitPercent = Math.Round(100 * TotalProfit / ownFlowsSum, 2);
ProfitsPerMonth = StatsCalculator.GetProfitsByMonths(StatsCalculator.GetProfits(Balances, Flows), Balances);
var lastMonthProfit = ProfitsPerMonth.Last();
LastMonthProfit = Math.Round(lastMonthProfit.Value * (1 - Benefit / 100), 2);
LastMonthPercent = Math.Round(lastMonthProfit.Percent * (1 - Benefit / 100), 2);
}