Quote Source: Google

 

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 values:

Field Primary Name

Field Synonyms

Field Definition

"DATE"

"D", "DT"

 

"OPEN"

"O"

 

"HIGH"

"H"

 

"LOW"

"L"

 

"CLOSE"

"C", "P", "PRICE"

 

"VOLUME"

"VOL","V"

 


Note: Fields in bold are default fields.

Note: Google supports only daily frequencies.

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

Field Primary Name

Field Synonyms

Field Definition

"TICKER"

"SYMBOL","SYM"

 

"AFTER_HOURS_CHANGE"

"AHCHG"

 

"AFTER_HOURS_CHANGE_IN_PERCENT"

"AHCHG%"

 

"AFTER_HOURS_LAST_PRICE"

"AHP", "AHPRICE"

 

"AFTER_HOURS_LAST_TIME"

 

 

"CHANGE"

"CHG"

 

"CHANGE_IN_PERCENT"

"CHG"

 

"CURRENCY"

"CCY","CURR"

 

"DIVIDEND"

"DIV"

 

"LAST_TRADE_DATE"

 

 

"LAST_TRADE_PRICE"

"P", "PRICE"

 

"LAST_TRADE_TIME"

 

 

"STOCK_EXCHANGE"

"EXCH", "EXCHANGE"

 

"YIELD"

"YLD%"

 


 

Examples:

1. Retrieve the latest price of FTSE 100 from Google

=q("g::UKX:INDEXFTSE","p")

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017