Manage Stock Book in sync with Financial Book upon buying and seling inventory instruments.
It works by monitoring Financial Books and tracking quantities of instruments bought or sold in a separate Stock Book.
The process of tracking realized gains and losses upon sales follows the FIFO (first in / first out) method.
Financial and Instruments Books should be in same Collection.
Only a single Instruments Book should be defined per Collection.
The Instruments Book is identified by a single book in the Collection with the decimal places set to 0 (zero) or by the
The bot interact with the following properties:
exc_code: Required - The book exchange code to match the
stock_exc_code: Required - Defines the exchange code of the instruments that will have quantities mirrored into the stocks book. Only transactions with accounts withing groups with
stock_exc_codeset will be mirrored.
stock_fees_account: The fees account used by the exchange account. The exchange account is identified by having an associated fees account.
quantity: The quantity of the instruments to track.
The Bot also add the following properties to the generated transaction in the Instruments Book:
purchase_price: The price the instrument was bought.
original_quantity: The original quantity used for rebuilding FIFO gains/losses if needed
original_amount: The original financial transaction amount for buy or sell the instrument
sale_price: The price the instrument was sold.
sale_amount: The financial amount the instrument was sold.
sale_date: The date the instrument was sold.
gain_amount: The total gain obtained from the instrument sale.
order: Used to reorder transactions on same day.