thank you for reply,
"If you're seeing a problem case, would you mind opening a bug in the repo
with a demo example?"
- opened the issue https://github.com/beancount/beangrow/issues/12
"The latter is exactly what I do for now: simply include
"Assets:Investing:CSchwab:Cash" as a commodity, and it'll show up with very
low returns."
- could you please share your config file for this cash account?
I can't seem to make it work with currency same as my main currency (USD).
Or do you use separate currency/commodity just for that account?
I tried
"investments {
investment {
currency: "USD"
asset_account: "Assets:Investing:CSchwab:Cash"
cash_accounts: "Assets:Cash"
}
}
groups {
group {
name: "CSchwabCash"
investment: "Assets:Investing:CSchwab:Cash"
}
}"
and
"investments {
investment {
currency: "USD"
asset_account: "Assets:Investing:CSchwab:Cash"
cash_accounts: "Assets:Cash"
}
}
groups {
group {
name: "CSchwabCash"
investment: "Assets:Investing:CSchwab:Cash"
currency: "USD"
}
}"
But i am getting error
"R:\b\b-office>python beangrow/compute_returns.py -e 2021-09-01 b.beancount
conf-returns returns
R:\b\b-office\beangrow\returns.py:63: RuntimeWarning: invalid value
encountered in power
return np.sum(cash_flows / (1. + irr) ** years)
R:\b\b-office\beangrow\returns.py:63: RuntimeWarning: invalid value
encountered in power
return np.sum(cash_flows / (1. + irr) ** years)
Traceback (most recent call last):
File "beangrow/compute_returns.py", line 105, in <module>
main()
File "beangrow/compute_returns.py", line 94, in main
reports.generate_price_pages(account_data_map,
File "R:\b\b-office\beangrow\reports.py", line 528, in
generate_price_pages
all_prices = prices.get_all_prices(price_map, base_quote)
File
"C:\Users\Btycoon\AppData\Local\Programs\Python\Python38\lib\site-packages\beancount\core\prices.py",
line 303, in get_all_prices
return _lookup_price_and_inverse(price_map, base_quote)
File
"C:\Users\Btycoon\AppData\Local\Programs\Python\Python38\lib\site-packages\beancount\core\prices.py",
line 278, in _lookup_price_and_inverse
return price_map[base_quote]
KeyError: ('USD', 'USD')"
On Monday, September 13, 2021 at 11:15:15 PM UTC-4 [email protected] wrote:
> On Monday, September 13, 2021 at 5:12:30 PM UTC-7 Bman Q wrote:
>
>> I have couple of additional questions on bean grow set-up:
>> 1. configure.py seems to ignore closed accounts, is it how it supposed to
>> work?
>> (usually for strictness i was closing accounts after i exited/sold
>> position, example: "2020-10-06 close Assets:Investing:CSchwab:RDFN")
>>
>
> Hmm, it shouldn't: see this line and comment
> <https://github.com/beancount/beangrow/blob/49bf41539cbb4fcee3c2034ce419ab507b3860bf/beangrow/configure.py#L37>and
>
> its code:
>
> """Return a list of account names from the balance sheet which either
> aren't
> closed or are closed now but were still open at the given start date. """
>
> If you're seeing a problem case, would you mind opening a bug in the repo
> with a demo example?
>
>
> 2. "Including Uninvested Cash"
>> Do i understand it right that the easiest way to account for uninvested
>> cash is to create
>> -commodity "IDDLEUSD"
>> -account Assets:Investing:IDDLEUSD
>> buy IDDLEUSD for all cash (USD) that i can invest at rate 1:1,
>> and then at each interval i do reports "price IDDLEUSD 1 USD",
>> and when i want to buy smng sell IDDLEUSD for USD, and buy what i want.
>> ?
>>
>> OR is there a way to make my investment cash accounts
>> "Assets:Investing:CSchwab:Cash", etc to be counted as investment (with 0
>> return) ?
>>
>
> The latter is exactly what I do for now: simply include
> "Assets:Investing:CSchwab:Cash" as a commodity, and it'll show up with very
> low returns.
>
> However, for me, this means that cash in other parts of the hierarchy
> (example: banks, paypal, etc.) are not counted. AFAIK, beangrow does not
> offer a global solution for this. See "Including Uninvested Cash" in Martin's
> doc
> <https://docs.google.com/document/d/1nPsMIunLnDvdsg6TSsd0PZb7jngojNpFlqnaX36WRp8/edit#>
> .
>
> Not really an analysis solution, but as a strategy, I personally use
> fava_investor <https://github.com/redstreet/fava_investor> to monitor
> uninvested cash.
>
>
> 3. Is there recommended time frame for "price" quotes?
>> Usually i open positions for 3-5 years, so not interested in daily or
>> even monthly fluctuations.
>> Do i understand it right that if i use
>> -"plugin "beancount.plugins.implicit_prices"" (to get price from buy/sell
>> transactions)
>> -price my investments on 1st of each Quarter
>> -run compute_returns.py with -e DATE = 1st of each Quarter (basically
>> same cut off as date of last price quote)
>> then i will be fine and won't need any more price quotes
>> ?
>>
>
> After including the implicit_prices plugin, and running beangrow once, you
> will want to run:
> beangrow/beangrow/download_prices_from_file.py
> <your_returns_output_dir>/prices/prices.beancount
>
> and include the resulting price database in your source, and re-reun
> beangrow. Without that, beangrow uses the price values on the closest dates
> it can find, which in your case could be weeks or months off, which means
> your returns numbers will be off.
>
> The file generated above provides the only dates on which the prices
> matter to beangrow for your configuration. These are the start and end
> dates of your cashflow. Meaning, period opening and closing dates, and
> dates on which you bought/sold, IIRC. More detail here
> <https://github.com/beancount/beangrow/issues/7>.
>
> Enjoy!
>
>
--
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/8760c9c7-6259-4921-a95f-e60dfd1611c6n%40googlegroups.com.
