Without seeing your spreadsheet I'm just taking stabs at what it looks like and possible solutions to the problem.
Is there a column of dates next to these formulas? I am assuming so because otherwise "no trade" seemingly has no purpose without a date to associate it with. If there is a column of dates, you can use XLOOKUP as I discussed in my earlier reply. It is a drag-fillable formula (vertically) so you will only have to make a change to one formula then drag it to the rest of the column.
I am not that well versed on pivot tables but it appears to me that the only way to create a reference to a cell in a pivot table is for that cell to be present. After that, you can delete the data and refresh the pivot table, which removes the row/cell from the pivot table and the reference becomes #REF. Later you can put the data back, refresh the pivot table, and the reference magically fixes itself. If this is what you are doing, I don't think I would rely on it. Plus, the only way to edit a formula like that is to first put the data back into the pivot table so the cell shows back up and fixes the reference.
There is a shortcut (Shortcut App) that will do find/replace in formulas so you can replace "NO TRADE" with "NONE" in multiple formulas but it won't solve your original problem of incrementing the row numbers in cell references.