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 ·
bleesgeld
Posted : Sunday, April 20, 2014 6:38:45 AM
Registered User
Joined: 4/15/2011
Posts: 29

Hi,

I try to export the Open/high/low/closing price of daily charts to excel (by right mouseclick on chart, "export chart data"). When I import the respective txt file into excel, I receive 8 columns instead of 4, and each of these prices is seperated into TWO columns (e.g. open column shows 35 dollars and high column 72 cents, although the opening price is 35,72 $, and so on.)
I don't know how to upload screenshots- I hope you understand what I mean.

How can I make dollars and cents show up in the same column??

Thank you and best regards

Thomas

Jessica_R
Posted : Monday, April 21, 2014 11:42:44 AM

Worden Staff

Joined: 7/23/2013
Posts: 211

bleesgeld,

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.

You can print this list.

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.