thanks a lot for taking time to answer. I am very new to beancount and I am not a programmer, so this will take a little longer to implement.
I will try to get started by running scripts like the one you provided, and hope to be able to can access it via CLI (like having the script available similar to a `bean-report` action. gonna read the docs and start step by step. it is my goal to have an overview of my current positions and from what I have seen so far, beancount is just perfect for that purpose. even without programming skills the advantage of having the tool to report my action exactly the way I want is promising and worth to get into this field. I am not trading futures or options, but sometimes using leverage. but my first task is to get my current positions into my main file (some are from 2018/2019 and I have to figure out how to handle the cost basis), some are cryptocurrencies and others are stocks. I do have a lot more of trading related questions, do you prefer to have them available as separate conversations or should I put them into here? thanks [email protected] schrieb am Dienstag, 9. März 2021 um 04:02:30 UTC+1: > On Mon, Mar 8, 2021 at 9:32 AM 'David E' via Beancount < > [email protected]> wrote: > >> Hello, I am very new to Beancount as I want to keep track of my trading >> activities and generate reports with FIFO settings. I love the tool so far >> and the community around it. >> >> 1) >> To get started, I want to better understand how Lots are handled and >> therefore want to report active Lots. In the docs (how inventories work > >> cost basis) there is a very good example of what I am looking for >> >> ```units ccy cost cost-ccy lot-date label >> 25 HOOL {23.00 USD, 2015-04-01, "first-lot"} 35 HOOL {27.00 USD, >> 2015-05-01, None}``` >> >> I tried `bean-report books.beancount holdings` but only get a total of >> the account, not the active Lots within. what else could I try? >> > > This this script, which runs the booking code by hand over your > transactions and stores the matches ("trades"): > > https://github.com/beancount/beanlabs/blob/master/beanlabs/trades/match_trades.py > > In v3, it will be built-in and the result of booking will leave traces in > the postings in order to rebuild the trades without having to rebook > everything. > See "Trade Matching and Reporting" section of this doc: > > https://docs.google.com/document/d/1qPdNXaz5zuDQ8M9uoZFyyFis7hA0G55BEfhWhrVBsfc/edit#heading=h.1on91pqrb473 > > In the meantime the script I shared should do the job, and will work on > current v2 branch. > > > >> >> 2) >> As a bonus, I would like to ask how it could be possible to track my >> trades so that I can analyse the outcome. I am thinking of categories like >> timeframe or setup. The query for example could be: show me the outcome of >> all trades based on the 1H chart (this way I could see where my profits >> come from, interesting to know). problem I see is that I would have to book >> it in order to have it available to query, but I would make an entry for >> PnL instead, right? >> > > You should build your own using the results of the above. > > I've done a bunch of custom scripts and many of these aren't shared - not > polished enough - although last year I took some time to structure my > returns calculation based on cash flows and shared it here: > doc: http://furius.ca/beancount/doc/returns > repo: https://github.com/beancount/beangrow > > For options and futures, I have a separate set of scripts, but those > aren't neat enough to share yet, as they remain with some amount of > dependence on my particular style of trading, strategies and they're made > more complicated by options on futures and pairs trades. I'm in a position > to have to generalize it across multiple brokers now so I may end up > putting that out there eventually. > > N.B. If you're on TD, this will come in handy: > > https://github.com/blais/ameritrade/blob/master/examples/ameritrade2beancount.py > > I also share an IBKR importer: > > https://github.com/beancount/beanlabs/blob/master/beanlabs/importers/ibkr/ibkr_flex_reports_csv.py > and have a pretty basic Tastyworks one I could share if anyone cares. > > Hope this helps, > > > >> looking forward to what you have in mind about it. >> thanks >> >> -- >> 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/b028cb55-2900-40e7-a473-c1330c5ce2dbn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/beancount/b028cb55-2900-40e7-a473-c1330c5ce2dbn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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/71ecf0a8-a4c3-4d97-94e0-346bc4b3afbfn%40googlegroups.com.
