use of name.abuchen.portfolio.money.Money in project portfolio by buchen.
the class ConsorsbankPDFExtractor method addQ42017DividendTransaction.
@SuppressWarnings("nls")
private void addQ42017DividendTransaction() {
DocumentType type = new DocumentType("Dividendengutschrift");
this.addDocumentTyp(type);
Block block = new Block("Dividendengutschrift.*");
type.addBlock(block);
block.set(new Transaction<AccountTransaction>().subject(() -> {
AccountTransaction t = new AccountTransaction();
t.setType(AccountTransaction.Type.DIVIDENDS);
return t;
}).section("name", "wkn", "isin", //
"currency").find(//
"Wertpapierbezeichnung WKN ISIN").match(//
"(?<name>.*) (?<wkn>[^ ]*) (?<isin>[^ ]*)$").match("Dividende pro Stück ([\\d.]+,\\d+) (?<currency>\\w{3}+).*").assign((t, v) -> {
t.setSecurity(getOrCreateSecurity(v));
}).section("amount", //
"currency").match("Netto zugunsten IBAN (.*) (?<amount>[\\d.]+,\\d+) (?<currency>\\w{3}+)$").assign((t, v) -> {
t.setCurrencyCode(asCurrencyCode(v.get("currency")));
t.setAmount(asAmount(v.get("amount")));
}).section(//
"shares").match(//
"(?<shares>[\\d.]+(,\\d+)?) Stück").assign((t, v) -> t.setShares(asShares(v.get("shares")))).section(//
"date").match("Valuta (?<date>\\d+.\\d+.\\d{4}+).*").assign((t, v) -> t.setDateTime(asDate(v.get("date")))).section("exchangeRate", "fxAmount", "fxCurrency", "amount", "currency").optional().match("Brutto in (\\w{3}+) (?<fxAmount>[\\d.]+,\\d+) (?<fxCurrency>\\w{3}+)").match(//
"Devisenkurs (?<exchangeRate>[\\d.]+,\\d+) (\\w{3}+) / (\\w{3}+)").match(//
"Brutto in (\\w{3}+) (?<amount>[\\d.]+,\\d+) (?<currency>\\w{3}+)").assign((t, v) -> {
BigDecimal rate = asExchangeRate(v.get("exchangeRate"));
BigDecimal inverseRate = BigDecimal.ONE.divide(rate, 10, BigDecimal.ROUND_HALF_DOWN);
type.getCurrentContext().put("exchangeRate", inverseRate.toPlainString());
Money fxAmount = Money.of(asCurrencyCode(v.get("fxCurrency")), asAmount(v.get("fxAmount")));
Money amount = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("amount")));
if (!t.getCurrencyCode().equals(t.getSecurity().getCurrencyCode())) {
Unit grossValue = new Unit(Unit.Type.GROSS_VALUE, amount, fxAmount, inverseRate);
t.addUnit(grossValue);
}
}).section("tax", "currency").optional().match("abzgl. Quellensteuer .* (\\w{3}+) (?<tax>[\\d.]+,\\d+) (?<currency>\\w{3}+)").assign((t, v) -> {
Money tax = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("tax")));
if (tax.getCurrencyCode().equals(t.getCurrencyCode())) {
t.addUnit(new Unit(Unit.Type.TAX, tax));
} else if (type.getCurrentContext().containsKey("exchangeRate")) {
BigDecimal exchangeRate = new BigDecimal(type.getCurrentContext().get("exchangeRate"));
Money txTax = Money.of(t.getCurrencyCode(), BigDecimal.valueOf(tax.getAmount()).multiply(exchangeRate).setScale(0, BigDecimal.ROUND_HALF_UP).longValue());
t.addUnit(new Unit(Unit.Type.TAX, txTax));
// update gross value if necessary
if (!t.getCurrencyCode().equals(t.getSecurity().getCurrencyCode())) {
Unit grossValue = t.getUnit(Unit.Type.GROSS_VALUE).get();
t.removeUnit(grossValue);
t.addUnit(new Unit(Unit.Type.GROSS_VALUE, grossValue.getAmount().subtract(txTax), grossValue.getForex().subtract(tax), grossValue.getExchangeRate()));
}
}
}).section("tax", "currency").optional().match("abzgl. Kapitalertragsteuer .* (\\w{3}+) (?<tax>[\\d.]+,\\d+) (?<currency>\\w{3}+)$").assign((t, v) -> {
Money tax = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("tax")));
t.addUnit(new Unit(Unit.Type.TAX, tax));
}).section("tax", "currency").optional().match("abzgl. Solidaritätszuschlag .* (\\w{3}+) (?<tax>[\\d.]+,\\d+) (?<currency>\\w{3}+)$").assign((t, v) -> {
Money tax = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("tax")));
t.addUnit(new Unit(Unit.Type.TAX, tax));
}).wrap(t -> t.getAmount() != 0 ? new TransactionItem(t) : null));
}
use of name.abuchen.portfolio.money.Money in project portfolio by buchen.
the class DABPDFExtractor method addSellTransaction.
@SuppressWarnings("nls")
private void addSellTransaction() {
DocumentType type = new DocumentType("Verkauf");
this.addDocumentTyp(type);
Block block = new Block("^Verkauf .*$");
type.addBlock(block);
Transaction<BuySellEntry> pdfTransaction = new Transaction<>();
pdfTransaction.subject(() -> {
BuySellEntry entry = new BuySellEntry();
entry.setType(PortfolioTransaction.Type.SELL);
return entry;
});
block.set(pdfTransaction);
//
pdfTransaction.section("isin", "name", "currency").find(//
"Gattungsbezeichnung ISIN").match("^(?<name>.*) (?<isin>[^ ]*)$").match("STK [\\d.]+(,\\d+)? (?<currency>\\w{3}+) ([\\d.]+,\\d+)$").assign((t, v) -> t.setSecurity(getOrCreateSecurity(v))).section(//
"shares").find(//
"Nominal Kurs").match("^STK (?<shares>[\\d.]+(,\\d+)?) (\\w{3}+) ([\\d.]+,\\d+)$").assign((t, v) -> t.setShares(asShares(v.get("shares")))).section("amount", "currency").optional().find("Wert Konto-Nr. Betrag zu Ihren Gunsten").match("^(\\d+.\\d+.\\d{4}+) ([0-9]*) (?<currency>\\w{3}+) (?<amount>[\\d.]+,\\d+)$").assign((t, v) -> {
t.setAmount(asAmount(v.get("amount")));
t.setCurrencyCode(asCurrencyCode(v.get("currency")));
}).section("amount", "currency", "exchangeRate", "forex", "forexCurrency").optional().find(".* Ausmachender Betrag (?<forexCurrency>\\w{3}+) (?<forex>[\\d.]+,\\d+)").find("Wert Konto-Nr. Devisenkurs Betrag zu Ihren Gunsten").match("^(\\d+.\\d+.\\d{4}+) ([0-9]*) .../... (?<exchangeRate>[\\d.]+,\\d+) (?<currency>\\w{3}+) (?<amount>[\\d.]+,\\d+)$").assign((t, v) -> {
Money amount = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("amount")));
t.setMonetaryAmount(amount);
BigDecimal exchangeRate = //
BigDecimal.ONE.divide(asExchangeRate(v.get("exchangeRate")), 10, BigDecimal.ROUND_HALF_DOWN);
Money forex = Money.of(asCurrencyCode(v.get("forexCurrency")), asAmount(v.get("forex")));
Unit grossValue = new Unit(Unit.Type.GROSS_VALUE, amount, forex, exchangeRate);
t.getPortfolioTransaction().addUnit(grossValue);
}).section(//
"date").match("^Handelstag (?<date>\\d+.\\d+.\\d{4}+) .*$").assign((t, v) -> t.setDate(asDate(v.get("date")))).section("fees", "currency").optional().match("^.*Provision (?<currency>\\w{3}+) (?<fees>[\\d.]+,\\d+)-$").assign((t, v) -> {
String currency = asCurrencyCode(v.get("currency"));
if (currency.equals(t.getAccountTransaction().getCurrencyCode())) {
t.getPortfolioTransaction().addUnit(new Unit(Unit.Type.FEE, Money.of(currency, asAmount(v.get("fees")))));
}
}).wrap(t -> {
if (t.getPortfolioTransaction().getAmount() == 0L)
throw new IllegalArgumentException("No amount found");
return new BuySellEntryItem(t);
});
addTaxesSectionsTransaction(type, pdfTransaction);
}
use of name.abuchen.portfolio.money.Money in project portfolio by buchen.
the class DegiroPDFExtractor method addBankAccountTransactions.
@SuppressWarnings("nls")
private void addBankAccountTransactions() {
DocumentType type = new DocumentType("Kontoauszug");
this.addDocumentTyp(type);
// 02-08-2017 00:00 Einzahlung EUR 350,00 EUR 350,00
Block blockDeposit = new Block(".* Einzahlung .*");
type.addBlock(blockDeposit);
blockDeposit.set(new Transaction<AccountTransaction>().subject(() -> {
AccountTransaction t = new AccountTransaction();
t.setType(AccountTransaction.Type.DEPOSIT);
return t;
}).section("date", "currency", "amount").match("(?<date>\\d+-\\d+-\\d{4}) \\d+:\\d+ Einzahlung (?<currency>\\w{3}) (?<amount>[\\d.]+,\\d{2}) .*").assign((t, v) -> {
t.setCurrencyCode(asCurrencyCode(v.get("currency")));
t.setDateTime(asDate(v.get("date")));
t.setAmount(asAmount(v.get("amount")));
}).wrap(t -> new TransactionItem(t)));
// 03-08-2017 15:32 BERKSHIRE HATHAWAY INC US0846707026 Währungswechsel USD 177,50 USD 0,00
// (Einbuchung)
// 03-08-2017 15:32 BERKSHIRE HATHAWAY INC US0846707026 Währungswechsel 1,1851 EUR -149,92 EUR 36,52
// (Ausbuchung)
// 03-08-2017 15:32 BERKSHIRE HATHAWAY INC US0846707026 Transaktionsgebühr EUR -0,50 EUR 186,44
// 03-08-2017 15:32 BERKSHIRE HATHAWAY INC US0846707026 Kauf 1 zu je 177,5 USD -177,50 USD -177,50
Block blockBuyForex = new Block(".*Einbuchung.*");
type.addBlock(blockBuyForex);
blockBuyForex.set(new Transaction<BuySellEntry>().subject(() -> {
BuySellEntry entry = new BuySellEntry();
entry.setType(PortfolioTransaction.Type.BUY);
return entry;
}).section("date", "isin", "name", "shares", "currency", "amount").match("(?<date>\\d+-\\d+-\\d{4} \\d+:\\d+) (?<name>.*) (?<isin>[^ ]+) Kauf (?<shares>[.\\d]+[,\\d]*) zu je [.\\d]+[,\\d]* (?<currency>\\w{3}) -(?<amount>[.\\d]+,\\d{2}) .*").assign((t, v) -> {
t.setSecurity(getOrCreateSecurity(v));
t.setDate(asDate(v.get("date")));
t.setShares(asShares(v.get("shares")));
t.setCurrencyCode(asCurrencyCode(v.get("currency")));
t.setAmount(asAmount(v.get("amount")));
}).section("exchangeRate", "currency", "amount").optional().match(".* Währungswechsel (?<exchangeRate>[.\\d]+,\\d+) (?<currency>\\w{3}) -(?<amount>[.\\d]+,\\d{2}) .*").assign((t, v) -> {
// in fx
Money currentMonetaryAmount = t.getAccountTransaction().getMonetaryAmount();
// exchange rate in fx/EUR
BigDecimal exchangeRate = asExchangeRate(v.get("exchangeRate"));
BigDecimal accountMoneyValue = BigDecimal.valueOf(t.getAccountTransaction().getAmount()).divide(exchangeRate, // in EUR
RoundingMode.HALF_DOWN);
// "EUR"
String currencyCode = asCurrencyCode(v.get("currency"));
// in EUR
Money accountMoney = Money.of(currencyCode, Math.round(accountMoneyValue.doubleValue()));
// change total amount to amount in EUR
// "EUR"
t.setCurrencyCode(currencyCode);
// in EUR
t.setMonetaryAmount(accountMoney);
// replace BRUTTO (which is in foreign currency) with the value in transaction currency
BigDecimal inverseRate = BigDecimal.ONE.divide(exchangeRate, 10, BigDecimal.ROUND_HALF_DOWN);
Unit grossValue = new Unit(Unit.Type.GROSS_VALUE, accountMoney, currentMonetaryAmount, inverseRate);
t.getPortfolioTransaction().addUnit(grossValue);
// the difference between the accountMoney and the amount after changing the currency
// are the fees and taxes which had to be paid in Fx
// in EUR
Money feesAndTaxes = Money.of(currencyCode, asAmount(v.get("amount"))).subtract(accountMoney);
BigDecimal feesAndTaxesFxValue = BigDecimal.valueOf(feesAndTaxes.getAmount()).multiply(// in USD
exchangeRate);
Money feesAndTaxesFx = Money.of(t.getPortfolioTransaction().getSecurity().getCurrencyCode(), // in USD
Math.round(feesAndTaxesFxValue.doubleValue()));
// add fee in fx currency and to total amount
t.getPortfolioTransaction().addUnit(new Unit(Unit.Type.FEE, feesAndTaxes, feesAndTaxesFx, inverseRate));
t.setMonetaryAmount(accountMoney.add(feesAndTaxes));
}).section("fee", "currency").optional().match(".* Transaktionsgebühr (?<currency>\\w{3}) -(?<fee>[.\\d]+,\\d{2}) .*").assign((t, v) -> {
// set fee
Money feeAmount = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("fee")));
t.getPortfolioTransaction().addUnit(new Unit(Unit.Type.FEE, feeAmount));
// add fee to total amount
Money currentMonetaryAmount = t.getAccountTransaction().getMonetaryAmount();
t.setMonetaryAmount(currentMonetaryAmount.add(feeAmount));
}).wrap(t -> new BuySellEntryItem(t)));
}
use of name.abuchen.portfolio.money.Money in project portfolio by buchen.
the class DeutscheBankPDFExtractor method addDividendTransaction.
@SuppressWarnings("nls")
private void addDividendTransaction(String nameOfTransaction) {
DocumentType type = new DocumentType(nameOfTransaction);
this.addDocumentTyp(type);
Block block = new Block(nameOfTransaction);
type.addBlock(block);
block.set(new Transaction<AccountTransaction>().subject(() -> {
AccountTransaction transaction = new AccountTransaction();
transaction.setType(AccountTransaction.Type.DIVIDENDS);
return transaction;
}).section("wkn", "isin", "name", //
"currency").find(//
"Stück WKN ISIN").match(//
"(\\d+,\\d*) (?<wkn>\\S*) (?<isin>\\S*)").match(//
"^(?<name>.*)$").match(//
"Bruttoertrag ([\\d.]+,\\d+) (?<currency>\\w{3}+).*").assign((t, v) -> t.setSecurity(getOrCreateSecurity(v))).section(//
"shares").match("(?<shares>\\d+,\\d*) (\\S*) (\\S*)").assign((t, v) -> t.setShares(asShares(v.get("shares")))).section("date", "amount", "currency").match("Gutschrift mit Wert (?<date>\\d+.\\d+.\\d{4}+) (?<amount>[\\d.]+,\\d+) (?<currency>\\w{3}+)").assign((t, v) -> {
t.setDateTime(asDate(v.get("date")));
t.setAmount(asAmount(v.get("amount")));
t.setCurrencyCode(asCurrencyCode(v.get("currency")));
}).section("grossValue", //
"currency").optional().match("Bruttoertrag (?<grossValue>[\\d.]+,\\d+) (?<currency>\\w{3}+)").assign((t, v) -> {
Money grossValue = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("grossValue")));
// calculating taxes as the difference between gross
// value and transaction amount
Money taxes = MutableMoney.of(t.getCurrencyCode()).add(grossValue).subtract(t.getMonetaryAmount()).toMoney();
if (!taxes.isZero())
t.addUnit(new Unit(Unit.Type.TAX, taxes));
}).section("forexSum", "forexCurrency", "grossValue", "currency", //
"exchangeRate").optional().match("Bruttoertrag (?<forexSum>[\\d.]+,\\d+) (?<forexCurrency>\\w{3}+) (?<grossValue>[\\d.]+,\\d+) (?<currency>\\w{3}+)").match(//
"Umrechnungskurs (\\w{3}+) zu (\\w{3}+) (?<exchangeRate>[\\d.]+,\\d+)").assign((t, v) -> {
Money grossValue = Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("grossValue")));
Money forex = Money.of(asCurrencyCode(v.get("forexCurrency")), asAmount(v.get("forexSum")));
BigDecimal exchangeRate = //
BigDecimal.ONE.divide(asExchangeRate(v.get("exchangeRate")), 10, BigDecimal.ROUND_HALF_DOWN);
Unit unit = new Unit(Unit.Type.GROSS_VALUE, grossValue, forex, exchangeRate);
// security actually matches
if (unit.getForex().getCurrencyCode().equals(t.getSecurity().getCurrencyCode()))
t.addUnit(unit);
// calculating taxes as the difference between gross
// value and transaction amount
Money taxes = MutableMoney.of(t.getCurrencyCode()).add(grossValue).subtract(t.getMonetaryAmount()).toMoney();
if (!taxes.isZero())
t.addUnit(new Unit(Unit.Type.TAX, taxes));
}).wrap(t -> new TransactionItem(t)));
}
use of name.abuchen.portfolio.money.Money in project portfolio by buchen.
the class FinTechGroupBankPDFExtractor method addForeignDividendTransaction.
@SuppressWarnings("nls")
private void addForeignDividendTransaction() {
DocumentType type = new DocumentType("Dividendengutschrift für ausländische Wertpapiere", (context, lines) -> {
Pattern pCurrency = Pattern.compile(".* Endbetrag .* (?<currency>\\w{3})$");
Pattern pCurrencyFx = Pattern.compile(".* Bruttodividende *: *[.\\d]+,\\d{2} (?<currencyFx>\\w{3})");
Pattern pExchangeRate = Pattern.compile("Devisenkurs *: *(?<exchangeRate>[.\\d]+,\\d+) .*");
// read the current context here
for (String line : lines) {
Matcher m = pCurrency.matcher(line);
if (m.matches()) {
context.put("currency", m.group(1));
// System.out.println("context currency found: " + context.get("currency"));
}
m = pCurrencyFx.matcher(line);
if (m.matches()) {
context.put("currencyFx", m.group(1));
// System.out.println("context currencyFx found: " + context.get("currencyFx"));
}
m = pExchangeRate.matcher(line);
if (m.matches()) {
context.put("exchangeRate", m.group(1));
// System.out.println("context exchangeRate found: " + context.get("exchangeRate"));
}
}
});
this.addDocumentTyp(type);
Block block = new Block("Ihre Depotnummer.*");
type.addBlock(block);
block.set(new Transaction<AccountTransaction>().subject(() -> {
AccountTransaction t = new AccountTransaction();
t.setType(AccountTransaction.Type.DIVIDENDS);
return t;
}).section("wkn", "isin", //
"name").match(//
"Nr\\.(\\d*) * (?<name>.*) *\\((?<isin>[^/]*)/(?<wkn>[^)]*)\\)").assign((t, v) -> {
Map<String, String> context = type.getCurrentContext();
// the security must be in Fx units, otherwise, dividends and taxes cannot be in Fx units
v.put("currency", context.get("currencyFx"));
// System.out.println("Security Currency: " + context.get("currency"));
t.setSecurity(getOrCreateSecurity(v));
// System.out.println("Security Info: " + t.getSecurity().toInfoString());
}).section(//
"shares").match(//
"^St\\.[^:]+: *(?<shares>[\\.\\d]+(,\\d*)?).*").assign((t, v) -> t.setShares(asShares(v.get("shares")))).section("amountGrossFx", //
"currencyFx").match(//
".* Bruttodividende *: *(?<amountGrossFx>[.\\d]+,\\d{2}) (?<currencyFx>\\w{3})").assign((t, v) -> {
// get exchange rate (in Fx/EUR) and calculate inverse exchange rate (in EUR/Fx)
Map<String, String> context = type.getCurrentContext();
BigDecimal exchangeRate = asExchangeRate(context.get("exchangeRate"));
BigDecimal inverseRate = BigDecimal.ONE.divide(exchangeRate, 10, BigDecimal.ROUND_HALF_DOWN);
// set currency of transaction (should be in EUR)
String currencyCode = asCurrencyCode(context.get("currency"));
t.setCurrencyCode(currencyCode);
// get foreign currency (should be in Fx)
String currencyCodeFx = asCurrencyCode(v.get("currencyFx"));
// get gross amount and calculate equivalent in EUR
Money mAmountGrossFx = Money.of(currencyCodeFx, Math.round(asAmount(v.get("amountGrossFx"))));
BigDecimal amountGrossFxInEUR = BigDecimal.valueOf(mAmountGrossFx.getAmount()).divide(exchangeRate, 10, BigDecimal.ROUND_HALF_DOWN);
Money mAmountGrossFxInEUR = Money.of(currencyCode, Math.round(amountGrossFxInEUR.longValue()));
t.addUnit(new Unit(Unit.Type.GROSS_VALUE, mAmountGrossFxInEUR, mAmountGrossFx, inverseRate));
}).section("amountFx", "currencyFx").optional().match(//
".* Gez. Quellenst. *: *(?<amountFx>[.\\d]+,\\d{2}) (?<currencyFx>\\w{3})").assign((t, v) -> {
// get exchange rate (in Fx/EUR) and calculate inverse exchange rate (in EUR/Fx)
Map<String, String> context = type.getCurrentContext();
BigDecimal exchangeRate = asExchangeRate(context.get("exchangeRate"));
BigDecimal inverseRate = BigDecimal.ONE.divide(exchangeRate, 10, BigDecimal.ROUND_HALF_DOWN);
// get foreign currency (should be in Fx) and transaction currency (should be in EUR)
String currencyCode = asCurrencyCode(context.get("currency"));
String currencyCodeFx = asCurrencyCode(v.get("currencyFx"));
// get foreign taxes and calculate equivalent in EUR
Money mTaxesFx = Money.of(currencyCodeFx, Math.round(asAmount(v.get("amountFx"))));
BigDecimal taxesFxInEUR = BigDecimal.valueOf(mTaxesFx.getAmount()).divide(exchangeRate, 10, BigDecimal.ROUND_HALF_DOWN);
Money mTaxesFxInEUR = Money.of(currencyCode, Math.round(taxesFxInEUR.longValue()));
t.addUnit(new Unit(Unit.Type.TAX, mTaxesFxInEUR, mTaxesFx, inverseRate));
}).section("amount", //
"currency").match(//
".* Endbetrag *: *(?<amount>[\\d.-]+,\\d+) (?<currency>\\w{3}+)").assign((t, v) -> {
t.setCurrencyCode(asCurrencyCode(v.get("currency")));
t.setAmount(asAmount(v.get("amount")));
}).section("tax", "currency").optional().match(//
"(.*)Einbeh. Steuer(.*):(\\s*)(?<tax>[\\d.]+,\\d+) (?<currency>\\w{3}+)").assign((t, v) -> t.addUnit(new Unit(Unit.Type.TAX, Money.of(asCurrencyCode(v.get("currency")), asAmount(v.get("tax")))))).section(//
"date").match(//
"Valuta * : *(?<date>\\d+.\\d+.\\d{4}+).*").assign((t, v) -> t.setDateTime(asDate(v.get("date")))).wrap(t -> new TransactionItem(t)));
}
Aggregations