Few tricks to reduce the numbers of =YHFINANCE calls and stay within the daily limit.

  1. Use multiple attributes in =YHFINANCE formulas instead of making separate calls for individual attributes.
    For example you can set one call for
    "symbol", "open", "regularMarketPrice" attributes
    instead of three calls

  2. Use =YHFINANCE_QUOTAS formula to obtain pricing data for multiple ticker symbols instead of separate =YHFINANCE calls.
    For example one call
    vs three calls