App does not sync unless I manually change a value in the google sheet

[chadstonks]

I have a google sheet that uses =GOOGLEFINANCE to pull data for stock tickers. When the google sheet gets an updated value for a particular stock, my app does not reflect the changes. For instance:

- Google sheet shows GOOG +1% (the currently correct value)

- Appsheet will show the last value that it had synced, for example GOOG +0.25%

- If I manually delete a row or enter data into a new cell in my google sheet, and then sync my App, it correct shows GOOG +1%

- 15 minutes later, if GOOG is at +2% in the google sheet, the app will still show "GOOG +1%", even after manually force-syncing inside the app

- If I edit the table and force sync, AppSheet will show GOOG +2%.

I am not sure what is causing this behavior, but I'm looking for a way to have AppSheet correctly update when data in the sheet changes. (Previously this functionality was working fine, let's say about a month ago -- I'm not sure what changed). 

These are my performance settings: