Exporting data from the Grid

Top  Previous  Next


There are two ways to extract data from the Grid. You can either (a) export selected columns to a file, or you can (b) copy data from the Grid, and paste into another application.

To export adjacent columns

1If you have closed Mechanica since the end of the last section, please open it and run Lesson2.sig now.
2Once the Grid is populated with data, press (left click) the Export to File button (shown below, circled).

3The Export Signal Data to File dialog box will appear. Please fill it in as shown below, including the check mark in the first option box, and press OK.

If you do not change the file name when the File Save dialog box opens (titled “Export data to file”), the file will save as BP_B_REV_Signal_Data.csv, in the Mechanica root directory.
4Switch to your spreadsheet application and open BP_B_REV_Signal_Data.csv. (It may be necessary to manually specify the file type *.csv).
5You should now see all your trade data, along with columns 1-4, displayed exactly as they appear in the Grid, and ready for further analysis.


To export non-adjacent columns

The Grids Export facility is designed to accommodate the export of mixed sets of adjacent and non-adjacent columns of data. This gives you the option of excluding columns of data that are displayed in the Grid, but that you do not want to export for subsequent analysis.

Given the assumption that your SIG file contains eight (8) column definitions, and you want to export them from the Grid, excluding columns 4 & 7, heres how youd do it:

Click OK. When you open the output file *_Signal_Data.csv in your spreadsheet application, you should see all the data from columns 1-3, 5, 6 and 8, along with its associated trade information.        

ThumbTack white

*.csv stands for comma-separated-value; Comma is the “delimiter” between data fields. Files of this type are often referred to as “comma delimited.”        


To copy using the mouse to select data

1Select data via left click & drag, as you would in any other Windows application.
2Once the data is “marked,” right click anywhere in the Grid.
3The Copy selected data to clipboard message will appear.
4Move your mouse slightly, until the Copy selected data to clipboard message becomes highlighted (as shown below).
5Left click to complete the copy operation. The data can now be pasted into another Windows application.

ThumbTack white

1.In order for Column numbers to be included in the copy output, your selection must include the top row of the Column.
2.In order for the date and trade data to be included in the copy output, your selection must include Col 1.

To copy using the keyboard to select data

The following exercise is designed to acquaint you with navigating the Grid, and selecting text using the keyboard. Obviously, you can navigate anywhere in the Grid using the arrow keys alone, but you can work much faster with a few simple shortcut key combinations.


1Make sure that a SIG file has recently been run, and that the Grid contains several columns of data.
2Press Ctrl + Home. Your cursor should now be located at R1, C1.
3Press Shift + Down Arrow for a second or two. This operation will select a portion of Column 1.
4Press Shift + Right Arrow once. Your selection should expand one column to the right.
5Press Shift + Up Arrow once. Your selection should contract by one row.
6Press Ctrl + Home to relocate the cursor at R1, C1.
7Press Ctrl + Down Arrow. Your cursor should jump to the last cell of Col 1 in the Grid (called Future Date).
8Press Ctrl + Up Arrow. Your cursor should jump back up to R1, C1.
9This time, press Ctrl + Shift + Down Arrow. Now, all of Col 1 should be selected. (If you start with your cursor at the bottom of a column, then pressing Ctrl + Shift + Up Arrow will select the entire column.)
10Press Shift + Right Arrow once. Your selection should expand one column to the right to include (all of) Col2.
11Complete the copy operation by following steps 2 5 on the previous page.

Once the copy operation is complete, the selection can be unselected by pressing any arrow key, Pg Up or Pg Dn, or clicking anywhere in the Grid.

ThumbTack white

In order to insure that the Column number, date, and associated trade data are included in your copy output, your selection must include Col1,  and you must select the top row of the Column(s) you want to copy.