=YHFINANCE_QUOTES()

Sample Usage

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


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


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

Syntax

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