Quote Source: Yahoo!

 

The supported fields depend on the time mode: historical values retrieval mode (a from or to date is specified) or current values retrieval mode (no date is specified).

1. For historical prices:

Field Primary Name

Field Synonyms

Field Definition

"ADJCLOSE"

"PRICE", "P"

 

"DATE"

"D", "DT"

 

"OPEN"

"O"

 

"HIGH"

"H"

 

"LOW"

"L"

 

"CLOSE"

"C"

 

"VOLUME"

"VOL","V"

 

 

Note: Fields in bold are default fields.
Note: Yahoo! does support only these frequencies: daily, weekly and monthly.


2. For current data ("LAST_TRADE_PRICE" is the current price)

Field Primary Name

Field Synonyms

Field Definition

"TICKER"

"SYMBOL","SYM"

 

"AFTER_HOURS_CHANGE_REALTIME"

"AHCHGRT"

 

"ANNUALIZED_GAIN"

"YRCHG"

 

"ASK"

"A"

 

"ASK_REALTIME"

 

 

"ASK_SIZE"

 

 

"AVERAGE_DAILY_VOLUME"

"AVGVOL"

 

"BID"

"B"

 

"BID_REALTIME"

 

 

"BID_SIZE"

 

 

"BOOK_VALUE_PER_SHARE"

"BK"

 

"CHANGE"

"CHG"

 

"CHANGE_CHANGE_IN_PERCENT"

"CHGCHG%"

 

"CHANGE_FROM_FIFTY_DAY_MOVING_AVERAGE"

"CHG50D"

 

"CHANGE_FROM_TWOHUNDRED_DAY_MOVING_AVERAGE"

"CHG200D"

 

"CHANGE_FROM_YEAR_HIGH"

"CHGYRHI"

 

"CHANGE_FROM_YEAR_LOW"

"CHGYRLW"

 

"CHANGE_IN_PERCENT"

"CHG%"

 

"CHANGE_IN_PERCENT_REALTIME"

 

 

"CHANGE_REALTIME"

 

 

"COMMISSION"

 

 

"CURRENCY"

"CCY","CURR"

 

"DAYS_HIGH"

"DAYHI","HIGH","H"

 

"DAYS_LOW"

"DAYLW","LOW","L"

 

"DAYS_RANGE"

"DAYRNG"

 

"DAYS_RANGE_REALTIME"

 

 

"DAYS_VALUE_CHANGE"

"DAYVALCHG"

 

"DAYS_VALUE_CHANGE_REALTIME"

 

 

"DIVIDEND_PAYDATE"

"DIVDATE"

 

"TRAILING_ANNUAL_DIVIDEND_YIELD"

"DIVYLD"

 

"TRAILING_ANNUAL_DIVIDEND_YIELD_IN_PERCENT"

"DIVYLD%"

 

"DILUTED_EPS"

"EPS"

 

"EBITDA"

 

 

"EPS_ESTIMATE_CURRENT_YEAR"

"EPSY1"

 

"EPS_ESTIMATE_NEXT_QUARTER"

"EPSQ2"

 

"EPS_ESTIMATE_NEXT_YEAR"

"EPSY2"

 

"EXDIVIDEND_DATE"

"EXDIVDATE"

 

"FIFTY_DAY_MOVING_AVERAGE"

"50D"

 

"SHARES_FLOAT"

"FLTSH"

 

"HIGH_LIMIT"

 

 

"HOLDINGS_GAIN"

 

 

"HOLDINGS_GAIN_PERCENT"

 

 

"HOLDINGS_GAIN_PERCENT_REALTIME"

 

 

"HOLDINGS_GAIN_REALTIME"

 

 

"HOLDINGS_VALUE"

 

 

"HOLDINGS_VALUE_REALTIME"

 

 

"LAST_TRADE_DATE"

 

 

"LAST_TRADE_PRICE"

"PRICE","P"

 

"LAST_TRADE_REALTIME_WITH_TIME"

 

 

"LAST_TRADE_SIZE"

 

 

"LAST_TRADE_TIME"

 

 

"LAST_TRADE_WITH_TIME"

 

 

"LOW_LIMIT"

 

 

"MARKET_CAPITALIZATION"

"MCAP","MC"

 

"MARKET_CAP_REALTIME"

"MCRT"

 

"MORE_INFO"

 

 

"NAME"

"N"

 

"NOTES"

"NO"

 

"ONE_YR_TARGET_PRICE"

"TGT"

 

"OPEN"

"O"

 

"ORDER_BOOK_REALTIME"

 

 

"PEG_RATIO"

"PEG"

 

"PE_RATIO"

"PE"

 

"PE_RATIO_REALTIME"

"PERT"

 

"PERCENT_CHANGE_FROM_FIFTY_DAY_MOVING_AVERAGE"

 

 

"PERCENT_CHANGE_FROM_TWO_HUNDRED_DAY_MOVING_AVERAGE"

 

 

"CHANGE_IN_PERCENT_FROM_YEAR_HIGH"

 

 

