Hi, I want to share some tools that I created.
Beancount cryptoassets: https://github.com/xuhcc/beancount-cryptoassets This package contains price sources for cryptocurrencies based on Coinmarketcap API and Cryptonator API, but also price sources for some DeFi assets (Compound, bZx, TokenSets). Ethereum transaction importer for Beancount: https://github.com/xuhcc/beancount-ethereum-importer It includes a script that downloads transactions from Etherscan and an importer for downloaded transactions. Price source for http://exchangeratesapi.io/ (not related to crypto, but I haven't shared it before): https://github.com/xuhcc/beancount-exchangerates On Monday, November 20, 2017 at 3:24:13 AM UTC+3, AV wrote: > > Hi, > > Congratulations on beancount. I am new to it but I think it is an amazing > software, therefore I would like to take the most advantage of it. This is > actually my first message on the forum. > > I would like to use beancount with cryptocurrencies. I have may doubts but > I prefer to take one step at a time. What I would like to be able to do > first is to be able to see the my portfolio value at the present time. For > instance, let's assume the following file: > > ; -*- mode: org; mode: beancount; coding: utf-8; fill-column: 400; -*- > ; > ; Cheatsheet > ; > https://docs.google.com/document/d/1M4GwF6BkcXyVVvj4yXBJMX7YFXpxlxo95W6CpU3uWVc/edit > > option "title" "Crypto" > option "operating_currency" "ETH" > option "operating_currency" "GAS" > option "operating_currency" "LTC" > option "operating_currency" "NEO" > > plugin "beancount.plugins.book_conversions" > "Assets:Crypto:ETH,Income:Capital-gains" > > ;* Equity > ;2017-11-01 open Equity:Opening-Balances > > * Account declarations > ; Account1 > 2017-08-18 open Assets:Crypto:ETH:Account1 ETH > 2017-08-18 open Assets:Crypto:LTC:Account1 LTC > ; Account2 > 2017-08-18 open Assets:Crypto:ETH:Account2 ETH > ; Exchange > 2017-08-18 open Assets:Crypto:GAS:Exchange GAS > 2017-08-18 open Assets:Crypto:NEO:Exchange NEO > > 2017-08-18 open Expenses:Crypto:ETH:Balance ETH > 2017-08-18 open Expenses:Crypto:GAS:Balance GAS > 2017-08-18 open Expenses:Crypto:LTC:Balance LTC > 2017-08-18 open Expenses:Crypto:NEO:Balance NEO > > * Income > 2017-08-18 open Income:Capital-gains > > * Expenses > 2017-08-18 open Expenses:Financial:Commisions:USD > > * Transactions > 2017-11-19 * "Opening balance: Account1" > Assets:Crypto:ETH:Account1 5.12561083 ETH > Assets:Crypto:LTC:Account1 7.58990978 LTC > Expenses:Crypto:ETH:Balance -5.12561083 ETH > Expenses:Crypto:LTC:Balance -7.58990978 LTC > > 2017-11-19 * "Opening balance: Account2" > Assets:Crypto:ETH:Account2 3.968560 ETH > Expenses:Crypto:ETH:Balance -3.968560 ETH > > 2017-11-19 * "Opening balance: Exchange" > Assets:Crypto:NEO:Exchange 4 NEO > Assets:Crypto:GAS:Exchange 0.18651499 GAS > Expenses:Crypto:NEO:Balance -4 NEO > Expenses:Crypto:GAS:Balance -0.18651499 GAS > > I am not experienced with accounting and english is not my primary > language, but I guess the file is in "accounting good shape" and it makes > sense somehow. If not please let me know. > > Now let's go to the point. Assuming that file I would like to be able to > issue a command on the command line and be able to see the portfolio in USD > or EUR at the present time value. I can query most of the coins using a pip > package, the question is, how I do that? I have read the "Prices in > Beancount" [1] google docs file, however there is no example and it would > be very useful to grasp a bit better how everything ties up. Is there any > example of fetcher module so I can build mine on top of it? Or if you are > aware of any module for prices that works with crypto that I could use out > of the box it would be even better. > > Please note that each coin might be on an exchange account or in a wallet > (account1 or account2). I would like to get the overview of this sum, for > instance when I refer to "ETH" I would like to see as it appears on the > balance, but at the current USD or EUR price, and so for the other > currencies. > > From what I understood about the prices document, the prices will be > fetched and saved on the beancount file automatically. I would like to do > this automatically on a weekly basis, so I guess cron is my friend here. I > guess it is wise to use a separated file and link them together somehow. > > I would also like (if possible) to have this on a web interface like fava > or similar if possible. I guess this might work automatically once the > prices are correctly fetched. > > Could you please point me into the right directions to get all these > things working properly? > > Thank you very much. > > [1]: > https://docs.google.com/document/d/1thYRAMell_QT1Da1F_laprSs6BlROZjyK_h3V8qHW9c/edit > -- 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/91101592-cfd2-4e70-8622-8357474f31a5%40googlegroups.com.
