Try TT Now

Running a Free Text Command

Before you run a Free Text command, follow the procedures under Backing Up the Datfiles Directory.

The Free Text window is used to run other data management commands originally only available using FMDSFileMonkey from the command line. Rather than, running a command from the command prompt, you can add the command in the Free Text window.

You can also use created scripts in conjunction with scheduling programs to automatically run the scripts as needed.

Follow these procedures to run a free text command:

  • Creating a Free Text command

To create a Free Text command:

  1. Make sure you have backed up the datfiles directory.
  2. Click the button and click Free Text Command.

The Free Text window appears.

  1. Type the command you want to create.

Tip: For a list of available FileMonkey commands, refer to Free Text (FileMonkey) Commands.

  1. Click OK.

The Free Text command appears in the script area.

You successfully created a Free Text command.

Note: If you want to save your archive command as a .fms file, click .

  • Running a Free Text command

To run a Free Text command:

  1. Follow the steps above to create a Free Text command.
  2. Click .

You successfully run a Free Text command.

Free Text (FileMonkey) Commands

The data management commands you can create using the Free Text window were originally only available using FMDSFileMonkey from the command line.

Warning!

  • It is possible to lose data while using FMDSFileMonkey.
  • If you are running FMDSFileMonkey from the command line, you must run the command from the <root>:tt directory.
  • Always stop TTFMDSResp before using FMDSFileMonkey from the command line.
Tool OptionsResult

-V [ --version ]

Prints version to stdout and exit

-h [ --help ]

Print this message to stdout and exit

-x [ --x ]

Pause for debugger attach

Commands and OptionsResult

--archive arg

Single archive to move or delete.

--archiveWarm

Flush the Warm file to an archive.

--backup

Back up files while renaming.

-c [ --contract ] arg

Contract string for binary output (files created in .DataFilesEx) and spreads (which have "|" separator).

--color arg

Colorize output as none, ansi, html, or console (default) where possible.

--consolidate

Consolidate archive files in a database.

--days

The oldest or newest number of days from current time.

--days-old arg

Expire data for contracts which have not been recorded in this many days.

--delete-tick

Delete the tick store for the contract specified with the --contract option.

--delete-bar

Delete the bar store for the contract specified with the --contract option.

--delete-spread

Delete the spread bar store for the contract specified with the --contract option.

--delete-archive

Delete the archives created before the specified time in the --dir option.

--dir arg

Directory where the archive files will be moved.

-e [ --end ] arg

End time, exclusive. where to stop converting (default: end of data).

--force

Force action to proceed without waiting for user input (useful for scripts).

--hide

Hide the data specified.

--input

Input file (.csv or .fmd).

--move-archive

Move the archives created before the specified time in the --end option to the directory specified in the --dir option.

--new-contract arg

Specify new contract store for the contract specified with the -contract option.

Refer to Renaming Contracts for contract renaming examples.

-o [ --output ] arg

CSV output filename (omit or specify '-' for stdout).

--oldest

Use the oldest days of data.

--rename

Rename the contract store for the contract specified with the -contract option.

--rollup

Roll up a binary TICK file to produce a binary bar file.

-s [ --start ] arg

Start time, inclusive. Where to begin converting (default: beginning of data).

--script arg

Use a script to execute multiple commands.

--spread

Make a spread bar file from tick files for the spread contract specified with the -contract option.

--timeshift

Make a copy of binary input time-shifted so that last element has the current universal date/time.

--unhide

Unhide the data specified.

-v [ --verbose ]

Enable diagnostic logging to console, in addition to standard log file.

--validate

Validate that timestamps are all sequential in a file.

Notes:

  • Time formats are typed as follows (quotes required):
  • “2011-Sep-08 19:05:00.001”
  • “2011-Sep-08 19:05”
  • “2011-Sep-08” (midnight)
  • For options that take file names, file names are typed as follows:
  • “FMDSData/CME_ES_Dec11_Future.fmd”
  • “FMDSData/CME_ES_Dec11_Future_Tick.fmd”