How print gains and losses in Etrade

I am unable to print a long list of trades (10 pages) from Etrade. Etrade provides a tab "Gains and Losses" which list all the trades for the year with short and long term gains noted. Thisis an extremely
handy feature, but it seems impossible to print this thing. They even have a tab "Printer friendly" but it does not do anything.
I have copied page after page into Word then pasted to Excel, where it wastes space by having the symbol on a separate line plus an extra blank line, this after reducing to 8 point and using automatic column width. I go through this every year it seems. Has anyone solved this? John Polasek
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Saturday, April 14, 2012 2:18:01 PM UTC-5, John Polasek wrote:

On Saturday, April 14, 2012 2:18:01 PM UTC-5, John Polasek wrote:

I'm looking at my ETrade account, which isn't necessarily going to be exactly like yours, but I think you're looking at: Trading Portfolios>>Gains & Losses
If that's the case, in addition to the "Printer Friendly" link, I see a Dowload link, immediately to the right of that (it's got a green, downward pointing arrow).
What does that do?
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Sun, 15 Apr 2012 04:53:47 -0700 (PDT), snipped-for-privacy@gmail.com wrote:

link, immediately to the right of that (it's got a green, downward pointing arrow).

Download is the way to go. Click on the word "download" (not the arrow) and take the option "to Excel". In excel it comes up in text all in the first column. Highlight the 1st column. Then I think it's \Tools\ or \Data\ \"text to colums" and select comma-delimited. It's then properly segregated to colums and easy to work with. Printer friendly is a dead link to the next page where "Continue" does not do anything. Thank you very much. John Polasek
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
wrote:

Dowload link, immediately to the right of that (it's got a green, downward pointing arrow).

As further information, it is easy to add subtotals to the list for each stock in Excel: With it sorted by symbol, click in the column and then \data\subtotals and indicate the $gain column to contain the subtotal and select the operation Sum. If you want losses red, click the $gains header, \format\color\red. Delete the column total that you may already have executed or it will be added twice. John Polasek
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
wrote:

Dowload link, immediately to the right of that (it's got a green, downward pointing arrow).

That should be conditional format, condition <0 of course
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.