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 |

Export Easy Scans to Excel Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
flare9x
Posted : Tuesday, March 1, 2016 12:59:57 PM
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

flare9x
Posted : Tuesday, March 1, 2016 1:00:34 PM
Registered User
Joined: 2/1/2016
Posts: 10

I meant to say... export the easy scan result list to excel

Bruce_L
Posted : Tuesday, March 1, 2016 1:18:09 PM


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
flare9x
Posted : Tuesday, March 1, 2016 1:59:30 PM
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 

Bruce_L
Posted : Tuesday, March 1, 2016 2:18:16 PM


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
flare9x
Posted : Tuesday, March 1, 2016 2:23:03 PM
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? 

Bruce_L
Posted : Tuesday, March 1, 2016 2:27:56 PM


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
flare9x
Posted : Tuesday, March 1, 2016 2:30:55 PM
Registered User
Joined: 2/1/2016
Posts: 10

Ok thanks for your help 

Bruce_L
Posted : Tuesday, March 1, 2016 2:31:21 PM


Worden Trainer

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

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.