I want to export my filled orders to a spreadsheet. Yes, I know I can click on Account Statement and select dates . The csv file produced by this process has lots of data I don’t want (cancelled orders, etc.) I called Thinkorswim, they tell me they have no tool do to this. This is something many people in this forum probably do every day. My programming knowledge is limited. Perhaps someone has some code snippets or knows of a useful link they would share?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Export filled trades
- Thread starter Cellsee6
- Start date
Is this for stocks or options ?
Amtd is the worst as far as exporting complete trades
I had to download 2 separate files to get everything I needed because 1 file was missing something while the other file had that but missing something else
I imagine downloading stock data would be much easier and you can probably find something online but I have not seen anything useful for options It's a lot more complicated especially when doing adjustments or rolling and I managed to do it but it was not easy
I just used basic macros and get some help online if I was stuck at some point
It's still not completely finished but it works for what I needed
I was only doing it so I can transfer it to a tradelog that would show the progress but with all the losses this year and the different strategies I was trying out it would not be consistent and would probably not get much use out of it
On the other hand doing all that work helped me to get better at using macros in excel so it was not a complete waste
Now that Tom came out with the spreadsheet for the boxcar I am using that to track my trades which takes a lot less work
I mean once you enter the fills and the commissions you pretty much have all the data you would have from Amtd
The only thing you would not have is historical data but once you start using it you would not need historical data
Amtd is the worst as far as exporting complete trades
I had to download 2 separate files to get everything I needed because 1 file was missing something while the other file had that but missing something else
I imagine downloading stock data would be much easier and you can probably find something online but I have not seen anything useful for options It's a lot more complicated especially when doing adjustments or rolling and I managed to do it but it was not easy
I just used basic macros and get some help online if I was stuck at some point
It's still not completely finished but it works for what I needed
I was only doing it so I can transfer it to a tradelog that would show the progress but with all the losses this year and the different strategies I was trying out it would not be consistent and would probably not get much use out of it
On the other hand doing all that work helped me to get better at using macros in excel so it was not a complete waste
Now that Tom came out with the spreadsheet for the boxcar I am using that to track my trades which takes a lot less work
I mean once you enter the fills and the commissions you pretty much have all the data you would have from Amtd
The only thing you would not have is historical data but once you start using it you would not need historical data
Cellsee6, Not sure what the problem is but TOS' Exported AccountStatement does contain your filled orders.
In TOS you set your time range fields to see and some others settings. In csv file you have to look for "Trade History" section - it has all your fills.
You may need to extract this section manually in Excel (Cut/Paste) will do. This method is fine for occasional use, if you want to do it on regular basis you have options:
_ learn how to automate things (this is by far preferable)
_ask somebody for script that more or less does what you want
_pay somebody to code for you exactly what you are looking for.
In TOS you set your time range fields to see and some others settings. In csv file you have to look for "Trade History" section - it has all your fills.
You may need to extract this section manually in Excel (Cut/Paste) will do. This method is fine for occasional use, if you want to do it on regular basis you have options:
_ learn how to automate things (this is by far preferable)
_ask somebody for script that more or less does what you want
_pay somebody to code for you exactly what you are looking for.
That is correct unfortunately it does not have the commissions that's why I said I had to download another excel file from the website that has the commissions but that file does not have the open/close so if you don't need the commissions you can just use the csv fileIn csv file you have to look for "Trade History" section - it has all your fills.