KNIME_sale of shares
Workflow to process a SELL table against a BUY table, by determining on a First In First Out basis which stock was sold against which purchase.
The process creastes an intermediate table of single shares, so for example the purchase of 1584 shares of stock A results in a table of 1584 "purchase records" for that stock.
Likewise for a SALE of 1584 shares.
The two are then compared on a row-for-row basis (linked by sequence number). From this we can determine which sale was made against which purchase. After that, we group them back up into their original groupings, and calculate what has happened..... simples... lol!
01 May 2021 @takbb Brian Bates