Functions on positions
Position.speciesvalue→number
Result: The Species value
function returns the sum of the market values of all positions of the same security type. The "Grouping" parameter (here grouping type "2") is used for transactions on securities account valuations: "species"). This function is obsolete and has now been replaced by the more flexible asset class constructs in the standard evaluations.
Position.stock→number
Result: The Position
function returns the position of the securities item on the evaluation date in units or nominal.
Position.valuationobject→Custody account valuation
Result: The Valuation object
function returns the valuation object that created the item.
Position.BookEntries→List
(BookEntry)
Result: The BookEntries
function returns the list of all transactions (BookEntries) that belong to this securities account item.
Position.BookEntryHistory→List
(BookEntry)
Result: The BookEntryHistory
function displays all BookEntries across transfers.
Position.sector value→number
Result: The sector value
function returns the sum of the market values of all items in the same sector. The "Grouping" parameter (here grouping type "1") is used for transactions on securities account valuations: "Industries"). This function is obsolete and has now been replaced by the more flexible asset class constructs in the standard evaluations.
Position.breakEvenPrice→Number
Result: The function returns the cost price as the break-even price calculated in position currency.
Position.BreakEvenPriceDev→Number
Result: The BreakEvenKursDev
function returns the cost price as the break-even price calculated in the evaluation currency.
Position.depot→Depot
Result: The Depot
function returns the depot to which the position refers.
Position.InstrumentCosts
[FromDate;ToDate]→InstrumentCosts
FromDate (date).
ToDate (date).
Result: The InstrumentCosts
function returns the product costs of the security in percent p.a. for the specified time interval from the cost service. If a product cost history has been created locally via the securities master data, these values are prioritized.
Cost service" module
Position.buy price→number
Result: The buy rate
function returns the purchase price as a mixed rate calculated in position currency.
Position.buy priceDev→number
Result: The function Buy rateDev
returns the purchase rate as a mixed rate calculated in the evaluation currency.
Position.purchase price→number
Result: The purchase price
function returns stock * purchase price.
Position.purchase.priceDev→number
Result: The purchase priceDev
function returns stock * purchase priceDev.
Position.purchase priceRel→Number
Result: The purchase priceRel
function returns the relative purchase price as a percentage (base 1): Purchase priceDev/total purchase priceDev of the depot valuation object.
Position.couponYieldStartDev→Number
Result: The KuponErtragBeginnDev
function provides the securities income in the reference currency plus taxes paid and interim profit/accrued interest difference on the start date.
Position.couponYieldDev→Number
Result: The KuponErtragDev
function provides the securities income in the reference currency plus taxes paid and interim profit/accrued interest difference on the valuation date.
Position.couponValue→Number
Result: The CouponValue
function provides the interest and accrued interest paid for bonds (no pending accrued interest), dividends for shares and fund distributions for funds in position currency. Before deduction of taxes paid (gross).
Position.couponValueDev→Number
Result: The KuponWertDev
function provides the interest and accrued interest paid for bonds (no pending accrued interest), dividends for shares and fund distributions for funds at the time of the order in the evaluation currency. Before deduction of taxes paid (gross).
Position.couponValueSzDev→Number
Result: The KuponWertSzDev
function returns the securities income in the reference currency including the accrued interest/interim profits currently accrued. Before deduction of taxes paid (gross).
Position.country value→number
Result: The Country value
function returns the sum of the market values of all positions in the same country. The "Grouping" parameter (here grouping type "3") is used for transactions on securities account valuations: "Countries"). This function is obsolete and has now been replaced by the more flexible asset class constructs in the standard evaluations.
Position.storage location→Storage location
Result: The Position
function returns the position to which the item refers.
Position.lastpurchase→Date
Result: The LastPurchase
function returns the last purchase date.
Position.PosPerformanceDev
[weight]→number
Weight (number).
Result: The PosPerformanceDev
function returns the performance share of the securities account position (geometric, weighted) as part of the performance attribution. The<PerformanceAttribution>parameter of the portfolio valuation
function must be set to "True".
Module "Portfolio Service Extended Portfolio Analysis"
Position.Restrictions→List
(PositionRestriction)
Result: The Restrictions
function provides the list of restrictions for the securities account item.
Module "Portfolio Service Extended Portfolio Analysis"
Position.restriction violations→List
(String)
Result: The Restriction violations
function provides the list of restrictions that were violated when a securities account position was checked. This evaluation can only be carried out at portfolio level.
Module "Portfolio Service Extended Portfolio Analysis"
Position.TA_Anz_Abgeltungsteuer→Zahl
Result: The TA_Anz_Abgeltungsteuer
function returns the number of taxable persons after withholding tax.
Position.TA_Anz_Steuerfrei→Zahl
Result: The TA_Anz_Steuerfrei
function returns the number of tax-free items.
Position.TA_AnzGesperrt→Zahl
Result: The TA_AnzGesperrt
function returns the number of locked items in the transaction.
Position.TO_delivery→number
Result: The TA_Delivery
function delivers the delivery in valuation currency.
Position.TA_Foreign exchange gain→Number
Result: The function TA_Foreign exchange gain
returns the unrealized foreign exchange gain of the position (without price gain).
Position.TA_Foreign exchange gainRealized→Number
Result: The function TA_DevisengewinnRealisiert
returns the total realized foreign exchange gain of the position.
Position.TO_delivery→number
Result: The TA_Einlieferung
function returns the deposit in valuation currency.
Position.TA_profit→number
Result: The function TA_Gewinn
returns the profit as (TA_KurswertVerkauf * TA_WechselkursVerkauf) - KaufpreisDev
in evaluation currency. Depending on the setting of the portfolio valuation parameters, distributions ("Include fund distributions"), dividends ("Include dividends") and interest coupons ("Include interest") are also added.
Position.TA_GewinnProzent→Zahl
Result: The TA_GewinnProzent
function returns the percentage profit as TA_Gewinn / abs(KaufpreisDev)
.
Position.TA_ProfitRealized→Number
Result: The TA_GewinnRealisiert
function returns the total profit realized on the position.
Position.TA_PriceDateSale→Date
Result: The TA_KursdatumVerkauf
function returns the date of the security price on the evaluation date, which may differ from the evaluation date.
Position.TA_price_gain→number
Result: The function TA_Kursgewinn
returns the unrealized price gain of the position (without foreign exchange gain).
Position.TA_Price_gainRealized→Number
Result: The function TA_KursgewinnRealisiert
returns the total realized price gain of the position.
Position.TA_PriceSale→Number
Result: The TA_KursVerkauf
function returns the potential selling price on the valuation date in position currency. This function returns the "Clean Price" for bonds and the price with or without interim profits for funds, depending on the "Consider interim profits" parameter.
Position.TA_price_value_share→number
Result: The TA_Kurswertanteil
function returns the share of the market value of the position in the assets.
Position.TA_PriceSale→Number
Result: The function TA_KurswertVerkauf
returns position * sales price / security price factor
in security currency (possibly reduced by charges from the commission scheme). The "clean price" (i.e. without accrued interest or interim profits) is always used as the selling price.
Position.TA_PriceSaleCum→Number
Result: The function TA_KurswertVerkaufCum
returns the sum of TA_KurswertVerkauf + TA_Stückzinsen + TA_Zwischengewinn
.
Position.TA_Pool_factor→number
Result: The TA_Poolfaktor
function returns the current pool factor of the position.
Position.TA_PortfolioExogen_WP→Number
Result: The TA_PortfolioExogen_WP
function returns the value of the exogenous cash flows in relation to a securities account or portfolio on the valuation date in valuation currency.
Position.TA_Yield→Number
Result: The function TA_Rendite
returns the yield of a bond (based on 1) if the security is a bond, otherwise n/a.
Position.TA_SperrListe→Liste
(LockInfo)
Result: The TA_SperrListe
function returns the list with the relevant lock information.
Item.TA_accrued_interest→number
Result: The TA_Per Accrued Interest
function returns the position * (accrued interest for bonds) in position currency.
Position.TA_Tranche→List
(Tranche)
Result: The TA_Tranches
function returns the list of tranches for this item.
Position.TA_UnclearedQuantity→Number
Result: The TA_UnclearedQuantity
function returns the sum of the nominal values for open orders. These are unsettled orders with the status "Released" or higher. This key figure is calculated if the "Open orders" parameter is set to "True" in the securities account valuation.
Position.TA_ExchangeRatePurchase→Number
Result: The function TA_WechselkursKauf
returns purchase rateDev / purchase rate
in evaluation currency by position currency.
Position.TA_ExchangeRateSale→Number
Result: The TA_WechselkursVerkauf
function returns the exchange rate from the evaluation currency to the item currency on the evaluation date.
Position.TA_Intermediate_profit→number
Result: The TA_Interim profit
function returns the interim profit of the fund position at the time of evaluation in position currency.
Position.TA_Interim_profit_paid→Number
Result: The TA_Zwischengewinn_Gezahlt
function returns the interim profit paid for the securities account position in position currency.
Position.TargetMarketProfileMatch
[Category]→TargetMarketMatchType
Category (IndexString|String): Target market category.
Result: The TargetMarketProfileMatch
function provides a value at portfolio level that indicates the match of the user profile with the respective target market category of the security from the target market service (possible states: "Yes", "No", "Partly", "n/a"). The target market category can be transferred as an index string or as a string. In the case of the IndexString, its code is used, otherwise the string is interpreted as the code of the target market category. If the category was not found or no value exists, the return value is an empty string.
"Target market" module and "Investment profile recording" module or "Direct investment profile recording" module
List(Position).TargetMarketProfileMatches→List
(TargetMarketMatchResult)
Result: The TargetMarketProfileMatches
function returns a list of TargetMarketMatchResult on a list of positions, which shows the match of the investment profile with the respective target market category of the securities from the target market service.
"Target market" module and "Investment profile recording" module or "Direct investment profile recording" module
Position.TargetMarketResult→TargetMarketMatchResult
Result: The TargetMarketResult
function provides information on the target market match.
Target market" module
Position.TotalInstrumentCosts→TotalInstrumentCosts
Result: The TotalInstrumentCosts
function provides the total securities costs of a position in the evaluation period in the valuation currency.
Cost service" module
Position.currency→Currency
Result: The Currency
function returns the position currency of the security from the transaction.
Position.currenciesvalue→number
Result: The currency value
function returns the sum of the market values of all items in the same currency. The "Grouping" parameter (here grouping type "4") is used for transactions on securities account valuations: "Currencies"). This function is obsolete and has now been replaced by the more flexible asset class constructs in the standard evaluations.
Position.WP→Securities
Result: The WP
function returns the security to which the position refers.
Position.WPPerformanceDev→Number
Result: The WPPerformanceDev
function provides the performance of the security linked to the securities account position (geometric, unweighted) as part of the performance attribution. The <PerformanceAttribution> parameter of the portfolio valuation function must be set to "True".
Module "Portfolio Service Extended Portfolio Analysis"