| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/2/2005
Posts: 33
|
I have made many attempts to import EXCEL stock info to a watchlist and have failed miserably.I am able to create a TEXT document in either Wordpad or Notepad with no difficulty and saved the file in My DOCUMENT file prior to importing to the new watchlist. The Import choices available in the ADD column for the new Watchlist do not give me a MY DOCUMENT choice to import the file.
So I have been shimmying ,shaking and jumping up and down and getting nowhere.
Your help would be appreciated.
Merry Christmas & a Happy,Healthy New Year
Grizzly
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Your MY DOCUMENTS folder is located on your C: drive (usually within the USER folder).
You may have to search to find it.
What folder does open when you search? It may be easier to just save the file there.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/2/2005
Posts: 33
|
I have been trying to import all morning with no headway.
I have my list stored in desktop. The desktop has a file of 50 stocks. Creating a new watchlist and attempting to import results in the data flashing in the watchlist and then disappearing. Of the total 50 stock list I am sometimes rewarded with a total of just three issues.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Are all of the stocks in TeleChart at all (can you jump to them)?
You cannot import symbols that are not already in the system.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/2/2005
Posts: 33
|
I checked the first ten stock issues appearing in my listing out of fifty and all that were checked where in the system.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Please email you TXT file to support@worden.com and put ATTN:Craig S in the subject line. Let me see what it does for me.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 4
|
Import excel: I am unable to import a watch list from excel.
The problem seems to be I cannot copy symbols alone to copy and paste. All of the spreadsheet seems to be attached and TC200 will not recoginize all attachment.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
cats4,
TeleChart will not import directly from a spreadsheet. You need to open the spreadsheet (as a spreadsheet) and highlight just the symbols (possibly by highlighting a single column) and then paste them into a text file and save it.
Once you have it saved as a text file, you should be able to import it, but if you can't, the most common problem in importing a list to TeleChart is extra characters in the text file that cause our program to miss some or all of the symbols. For example, saving a list in Excel can leave invisible Tab markers that prevent anything from being imported.
To prepare a text file to be imported:
1. Highlight the column of symbols
2. On the program's menu bar, click Edit and select Copy
3. Click the Windows Start button and select Run
4. Type notepad and click OK
5. On Notepad's menu bar, click Edit and select Paste
6. Click File and select Save
You can save the file anywhere but it is best to put it in C:\Program Files\TeleChart. If you choose a different location, be sure to remember where you save the file so you can find it when using TeleChart's import feature.
Note: It is best to make the list of symbols a single column.
To create a new WatchList from a list of symbols generated outside TeleChart:
1. Click TeleChart’s New button and select New WatchList
2. Name the WatchList, select Import from a File and click OK
3. In the Import Symbols From List window, navigate to and select the text file
4. Click Import
Note: If a symbol in the list is not already in the TeleChart database, the import utility will simply skip the symbol.
Other Options:
TeleChart also accepts lists imported from Metastock, TC2000 Version 3, and Watchlists already present in TeleChart.
If this does not address the issue, please contact technical support.
All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-9PM and Saturday 9AM-3PM ET except holidays) should be answered within 20 minutes of arrival.
For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 during business hours.
You can also contact us using Live Chat Support during business hours.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |