Pos to Transaction Mapping

Stock  July 2025   August 2025 TRX Data
AAPL  100  150  +50
MSFT  150  0 -150
Google  75  50 -25
META  0 250 +250


So there are 3 Scenarios:
1. Update stock to the portfolio / Buy
2. Zero out/ Full Sell of a stock
3. Partial Sell of a stock
4. Open New Entry / new Purchase

For example:
Stock Month Quantity WA Price(PP) Purchase Price (WA = Purchase Value/Quantity)
AAPL July 100 210 21000
AAPL August 150 240 36000
MSFT July 150 100 15000
MSFT August 0 0 0
Google July 75 150 11250
Google August 50 140 7000
META July 0 0 0
META August 250 260 65000



So we need to create transaction data from above POS Data.

Basically we need to create the DIFF like below:
STOCK MONTH QUANTITY WA PRICE(PP) PURCHASE PRICE
AAPL August +50 +30 +15000
MSFT August -150 +100 -15000
Google August -25 +10 -2500
META August +250 +10 +25000