=YHFINANCE_QUOTES()

=YHFINANCE_QUOTES ("AAPL,BTC-USD,EURUSD=X")

=YHFINANCE_QUOTES (A1:A3,"*.*")

=YHFINANCE_QUOTES ("GLD","marketCap,sharesOutstanding",false)

YHFINANCE_QUOTES (ticker, [attributes], [show_header])

• tickers - The comma separated ticker symbols for the security to consider. Up to 50 tickers.

• attributes - [ OPTIONAL - "regularMarketPrice" by default ] - The attributes to fetch about tickers from YH Finance. attributes is one or comma separated many of the following for real-time data:

  • *.* - all attributes

    • symbol

    • longName

    • quoteType

    • quoteSourceName

    • marketState

    • currency

    • regularMarketTime

    • regularMarketPrice

    • regularMarketDayHigh

    • regularMarketDayLow

    • regularMarketVolume

    • regularMarketChange

    • regularMarketChangePercent

    • regularMarketOpen

    • regularMarketPreviousClose

    • preMarketTime

    • preMarketPrice

    • preMarketChange

    • preMarketChangePercent

    • postMarketTime

    • postMarketPrice

    • postMarketChange

    • postMarketChangePercent

    • bid

    • ask

    • bidSize

    • askSize

    • marketCap

    • sharesOutstanding

    • averageAnalystRating

    • fiftyTwoWeekRange

    • fiftyTwoWeekLow

    • fiftyTwoWeekLowChange

    • fiftyTwoWeekLowChangePercent

    • fiftyTwoWeekHigh

    • fiftyTwoWeekHighChange

    • fiftyTwoWeekHighChangePercent

    • fiftyDayAverage

    • fiftyDayAverageChange

    • fiftyDayAverageChangePercent

    • twoHundredDayAverage

    • twoHundredDayAverageChange

    • twoHundredDayAverageChangePercent

    • averageDailyVolume3Month

    • averageDailyVolume10Day

    • dividendDate

    • trailingAnnualDividendRate

    • trailingAnnualDividendYield

• show_header - [ OPTIONAL - "true" by default ] - The flag to show or hide header row.

  • true - show header row

  • false - hide header row