>>27203750>also automating fund age for the profit/day how do you even do that in sheets, is there a now-then function or unix timecode bullshitI have no idea, you're entering levels of sheeting that are beyond me. I just like it when they look nice.
I have been manually saving a duplicate copy of every API scrape I make.>api calls for networth or shares which would make it automaticIf it will make your life easier, I can try and see if I can add share volume and net worth to this sheet, so you can just import all of your data from there. The code I'm using isn't mine, so no promises.
Funds being broken kind of negated the need to update the prices on it once I actually got it automated. If it didn't completely break filter views (empty cells) I'd just move the "TOTAL DUE" to the TOP so that you really never had to fucking copy it again. Add new funds to the bottom, done. There's already a new fund that was made either while I was working on this or right when I finished... 