Optimization

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
    =YHFINANCE("AAPL",    "symbol,open,regularMarketPrice")
    instead of three calls
    =YHFINANCE("AAPL",    "symbol")
    =YHFINANCE("AAPL",    "open")
    =YHFINANCE("AAPL",    "regularMarketPrice")

  2. Use =YHFINANCE_QUOTAS formula to obtain pricing data for multiple ticker symbols instead of separate =YHFINANCE calls.
    For example one call
    =YHFINANCE_QUOTES(    "AAPL,TSLA,V")
    vs three calls
    =YHFINANCE(    "AAPL")
    =YHFINANCE(    "TSLA")
    =YHFINANCE(    "V")