GNOME Bugzilla – Bug 638500
Average Balance Report: Nearest in Time prices don't work correctly (See comment 3)
Last modified: 2018-06-29 22:50:37 UTC
The documentation explains how to modify a Stock Value Report but it does not indicate where to *find* or *create* the Stock Value Report. Clicking on the Reports drop-down menu does not contain a line for "Stock Value Reports" or "Assets Over Time" when starting from the main Accounts screen or from an individual Account Register screen. Based on the sample picture "GuideInvestExample - Assets Over Time" one would assume that it was necessary to begin from an Account Register screen, but that is not specified in the documentation. I have looked high and low to find a way to generate this report but have come up empty. Could somebody please tell me how to do this?! I have 15 Mutual Fund investment accounts that I need to be able to track over time.
You're not going to find it. Stock tracking isn't something that Gnucash does, sorry. It's not an unreasonable request, so I'll change it to an enhancement request and see if anyone picks it up in the next few months (after which it will be closed if it's not picked up).
> Hi John, > I'm so confused. In the documentation section "Making Stock Value Reports" it > shows a chart "Amazon Over Time" I just want to know how to make that chart. > The documentation doesn't give me a starting point. I don't understand how this > would be and enhancement request. > Don Please use Bugzilla for all communications about the ticket. Ah, OK, I found it. It's a demonstration of customizing a report, but it needs a bit of fleshing out. Start with Reports>Assets & Liabilities>Average Balance Once the report opens, click on the Options button on the toolbar. A dialog box will open with the tabs Accounts, Display, and General. On the General tab, change the Report Name to "Assets Over Time". Select the dates or predefined period that you want to cover, the step size, and for Price Source select "Nearest in Time". On the display tab select "Average" (the default). If you have only one price entry per step you'll get that value, otherwise you'll get an average over the step. On the Accounts tab navigate to and select the asset (mutual fund in your case) that you want to chart. In reality, you'll want to name the report for each fund individually so that you can save each one (once you change the name to something unique you can save the report description). You might also be interested in Price Scatterplot in the same menu. Thanks for pointing this out. I hadn't noticed this report before, and I'll find it useful.
On Jan 9, 2011, at 4:28 AM, Don Butterworth wrote: >Thanks for walking me through these steps, John. I can now duplicate the look >of the chart found in the documentation. Now I'm thinking that there is a bug. > >I have successfully used the Price editor to retrieve quotes for the mutual >funds in my portfolio. I am planning to do this on a weekly basis. Here is an >example. >USD (US Dollar) 01/07/2011 Finance::Quote last 58.010000 >USD (US Dollar) 01/01/2011 Finance::Quote last 58.150000 >This represents a slight loss for the fund over the 7 day period. > >Using the steps outlined I created a chart with a start date of "Start of this >Year" an end date "Today" and a step size "Day". In the Accounts tab I >selected the specific fund. On the display tab I also checked "Show Table" The >Table displays a line entry for each daily transaction ... but all the lines >are identical! Example: >Period Start Period End Average Maximum Minimum Gain Loss Profit >01/01/2011 01/01/2011 13,434.28 13,434.28 13,434.28 0.00 0.00 0.00 >01/07/2011 01/01/2011 13,434.28 13,434.28 13,434.28 0.00 0.00 0.00 > >As you can see the report is not being "calculated based on the nearest >available price in the price editor" as the documentation says it should. > >Changing topics, I am still not clear about the right way to save a report. >With the report setup window displaying, I went to File>Save Report and the >report was saved in ...\.gnucash\saved-reports-2.4. How am I supposed to >retrieve it so I can use it again? It doesn't appear anywhere in the Reports >pull down menu and clicking on File > Open > ... > Saved-Reports-2.4 doesn't >display it. What I want to be able to do is have that report appear in the >Reports pull down menu, preferably when the specific fund account register >window is active, so I can run it on a regular basis but not be required to >recreate it every single time. > >Finally Price Scatterplot looks intreaguing but when I click on it the screen >says, "Identical commodities ..." with a null result. Clicking on the Options >icon doesn't give categories where I can specify a specific fund. So I am not >sure how to use it. > >Thanks for all your help! > >Don I do agree that the "nearest in time" setting on the report is producing incorrect results, and I've changed the summary line accordingly so that you don't need to file a new bug. You can find the saved report by selecting Reports>Custom Reports. A dialog box will appear giving you a list of your saved reports and the option to run or delete the selected report. On the price scatter plot, select the Price tab and the Select button on the line "Price of Commodity". A commodity selection dialog box will appear from which you can select a commodity (e.g., a fund) in your portfolio. Remember, don't reply to the email you get with a transcript of this comment: Click on the link to the bug in that email to open it in your browser and post a followup comment on the web page.
*** This bug has been marked as a duplicate of bug 720490 ***
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=638500. Please update any external references or bookmarks.