Martin Blais wrote: ... > I just wanted to chip in some context to importing from TD. I spent a > significant amount of time in the past getting data from TD to a normalized > form for importing into systems (including Beancount, but mostly for > Johnny, which is better suited to mark P/L on complex trades - > https://github.com/beancount/johnny). In short, what I've learned is > > - The most complete way to get data out of the system is via the > thinkorswim platform's Account Statement tab.
yes, but i don't have that nor do i plan on going there right now. i just want to get the past history files i have imported. so i'm writing a csv importer for that file format (their regular account csv format which is probably not like TOS). it is not complete or easy to work with, but i should be able to wrangle it somehow. ...details snipped, thanks... :) > If all you use is equities and a cash account, you're possibly okay with > other sources of downloads. However, if you're using futures or options, > you're likely to run into similar issues. You can see the (messy) parsing > code here: > https://github.com/beancount/johnny/blob/ma]ster/johnny/sources/thinkorswim_csv/transactions.py > and here: > https://github.com/beancount/johnny/blob/master/johnny/sources/thinkorswim_csv/positions.py > ) i'm not using futures or options so that makes things simpler. no margin stuff, nothing crazy, just simple trades. i did trade using lots at first because it made it easier for my own record keeping but now i'm just going with the account setting (FIFO i think, but since i hardly ever sell i'd have to check). now the harder part is the various Money Market accounts that they move money between, first there is the cash account and then the sweep accounts. it looks to me like they put the transactions in the account in the opposite order of what i'd expect, so they are grouped together by one day or a few days before you can reconcile between them all but that is like any other transaction where you sometimes have a lag between when you book it and when it hits the other side. fin -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/ib4gaj-9t7.ln1%40anthive.com.
