Re: Rounding in the price db.
> On Aug 17, 2015, at 8:07 PM, Mike Alexander wrote: > >> On Aug 17, 2015, at 5:36 AM, John Ralls wrote: >> >> >>> On Aug 12, 2015, at 2:13 PM, John Ralls wrote: >>> It might help to consider what the price db is used for: Aside from >>> providing a default rate in the transfer dialog, it’s used for pricing >>> assets in the Accounts page and the summary bar — only the latest entry is >>> used there. It’s used for calculating values in reports, where the reports >>> can use a weighted average, nearest in time, most recent, or average cost. >>> I need to look to see if the average cost actually looks at the buy >>> transactions or if it does something similar to nearest in time and at >>> weighted average to see what it’s averaging and how it’s weighting the >>> averaged values. Depending on what those two are doing might drive whether >>> multiple F::Q entries per day make sense, assuming that the algorithms make >>> sense. >> >> OK, I’ve looked. They don’t use the price db, which is what one would >> expect. Weighted-average is weighted by the transaction size, which will be >> distorted by stock splits but is otherwise OK. > > The Advanced Portfolio report uses the Price DB to get the current value of a > holding. There is an option to use a transaction price instead, but the > default is to use the Price DB. The only Price DB options it supports are > "latest" and "nearest in time". If you ask it to use a transaction price (or > if it can't find a price in the Price DB) it uses the most recent transaction > which defines a price that can be converted to the report's currency. > > I can't speak for other reports. I'm out of town and don't have easy access > to the source code. I was referring only to the “average” and “weighted average” options provided by price-quotes.scm and really only concerned about whether or not they would affect or be affected by mods to what we store in the price db. I don’t think they will, so I’ll proceed with what we’ve discussed already. Regards, John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: Rounding in the price db.
> On Aug 17, 2015, at 5:36 AM, John Ralls wrote: > > >> On Aug 12, 2015, at 2:13 PM, John Ralls wrote: >> It might help to consider what the price db is used for: Aside from >> providing a default rate in the transfer dialog, it’s used for pricing >> assets in the Accounts page and the summary bar — only the latest entry is >> used there. It’s used for calculating values in reports, where the reports >> can use a weighted average, nearest in time, most recent, or average cost. I >> need to look to see if the average cost actually looks at the buy >> transactions or if it does something similar to nearest in time and at >> weighted average to see what it’s averaging and how it’s weighting the >> averaged values. Depending on what those two are doing might drive whether >> multiple F::Q entries per day make sense, assuming that the algorithms make >> sense. > > OK, I’ve looked. They don’t use the price db, which is what one would expect. > Weighted-average is weighted by the transaction size, which will be distorted > by stock splits but is otherwise OK. The Advanced Portfolio report uses the Price DB to get the current value of a holding. There is an option to use a transaction price instead, but the default is to use the Price DB. The only Price DB options it supports are "latest" and "nearest in time". If you ask it to use a transaction price (or if it can't find a price in the Price DB) it uses the most recent transaction which defines a price that can be converted to the report's currency. I can't speak for other reports. I'm out of town and don't have easy access to the source code. Mike ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
calc2qif hack of oDialog.Execute()
after some experimentation here is a hack that loads alc2qif into the main menu file open calc2qif.sxc change line 147 of Calc2qif. Standard. Install. install_en from oDialog.Execute() to oDialog.endExecute() and run macro install_en it at least runs Ok No time to rewrite the GUI using the GUI editor and re-use appropriate macros exercise left to readers My squid bank doesn't save qif files longer than 12 months so I have to cut & paste into lebreoffice 4.1.1 tedc From: gnucash-devel on behalf of John Ralls Sent: Monday, August 17, 2015 9:29 AM To: wwhk10 Cc: gnucash-devel@gnucash.org Subject: Re: report guid > On Aug 17, 2015, at 4:23 PM, wwhk10 wrote: > > Hi. > > I am trying to add a report and read in the documentation that each report > needs a unique ID. How can I run gnucash-make-guids or uuidgen? I am using > the Windows version. > > I did a search but cannot find these commands. Google turns up many web-based uuid generators. You can use any of them. Just remove the ‘-‘ chanracters from the result after you paste it in to your custom report. Regards, John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: report guid
> On Aug 17, 2015, at 4:23 PM, wwhk10 wrote: > > Hi. > > I am trying to add a report and read in the documentation that each report > needs a unique ID. How can I run gnucash-make-guids or uuidgen? I am using > the Windows version. > > I did a search but cannot find these commands. Google turns up many web-based uuid generators. You can use any of them. Just remove the ‘-‘ chanracters from the result after you paste it in to your custom report. Regards, John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: report guid
Hi. I am trying to add a report and read in the documentation that each report needs a unique ID. How can I run gnucash-make-guids or uuidgen? I am using the Windows version. I did a search but cannot find these commands. Thanks. Wendy Wong -- View this message in context: http://gnucash.1415818.n4.nabble.com/report-guid-tp1444806p4680007.html Sent from the GnuCash - Dev mailing list archive at Nabble.com. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: Rounding in the price db.
> On Aug 12, 2015, at 2:13 PM, John Ralls wrote: > It might help to consider what the price db is used for: Aside from providing > a default rate in the transfer dialog, it’s used for pricing assets in the > Accounts page and the summary bar — only the latest entry is used there. It’s > used for calculating values in reports, where the reports can use a weighted > average, nearest in time, most recent, or average cost. I need to look to see > if the average cost actually looks at the buy transactions or if it does > something similar to nearest in time and at weighted average to see what it’s > averaging and how it’s weighting the averaged values. Depending on what those > two are doing might drive whether multiple F::Q entries per day make sense, > assuming that the algorithms make sense. OK, I’ve looked. They don’t use the price db, which is what one would expect. Weighted-average is weighted by the transaction size, which will be distorted by stock splits but is otherwise OK. Regards, John Ralls ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel