thanks. yes my intention was simply to have the cost basis available to basically start calculating profits from today on instead of trying to re-build history entries and might be failing, leading to frustration. like doing one step after the other.
but you are right, this way I might have the right cost basis but the actual entries aren't booked as it should be. as a non-dev the importer doesn't appear easy to start with, but I found some community contribution and might be able to get things going. [email protected] schrieb am Dienstag, 23. März 2021 um 18:12:45 UTC+1: > If you really want but I'm somewhat unclear what you are trying to do. > Normally you'd book sales to PnL + a cash account for the proceeds. If you > group the transactions together under a single txn your income statement > will all be grouped under that date. Maybe that's fine if you don't care > about the history, just the lot details. > > If you're trying to avoid a lot of tedious typing, you can probably get a > history CSV from Etherscan and then use a CSV importer (or make your own) > to import these automatically. > > You could always start like this and import more history as you have the > need / desire for. > > On Tue, Mar 23, 2021 at 9:31 AM david e <[email protected]> wrote: > >> thanks good idea – so the second entry with negative amounts is also >> balanced against Equity:Opening-Balances? >> >> [email protected] schrieb am Dienstag, 23. März 2021 um 17:24:40 UTC+1: >> >>> Beancount doesn't currently support transactions that self-reduce. So >>> you need to at least split the buys and sells. Should be no problem with >>> having those be grouped together though. >>> >>> On Tue, Mar 23, 2021, 09:12 david e <[email protected]> wrote: >>> >>>> I am trying to open an account and immediately add existing lots that >>>> go back in time to my journal file. >>>> >>>> for small positions with only one entry I simply did the following: >>>> >>>> 2021-03-23 * "Open XYZ" >>>> Assets:Crypto:WalletB:XYZ 3000.00 XYZ {0.03 USD, 2018-11-11} >>>> Income:Crypto:Airdrop >>>> >>>> but what about having several buy and sell transactions? >>>> >>>> ideally, I would like to have an entry like this >>>> >>>> 2000-01-01 * "Open ETH" >>>> Assets:Crypto:WalletB:ETH 0.5 ETH {1200.00 USD, 2018-01-01} >>>> Assets:Crypto:WalletB:ETH -0.1 ETH >>>> Assets:Crypto:WalletB:ETH 0.5 ETH {1300.00 USD, 2018-01-20} >>>> Equity:Opening-Balances >>>> >>>> to automatically subtract from the first lot, but this doesn't work as >>>> in bean-report holdings simply all listed positions show up, positive and >>>> negative. the subtraction only works when I specify from which lot I want >>>> to sell, like this: >>>> >>>> 2000-03-23 * "Open ETH" >>>> Assets:Crypto:WalletB:ETH 0.5 ETH {1212.59 USD, 2018-01-01} >>>> Assets:Crypto:WalletB:ETH -0.1 ETH {1212.59 USD} >>>> Assets:Crypto:WalletB:ETH 0.5 ETH {1300 USD, 2018-01-20} >>>> Equity:Opening-Balances >>>> >>>> here the problem is that a lot of other entries are following and I >>>> can't keep track of the lots so the manual approach doesn't work here. >>>> >>>> is there any way I can open this account and calculate the correct Lots >>>> by putting several ins and out into the same entry? otherwise I could also >>>> book an average price for all transactions but I would very much prefer to >>>> have it as accurate as possible. >>>> >>>> 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/a5186533-f5c1-4ad6-93d8-4404bed0a927n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/beancount/a5186533-f5c1-4ad6-93d8-4404bed0a927n%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/a8719a65-44c1-42cb-85ef-f0356038b798n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/beancount/a8719a65-44c1-42cb-85ef-f0356038b798n%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/91461cfe-bab2-4c9f-bf12-794ab2985c3bn%40googlegroups.com.
