Re: Cryptocurrencies transactions that are exchanges (cost basis)

2024-03-17 Thread CD
Another question on your two examples... If it's set to FIFO... What if you have multiple Assets accounts for ETH? For example - if you had 100 ETH in Assets:Coinbase:ETH and another 100 ETH in Assets:BItstamp:ETH would the transactions below still pull FIFO from both of those accounts or

Re: How to get last day of month in BQL

2024-03-17 Thread Andreas Gerstmayr
Hi! I'm trying to get a report of the market value of my assets at the end of each month:     SELECT year, month,     CONVERT(LAST(balance),   'USD', DATE_ADD(DATE(year, month+1, 1), -1)) AS market_value,     CONVERT(COST(LAST(balance)), 'USD', DATE_ADD(DATE(year, month+1, 1), -1))

How to get last day of month in BQL

2024-03-17 Thread Andreas Gerstmayr
Hi! I'm trying to get a report of the market value of my assets at the end of each month: SELECT year, month, CONVERT(LAST(balance), 'USD', DATE_ADD(DATE(year, month+1, 1), -1)) AS market_value, CONVERT(COST(LAST(balance)), 'USD', DATE_ADD(DATE(year, month+1, 1), -1)) AS

Re: Cryptocurrencies transactions that are exchanges (cost basis)

2024-03-17 Thread Eric Altendorf
TLDR: it's a hack to try to get beancount to carry cost basis along if that position is ever transferred to another account. There have been a bunch of discussions about this and to be honest, I'm not 100% confident in the current state of affairs. In general, beancount is not very reliable

Re: Cryptocurrencies transactions that are exchanges (cost basis)

2024-03-17 Thread CD
Thank you for this. I figured out the USD price importing (I downloaded price histories from Yahoo and put them all in a folder that my script references) but I am not clear on what the empty {} does I understand if I want to book the price I purchased at in the database I want to use