Spreadsheet: 769767d1645680405-filter-function-with-scroll-bar-book1
Sheet: Master Data

Stock | Qty (I) | Buy value (I) | Sell Value (I) | P/L (I) | [NAME] (D) | Buy value (D) | [NAME] (D) | P/L (D) | Overall Qty | Overbuy Value | Overall Sell Value | Overall P/L | Total Buy Qty (D) | Total Buy value (D) | Charges (I) | Charges (D) | Holding Qty | Long Term | Current Value | Investment Value | Investment Price | Charges (H) | Price |  | Row | Stock | Order Dt | Qty | Price | Value | Charges | Earlier Bought | Total Sold | Holding Qty | Holding Value | Charges (H) | Long Term |  | Stock | Quantity | Buy | Sell | Profit / Loss |  | P/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option Button | 3
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 7 | 33521 | 0 |  | 7 |  | 28676.2 |  |  |  | 4096.6 |  | 2 | #[NAME]! | 2022-02-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scroll Bar | 1
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 105 | 6575 | 0 |  | 105 |  | 5302.5 |  |  |  | 50.5 |  | 3 | #[NAME]! | 2021-10-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Condition
#[NAME]! | 0 | 0 | 0 | 0 | 35 |  | 5740 |  | 35 |  | 5740 |  | 35 | 5705 | 0 |  | 0 |  | 0 |  |  |  | 161.2 |  | 4 | #[NAME]! | 2021-10-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 10 | 1687.5 | 0 |  | 10 |  | 1587.5 |  |  |  | 158.75 |  | 5 | #[NAME]! | 2021-11-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holding Stock ScrollBar | 21
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 79 | 2316.25 | 0 |  | 79 |  | 2346.3 |  |  |  | 29.7 |  | 6 | #[NAME]! | 2022-02-11 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 4 | 6498 | 0 |  | 4 |  | 5310.2 |  |  |  | 1327.55 |  | 7 | #[NAME]! | 2021-11-15 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 53 | 7777 | 0 |  | 53 |  | 7223.900000000001 |  |  |  | 136.3 |  | 8 | #[NAME]! | 2022-01-24 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 2 | 8762 | 0 |  | 2 |  | 8885.3 |  |  |  | 4442.65 |  | 9 | #[NAME]! | 2022-01-24 00:00:00
#[NAME]! | 1 | 1 | 2 | 1 | 0 |  | 0 |  | 1 |  | 2 |  | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  | 1.49 |  | 10 | #[NAME]! | 2022-02-11 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 3 | 4369 | 0 |  | 3 |  | 4128.450000000001 |  |  |  | 1376.15 |  | 11 | #[NAME]! | 2022-01-24 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 8 | 22944 | 0 |  | 8 |  | 15006.4 |  |  |  | 1875.8 |  | 12 | #[NAME]! | 2022-02-14 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 6 |  | 2544 |  | 6 |  | 2544 |  | 6 | 2235 | 0 |  | 0 |  | 0 |  |  |  | 435.6 |  | 13 | #[NAME]! | 2022-02-18 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 675 |  | 17685 |  | 675 |  | 17685 |  | 675 | 15543.75 | 0 |  | 0 |  | 0 |  |  |  | 26.6 |  | 14 | #[NAME]! | 2021-11-12 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 6 | 4945.5 | 0 |  | 6 |  | 4711.5 |  |  |  | 785.25 |  | 15 | #[NAME]! | 2022-02-14 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 180 | 1761 | 0 |  | 180 |  | 1737 |  |  |  | 9.65 |  | 16 | #[NAME]! | 2022-01-24 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 3 | 4370 | 0 |  | 3 |  | 4254.6 |  |  |  | 1418.2 |  | 17 | #[NAME]! | 2022-01-27 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 10 | 965 | 0 |  | 10 |  | 997.5 |  |  |  | 99.75 |  | 18 | #[NAME]! | 2022-02-03 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 131 | 11592.01 | 0 |  | 131 |  | 10683.05 |  |  |  | 81.55 |  | 19 | #[NAME]! | 2022-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | #[NAME]! | 2021-10-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | #[NAME]! | 2022-01-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | #[NAME]! | 2021-11-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | #[NAME]! | 2022-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | #[NAME]! | 2022-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | #[NAME]! | 2022-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | #[NAME]! | 2022-02-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | #[NAME]! | 2022-01-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | #[NAME]! | 2022-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | #[NAME]! | 2022-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | #[NAME]! | 2022-01-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | #[NAME]! | 2022-01-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | #[NAME]! | 2022-02-14 00:00:00