Spreadsheet: 769782d1645685216-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 |  | 28406 |  |  |  | 4058 |  | 2 | #[NAME]! | 2022-02-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scroll Bar | 1
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 105 | 6575 | 0 |  | 105 |  | 4887.75 |  |  |  | 46.55 |  | 3 | #[NAME]! | 2021-10-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Condition
#[NAME]! | 0 | 0 | 0 | 0 | 35 |  | 5740 |  | 35 |  | 5740 |  | 35 | 5705 | 0 |  | 0 |  | 0 |  |  |  | 154.2 |  | 4 | #[NAME]! | 2021-10-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 10 | 1687.5 | 0 |  | 10 |  | 1501.5 |  |  |  | 150.15 |  | 5 | #[NAME]! | 2021-11-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holding Stock ScrollBar | 8
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 79 | 2316.25 | 0 |  | 79 |  | 2121.15 |  |  |  | 26.85 |  | 6 | #[NAME]! | 2022-02-11 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 4 | 6498 | 0 |  | 4 |  | 5188.8 |  |  |  | 1297.2 |  | 7 | #[NAME]! | 2021-11-15 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 53 | 7777 | 0 |  | 53 |  | 7043.700000000001 |  |  |  | 132.9 |  | 8 | #[NAME]! | 2022-01-24 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 2 | 8762 | 0 |  | 2 |  | 8574.1 |  |  |  | 4287.05 |  | 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 |  | 3617.7 |  |  |  | 1205.9 |  | 11 | #[NAME]! | 2022-01-24 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 8 | 22944 | 0 |  | 8 |  | 14429.2 |  |  |  | 1803.65 |  | 12 | #[NAME]! | 2022-02-14 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 6 |  | 2544 |  | 6 |  | 2544 |  | 6 | 2235 | 0 |  | 0 |  | 0 |  |  |  | 404.9 |  | 13 | #[NAME]! | 2022-02-18 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 675 |  | 17685 |  | 675 |  | 17685 |  | 675 | 15543.75 | 0 |  | 0 |  | 0 |  |  |  | 25.7 |  | 14 | #[NAME]! | 2021-11-12 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 6 | 4945.5 | 0 |  | 6 |  | 4481.4 |  |  |  | 746.9 |  | 15 | #[NAME]! | 2022-02-14 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 180 | 1761 | 0 |  | 180 |  | 1629 |  |  |  | 9.05 |  | 16 | #[NAME]! | 2022-01-24 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 3 | 4370 | 0 |  | 3 |  | 4051.05 |  |  |  | 1350.35 |  | 17 | #[NAME]! | 2022-01-27 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 10 | 965 | 0 |  | 10 |  | 951 |  |  |  | 95.1 |  | 18 | #[NAME]! | 2022-02-03 00:00:00
#[NAME]! | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 131 | 11592.01 | 0 |  | 131 |  | 10611 |  |  |  | 81 |  | 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