New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Export watchlist to Excel Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
egil
Posted : Thursday, May 10, 2012 12:06:15 PM
Registered User
Joined: 10/7/2004
Posts: 22

Is there any way to export a watchlist to Excel.  I am using Tc2000 Gold and I need to export the last price from a watchlist or easyscan to an excel spread sheet.  I can get the Symbols, but can't figure out how to import the last price except to copy each price manually.  I would appreciate any help on this.

Thanks,

Ed

Bruce_L
Posted : Thursday, May 10, 2012 12:11:28 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,305

You can export the active symbol on a chart along with its indicators, but it is not currently possible to do the same for a WatchList in TC2000 version 12.1.

You you need to export a WatchList, I would suggest using TC2000 version 7.

Exporting data to text format - comma, space or tab delimited



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rb73
Posted : Thursday, June 14, 2012 7:56:47 PM
Registered User
Joined: 10/13/2011
Posts: 10

Is there any plan to allow the export of watchlist data in version 12 in the future please? I'm trying v7 but the fields that can be exported look quite limited.

If this were imlemented along with the ability to create a chart for a user generated index, my TC2000 wish list would be complete!

Bruce_L
Posted : Thursday, June 14, 2012 9:32:54 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,305

I do not know when the ability to export a WatchList will be added to TC2000 version 12.2.

Thank you for the suggestion. It has been assigned case number 7889.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
toferko
Posted : Thursday, June 08, 2017 6:59:39 AM
Registered User
Joined: 5/16/2007
Posts: 50

QUOTE (Bruce_L)

I do not know when the ability to export a WatchList will be added to TC2000 version 12.2.

Thank you for the suggestion. It has been assigned case number 7889.

sinoyank
Posted : Tuesday, March 13, 2018 12:55:51 PM
Gold Customer Gold Customer

Joined: 12/10/2004
Posts: 4

Hi Bruce:

If you could, please let me know if this function of exporting a watchlist and values of its various columns has been added to version 17.

Thanks.

Kenneth

Bruce_L
Posted : Tuesday, March 13, 2018 12:58:04 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,305

There isn't a way to export WatchList Column values in TC2000 v17. You can copy and paste the list of symbols, but there isn't a way to export data for entire WatchList at a time.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
neil.galloway
Posted : Thursday, November 15, 2018 3:32:41 PM
Registered User
Joined: 5/3/2011
Posts: 7

Any word on this case or workaround available?  Copy/paste from a grid seems like it would be a relatively simple ask as copy/paste does work already for the symbols.

My situation is this and maybe you have another way to do it:

  • I'm trying to backtest a strategy
  • I'm trading on the 2m chart
  • I have easyscans that output my scan results and how they performed for a day historically.
  • I would like to take the entire contents of my watchlist (symbol from scan, columns showing how it would look if I scanned it at the same point in time, and what the results were for the day)
  • I want to keep it in Excel and perform analysis on the # of symbols and how the strategy performs over time.
  • A simple copy/paste would be extremely useful.
Bruce_L
Posted : Thursday, November 15, 2018 3:36:31 PM


Worden Trainer

Joined: 10/7/2004
Posts: 64,305

No, I do not have any sort of workaround.



-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.