"PERCENT_CHANGE_FROM_YEAR_LOW"

 

 

"PREVIOUS_CLOSE"

"CLOSE","PRV","C"

 

"PRICE_BOOK"

"PB"

 

"PRICE_EPS_ESTIMATE_CURRENT_YEAR"

"PEPSY1"

 

"PRICE_EPS_ESTIMATE_NEXT_YEAR"

"PEPSY2"

 

"PRICE_PAID"

 

 

"PRICE_SALES"

"PS"

 

"REVENUE"

"REV"

 

"SHARES_OWNED"

"OWNSH"

 

"SHARES_OUTSTANDING"

"OUTSH"

 

"SHORT_RATIO"

"SR"

 

"STOCK_EXCHANGE"

"EXCH","EXCHANGE"

 

"TICKER_TREND"

 

 

"TRADE_DATE"

 

 

"TRADELINKS"

 

 

"TRADELINKSADDITIONAL"

 

 

"TWO_HUNDRED_DAY_MOVING_AVERAGE"

"200D"

 

"VOLUME"

"VOL","V"

 

"YEAR_HIGH"

"YRHI"

 

"YEAR_LOW"

"YRLOW"

 

"YEAR_RANGE"

"YRRNG"

 


 

Note: Yahoo Currency Tickers are of the form EURUSD=X.

Note: For some tickers, there is neither real time nor current data provided, though the historical data may be provided. Thus, if the real time function returns an N/A, try to retrieve the last year of history.

 

Examples:

1. Retrieve all latest information on a security

Example: =Q("MSFT","?") displays all latest market information on the Microsoft's stock.

 

 

2. Retrieve all latest information on a number of securities

=Q(C2:C3,"?") displays all latest market information on the Microsoft's and Oracle's stock. 



 

3. Retrieve latest prices of a security

=Q("MSFT") displays the latest market price of the Microsoft's stock.

 

 

 

 

4. Retrieve adjusted close price of a security from a given day

=Q("MSFT", "ADJCLOSE", "2010-02-10", ";") displays the adjusted close price of the Microsoft's stock on February 10, 2010.

 

 

 

5. Retrieve adjusted close price, and any other historical field of a security from a given day

This is a bulk fields variant of (4).

=Q("MSFT", D1:E1, "2010-02-10",";") displays the adjusted close price and volume of the Microsoft's stock on February 10, 2010. Any historical field described above is supported.


 

 

NOTE: If no data is found, e.g. =Q("MSFT", D1:E1, "2013-02-10",";"),  Spearian advises of that:
 

 

6. Retrieve adjusted close price of a number of securities for a given day

=Q(D1:D5,"ADJCLOSE","2010-02-10") displays the adjusted close price of the range of tickers on February 10, 2010. This function does fully support AutoRange.

 

 

While downloading, Spearian does provide the estimated time of downloading all the data. Note: the free Yahoo! does NOT provide bulk download interface.  When the download finishes, the computer beeps.

 

7. Retrieve adjusted close price and other fields of a number of securities for a given day

This is a bulk fields variant of (6).

=Q(D2:D6,E1:F1,"2010-02-10") displays the adjusted close price and volume of the range of tickers on February 10, 2010. Any historical field described above is supported.
 

 

8. Retrieve adjusted close price of a security for a range of days

=Q("MSFT", "ADJCLOSE", A1:A10) displays the adjusted close price of the Microsoft's stock on the days in the range A1:A10. 

 

 

9. Retrieve a number of historical fields of a security for a range of days

This is a bulk fields variant of (7).

=Q("MSFT", B1:C1, A2:A11) displays the adjusted close price and volume of the Microsoft's stock on the days in the range A2:A14.

 

 

10. Retrieve complete historical profile of a stock in weekly frequency between two given days

=Q("MSFT::w","?","2010-02-10","2010-06-10") retrieves all historical data on a weekly basis between Feb 10, 2010 and June 10, 2010 for the Microsoft stock.

 

 

11. Retrieve complete historical profile of a stock with specified columns

=Q("MSFT","DATE;ADJCLOSE","2010-02-10","2010-06-10") retrieves all historical data on a daily basis between Feb 10, 2010 and June 10, 2010 for the Microsoft stock. 

 

 

12. Retrieve complete historical profile of a stock with specified columns for a given set of days

=Q("MSFT","DATE;ADJCLOSE",A1:A10) retrieves all historical data on a daily basis for the specified days for the Microsoft stock. 

 


 

13. Download a year of prices for a given ticker order in both ways

=Q("MSFT",,,"-1y") produces this

 

 

and =Q("MSFT",,"-1y") displays this:

 

 

 

14. Retrieve Current Exchange Rate from Yahoo

=Q("CHFEUR=X")  displays the latest exchange rate between CHF and EUR from Yahoo. 

 

 

NOTE: Yahoo doesn't provide historical exchange rates. Yahoo's exchange rates also have lower precision than Open Exchange Rates.

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017