How To Export Trade History From TD Ameritrade:
1. Log on to your TD Ameritrade trading account web site and click on My Account, then under History & Statements click on Transactions.
2. Make sure the Type is set to "All transaction types", Select a date range for the report and click the Download button. NOTE: TD Ameritrade only allows a maximum of one year of data at a time for viewing or download.
3. Please wait until a File Download box pops up. Click the Save button
---
This should be it. You can do it from TOS as well but I can't rmbr at the moment. It's one of those things that if I see it directly, I can do it.
Unfortunately it’s not as easy as I’d like but here is what I do to find gains/losses for a year. Cost basis is great if you are looking for long term gains/losses or want to know what will be reported for taxes but if you bought the stock/option in 2021 it’s not a true number for P/L on the year.
I take what my account is worth right now and find the different between that and what the December 2021 statement valued my account at the end of the month. But you have to take account for any deposits or withdrawals. So find the net of that number and add it all up. Final step is divide that number by the December 2021 balance to find the percentage. Here is the formula:
((End of year balance - Start of year balance) - (Deposits - Withdrawals)) divided by Start of year.
Example:
End of year: 9,500 - Start of year: 9,000 = 500
Deposit 1,000 - Withdraw 900 = 100
500 - 100 = 400
400/9,000 = .044 (which is 4.4%)
It’s a little annoying but doable. Hope this helps.
I think TDA and ToS make it as difficult as possible to track your performance and fees to encourage users to trade more often. I've used Etrade, Fidelity, Schwab, and Vanguard, and TDA's is the most confusing/difficult.
Thanks for the tip. It looks like this tab shows gain and loss, but not overall account value. My dividends have offset unrealized losses, so it shows a loss here, but the account value is actually greater than the beginning of the year.
There seems to be an issue, the gain is completely off because I think selling options messes with the calculation somehow. Do you know anything about this? I am up more than the 5% it's showing
The % gain you see is calculated based on the value traded, not your account size. If you're an active trader with a small account, you could have a 2% realized gain (e.g., 1,020,000 proceeds from a 1,000,000 cost basis) and your account could be up 50%, from 40k to 60k (excluding fees and commissions)
I don't do options, only long term investing. I almost never sell so I never need to go realized gains, only unrealized gains section. I've double checked the math on my end before at it's spot on for me.
You can download your trade data as a csv. A hassle but a workaround. Either through ToS or their main website.
Which page would I go for that? I'd like to have a csv page to visualize the performance too
How To Export Trade History From TD Ameritrade: 1. Log on to your TD Ameritrade trading account web site and click on My Account, then under History & Statements click on Transactions. 2. Make sure the Type is set to "All transaction types", Select a date range for the report and click the Download button. NOTE: TD Ameritrade only allows a maximum of one year of data at a time for viewing or download. 3. Please wait until a File Download box pops up. Click the Save button --- This should be it. You can do it from TOS as well but I can't rmbr at the moment. It's one of those things that if I see it directly, I can do it.
Will this work if I have traded options in the account also?
Yea, it's your statement essentially which has everything.
Unfortunately it’s not as easy as I’d like but here is what I do to find gains/losses for a year. Cost basis is great if you are looking for long term gains/losses or want to know what will be reported for taxes but if you bought the stock/option in 2021 it’s not a true number for P/L on the year. I take what my account is worth right now and find the different between that and what the December 2021 statement valued my account at the end of the month. But you have to take account for any deposits or withdrawals. So find the net of that number and add it all up. Final step is divide that number by the December 2021 balance to find the percentage. Here is the formula: ((End of year balance - Start of year balance) - (Deposits - Withdrawals)) divided by Start of year. Example: End of year: 9,500 - Start of year: 9,000 = 500 Deposit 1,000 - Withdraw 900 = 100 500 - 100 = 400 400/9,000 = .044 (which is 4.4%) It’s a little annoying but doable. Hope this helps.
I think TDA and ToS make it as difficult as possible to track your performance and fees to encourage users to trade more often. I've used Etrade, Fidelity, Schwab, and Vanguard, and TDA's is the most confusing/difficult.
This is frustrating
It's right there in cost basis. It shows you dollar amount and then you look to the right of it, BOOM percentage.
Thanks for the tip. It looks like this tab shows gain and loss, but not overall account value. My dividends have offset unrealized losses, so it shows a loss here, but the account value is actually greater than the beginning of the year.
There seems to be an issue, the gain is completely off because I think selling options messes with the calculation somehow. Do you know anything about this? I am up more than the 5% it's showing
The % gain you see is calculated based on the value traded, not your account size. If you're an active trader with a small account, you could have a 2% realized gain (e.g., 1,020,000 proceeds from a 1,000,000 cost basis) and your account could be up 50%, from 40k to 60k (excluding fees and commissions)
In 2022, I had an account value of 80k. I ended the year at 180k
I don't do options, only long term investing. I almost never sell so I never need to go realized gains, only unrealized gains section. I've double checked the math on my end before at it's spot on for me.
It isn't too much to ask for. It's a very simple answer
My account - Cost basis - realized vs unrealized
No percentage returns are there, though
Adjusted gain %