google sheet

Job ID: 37502975

Budget: $10 – $30 USD

Hi I have this Google Sheet, https://docs.google.com/spreadsheets/d/1IxqAC4MozcoxQYEADVgYH262fimGbXgNcEiKO45Ap7k/edit#gid=0 , and I would like the function to delete operations at my discretion. The sheet updates itself via Binance API, it does not save my changes and does not allow me to delete operations (each operation is made up of buy and sell, therefore 2 rows). I therefore need to permanently delete operations, and therefore are not displayed, and be careful, I said operations not fixed rows, because as they self-update the values of the operations scale into new rows.

If instead I wanted to work with an offline sheet, without the data being synchronized via Binance API, would it be possible to implement a function that eliminates the values ranging from -70% to -inf%, of column I, with a single keystroke?
Related categories: Visual Basic Excel Google Sheets