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 |

Pass a symbol from Excel to TC2000 to change chart. Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
abond
Posted : Monday, August 6, 2012 12:27:09 AM
Gold Customer Gold Customer

Joined: 1/18/2005
Posts: 7

I need to manage my watchlists in Excel (because I want to keep the symbols in a certain order and nest child symbols, etc.).   I want to be able to pass one symbol at a time to TC2000 to display the chart. I can create the VBA code for the macro to do what is needed on the Excel side, but cannot get TC2000 to accept the symbol.  In an old version of Telechart I used to be able to use SendKeys. I'd send 'j' for jump and the symbol and it would change the chart. For some reason, I cannot get it to work in TC2000. I tried changing the setting to use the telechart hotkeys and sending the j plus symbol and I tried not using the hotkeys setting and just sending the symbol. Nothing works. Any suggestions on what I need to do to get TC2000 to recognize the symbol and change the chart?

 

 

Bruce_L
Posted : Monday, August 6, 2012 9:45:27 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

TC2000 version 12.2 doesn't have an API, but as far as I know, macros that look like mouse and keyboard interactions with the program should work.

I'm pretty sure the chart portion of TC2000 needs to have focus to be able to jump to another symbol using the keyboard as I don't think you can jump to another symbol if any other portion of TC2000 version 12.2 has focus. A mouse click on the chart section of TC2000 version 12.2 could probably force focus to the chart if you can use a macro to send that as well.

That said, we do not support third party software. I really don't have any other suggestions if it doesn't work.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
abond
Posted : Wednesday, August 8, 2012 11:17:10 PM
Gold Customer Gold Customer

Joined: 1/18/2005
Posts: 7

After some tweaking, was able to get it working perfectly. Now I can maintain my watchlists in a visual order that I like and use TC2000 to browse the charts. Excellent. Thank you.

Ofree
Posted : Tuesday, January 7, 2014 2:41:23 PM
Registered User
Joined: 11/21/2011
Posts: 12

QUOTE (abond)

After some tweaking, was able to get it working perfectly. Now I can maintain my watchlists in a visual order that I like and use TC2000 to browse the charts. Excellent.

  What tweaking do you use?

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.