| Welcome Guest, please  sign in  to participate in a discussion. | Search | 	Active Topics | | 
	
	
	| Registered User Joined: 2/1/2016
 Posts: 10
 
 | 
	Hello  
	  
	I have created scans of the NYSE, NASDAQ and S&P500  
	  
	I wish to export all ticker symbols with open, high, low, close and volume data to excel.  
	  
	Is there an option to scan the easy scan result list?  
	  
	Thanks | 
	|  | 
	
	
	| Registered User Joined: 2/1/2016
 Posts: 10
 
 | 
	I meant to say... export the easy scan result list to excel | 
	|  | 
	
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	You can copy and paste the symbols, but there isn't any built in way to export the the data for an entire WatchList or EasyScan at a time from TC2000 v12 or v16. 
	It is possible to export the data for an entire WatchList at a time using TC2000 v7. 
	Exporting data to text format - comma, space or tab delimited  
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	|  | 
	
	
	| Registered User Joined: 2/1/2016
 Posts: 10
 
 | 
	Ok thanks  
	  
	I see the common stock universe is larger in V7....  
	  
	v7: 5829 
	v16: 5023  
	  
	Can this be explained?  
	  
	Thanks  | 
	|  | 
	
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	American Depository Receipts are consider Common Stocks in v7 but have a specific WatchList in v16. There are also differences in the preferred stocks listed between v7 and v16 which affects the Common Stocks WatchLists. 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	|  | 
	
	
	| Registered User Joined: 2/1/2016
 Posts: 10
 
 | 
	Ok thanks!  
	  
	One last thing... If i export ALL S&P500 data in v7 - Will it account of the updates and changes to the s&p500 list throughout the years?  | 
	|  | 
	
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	No, it will not. The exported data will be for the current list of symbols and will not contain any symbols which havee been remomved from the S&P500. 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	|  | 
	
	
	| Registered User Joined: 2/1/2016
 Posts: 10
 
 | 
	Ok thanks for your help  | 
	|  | 
	
	
	|  
  Worden Trainer
 
 Joined: 10/7/2004
 Posts: 65,138
 
 | 
	You're welcome. 
 -Bruce
 Personal Criteria Formulas
 TC2000 Support Articles
 | 
	|  | 
| Guest-1 |