Do you need to file a quarterly tax estimate (1040-ES)? Or, do you want to check your YTD realized profit performance? Either way, you can export your Year-to-Date transactions by visiting our Tax Center. The Year-to-Date Data Export file is a .csv file, which is a standard spreadsheet file type. You can use your favorite spreadsheet-making program to open and view your YTD data.
Year-to-Date Export files update every night from Tuesday to Saturday. As a result, there is a two-day delay before you see any realized/closing securities trades populate in your year-to-date CSV data.
TABLE OF CONTENTS
- Where is the Year-to-Date Data Export file located?
- What does my Year-to-Date Export file include?
- Example of Year-to-Date Export Data File
- Code Key for Opening and Closing Transaction Columns
- How to track Wash Sales
- How can I track my YTD futures performance?
Where is the Year-to-Date Data Export file located?
Visit our Tax Center
Your Year-to-Date Data Export file is in our Tax Center. To access the Tax Center, please log in to your account at tastytrade.com>My Accounts>Tax Center, or click here, then scroll down to the Year-to-Date Data Export section. There will be a link to download your Year-to-Date Data Export Data file (CSV). Year-to-Date Data Export files update Tuesday through Saturday. That means if you had any closing transactions, then the data will reflect in your YTD file the following day.
What does my Year-to-Date Export file include?
Equity (stocks/ETFs), Equity Options, and Index Options.
Your Year-to-Date Data Export file only includes realized profits or losses on equity (stock and ETFs) and equity options. Realized gains or losses include options positions held to expiration. Additionally, index options trades such as SPX, NDX, RUT, VIX, etc., will appear in your YTD Export file. However, unrealized index options trades will appear since these products (section 1256 products) mark-to-market daily.
How to calculate your P/L in the Year-to-Date Export File
To quickly distinguish amongst the different holding periods (TERM), you can use your spreadsheet's built-in filter function. Below is a list of links, to help articles for some of the most common spreadsheet software.
Term Column Designations
- ShortTerm = Short-term capital gains/loss
- LongTerm = Long-term capital gains/loss
- Unknown = Unknown term
- SixtyForty = Section 1256 Contracts (cash-settled index options)
How to quickly filter and separate items in a CSV file
- Microsoft Excel
- Google Sheets
- Apple Numbers
- OpenOffice (Autofilter)
After filtering and separating your different trading terms, you can quickly determine your profit and loss for your short-term and long-term trades by taking the sum of the 8949_GAINLOSS column. Due to the unique profit and loss handling of Section 1256 contracts, you can quickly determine your profit and loss by taking the sum of the 1099_1256_CY_REALIZED column.
Due to the nature of 1256 contracts, any positions held through the previous Calendar Year, will be noted under the 1099_1256_CY_UNREALIZED column. If this is the case, you can quickly view your Aggregate P/L, by calculating the sum of the 1099_1256_AGGREGATE column.
How to take the sum of a column
Example of Year-to-Date Export Data File
Code Key for Opening and Closing Transaction Columns
When viewing your Year-to-Date Export file or Tax Work, you can use the following columns when determining your Cost Basis, Proceeds and P/L.
- SEC_SUBTYPE - Equity Option, Common Stock, Index Option
- NO_WS_COST - Cost Basis where no wash sale wash was reported
- NO_WS_PROCEEDS - Proceeds where no wash sale was reported
- NO_WS_GAIN_LOSS - Total gain/loss where no wash sale was reported
- TERM - Short Term, Long Term, SixtyForty, Undetermined
- COVERED_IND - Covered, Non-covered
How to track Wash Sales
If a wash sale is reported a "W" will be listed under the 8949_CODE column. You can filter this column to only display the reported wash sales, to determine the total sum.
How can I track my YTD futures performance?
Check your tasty daily futures statement
Each day you hold a futures position, our Futures Commission Merchant (FCM) issues a statement. On the bottom of your tasty daily futures confirmation, your YTD performance lists on the bottom, as illustrated below. If you need to look up a specific period, such as the end of a quarter, then refer to the latest futures confirmation date for your specified end date. For example, if it is currently September and you want to estimate your Q2 (April-June) futures performance, refer to the latest confirmation issued in June. You can locate your futures confirmations by logging in to your account at tastytrade.com>My Account>Confirmations.