| broker |
note |
we get data by logging into the website as
you |
you can copy and paste website data (data
conversion surcharge may apply)
Note 1 |
you can download a file
(csv or txt -
reports) and email it to us (we can help you with detailed instructions) |
| Ameritrade |
|
yes |
yes |
no |
| CSFB Direct |
|
yes |
no |
no |
| CyberTrader |
clears via Penson |
yes |
not required |
see Penson |
| Datek (now Ameritrade) |
|
yes |
yes
Note 2 |
yes
Note 9 |
| E-trade |
|
yes |
no |
no |
| Excel - your own spreadsheet |
will be fine in majority of cases, please send
us a sample to make sure. Note 3 |
| Interactive Brokers |
|
yes |
not required |
yes
Note 4 |
| new MB Trading (platform called The
Navigator) |
before September 2001
see Note 5 |
| September 2001 and on clears via Penson |
yes |
not required |
yes
see Penson |
MB Trading
(now Terra Nova - MB) |
see TerraNova - MB |
| MyTrack |
clears via Penson |
yes |
not required |
yes
see Penson |
| Optionsxpress.com |
|
yes |
not required |
yes
csv download available on the website |
| RealTick III brokers offering csv downloads |
|
yes |
not required
|
yes
Note 6
|
TerraNova-MB
other RealTick III brokers |
Real Tick III broker |
yes |
not required |
yes
Note 6
|
Penson online -
all brokers clearing via Penson |
|
yes |
not required |
yes
Note 7
|
| Preferred Trade |
|
|
|
|
| Quicken |
in some cases, we can accept broker files for
Quicken import, but we prefer not to. Generally, brokers who offer
QIF download also have CSV and TXT downloads that are
superior.
because of the many versions of Quicken available, we do not support QIF
files exported out of Quicken. |
| Schwab |
|
yes |
no
short page displays, would not be practical |
no |
| Scottrade |
|
yes |
|
csv file |
| Shoreline Trading |
|
yes |
not required |
yes
csv file emailed to client monthly, just forward to us |
| spreadsheet - own spreadsheet |
will be fine in majority of cases, please send
us a sample to make sure |
| Think
or Swim |
clears via Penson
but does not use standard Penson access to data |
yes |
see Note 8 |
see Note 8 |
| Tradestation |
clears via BearStearns
no
electronic data access available.
Paper confirmations use averaged cost, not actual.
|
no |
csv files downloadable via "TraderToolbox"
that client requests from account rep |
csv files downloadable via "TraderToolbox"
that client requests from account rep
|
| TradingDirect |
|
yes |
yes |
no |
| The
Trade Pros |
RealTick III
platform |
yes |
not required |
yes
see Penson |
NexTrend
platform |
yes |
not required |
yes
see Penson |
|
|
|
|
|
Note 1
Query transactions for whole calendar year date range (or one
month of data at a time, as appropriate with your broker), select all, copy, and paste into (in order of
our preference: MS Excel, Notepad, Wordpad, MS Word) . Save
file(s)
and email to us.
Repeat with the month of January of following year (for wash sale purposes -
non-MTM clients only)
Note 2
Datek/Ameritrade - displays only one month at a time, will have to save
at least 13
files one by one. Caution: for active traders, one month may be
split into more than one page. Need to pay close attention to see if
multiple pages are indicated in the history.
Note 3
client's own Excel worksheet
We require the following columns, does not matter in what order:
Transaction Date
Symbol
indication of Buy or Sell, Short or Cover
indication of Long or Short trade
total amount of transaction, including commission (or ability to derive this
amount from other columns)
Note 4
Interactive Brokers
We work with the "annual summary" that IB makes available for the whole year in
about early February of each year. In the absence of this report, we are
able to work with monthly statements, but it's more time consuming.
Note 5
MBtrading, The Navigator platform, pre September 2001 only
cleared
via ICS, no electronic access to data available, transactions must be
re-typed manually!
Note 6
TerraNova (RealTick)
go to "Reports and Download" data section of the
website.
Select date range (calendar year) and select "CSV
standard" radio button - not QIF or Detailed CSV.
Save report
to your hard drive. Rename file on your hard drive to prevent getting
overwritten in the next step.
Repeat for month of January of following year. Email us both files.
Note 7
Penson
Ad Hoc Data Retrieval via website for a date range for
whole calendar year, request sent by email, you can enter our email
directly (simona@edaytradertax.com).
Repeat for month of
January of following year.
Note 8
Thinkorswim.com
Penson - Quicken download only
after logging into your www.thinkorswim.com
website, go to the "enter client section" near the bottom.
click on "statements", then "statement
downloads". You will be redirected to the online.penson.com
website. Click "access clearing firm data", then proceed
to "data retrieval" near the top.
On the next page, click "Quicken extract". enter date
range for individual quarters, only 3 months at a time can be
accessed. Follow the instructions on screen to save the files to
your harddrive, and then attach them to an email to us.
Note 9
Datek
from the history menu, select the "Download 2002 baseline
positions". Save this file to your harddrive per instructions, and
then attach it to an email to us.
