Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
Bruce,
I have an excel sheet with a list of symbols I track from the day of their buy signal.
So far every week or when necessary I have to manually update the current price of those stocks in the excel to update the performance.
Is there a way I can somehow link TC to the excel to feed the prices into the excel?
This doesn't have to be real time. It can be on closing prices only
Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
We don't have any sort of API or SDK to interface with TC2000 v18/v19b. The TCDK only works with TC2000 v7 (this requires a Dow Jones Indexes feed of some sort in addition to at least TC2000 Gold).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
What's TCDK and How old is V7?
If I launch it at the end of every day would I be able to then automatically update the prices in the excel?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The TCDK is the TeleChart Developer Kit. Documentation is available in the folder linked where I initially mentioned it. The TCDK is no longer supperted, but it still works. You will probably need at least some programming experience to be able to use it (and we aren't going to help you with implementation beyond what is given in the documentation and examples).
The basics of TC2000 v7 were around when I first started working at Worden Brothers in January of 2000 (the DOS version was completely discontinued at the end of 1999 and we were in the process of converting everybody with just the DOS version over to the Windows version). The way TC2000 for Mutual Funds works now is pretty much the way TC2000 as a whole worked then.
I could be misremembering, but I think the last major update happened in 2005 when we switched from sending out CDs with fixed data blocks which had to be occassionally massed shipped to all customers to a completely downloadable version which did not require sending out CDs.
Some smaller updates continued through to about 2007 or so, but everything except a few minor tweaks to just keep things running had already ceased by the time StockFinder was released (although SF was initially called SnapSheets and then Blocks before changing its name to StockFinder).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 9/17/2010 Posts: 484
|
You might consider using paper trading to track daily status of your holdings. It can report % P&L as well as $P&L without any action on your part.
You can also display any (exit) indicators at the same time
If you want a post sale record, then you might want to transfer buy and sell to Excel, but still would reduce your workload significantly
|
|
Platinum Customer
Joined: 3/31/2006 Posts: 3,207
|
Thanks guys.
Are there easier ways I can feed prices from websites like Yahoo or CNBC into excel ?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
There are a variety of websites with APIs to access delayed data (some free, some not - I really can't provide links). Not sure if they would be easier than using the TCDK for this or not.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |