Define Queries

In order to submit a query to the 1010data server using the 1010data Excel Add-in, you must fill out a query sheet.

To define a query in the 1010data Excel Add-in:
  1. Press CTRL-T or click 1010data > Add New Q-Sheet.
  2. Enter all required information into the input cells in the q-sheet. (See Query Sheets.) Hover your mouse over any input cell with a red triangle in the top right corner to see a tooltip containing information defining the required input.
The new q-sheet will appear after the active worksheet. Once the query is defined, you may run the query. (See Run Queries.)
Note: You may rename the worksheet, but ensure that the first 6 characters (_1010q) of the worksheet name remain intact. This prefix is used to identify the worksheet as a q-sheet.