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
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))
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
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
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