Spreadsheet: 92183d1291830449-recode-string-into-number-on-condition-example3
Sheet: Sheet3

Transaction Type | CODE
Decrease | 0
Decrease | 0
Decrease | 0
Bought | 1
Sold | 0
Bought | 1
Bought | 1
Sold | 0
Bought | 1
Bought | 1
Increase | 1
Increase | 1
Bought | 1
Bought | 1
Increase | 1
Bought | 1
Sold | 0
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Increase
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Sold
Bought
Bought
Sold
Bought
Bought
Sold
Bought
Sold
Bought
Bought
Sold
Bought
Bought
Sold
Bought
Sold
Bought
Bought
Sold
Bought
Bought
Bought
Sold
Bought
Bought
Increase
Increase
Increase
Decrease
Bought
Sold
Sold
Bought
Sold
Increase
Increase
Increase
Increase
Increase
Bought
Sold
Bought
Bought
Increase
Bought
Sold
Increase
Increase
Increase
Sold
Increase
Increase
Increase
Increase
Bought
Increase
Bought
Bought
Bought
Bought
Increase
Increase
Increase
Bought
Sold
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Sold
Bought
Bought
Bought
Bought
Sold
Sold
Increase
Increase
Increase
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Increase
Bought
Bought
Increase
Bought
Bought
Bought
Increase
Bought
Bought
Sold
Increase
Bought
Bought
Sold
Increase
Increase
Decrease
Sold
Decrease
Increase
Sold
Decrease
Decrease
Increase
Increase
Sold
Increase
Increase
Decrease
Increase
Decrease
Increase
Increase
Decrease
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Increase
Bought
Increase
Increase
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Increase
Decrease
Sold
Bought
Sold
Bought
Bought
Bought
Sold
Sold
Bought
Bought
Bought
Bought
Bought
Increase
Increase
Bought
Bought
Increase
Increase
Sold
Increase
Increase
Increase
Sold
Bought
Sold
Bought
Bought
Increase
Bought
Bought
Bought
Increase
Increase
Increase
Increase
Increase
Sold
Bought
Sold
Sold
Increase
Increase
Increase
Increase
Increase
Increase
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Sold
Sold
Bought
Sold
Decrease
Decrease
Sold
Sold
Sold
Increase
Sold
Sold
Sold
Sold
Decrease
Decrease
Decrease
Sold
Sold
Sold
Sold
Sold
Bought
Sold
Sold
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Increase
Bought
Bought
Increase
Increase
Increase
Increase
Bought
Increase
Bought
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Sold
Bought
Bought
Increase
Increase
Increase
Bought
Bought
Increase
Increase
Increase
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Sold
Sold
Increase
Increase
Bought
Bought
Increase
Sold
Bought
Increase
Increase
Increase
Increase
Bought
Increase
Bought
Bought
Increase
Increase
Increase
Increase
Increase
Increase
Sold
Bought
Sold
Bought
Sold
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Increase
Bought
Sold
Bought
Increase
Bought
Bought
Increase
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Sold
Bought
Sold
Sold
Sold
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Increase
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Sold
Decrease
Bought
Sold
Bought
Bought
Bought
Sold
Bought
Bought
Sold
Bought
Sold
Bought
Increase
Increase
Bought
Bought
Increase
Bought
Bought
Increase
Sold
Bought
Sold
Bought
Sold
Increase
Increase
Increase
Bought
Increase
Bought
Increase
Sold
Bought
Sold
Bought
Sold
Increase
Increase
Increase
Bought
Bought
Sold
Increase
Sold
Increase
Increase
Increase
Increase
Increase
Sold
Increase
Increase
Increase
Increase
Sold
Bought
Increase
Increase
Sold
Bought
Bought
Bought
Decrease
Increase
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Decrease
Bought
Bought
Bought
Bought
Sold
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Bought
Sold
Sold
Increase
Bought
Sold
Bought
Sold
Bought
Sold
Bought
Bought
Bought
Bought
Increase
Bought
Bought
Sold