Default Fields

 

Whenever a function expects fields, leaving that parameter blank results in that function returning values for default fields.

 

Default fields are:

1.For current data: LAST_TRADE_PRICE

2.For historical data: DATE, and EITHER a) the first column which contains any of the strings "ADJ", "CLOSE" or "VALUE" OR b)  if no such column is found, then the first non-date column

 

Examples:

1. =Q("MSFT") returns the current price of the Microsoft stock

 

 

2. =Q("MSFT",,"-1y") returns the adjusted close price for the Microsoft stock for the last year

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017