Shrug. Sometimes the best tool for a job is a simple wrench turn. I literally go in after each close and input the daily close values of my holdings on to sheet 1. Thats it. From there all the formulas do their magic across the rest of the sheets.I spend all day automating this kind of data parsing for shit at work.
The very idea I would deal with manual uploads of anything is completely fucking preposterous.
The only other work I have to update is purchases/sales and dividend reinvestments on sheet 1. Again, takes me less than a minute.
#BoomerLife
- 1