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 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 Wednesday to Sunday. 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.
- Where is the Year-to-Date Data Export file located?
- What does my Year-to-Date Export file include?
- How can I track my YTD futures performance?
- Example of Year-to-Date Export Data File
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 tastyworks.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
Before figuring any numbers, it is good practice to separate any short-term, long-term, or Section 1256 contract trades in your Year-to-Date Export File. You can distinguish these by referring to the column labeled TERM.
Term Column Designations
- S = Short-term capital gains/loss
- L = Long-term capital gains/loss
- U = Unknown term
- 60/40 = Section 1256 Contracts (cash-settled index options)
How to quickly filter and separate items in a CSV file
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 GAIN_LOSS 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 1256_TOTAL_GAIN_LOSS column.
How to take the sum of a column
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 tastyworks.com>My Account>Confirmations.
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 Worksheets, you may see the following codes listed in the opening and closing transaction columns.
- SHS: Non-Option Open Short
- CVS: Cover Short
- SEL: Sell
- ATF: Account Transfer
- ACT: ACAT
- RSP: Reverse Split
- CCG: CUSIP Change