| This
study can be used to import
values from a text file into
Stormtracker and associate them
with particular symbols.
It's very easy to do. Say
you have the following buy/sell
levels which you want to import:
Buy
Sell
MSFT
31
30
HPQ
46
45
INTC
22
21
Here are the steps to
configure it:
1) Configure a FileInput
study in stormtracker(the
timeframe doesn't matter)
2) In c:\FIStudyname\Realtime\stvalues.csv
put the values(although csv
files can be opened and edited
via Excel, they are not Excel
files. Do not use an Excel file
as it won't work) CSV
files can also be opened and
edited by a text editor such as
NotePad.
3) Configure the symbols in
the Load Symbols window.
For values to be successfully
imported using the FileInput
study, they need to be
configured twice, once in the
Load Symbol Symbol List, and a
second time in the stvalues.csv
list as shown on this page
Notes:
1) When stormtracker is
scanning the values in the
FileInput file can be
changed. Once the
FileInput file is saved and
closed, the new values will be
picked up in Stormtracker
2) This is a realtime
scanning study only. It
cannot be used with backtesting.
If you trade using an
Excel Spreadsheet you can export
values to a csv file using the
following macro
Sub TimerMacro()
Dim lngLoop As Long
g_datStartTime = Now
DoEvents
While True
If Now - g_datStartTime > TimeValue("00:00:02") Then
Dim fileno
Dim i As Integer
fileno = FreeFile
Open "c:\FI01\RealTime\FI01.csv" For Output As #fileno
i = 1
While Cells(i, 1) <> ""
Print #fileno, Cells(i, 1) & "," & Cells(i, 2) & "," & Cells(i, 3)
i = i + 1
Wend
Close fileno
g_datStartTime = Now
Else
DoEvents
End If
Wend
End Sub
This will generate a new csv
file every 2 seconds from the
Excel spreadsheet cells that you
specify, which will then picked
up by Stormtracker |
