Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Import symbols from file... Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
trendchange
Posted : Thursday, January 17, 2013 2:27:50 PM
Registered User
Joined: 2/5/2005
Posts: 55

Hi Bruce!

 

I want to imort a symbol from excel spreadsheet to a personal watch list.  Can you tell me what format I need to have the symbol in?  Better yet if you can link me to any discussions on this I can figure it out that way.  Thanks so much!


Dave

Bruce_L
Posted : Thursday, January 17, 2013 2:30:55 PM


Worden Trainer

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

You should be able to just highlight the symbols in the Excel spreadsheet, right-click on them, select copy and then right-click on the symbols in a Personal WatchList and select Paste (or use ctrl-v).

Copying Symbols to Personal WatchLists



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
trendchange
Posted : Thursday, January 17, 2013 2:34:51 PM
Registered User
Joined: 2/5/2005
Posts: 55

I should have mentioned I want to import my own data from an excel spreadsheet that has date,open,high,low,close.

 

Dave

Bruce_L
Posted : Thursday, January 17, 2013 2:43:26 PM


Worden Trainer

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

You can import a list of symbols which are already available in TC2000 to create a Personal WatchList, but you cannot import symbols which are not already available in TC2000. It is not possible to import data.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
trendchange
Posted : Thursday, January 17, 2013 2:45:01 PM
Registered User
Joined: 2/5/2005
Posts: 55

I think I found the answer and that is to do it in version 7?  If this is in fact the solution and it cannot be done in version 12, it would be a great feature to add!

 

Dave

Bruce_L
Posted : Thursday, January 17, 2013 2:53:43 PM


Worden Trainer

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

It is not possible to import or plot external data into any version of TC2000.

StockFinder doesn't actually have a way to import external data, but it does have the ability to Plot external CSV data contained in a text file.

Market Data Reader Overview
RealCode File Reader Overview

The blogs containing the examples no longer exist. That said, the Minutes Data is incomplete topic contains both an example file and a RealCode Indicator which can display its contents in StockFinder.

Thank you for your suggestion. It has been assigned case number 9923.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MCPP
Posted : Wednesday, June 5, 2013 2:10:38 PM
Registered User
Joined: 8/20/2012
Posts: 27

Hi Bruce,

Can you clarify this for me (along the same lines of the above OP) please.

I have a list of symbols in excel. Can I copy & paste them into a new Watch List in TC2000?

I read an earlier post where you said to put them into Notepad and transfer them from there, but that was for different software.

 

Thanks

Bruce_L
Posted : Wednesday, June 5, 2013 2:15:07 PM


Worden Trainer

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

You should be able to copy and paste a list of symbols from Excel into TC2000 version 12.3.

Copying Symbols to Personal WatchLists



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MCPP
Posted : Wednesday, June 5, 2013 2:28:27 PM
Registered User
Joined: 8/20/2012
Posts: 27

Bruce,

I watched that video before I posted, and just watched it again. No mention of transfering from excel on there. Any other link?

Thanks

Bruce_L
Posted : Wednesday, June 5, 2013 2:29:53 PM


Worden Trainer

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

The video is just general instructions on how to copy and paste symbols into WatchLists. It does not specifically demonstrate doing so from excel, but it works the same way.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MCPP
Posted : Wednesday, June 5, 2013 3:43:19 PM
Registered User
Joined: 8/20/2012
Posts: 27

Thanks Bruce, 

but I need to clarify what I want to do. I have a list of 30 symbols in an excel file, and I want to copy and paste at one time the entire list so I don't have to enter them one at a tme.

If this is possible, I don't see the next step.

Thanks again

 

Bruce_L
Posted : Wednesday, June 5, 2013 3:48:18 PM


Worden Trainer

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

The steps are exactly the same as any other type of symbol copy and paste. It doesn't matter if you are copying from a TC2000 WatchList, a text file or an Excel file.

- Highlight the symbols.
- Right-click on the highlighted section and select Copy.
- Right-click on a symbol in a Personal WatchList in TC2000 and select Paste.
- Select OK.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ghanson
Posted : Sunday, April 12, 2015 2:33:48 PM
Gold Customer Gold Customer

Joined: 1/29/2005
Posts: 55

Hey Bruce,

I needed to import  a ton of symbols into a new watch list and knew there must be a way to load them in altogether. So I did a quick search and this post series popped up. Even though I'm resurrecting an old thread I had to make the following comments:

1. Your clear explanation made it simple and quick to populate my list.

2. Your patience working with us users out here is truly remarkable!

 

Thanks,

Greg

nimal
Posted : Saturday, November 25, 2017 2:29:40 PM
Registered User
Joined: 2/14/2006
Posts: 117

Hi,

I use Version 17 of TC 2000 and would like to import a list of symbols from Excell. I tried some of the instructions in this thread but they do not seem to work. Any help is appreciated.

Thanks

 

bcochrane
Posted : Sunday, November 26, 2017 6:44:14 AM
Registered User
Joined: 9/17/2010
Posts: 484

Perhaps it would be helpful if you posted the steps you went through, and what seemed to work or not work.

nimal
Posted : Sunday, November 26, 2017 5:20:10 PM
Registered User
Joined: 2/14/2006
Posts: 117

I tried the steps outlined such as;

1. Selecting the range from excell file and copying

2. Then pasting on to the add new symbols field 

The procedure seems to work except that it pastes only one symbol and not he entire range of symbols selected and copied.

Thanks.

bcochrane
Posted : Sunday, November 26, 2017 9:02:54 PM
Registered User
Joined: 9/17/2010
Posts: 484

Gotcha.

The Add New Symbol field paste will only add one symbol, as you noticed.

But try placing your cursor over the watchlist itself, and then pasting. You don't need to go thru the Add New Symbol cell.

Bon Chance

nimal
Posted : Monday, November 27, 2017 10:09:06 PM
Registered User
Joined: 2/14/2006
Posts: 117

Thanks a lot. It worked.

Nimal

 

Baseball72
Posted : Monday, April 2, 2018 4:54:54 PM
Registered User
Joined: 4/19/2017
Posts: 5

I'm having trouble making this work with the latest version of TC2000 (version 18)

biseniusr
Posted : Monday, April 2, 2018 5:50:18 PM
Registered User
Joined: 9/2/2006
Posts: 12

I do this once a week with the IBD lists.  I copy just the column of symbols, and past them into a text file and save it to a folder. Below is how the symbols are formatted.  I then create a New Watch List.  Right clicking in the blank watch list opens a dialog menu.  Select Import Symbols from File with a left click, browse to the text file you just saved select it and the symbols will import to the watch list.

ANF
CPRT
KSS
EL
SSNC
FIVE
GWW
ODFL
OLLI
KEYS
VNOM
WRD
ZTS
BURL
FND
RMD
SPGI
PVH
CHRW
STZ
bcochrane
Posted : Tuesday, April 3, 2018 7:30:22 AM
Registered User
Joined: 9/17/2010
Posts: 484

FWIW another technique for copying over IBD lists

  1. Export IBD list to Excel (option is usually at bottom of list)
  2. This automatically opens an instance of Excel, with the stock symbols in Column A
  3. Copy column with list of symbols
  4. Paste into TC2000 watch list
  5. Close Excel with out saving
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.