|
PureBytes Links
Trading Reference Links
|
Did you ever want to feed live data from TS2000i to an Excel spreadsheet but
were frustrated because there was no DDE link like in TS4? Where there's a
will there's a way as they say, at least for a limited number of symbols.
There may be other ways to do this, but this is what I came up with, a
simple modification to Clyde Lee's MakeAsciFile indicator
http://www.theswingmachine.com.
1. Create a chart in TS2000i with one or more daily bars, keep the number
low because all you want is the date,time,O,H,L,C,VOL for the current bar.
2. Modify Clyde Lee's MakeAsciFile in the Power Editor by putting braces
{ } around the DoInit=False; line as {DoInit=False;} verify, and then
insert the indicator into the chart and enable Update Every Tick. Be sure
to specify the file location for the exported .txt file. I am exporting
from the TS machine to another machine with Excel installed on it across a
local area network using a directory path of \\machine name\machine name C
Drive\Data. Could be done on the same machine too of course.
3.Then in Excel you have to go through the setup and format to do data
import from the .txt file location. Follow the Excel instructions and you
should see the data imported.
4.Next right click on the data cell and select Data Range Properties.
5.Set the Refresh control options. Uncheck request Prompt for File Name.
Check Refresh Every box and select the number of minutes. The minimum time
is one minute, unless someone knows of a way to make a continuous update.
I've had this running this morning with a dozen symbols with no noticeable
problems as of yet. The Excel version is 2000. Can't answer for earlier
versions or any other questions about Excel.
bobr
|