public void SettlementDateEvent(PostingEngineEnvironment env, Transaction element)
{
// Entry has already been processed
if (element.TradeDate.Date.Equals(element.SettleDate.Date) && element.SecurityType.ToLowerInvariant().Equals("cash"))
{
CommonRules.GenerateSettlementDateJournals(env, element);
return;
}
return;
}
public void TradeDateEvent(PostingEngineEnvironment env, Transaction element)
{
if (element.AccrualId == null)
{
// We have just cash here so what do we do ?
CommonRules.GenerateTradeDateJournals(env, element);
return;
}
var accrual = env.Accruals.ContainsKey(element.AccrualId) ? env.Accruals[element.AccrualId] : null;
if (accrual != null)
{
AccrualPayment(env, element, accrual);
return;
}
return;
}
/// <summary>
/// Run for each day that the Tax Lot remains open / partially closed
/// </summary>
/// <param name="env"></param>
/// <param name="element">Trade we aee interested in</param>
public void DailyEvent(PostingEngineEnvironment env, Transaction element)
{
double fxrate = 1.0;
// Lets get fx rate if needed
if (!element.SettleCurrency.Equals(env.BaseCurrency))
{
fxrate = Convert.ToDouble(FxRates.Find(env.ValueDate, element.SettleCurrency).Rate);
}
// Calculate the unrealized PNL
if (env.TaxLotStatus.ContainsKey(element.LpOrderId))
{
// Determine if we need to accumulate unrealized PNL
var taxlot = env.TaxLotStatus[element.LpOrderId];
// Check to see if the TaxLot is still open and it has a non zero Quantity
if (!taxlot.Status.ToLowerInvariant().Equals("closed") && Math.Abs(taxlot.Quantity) > 0)
{
var listOfTags = new List <Tag>
{
Tag.Find("SecurityType"),
Tag.Find("CustodianCode")
};
// We have an open / partially closed tax lot so now need to calculate unrealized Pnl
var quantity = taxlot.Quantity;
var prevEodPrice = 0.0;
var eodPrice = 0.0;
if (env.ValueDate == element.TradeDate)
{
eodPrice = MarketPrices.GetPrice(env, env.ValueDate, element).Price;
prevEodPrice = element.SettleNetPrice;
}
else
{
prevEodPrice = MarketPrices.GetPrice(env, env.PreviousValueDate, element).Price;
eodPrice = MarketPrices.GetPrice(env, env.ValueDate, element).Price;
}
var unrealizedPnl = CommonRules.CalculateUnrealizedPnl(env, taxlot);
AccountToFrom fromToAccounts = null;
if (element.IsDerivative())
{
var originalAccount = AccountUtils.GetDerivativeAccountType(unrealizedPnl);
if (originalAccount.Contains("(Liabilities)"))
{
// This needs to be registered as a Credit to the Libabilities
unrealizedPnl *= -1;
}
fromToAccounts = new AccountUtils().GetAccounts(env, originalAccount, "Change in Unrealized Derivatives Contracts at Fair Value", listOfTags, taxlot.Trade);
}
else
{
var originalAccount = taxlot.Side == "SHORT" ? "Mark to Market Shorts" : "Mark to Market Longs";
fromToAccounts = new AccountUtils().GetAccounts(env, originalAccount, "CHANGE IN UNREALIZED GAIN/(LOSS)", listOfTags, taxlot.Trade);
}
var fund = env.GetFund(element);
var debit = new Journal(element)
{
Account = fromToAccounts.From,
When = env.ValueDate,
Symbol = taxlot.Symbol,
Quantity = quantity,
FxRate = fxrate,
Value = env.SignedValue(fromToAccounts.From, fromToAccounts.To, true, unrealizedPnl),
CreditDebit = env.DebitOrCredit(fromToAccounts.From, unrealizedPnl),
StartPrice = prevEodPrice,
EndPrice = eodPrice,
Event = Event.DAILY_UNREALIZED_PNL,
Fund = fund,
};
var credit = new Journal(element)
{
Account = fromToAccounts.To,
When = env.ValueDate,
FxRate = fxrate,
Quantity = quantity,
Value = env.SignedValue(fromToAccounts.From, fromToAccounts.To, false, unrealizedPnl),
CreditDebit = env.DebitOrCredit(fromToAccounts.To, env.SignedValue(fromToAccounts.From, fromToAccounts.To, false, unrealizedPnl)),
Event = Event.DAILY_UNREALIZED_PNL,
StartPrice = prevEodPrice,
EndPrice = eodPrice,
Fund = fund,
};
Logger.Info($"[Journals] ==> From : {debit.CreditDebit}::{debit.Value}::{debit.Account.Type.Category.Name} --> To : {credit.CreditDebit}::{credit.Value}::{credit.Account.Type.Category.Name} ({unrealizedPnl})");
env.Journals.AddRange(new[] { debit, credit });
// For Derivatives this is un-necessary as we do not have an investment at cost, but we do have Fx on unsettled
if (taxlot.Quantity != 0.0)
{
if (element.TradeDate != env.ValueDate)
{
new FxPosting().CreateFxUnsettled(env, element);
}
}
}
}
else
{
if (fxrate != 1.0)
{
if (element.TradeDate != env.ValueDate && element.SettleDate >= env.ValueDate)
{
/*
* var fxJournals = FxPosting.CreateFx(
* env,
* "DUE FROM/(TO) PRIME BROKERS ( Unsettled Activity )",
* "fx gain or loss on unsettled balance",
* "daily",
* element.Quantity, null, element);
* env.Journals.AddRange(fxJournals);
*/
}
}
}
}
public void TradeDateEvent(PostingEngineEnvironment env, Transaction element)
{
double fxrate = 1.0;
double multiplier = 1.0;
if (env.SecurityDetails.ContainsKey(element.BloombergCode))
{
multiplier = env.SecurityDetails[element.BloombergCode].Multiplier;
}
// Lets get fx rate if needed
if (!element.SettleCurrency.Equals(env.BaseCurrency))
{
fxrate = Convert.ToDouble(FxRates.Find(env.ValueDate, element.SettleCurrency).Rate);
}
var tradeAllocations = env.Allocations.Where(i => i.LpOrderId == element.LpOrderId).ToList();
if (element.IsBuy() || element.IsShort())
{
var t1 = env.GenerateOpenTaxLot(element, fxrate);
if (element.Quantity == 0)
{
// TODO: Need to review this as we need to see if there is a parent, and what the parents actuall is
return;
}
//tl.Save(env.Connection, env.Transaction);
}
else if (element.IsSell() || element.IsCover())
{
// Get Matching Lots
var openLots = env.Methodology.GetOpenLots(env, element, element.Quantity);
if (openLots.Count() == 0)
{
var t1 = env.GenerateOpenTaxLot(element, fxrate);
// Whats going on here?
// We are skipping anything that does not get an OpenLot
env.AddMessage($"There should be for a sell {element.Symbol} have at least one open lot, non found");
}
else
{
var workingQuantity = element.Quantity;
foreach (var lot in openLots)
{
if (workingQuantity == 0)
{
break;
}
if (!env.TaxLotStatus.ContainsKey(lot.Trade.LpOrderId))
{
// TODO: For this open lot there should be a corresponding open to
continue;
}
var taxlotStatus = env.TaxLotStatus[lot.Trade.LpOrderId];
if (taxlotStatus != null && taxlotStatus.Quantity != 0 && !taxlotStatus.Status.ToLowerInvariant().Equals("closed"))
{
// Does the open Lot fully fullfill the quantity ?
if (Math.Abs(taxlotStatus.Quantity) >= Math.Abs(workingQuantity))
{
var taxlot = CommonRules.RelieveTaxLot(env, lot, element, workingQuantity, true);
taxlotStatus.Quantity += workingQuantity;
if (taxlotStatus.Quantity == 0)
{
taxlotStatus.Status = "Closed";
}
else
{
taxlotStatus.Status = "Partially Closed";
}
CommonRules.GenerateCloseOutPostings(env, lot, taxlot, element, taxlotStatus, tradeAllocations[0].Fund);
break;
}
else
{
var taxlot = CommonRules.RelieveTaxLot(env, lot, element, taxlotStatus.Quantity * -1);
workingQuantity -= Math.Abs(taxlotStatus.Quantity);
CommonRules.PostRealizedPnl(env, element, taxlot.RealizedPnl, taxlot.TradePrice, taxlot.CostBasis);
taxlotStatus.Quantity = 0;
taxlotStatus.Status = "Closed";
}
}
}
}
}
else
{
// We have a Debit / Credit Dividends
}
}
private void GenerateDailyUnrealized(PostingEngineEnvironment env, TaxLotStatus taxLotStatus, Transaction element, double quantity, double fxRate)
{
var prevEodPrice = 0.0;
var eodPrice = 0.0;
if (env.ValueDate == taxLotStatus.Trade.TradeDate)
{
prevEodPrice = taxLotStatus.Trade.SettleNetPrice;
eodPrice = MarketPrices.GetPrice(env, env.ValueDate, taxLotStatus.Trade).Price;
}
else
{
prevEodPrice = MarketPrices.GetPrice(env, env.PreviousValueDate, taxLotStatus.Trade).Price;
eodPrice = MarketPrices.GetPrice(env, env.ValueDate, taxLotStatus.Trade).Price;
}
var endPrice = element.SettleNetPrice;
if (taxLotStatus.Quantity == 0.0)
{
eodPrice = endPrice;
}
var unrealizedPnl = CommonRules.CalculateUnrealizedPnl(env, taxLotStatus, quantity, eodPrice);
var originalAccount = taxLotStatus.Side == "SHORT" ? "Mark to Market Shorts" : "Mark to Market Longs";
var fromToAccounts = new AccountUtils().GetAccounts(env, originalAccount, "CHANGE IN UNREALIZED GAIN/(LOSS)", listOfTags, taxLotStatus.Trade);
if (taxLotStatus.Side == "SHORT")
{
unrealizedPnl *= -1;
}
var fund = env.GetFund(taxLotStatus.Trade);
var debit = new Journal(taxLotStatus.Trade)
{
Account = fromToAccounts.From,
When = env.ValueDate,
Symbol = taxLotStatus.Symbol,
Quantity = quantity,
FxRate = fxRate,
Value = env.SignedValue(fromToAccounts.From, fromToAccounts.To, true, unrealizedPnl),
CreditDebit = env.DebitOrCredit(fromToAccounts.From, unrealizedPnl),
StartPrice = prevEodPrice,
EndPrice = eodPrice,
Event = Event.DAILY_UNREALIZED_PNL,
Fund = fund,
};
var credit = new Journal(debit)
{
Account = fromToAccounts.To,
Value = env.SignedValue(fromToAccounts.From, fromToAccounts.To, false, unrealizedPnl),
CreditDebit = env.DebitOrCredit(fromToAccounts.To, unrealizedPnl),
};
env.Journals.AddRange(new[] { debit, credit });
if (fxRate != 1.0)
{
if (element.TradeDate != env.ValueDate && element.SettleDate >= env.ValueDate)
{
var fxJournals = FxPosting.CreateFx(
env,
"DUE FROM/(TO) PRIME BROKERS ( Unsettled Activity )",
"fx gain or loss on unsettled balance",
"daily",
quantity, null, element);
env.Journals.AddRange(fxJournals);
}
if (taxLotStatus.Quantity != 0.0)
{
if (env.ValueDate.Equals(new DateTime(2019, 12, 17)))
{
}
if (element.TradeDate != env.ValueDate)
{
// Has to happen for every day
var fxJournalsForInvestmentAtCost = FxPosting.CreateFx(
env,
CommonRules.GetFXMarkToMarketAccountType(element, "FX MARKET TO MARKET ON STOCK COST"),
"Change in unrealized due to fx on original Cost",
"daily", quantity, taxLotStatus, element);
env.Journals.AddRange(fxJournalsForInvestmentAtCost);
new FxPosting().CreateFxUnsettled(env, element);
}
}
}
}
/// <summary>
/// Generate all of the journal entries we need for reduction / closeout of a tax lot
/// </summary>
/// <param name="env"></param>
/// <param name="lot"></param>
/// <param name="taxlotStatus"></param>
/// <param name="element"></param>
/// <param name="workingQuantity"></param>
/// <param name="fxrate"></param>
/// <param name="multiplier"></param>
private void GenerateJournals(PostingEngineEnvironment env, TaxLotDetail lot, TaxLotStatus taxlotStatus, Transaction element, double workingQuantity, double fxrate, double multiplier)
{
var buyTrade = env.FindTrade(lot.Trade.LpOrderId);
var taxlot = CommonRules.RelieveTaxLot(env, lot, element, workingQuantity, true);
// Has to happen for every day
var fxJournalsForInvestmentAtCost = FxPosting.CreateFx(
env,
CommonRules.GetFXMarkToMarketAccountType(element, "FX MARKET TO MARKET ON STOCK COST"),
"Change in unrealized due to fx on original Cost",
"daily", workingQuantity, taxlotStatus, buyTrade);
env.Journals.AddRange(fxJournalsForInvestmentAtCost);
taxlotStatus.Quantity += workingQuantity;
if (taxlotStatus.Quantity == 0)
{
taxlotStatus.Status = "Closed";
}
else
{
taxlotStatus.Status = "Partially Closed";
}
if (taxlotStatus.Quantity == 0.0)
{
// Is this really needed, as if the tax lot is zero then should not generate any additional unrealized pnl
//GenerateDailyUnrealized(env, taxlotStatus, element, workingQuantity * -1, fxrate);
}
var eodPrice = MarketPrices.GetPrice(env, env.PreviousValueDate, buyTrade).Price;
// Calculate the unrealized Backout PNL for the created Tax Lot
var unrealizedPnl = Math.Abs(taxlot.Quantity) * (eodPrice - buyTrade.SettleNetPrice) * multiplier * fxrate;
unrealizedPnl *= CommonRules.DetermineSign(element);
// Need to backout the Unrealized PNL here, as we are reducing the position of the TaxLot
CommonRules.ReverseUnrealizedPnl(
env,
buyTrade,
element,
unrealizedPnl * -1,
buyTrade.SettleNetPrice,
element.SettleNetPrice,
fxrate);
// Original FxRate
var changeDueToFx = fxrate - taxlotStatus.FxRate;
// Original Trade Price
var changeInRealizedPnlDueToFx = changeDueToFx * (taxlot.TradePrice) * Math.Abs(taxlot.Quantity);
var changeInUnRealizedPnlDueToFx = changeDueToFx * (taxlot.CostBasis - taxlot.TradePrice) * Math.Abs(taxlot.Quantity);
CommonRules.PostRealizedPnl(
env,
buyTrade,
taxlot.RealizedPnl,
taxlot.TradePrice,
taxlot.CostBasis,
fxrate);
if (fxrate != 1.0)
{
PostRealizedFxGain(env, buyTrade, changeInRealizedPnlDueToFx, taxlot.TradePrice, taxlot.CostBasis, changeDueToFx);
}
var fxChange = new FxPosting().CreateFxUnsettled(env, buyTrade);
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@busDate", env.ValueDate));
sqlParams.Add(new SqlParameter("@LpOrderId", lot.Trade.LpOrderId));
var dataTable = new SqlHelper(env.ConnectionString).GetDataTables("ClosingTaxLot", CommandType.StoredProcedure, sqlParams.ToArray());
var changeInUnRealized = 1.0;
if (dataTable[0].Rows.Count > 0)
{
changeInUnRealized = Convert.ToDouble(dataTable[0].Rows[0][2]);
}
var changeInUnRealizedFx = 0.0;
if (dataTable[1].Rows.Count > 0)
{
changeInUnRealizedFx = Convert.ToDouble(dataTable[1].Rows[0][2]);
}
if (changeInUnRealizedFx != 0.0)
{
var closeOut = changeInUnRealizedFx + fxChange;
PostUnrealizedFxGain(env, buyTrade, closeOut, taxlot.TradePrice, taxlot.CostBasis, changeDueToFx);
}
var sumFxMarkToMarket = 0.0;
if (dataTable[2].Rows.Count > 0)
{
sumFxMarkToMarket = Convert.ToDouble(dataTable[2].Rows[0][2]);
sumFxMarkToMarket += fxJournalsForInvestmentAtCost[0].Value;
ReversePosting(env, "Change in unrealized due to fx on original Cost", CommonRules.GetFXMarkToMarketAccountType(element, "FX MARKET TO MARKET ON STOCK COST"), buyTrade, sumFxMarkToMarket);
}
var listOfFromTags = new List <Tag>
{
Tag.Find("SecurityType"),
Tag.Find("CustodianCode")
};
/*
* var markToMarketAccount = (buyTrade.IsShort() || buyTrade.IsCover()) ? "Mark to Market Shorts" : "Mark to Market Longs";
*
* var fromTo = new AccountUtils().GetAccounts(env, "CHANGE IN UNREALIZED GAIN/(LOSS)", markToMarketAccount, listOfFromTags, element);
*
* if (fxrate == 1.0)
* {
* changeInUnRealized = Convert.ToDouble(taxlot.RealizedPnl) * -1;
* }
*
* // Now Generate Entries for the trade that is drawing down on the taxLot
* var fromJournal = new Journal(buyTrade)
* {
* Account = fromTo.From,
* When = env.ValueDate,
*
* CreditDebit = env.DebitOrCredit(fromTo.From, changeInUnRealized),
* Value = env.SignedValue(fromTo.From, fromTo.To, true, changeInUnRealized),
* Event = Event.UNREALIZED_PNL,
* Fund = env.GetFund(element),
*
* StartPrice = taxlot.TradePrice,
* EndPrice = taxlot.CostBasis,
* FxRate = fxrate,
* };
*
* var toJournal = new Journal(buyTrade)
* {
* Account = fromTo.To,
* When = env.ValueDate,
*
* CreditDebit = env.DebitOrCredit(fromTo.To, changeInUnRealized * -1),
* Value = env.SignedValue(fromTo.From, fromTo.To, false, changeInUnRealized),
* Event = Event.UNREALIZED_PNL,
* Fund = env.GetFund(element),
*
* StartPrice = taxlot.TradePrice,
* EndPrice = taxlot.CostBasis,
* FxRate = fxrate,
* };
*
* env.Journals.AddRange(new[] { fromJournal, toJournal });
*/
}
internal void TradeDateEvent(PostingEngineEnvironment env, Transaction element)
{
double multiplier = 1.0;
if (env.SecurityDetails.ContainsKey(element.BloombergCode))
{
multiplier = env.SecurityDetails[element.BloombergCode].Multiplier;
}
double fxrate = 1.0;
// Lets get fx rate if needed
if (!element.SettleCurrency.Equals(env.BaseCurrency))
{
fxrate = Convert.ToDouble(FxRates.Find(env.ValueDate, element.SettleCurrency).Rate);
}
if (element.IsCredit() || element.IsDebit())
{
if (element.TransactionCategory == "Cash Dividends")
{
// We have a Cash Dividend, so how do we treat this
return;
}
}
if (element.IsBuy() || element.IsShort())
{
if (element.Quantity == 0)
{
// TODO: Need to review this as we need to see if there is a parent, and what the parents actuall is
return;
}
var tl = env.GenerateOpenTaxLot(element, fxrate);
}
else if (element.IsSell() || element.IsCover())
{
// Get Matching Lots
var taxLotMethodology = ConfigurationManager.AppSettings["TaxMethod"].ToString();
var workingQuantity = element.Quantity;
if (taxLotMethodology.Equals("MINTAX"))
{
while (workingQuantity != 0.0)
{
var localOpenTaxLots = env.Methodology.GetOpenLots(env, element, workingQuantity);
var lot = localOpenTaxLots[0];
if (!env.TaxLotStatus.ContainsKey(lot.Trade.LpOrderId))
{
// TODO: For this open lot there should be a corresponding open to
env.AddMessage($"Unable to Find Tax Lot for {lot.Trade.Symbol}::{lot.Trade.Side}::{lot.Trade.Status}");
//Logger.Warn($"Unable to Find Tax Lot for {element.Symbol}::{element.Side}::{element.Status}");
continue;
}
var taxlotStatus = env.TaxLotStatus[lot.Trade.LpOrderId];
if (taxlotStatus != null && taxlotStatus.Quantity != 0 && !taxlotStatus.Status.ToLowerInvariant().Equals("closed"))
{
Logger.Info($"Relieving Tax Lot {taxlotStatus.Symbol}::{taxlotStatus.TradePrice}::{taxlotStatus.TradeDate.ToString("MM-dd-yyyy")}::{taxlotStatus.OpenId}::{lot.TaxLiability}::{lot.TaxRate.Rate}::{lot.PotentialPnl}");
// Does the open Lot fully fullfill the quantity ?
if (Math.Abs(taxlotStatus.Quantity) >= Math.Abs(workingQuantity))
{
// Lets generate all the journal entries we need
GenerateJournals(env, lot, taxlotStatus, element, workingQuantity, fxrate, multiplier);
break;
}
else
{
var quantity = taxlotStatus.Quantity;
GenerateJournals(env, lot, taxlotStatus, element, taxlotStatus.Quantity * -1, fxrate, multiplier);
workingQuantity += quantity;
}
}
}
}
else
{
var openLots = env.Methodology.GetOpenLots(env, element, workingQuantity);
foreach (var lot in openLots)
{
if (workingQuantity == 0)
{
break;
}
if (!env.TaxLotStatus.ContainsKey(lot.Trade.LpOrderId))
{
// TODO: For this open lot there should be a corresponding open to
env.AddMessage($"Unable to Find Tax Lot for {lot.Trade.Symbol}::{lot.Trade.Side}::{lot.Trade.Status}");
//Logger.Warn($"Unable to Find Tax Lot for {element.Symbol}::{element.Side}::{element.Status}");
continue;
}
var taxlotStatus = env.TaxLotStatus[lot.Trade.LpOrderId];
if (taxlotStatus != null && taxlotStatus.Quantity != 0 && !taxlotStatus.Status.ToLowerInvariant().Equals("closed"))
{
Logger.Info($"Relieving Tax Lot {taxlotStatus.TradeDate.ToString("MM-dd-yyyy")}::{taxlotStatus.Symbol}::{taxlotStatus.OpenId}::{lot.TaxLiability}::{lot.TaxRate.Rate}::{lot.PotentialPnl}");
// Does the open Lot fully fullfill the quantity ?
if (Math.Abs(taxlotStatus.Quantity) >= Math.Abs(workingQuantity))
{
// Lets generate all the journal entries we need
GenerateJournals(env, lot, taxlotStatus, element, workingQuantity, fxrate, multiplier);
break;
}
else
{
var quantity = taxlotStatus.Quantity;
GenerateJournals(env, lot, taxlotStatus, element, taxlotStatus.Quantity * -1, fxrate, multiplier);
workingQuantity += quantity;
}
}
}
}
}
else
{
// We have a Debit / Credit Dividends
}
CommonRules.GenerateTradeDateJournals(env, element);
}
internal void SettlementDateEvent(PostingEngineEnvironment env, Transaction element)
{
CommonRules.GenerateSettlementDateJournals(env, element);
}
public void SettlementDateEvent(PostingEngineEnvironment env, Transaction element)
{
// On Settlement Date we backout the Tax Lot for FORWARDS
if (env.TaxLotStatus.ContainsKey(element.LpOrderId))
{
var taxlotStatus = env.TaxLotStatus[element.LpOrderId];
var split = element.Symbol.Split(new char[] { '/', ' ' });
var baseCurrency = split[0];
var riskCurrency = split[1];
var accountBuy = new AccountUtils().CreateAccount(atSettledCash, new List <string> {
element.SecurityType, element.CustodianCode, baseCurrency
});
var accountSell = new AccountUtils().CreateAccount(atSettledCash, new List <string> {
element.SecurityType, element.CustodianCode, riskCurrency
});
new AccountUtils().SaveAccountDetails(env, accountBuy);
new AccountUtils().SaveAccountDetails(env, accountSell);
var fxCurrency = riskCurrency;
var tradePrice = taxlotStatus.TradePrice;
var baseQuantity = element.Quantity;
var eodPrice = MarketPrices.GetPrice(env, env.ValueDate, element).Price;
var fxRate = FxRates.Find(env.ValueDate, fxCurrency).Rate;
var buyValue = baseQuantity * tradePrice * fxRate;
var sellValue = baseQuantity * eodPrice * fxRate;
if (element.IsBuy()) // BUY
{
var realizedPnl = sellValue - buyValue;
var debit = new Journal(accountBuy, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = baseCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(element.Quantity),
FxRate = tradePrice,
StartPrice = tradePrice,
EndPrice = eodPrice,
Value = env.SignedValue(accountBuy, accountSell, true, buyValue),
CreditDebit = env.DebitOrCredit(accountBuy, buyValue),
};
var credit = new Journal(accountSell, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = riskCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(element.Quantity),
FxRate = tradePrice,
StartPrice = 0,
EndPrice = 0,
Value = env.SignedValue(accountBuy, accountSell, true, sellValue * -1),
CreditDebit = env.DebitOrCredit(accountSell, sellValue),
};
env.Journals.AddRange(new[] { credit, debit });
var originalAccount = AccountUtils.GetDerivativeAccountType(realizedPnl);
// Realized Pnl to go along with the Settled Cash
CommonRules.GenerateJournalEntry(env, element, listOfTags, realizedAccountType, Event.REALIZED_PNL, realizedPnl);
CommonRules.GenerateJournalEntries(env, element, listOfTags, originalAccount, "Change in Unrealized Derivatives Contracts at Fair Value", realizedPnl * -1);
}
else // SELL
{
var realizedPnl = buyValue - sellValue;
var debit = new Journal(accountBuy, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = baseCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(element.Quantity),
FxRate = tradePrice,
StartPrice = 0,
EndPrice = 0,
Value = env.SignedValue(accountBuy, accountSell, true, sellValue),
CreditDebit = env.DebitOrCredit(accountBuy, element.Quantity),
};
var credit = new Journal(accountSell, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = riskCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(element.Quantity),
FxRate = tradePrice,
StartPrice = 0,
EndPrice = 0,
Value = env.SignedValue(accountBuy, accountSell, true, buyValue * -1),
CreditDebit = env.DebitOrCredit(accountSell, element.Quantity),
};
env.Journals.AddRange(new[] { credit, debit });
var originalAccount = AccountUtils.GetDerivativeAccountType(realizedPnl);
// Realized Pnl to go along with the Settled Cash
CommonRules.GenerateJournalEntry(env, element, listOfTags, realizedAccountType, Event.REALIZED_PNL, realizedPnl);
CommonRules.GenerateJournalEntries(env, element, listOfTags, originalAccount, "Change in Unrealized Derivatives Contracts at Fair Value", realizedPnl * -1);
}
if (taxlotStatus.Quantity != 0)
{
var buyTrade = env.FindTrade(taxlotStatus.OpenId);
var taxlot = CommonRules.RelieveTaxLot(env, buyTrade, element, taxlotStatus.Quantity * -1, true);
taxlotStatus.Quantity = 0;
taxlotStatus.Status = "Closed";
}
}
}
public void TradeDateEvent(PostingEngineEnvironment env, Transaction element)
{
double fxrate = 1.0;
double multiplier = 1.0;
if (env.SecurityDetails.ContainsKey(element.BloombergCode))
{
multiplier = env.SecurityDetails[element.BloombergCode].Multiplier;
}
// Lets get fx rate if needed
if (!element.SettleCurrency.Equals(env.BaseCurrency))
{
fxrate = Convert.ToDouble(FxRates.Find(env.ValueDate, element.SettleCurrency).Rate);
}
if (element.IsBuy() || element.IsShort())
{
var t1 = env.GenerateOpenTaxLot(element, fxrate);
if (element.Quantity == 0)
{
// TODO: Need to review this as we need to see if there is a parent, and what the parents actuall is
return;
}
}
else if (element.IsSell() || element.IsCover())
{
// Get Matching Lots
var openLots = env.Methodology.GetOpenLots(env, element, element.Quantity);
if (openLots.Count() == 0)
{
var t1 = env.GenerateOpenTaxLot(element, fxrate);
// Whats going on here?
// We are skipping anything that does not get an OpenLot
env.AddMessage($"There should be for a sell {element.Symbol} have at least one open lot, non found");
}
else
{
var workingQuantity = element.Quantity;
foreach (var lot in openLots)
{
if (workingQuantity == 0)
{
break;
}
if (!env.TaxLotStatus.ContainsKey(lot.Trade.LpOrderId))
{
// TODO: For this open lot there should be a corresponding open to
continue;
}
var taxlotStatus = env.TaxLotStatus[lot.Trade.LpOrderId];
if (taxlotStatus != null && taxlotStatus.Quantity != 0 && !taxlotStatus.Status.ToLowerInvariant().Equals("closed"))
{
// Does the open Lot fully fullfill the quantity ?
if (Math.Abs(taxlotStatus.Quantity) >= Math.Abs(workingQuantity))
{
var taxlot = CommonRules.RelieveTaxLot(env, lot, element, workingQuantity, true);
taxlotStatus.Quantity += workingQuantity;
if (taxlotStatus.Quantity == 0)
{
taxlotStatus.Status = "Closed";
}
else
{
taxlotStatus.Status = "Partially Closed";
}
CommonRules.GenerateCloseOutPostings(env, lot, taxlot, element, taxlotStatus, env.GetFund(element));
break;
}
else
{
var taxlot = CommonRules.RelieveTaxLot(env, lot, element, taxlotStatus.Quantity * -1);
workingQuantity -= Math.Abs(taxlotStatus.Quantity);
var accountTypes = AccountType.All;
var listOfTags = new List <Tag> {
Tag.Find("SecurityType"),
Tag.Find("CustodianCode")
};
Account fromAccount = null; // Debiting Account
Account toAccount = null; // Crediting Account
var realizedPnl = taxlot.RealizedPnl;
var originalAccount = AccountUtils.GetDerivativeAccountType(realizedPnl);
if (originalAccount.Contains("(Liabilities)"))
{
// This needs to be registered as a Credit to the Libabilities
realizedPnl *= -1;
}
var fromToAccounts = new AccountUtils().GetAccounts(env, originalAccount, "REALIZED GAIN/(LOSS)", listOfTags, taxlot.Trade);
fromAccount = fromToAccounts.From;
toAccount = fromToAccounts.To;
var debitJournal = new Journal(element)
{
Account = fromAccount,
When = env.ValueDate,
StartPrice = taxlot.TradePrice,
EndPrice = taxlot.CostBasis,
CreditDebit = env.DebitOrCredit(fromAccount, taxlot.RealizedPnl),
Value = env.SignedValue(fromAccount, toAccount, true, taxlot.RealizedPnl),
FxRate = fxrate,
Event = Event.REALIZED_PNL,
Fund = env.GetFund(element),
};
var creditJournal = new Journal(debitJournal)
{
Account = toAccount,
CreditDebit = env.DebitOrCredit(toAccount, taxlot.RealizedPnl * -1),
Value = env.SignedValue(fromAccount, toAccount, false, taxlot.RealizedPnl),
};
env.Journals.AddRange(new[] { debitJournal, creditJournal });
taxlotStatus.Quantity = 0;
taxlotStatus.Status = "Closed";
}
}
}
}
}
else
{
// We have a Debit / Credit Dividends
}
}
public void SettlementDateEvent(PostingEngineEnvironment env, Transaction element)
{
if (env.TaxLotStatus.ContainsKey(element.LpOrderId))
{
var taxlot = env.TaxLotStatus[element.LpOrderId];
var tradeCurrency = element.TradeCurrency;
var settleCurrency = element.SettleCurrency;
var allocations = env.FindTradeAllocations(element);
var buy = allocations.Where(i => i.SecurityType.Equals("SPOT") && i.Side.Equals("BUY")).FirstOrDefault();
var sell = allocations.Where(i => i.SecurityType.Equals("SPOT") && i.Side.Equals("SELL")).FirstOrDefault();
if (buy == null || sell == null)
{
Logger.Error($"Unable to process {element.SecurityType}::{element.LpOrderId}");
return;
}
var accountSell = new AccountUtils().CreateAccount(atSettledCash, listOfTradeTags, sell);
var accountBuy = new AccountUtils().CreateAccount(atSettledCash, listOfTradeTags, buy);
new AccountUtils().SaveAccountDetails(env, accountSell);
new AccountUtils().SaveAccountDetails(env, accountBuy);
var sellFx = FxRates.Find(env.ValueDate, sell.TradeCurrency);
var buyFx = FxRates.Find(env.ValueDate, buy.TradeCurrency);
var sellValue = sell.Quantity * sellFx.Rate;
var buyValue = buy.Quantity * buyFx.Rate;
if (element.IsBuy()) // BUY
{
var realizedPnl = buyValue + sellValue;
var debit = new Journal(accountBuy, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = element.TradeCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(buy.Quantity),
FxRate = buyFx.Rate,
StartPrice = 0,
EndPrice = 0,
Value = env.SignedValue(accountBuy, accountSell, true, buyValue),
CreditDebit = env.DebitOrCredit(accountBuy, buy.Quantity),
};
var credit = new Journal(accountSell, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = element.SettleCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(sell.Quantity),
FxRate = sellFx.Rate,
StartPrice = 0,
EndPrice = 0,
Value = env.SignedValue(accountBuy, accountSell, true, sellValue),
CreditDebit = env.DebitOrCredit(accountSell, sell.Quantity),
};
env.Journals.AddRange(new[] { credit, debit });
var originalAccount = AccountUtils.GetDerivativeAccountType(realizedPnl);
// Realized Pnl to go along with the Settled Cash
CommonRules.GenerateJournalEntry(env, element, listOfTags, realizedAccountType, Event.REALIZED_PNL, realizedPnl);
CommonRules.GenerateJournalEntries(env, element, listOfTags, originalAccount, "Change in Unrealized Derivatives Contracts at Fair Value", realizedPnl * -1);
}
else // SELL
{
var realizedPnl = buyValue + sellValue;
var debit = new Journal(accountBuy, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = element.TradeCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(buy.Quantity),
FxRate = buyFx.Rate,
StartPrice = 0,
EndPrice = 0,
Value = env.SignedValue(accountBuy, accountSell, true, buy.Quantity * buyFx.Rate),
CreditDebit = env.DebitOrCredit(accountBuy, buy.Quantity),
};
var credit = new Journal(accountSell, Event.SETTLED_CASH, env.ValueDate)
{
Source = element.LpOrderId,
Fund = env.GetFund(element),
FxCurrency = element.SettleCurrency,
Symbol = element.Symbol,
SecurityId = element.SecurityId,
Quantity = Convert.ToDouble(sell.Quantity),
FxRate = sellFx.Rate,
StartPrice = 0,
EndPrice = 0,
Value = env.SignedValue(accountBuy, accountSell, true, sell.Quantity * sellFx.Rate),
CreditDebit = env.DebitOrCredit(accountSell, sell.Quantity),
};
env.Journals.AddRange(new[] { credit, debit });
var originalAccount = AccountUtils.GetDerivativeAccountType(realizedPnl);
// Realized Pnl to go along with the Settled Cash
CommonRules.GenerateJournalEntry(env, element, listOfTags, realizedAccountType, Event.REALIZED_PNL, realizedPnl);
CommonRules.GenerateJournalEntries(env, element, listOfTags, originalAccount, "Change in Unrealized Derivatives Contracts at Fair Value", realizedPnl * -1);
}
if (taxlot.Quantity != 0)
{
var buyTrade = env.FindTrade(taxlot.OpenId);
CommonRules.RelieveTaxLot(env, buyTrade, element, taxlot.Quantity * -1, true);
taxlot.Quantity = 0;
taxlot.Status = "Closed";
//Now we have Realized Pnl
}
}
}
internal static void GenerateCloseOutPostings(PostingEngineEnvironment env, TaxLotDetail lot, TaxLot taxlot, Transaction element, TaxLotStatus taxlotStatus, string fund)
{
double multiplier = 1.0;
if (env.SecurityDetails.ContainsKey(element.BloombergCode))
{
multiplier = env.SecurityDetails[element.BloombergCode].Multiplier;
}
double fxrate = 1.0;
// Lets get fx rate if needed
if (!element.SettleCurrency.Equals(env.BaseCurrency))
{
fxrate = Convert.ToDouble(FxRates.Find(env.ValueDate, element.SettleCurrency).Rate);
}
var prevPrice = MarketPrices.GetPrice(env, env.PreviousValueDate, lot.Trade).Price;
var unrealizedPnl = Math.Abs(taxlotStatus.Quantity) * (element.SettleNetPrice - prevPrice) * multiplier;
unrealizedPnl = Math.Abs(unrealizedPnl) * CommonRules.DetermineSign(taxlotStatus.Trade);
var buyTrade = env.FindTrade(lot.Trade.LpOrderId);
ReverseUnrealizedPnl(
env,
buyTrade,
element,
unrealizedPnl,
MarketPrices.GetPrice(env, env.PreviousValueDate, lot.Trade).Price,
element.SettleNetPrice, fxrate);
var PnL = taxlot.RealizedPnl;
PostRealizedPnl(
env,
buyTrade,
PnL,
taxlot.TradePrice,
taxlot.CostBasis, fxrate);
var listOfFromTags = new List <Tag>
{
Tag.Find("SecurityType"),
Tag.Find("CustodianCode")
};
Account fromAccount = null;
Account toAccount = null;
if (element.IsDerivative())
{
return;
}
else
{
var accountType = (buyTrade.IsShort() || buyTrade.IsCover()) ? "SHORT POSITIONS AT COST" : "LONG POSITIONS AT COST";
var markToMarketAccount = (buyTrade.IsShort() || buyTrade.IsCover()) ? "Mark to Market Shorts" : "Mark to Market Longs";
fromAccount = new AccountUtils().CreateAccount(AccountType.Find(accountType), listOfFromTags, element);
toAccount = new AccountUtils().CreateAccount(AccountType.Find(markToMarketAccount), listOfFromTags, element);
}
new AccountUtils().SaveAccountDetails(env, fromAccount);
new AccountUtils().SaveAccountDetails(env, toAccount);
// Now Generate Entries
var fromJournal = new Journal(element)
{
Account = fromAccount,
CreditDebit = env.DebitOrCredit(fromAccount, PnL),
When = env.ValueDate,
StartPrice = taxlot.TradePrice,
EndPrice = taxlot.CostBasis,
Value = PnL,
FxRate = 1,
Event = Event.REALIZED_PNL,
Fund = env.GetFund(element),
};
var toJournal = new Journal(fromJournal)
{
Account = toAccount,
CreditDebit = env.DebitOrCredit(toAccount, PnL * -1),
Value = PnL * -1,
};
env.Journals.AddRange(new[] { fromJournal, toJournal });
}
