Reporting

[Charles Day]

On Wed, Jun 11, 2008 at 6:31 AM, Daniel Carrera <daniel.carrera at zmsl.com>
wrote:

> Hello,
>
> I would like to confirm that the Net Worth bar chart and other reports
> actually do what I think they should. I have multiple currencies and
> soon I'll start buying some stocks. I want to confirm that the reported
> value of my assets and liabilities for each month reflects the price of
> the currency (or stock) for that month. In other words:
>
> Suppose I have 1000 CAD and 1000 GBP and my reporting currency is CAD.
> In April the exchange rate is 1.9 CAD equals 1 GBP. In May it is 2 CAD
> equals 1 GBP. I would expect that the net worth chart should tell me
> that in April I had $2900 CAD and in May I had $3000 CAD. So the "asset"
> bar would be a little higher in May than in April (assuming nothing else
> changed).
>
> Is this how the reporting tools work?
>

I played with this a bit today. If you have the necessary prices available
in the price editor and choose "nearest in time" as your price source, then
yes, it appears works the way it ought to (or close). For each bar it seems
to use the price in effect at the end of the month (or the closest
available). Mind you, I only tested briefly and I haven't looked at the
code.

On the other hand, if you pick "Most Recent" or "Weighted Average" then one
price is applied everywhere. So these seem to me to be completely
inappropriate options. I think they should be removed.

Adding a "nearest in register" option might be good. This would find the
most recent exchange recorded prior to each month's end and use that price
when computing the net worth for that month. This would at least allow the
report to run somewhat reasonably in the absence of Price Editor entries.

Regarding stocks vs. currencies, I assume they are treated exactly the same.
Black boxes with an exchange rate to the reporting currency.

-Charles

Similarly, if in June I buy stock XYZ for $1000 and in July it is worth
> $1050, will this difference be reflected in the chart? In other words,
> all other things being equal, the asset bar should be $50 bigger in July
> than in June. Is this correct?
>
> Thanks.
>
> Cheers,
> Daniel.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>