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



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