I'm pulling in a few hundred real-time stock quotes at once and automatically performing a bunch of sorting and modeling as the data updates, but it often lags badly so that I'm sometimes seeing stale stock quotes (30-60s after they change). I've determined that it's not the real-time quotes themselves b/c as part of my troubleshooting I created a separate bare-bones file that does nothing but pull in the streaming quotes, and the prices update in that file almost immediately. I have a 2nd file that pulls in the quotes from the 1st and does all of the sorting, formatting, etc, and only when that one is open does the lag get bad.)
I want to know whether there's any way to figure out just which formulas, calculations, or formatting are most responsible for the lag. To this point I've been troubleshooting by saving a copy of the file and systematically deleting formula groups, turning off conditional formatting, and trying to see if I notice a difference. Problem is there's probably 100+ different such variables and the lag -- even when it happens -- is very inconsistent (re: when it happens, and how bad it is) so it's really hard / time-consuming to isolate using that kind of iteration.
TLDR: Is there any kind of auditing tool or something else that can quantify which formulas / calculations / formatting / processes are most bogging me down?
I want to know whether there's any way to figure out just which formulas, calculations, or formatting are most responsible for the lag. To this point I've been troubleshooting by saving a copy of the file and systematically deleting formula groups, turning off conditional formatting, and trying to see if I notice a difference. Problem is there's probably 100+ different such variables and the lag -- even when it happens -- is very inconsistent (re: when it happens, and how bad it is) so it's really hard / time-consuming to isolate using that kind of iteration.
TLDR: Is there any kind of auditing tool or something else that can quantify which formulas / calculations / formatting / processes are most bogging me down?
