Get Portfolio Transactions - rosssaunders/FusionLinkDocs GitHub Wiki
Description
Returns the transactions of a portfolio as a table for the given date range.
(Similar to BBG BDH function)
Syntax
GETPORTFOLIOTRANSACTIONS(portfolio_id, start_date, end_date, extra_fields)
The GETPORTFOLIOTRANSACTIONS function has the following arguments
- portfolio_id Required. The Portfolio Id.
- start_date Optional. Start date of the price range.
- end_date Optional. End date of the price range.
- extra_fields Optional. A list of additional fields to display for each transaction. The below for the full list of available fields.
Returns
A table array with the transaction details. The following fields are returned by default
| Position | TransactionCode | InstrumentCode | Instrument | TransactionDate | TransactionTime | Operator | TransactionType | Entity | Depositary | Broker | Counterparty | BrokerFees | CounterpartyFees | MarketFees | Quantity | Spot | AskQuotationType | GrossAmount | NetAmount | Comment | BackOfficeInfos | BackOfficeType |
|---|
Examples
| Formula | Result |
|---|---|
| =GETPORTFOLIOTRANSACTIONS(12345) | An array of transactions |
| =GETPORTFOLIOTRANSACTIONS(12345, "01-JAN-2019", "31-MAY-2019") | An array of transactions with the given start and end dates |
Extra Fields
The extra fields parameter can take any of the following fields
- AccountancyDate
- AccountingBook
- AccruedAmount
- AccruedAmount2
- AccruedCoupon
- AccruedCouponDate
- Adjustment
- AskQuotationType
- BackOfficeInfos
- BackOfficeRef
- BackOfficeType
- BasketInstrumentRef
- BasketInternalCode
- BasketQuantity
- BenchmarkCode
- BlockTrade
- Broker
- BrokerFees
- CashDepositary
- ClearingExceptionParty
- ClearingHouse
- ClearingMember
- Comment
- Commission
- CommissionDate
- ComponentCode
- CompressionResult
- Counterparty
- Counterparty2
- CounterpartyFees
- CreationKind
- CrossedReference
- DecisionMaker
- DeliveryDate
- DeliveryType
- Depositary
- DepositaryOfCounterparty
- Entity
- ExecutionVenue
- FolioCode
- ForceLoad
- ForexCertaintyType
- ForexSpot
- ForwardFixingDate
- GrossAmount
- InitialMargin
- Instrument
- InstrumentCode
- InvestmentStrategyId
- LostroCashId
- LostroPhysicalId
- MarketFees
- MirroringEnabler
- MirroringReference
- MirrorRule
- NetAmount
- NostroCashId
- NostroPhysicalId
- Notional
- Operator
- OrderId
- OrderReference
- OtherTradeRepository
- PariPassuDate
- PaymentCurrencyType
- PaymentMethod
- PoolFactor
- Position
- PositionType
- PsetId
- Quantity
- Reference
- ReportingCtpy
- SettlementCurrency
- SettlementDate
- SettlementMethod
- SophisOrderId
- Spot
- TradeRepository
- TradeYtm
- TransactionCode
- TransactionDate
- TransactionTime
- TransactionType
- TypeSpotCurrency