Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Automation - updating data on a schedule Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
siddha
Posted : Tuesday, October 17, 2006 2:10:12 AM
Registered User
Joined: 9/17/2005
Posts: 7
I have the rest of my trading system fully automated. The only thing I can't get to automate is TC2007 data updates on a daily basis. The TC2007 software either crashes my PC or it hangs as the update is happening. I am using System Scheduler (freeware) to perform the automation on TC2005. My preference is to use JavaScript, since I am using JavaScript to interface with my other trading system applications, and automating all of my scripting and analysis.

Just stumbled into the TC SDK here. Is this the best way to automate? I am trying to reduce TC DLL conflicts with Windows so I can just get this over with. Either that, or I will dump TC altogether and find another EOD data source provider.

I already called TC support and they were unable to help resolve the issues I am seeing. Only system issue I have is related to TC2007 it seems. My previous TC2005 worked forever without issues.

Can I use my TC2005 install disks and still update EOD data, without TC trying to update my TC software to TC2007, also?
siddha
Posted : Tuesday, October 17, 2006 2:16:35 AM
Registered User
Joined: 9/17/2005
Posts: 7
I should mention that I use the sector/industry breakdowns in TC, since they import nicely into Amibroker for more intensive analysis. I would very much like to stay with TC, but it's been two full days troubleshooting DLLs and hardware and it's now whittled down to using TC2007 with WinXP. Anyone else experiencing this error? --

AppName: telechart.exe AppVer: 6.0.0.48 ModName: ntdll.dll
ModVer: 5.1.2600.2180 Offset: 00018fea

C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\85a6_appcompat.txt

R6025 Pure virtual function call


.... or this one?

AppName: telechart.exe AppVer: 6.0.0.48 ModName: kernel32.dll
ModVer: 5.1.2600.2945 Offset: 00012a5b

C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\d91e_appcompat.txt
siddha
Posted : Tuesday, October 17, 2006 10:11:27 AM
Registered User
Joined: 9/17/2005
Posts: 7
I uninstalled System Scheduler, which looks like it may have been conflicting with TC2007 (along with WinXP). I then installed AutoIT and am using this small script (written in proprietary AutoIT language) to automatically launch and update TC2007 --

Run("C:\Program Files\TeleChart\TeleChart.exe")
Sleep(60000)
WinWaitActive("Update TeleChart Databank")
Send("{ENTER}")

I launch the script once a day using the "Scheduled Tasks" application that comes with WinXP. Setting up multiple scheduled tasks would allow for additional updates of TC data throughout the day, if you are doing intraday trading.

I have tested this and it appears rock solid. AutoIT (freeware) is far less invasive with WinXP than System Scheduler (freeware).

WinXP's "Scheduled Tasks" software will open TC2007, but you cannot pass keyboard commands (for updating the TC2007 data, for example, since the update function requires separate keyboard commands), so you have to use another program such as AutoIT to automate the process.

If TC2007 simply had built into it something that would allow it to automatically update data each time it was opened, or by launching a separate .exe file, the need for something other than WinXP's "Scheduled Tasks" software would not exist.

In the meantime, I recommend using AutoIT.
siddha
Posted : Tuesday, October 17, 2006 3:18:40 PM
Registered User
Joined: 9/17/2005
Posts: 7
Okay, here's my final AutoIT (freeware) script... this will open TC, update the database, and then also close TC, automatically, using WinXP's "Scheduled Tasks."

Run("C:\Program Files\TeleChart\TeleChart.exe")
Sleep(60000)
WinWaitActive("Update TeleChart Databank")
Send("{ENTER}")
Sleep(120000)
ProcessClose("TeleChart.exe")
gtarnold
Posted : Friday, November 3, 2006 3:13:33 AM
Registered User
Joined: 12/30/2004
Posts: 74
siddha - thanks for posting this, especially of your success with AutoIT.

Garth
shevkoplyas
Posted : Tuesday, March 30, 2010 10:13:27 PM

Registered User
Joined: 11/26/2009
Posts: 16
QUOTE (siddha)
Okay, here's my final AutoIT (freeware) script...
<skipped>


siddha , thank you so much! It doesn't look like a perfect solution, but it WORKS!!!
Thank you!
investalert
Posted : Thursday, August 26, 2010 2:53:51 PM
Registered User
Joined: 4/29/2006
Posts: 75
Thanks to those before me that posted the script to automate updating Telechart using AutoIT. I modified the script, as shown below, so that the update is called from the routine and does not need the dialog box to be open. This saves having to cancel the update dialog box when opening Telechart and one does not wish to update at that time. Note: you can change the (15000) if you want more than 15 seconds for the update to start. This is a recommended minimum.

Run("C:\worden\TeleChart\TeleChart.exe")
Sleep(15000)
Send("!du")
Send("{ENTER}")
Sleep(10800000)
ProcessClose("TeleChart.exe") 

Regards, Richard
investalert
Posted : Friday, October 29, 2010 6:11:42 AM
Registered User
Joined: 4/29/2006
Posts: 75
Herer's another AutoIT routine that may be of interest. Setup the watchlist you want to export and and do it one manually. Then substitute "Current Holdings" with the name of your list. Once you set it in Task Scheduler, it will export automatically on your schedule. Enjoy!


Run("C:\worden\TeleChart\TeleChart.exe")
Sleep(15000)
Send("!dx")
Sleep(5000)
ControlFocus("Data Export to Text","","ThunderRT5TextBox1")
ControlSetText("Data Export to Text","","ThunderRT5TextBox1", @YEAR & "-" & @MON & "-" & @MDAY & " Current Holdings")
ControlClick("Data Export to Text","","ThunderRT5CommandButton2")
Sleep(5000)
ControlClick("TeleChart","","Button1")
ProcessClose("TeleChart.exe")
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.