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

Reply to
John Polasek
Loading thread data ...

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?

Reply to
bartt.shelton

like yours, but I think you're looking at:

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

Reply to
John Polasek

like yours, but I think you're looking at:

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

Reply to
John Polasek

like yours, but I think you're looking at:

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

That should be conditional format, condition

Reply to
John Polasek

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.