@jon.winston7, I’d recommend querying the Balance History sheet rather than the Balances sheet as that is the raw data source and should give you better results.
Otherwise, I’m not totally sure, but maybe this thread would help or check out the solutions in Tiller Money Labs as there might already be something built for what you’re trying to do.