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 to Excel Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
woefulseasel
Posted : Friday, May 23, 2014 7:04:29 PM
Registered User
Joined: 3/13/2014
Posts: 8

How do I export say DJ-30 to Excel for the last 15 years?

woefulseasel
Posted : Friday, May 23, 2014 7:12:38 PM
Registered User
Joined: 3/13/2014
Posts: 8

How do I export a file in TC2000 (vs. 12.4) platinum to Excel?

Jessica_R
Posted : Wednesday, May 28, 2014 3:48:18 PM

Worden Staff

Joined: 7/23/2013
Posts: 211

There is not really a way to export a Watchlist, however, I have a work-around that may be helpful for you.

With your Watchlist open, Click More (from your toolbar) > Old Items > Today's Prices

** In 12.4Beta, go to Tools > Old Features > Today’s Prices**

This will bring up a box with the following columns:
Symbol, Company Name, Open, High, Low, Last, Volume, Net, %Change.

Click the first row in this box so that the entire row is highlighted.

Scroll to the bottom of the box and press the CTRL key on your keyboard and click the last row. 

This will highlight everything in this box.

To copy everything in this box- press CTRL C.

Open an Excel spreadsheet or something like it.

To paste everything in this box- press CTRL V.

Now you should have the contents from Today's Prices in your Excel spreadsheet.

 

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.