Help Files
Modify Historical Query

 

                  

New Data Fields

 

Once an historical query has been added to a spreadsheet, it is easy to add additional data fields for the symbols you've selected, as long as you know the Field ID that represents the data. When using a header to identify the data, you simply need to add a new column and change the header using one of the valid Field ID names for the data you want.

 

When using "No Headers" on the query, you need to insert the Field ID name in the cell function.

 



 
Use the header to identify the data.
No Headers: insert the Field ID in the cell function.

 

Sample Syntax

=GvIntraday($A$12, $B12, 10, C$11, , , , , , )

=GvDaily($A$26, $B26, C$25, , , , , "p")

=GvWeekly($A$33, $B33, C$32, , , , , "p")

=GvMonthly($A$2, $B2, C$1, , , "THM", , "p")

=GvQuarterly($A$33, $B33, C$32, , , , , "p")

=GvYearly($A$2, $B2, C$1, , , , , "p")

=GvMonthly("/GCL", "Close", GvCombineDate(C$19, $C$19, $B20),,,,,"p")

=GvWeekly("/CL<1>", "Close", GvCombineDate(C$23, $C$23, $B24),0,"SGD","GAL",,"p")