Open the EveryTick Spreadsheet and enter your user name and password.
Navigate to the Settings Tab
Choose your data feed provider from the dropdown list. This will ensure that the data is written in the correct format that your Trading Software provider requires.
Choose the directory where you'd like the data files to be stored. For SierraChart, this will be
C:\SierraChart\Data\. For any of the other Trading Software providers, you are free to create a folder
anywhere you'd like to
folder. Be sure to use a backslash (\) and not a forward slash(/). Also, don't forget the
trailing slash at the end of the path like this:
Choose the interval (in seconds) that you'd like the data written to your files. For example, entering a number "1" will write data to your files every 1 second. This can be changed at anytime (even while EveryTick is running). For example, if you want data written every 1 second during the first hour of trading (when volume is the heaviest) but then would like to reduce the interval to every 2 seconds, you can simply change the "1" to a "2" without stopping the EveryTick Macro. Thereafter, the timestamps will spread out to every 2 seconds.
Make up a Text symbol and enter it into Column 1 of the "Write" sheet. Be careful not to use any existing symbols that trade on any exchanges. To be safe, you might want to include a number in the symbol you make up. For instance AAPL1 is sure not to interfere with AAPL. Now enter a DDE or RTD subscription code into Column 2. For instance, for IQFeed, the DDE format is =IQLINK|AAPL!Last or IQLINK=|AAPL!Volume. Then press "Start." You are now logging data!