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