Redemptions and Subscriptions Inserter¶
The Redemptions and Subscriptions Inserter worker is responsible for processing and entering redemptions and subscriptions of funds. It receives a file, and insert the operations into its respective destination portfolio. The Redemptions and Subscriptions Inserter worker generates a datastore with the Redemptions and Subscriptions information.
Parameters¶
The Redemptions and Subscriptions Inserter worker must receive specific parameters in order to execute properly. When parameters are not set correctly it may cause the worker to not work as expected. This worker's parameters are separated in the following tabs: Input and Output.
Input¶
The Input tab contains parameters which are consumed by the worker, in order to execute its calculations or actions.
File
The File field receives the data of redemptions and subscriptions carried out in the portfolio. These information must be properly structured in a .csv file extension. Set File using Upstream File, Fixed File or Get Latest variants.
The Redemptions and Subscriptions Inserter file is a Comma-Separated Values (csv) extension, the header must contain the following fields: Value (negative for Redemption, positive for Subscription), Cash Date, and Portfolio UID information. If additional information related to the operation is sent, such as book, dealer, the worker automatically adds these columns to the datastore data. Each row corresponds to a Redemption/Subscription. The table below shows an example of filling.
| Cash Date | Value | Portfolio UID |
|---|---|---|
| 20211216 | -150000 | 00000000000000 |
Workspace
The so-called fields set the research workspace of the File (1.1). Set workspace using Fixed Workspace variant.
Output¶
The Output tab contains parameters that defines the worker execution results, and how it will be provided to downstream workers.
Name
Set the output datastore name using Template Text or Upstream Datavariants.
Date
Select the output datastore date using Fixed Date or Upstream Data variants. By default, the created datastore has the same date as the operations.
Workspace
Set the workspace in which the datastore will be saved on the platform.
Tags
Set the datastore tags using Fixed Tags or Upstream Data variants.
Results¶
The results of the Redemptions and Subscriptions Inserter worker, is a datastore, containing information about the redemptions and subscriptions. Below you can see an example of the Redemptions and Subscription Inserter result object hierarchy. You can check the Output Types article to learn more about result objects types.
- Datastore (datastore)
- ID (string)
- Name (string)
- Date (date)
- Tags (list)
- Data (list)
Data
The data in the datastore is a table, in which has the at least the following columns: Value, Quantity, Execution Date and Portfolio UID. Each row corresponds to a Redemption/Subscription operation.