Re: [GNC] Finance::Quote started multiplying prices by 100

2024-09-19 Thread Bruce Schuck
On 9/19/24 8:06 AM, aeg wrote: Perhaps I should have mentioned in my original post that I had previously been downloading quotes on my old laptop, which is running GnuCash version 4.12 on Windows 10 with Finance::Quote version 1.5301 installed, so presumably something has changed since those v

Re: [GNC] Finance::Quote started multiplying prices by 100

2024-09-19 Thread aeg via gnucash-user
Hi Bruce, While using F::Q version 1.5301, the quoted prices always matched the figures obtained elsewhere, and GnuCash displayed those figures in GB Pounds, so all was well. It was only when I transferred my GC file to the computer running GC version 5.4 and F::Q version 1.62 that I started to

Re: [GNC] Database storage

2024-09-19 Thread Roberts K
Blast from the past, Yes, I do remember when 200mb hard drive was quite big harddrive to buy in the shop. I was fairly young man then :-D. But W541 is pretty sweet machine. I run linux on P70 and do not foresee the need to change it anytime soon. Roberts > Now this Lenovo work station I am sitti

Re: [GNC] How to treat a sale which involves more accounts?

2024-09-19 Thread Boniforti Flavio
Hi David and David :-) Thanks for your replies. I'm not running any business at all. I am a musician who also collects (vintage) music instruments. As I also do play them, it happens a couple of times a year that I'm not interested anymore in keeping one or the other instrument. For this reason, I

Re: [GNC] Database storage

2024-09-19 Thread Steve Butler
My first job out of college had a Honeywell 115 Mod 2 box. Hard drive (singular) was 10 MB. RAM was 32K of magnetic core. 6 bit CPU and 7 track 556 bpi tape (3 of them). Thought we were going to heaven when it was replaced by an HP 3000 with 7 hard drives of 47 MB each and 512 KB memory. The p

Re: [GNC] dollar signs in reports

2024-09-19 Thread Murugan Mariappan
You cannot remove the sign altogether. Can you explain the use case Saludos Cordiales Murugan From: gnucash-user on behalf of Ian D Henry Sent: 19 September 2024 20:44 To: gnucash-user@gnucash.org Subject: [GNC] dollar signs in reports I would like to

Re: [GNC] Database storage

2024-09-19 Thread Bruce Griffis
Slightly off topic. In my earliest working days we had a Honeywell mainframe, were bringing in an IBM mainframe and had a Tandem system for airline reservations. The Tandem wrote to two different disks at the same time so if there was ever a failure, no data would be lost. One day I came in and

Re: [GNC] Credit cards - how to deal with those?

2024-09-19 Thread Boniforti Flavio
Hi and thanks for your replies. I've gone through the tutorial chapter 7 and I think it's much clearer now. I'll try setting up the corresponding accounts and playing with them a bit to understand. Many thanks, F. https://www.instagram.com/boniforti_music https://soundcloud.com/boniforti_music ht

Re: [GNC] How to treat a sale which involves more accounts?

2024-09-19 Thread David Cousens
Flavio, > I would do the following when selling something for 120 which I bought for 100: > 1. increase the checking account by 120; > 2. increase the "Income:Sales" account by 120; > 3. increase the "Inventory:Music Equipment Sales" account by 120; > 4. decrease the "Expenses:Cost of Goods Sold"

Re: [GNC] Database storage

2024-09-19 Thread Kalpesh Patel
Anyone remembers Commodore PET and C64? 64MB or less of core and of course big whopping modern 3.5 inch 1.44MB floppy drives? load "asteroid",8,1 -Original Message- From: Roberts K Sent: Thursday, September 19, 2024 3:18 PM To: stepbystepf...@comcast.net Cc: gnucash-user@gnucash.org

[GNC] dollar signs in reports

2024-09-19 Thread Ian D Henry
I would like to suppress the dollar sign in my income statement and balance sheet. How can I do that? -- Ian D Henry ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash

Re: [GNC] Finance::Quote started multiplying prices by 100

2024-09-19 Thread aeg via gnucash-user
Hi Geoff, Thank you for following up on this. Please see the attached screenshot example. Regards,AlanG On Wednesday 18 September 2024 at 10:28:59 BST, gnucash-user-requ...@gnucash.org wrote: Date: Wed, 18 Sep 2024 19:27:01 +1000 From: Geoff Hi Alan Can you please show us the stock in

Re: [GNC] Finance::Quote started multiplying prices by 100

2024-09-19 Thread aeg via gnucash-user
Martin, Geoff, Bruce, Thank you very much for your help with this. I'm pleased to report that it now works as expected, having added an X to the symbol as suggested. Perhaps I should have mentioned in my original post that I had previously been downloading quotes on my old laptop, which is runni

Re: [GNC] Database storage

2024-09-19 Thread Roberts K
In my experience the amount of data is relatively small (even for thousands of records) and database performs well in XML form. As other people have said - it is copied into memory, So not much use putting it on proper RDBMS. I remember when I used it on MySQL over 100Mb connection on LAN (or even

Re: [GNC] Finance::Quote started multiplying prices by 100

2024-09-19 Thread Bruce Schuck
On 9/19/24 6:46 AM, Martin Booth wrote: Downloading UK traded stock from Alphavantage you need to add an 'X' to the symbol like CNA.L.X your prices will now be pounds. Correct, I added the code to do this in AlphaVantage.pm last July. The comment in the source code explains the issue. J

Re: [GNC] Database storage

2024-09-19 Thread Michael or Penny Novack via gnucash-user
However the behavior of autosave is a pet peeve of mine. The behavior I would like to see is for gnucash to have two states, "not in the middle of entering a transaction" an "in the middle of entering a transaction"  I want autosave to pop up only when in the first state (if the timer goes off

Re: [GNC] Credit cards - how to deal with those?

2024-09-19 Thread R Losey
The other account is what you purchased... usually an expense category. Food? Dining? Clothing? Entertainment? It depends upon the expense accounts you have set up, but it should answer the question "what did you use your credit card to buy?" On Wed, Sep 18, 2024 at 5:08 PM Boniforti Flavio wro

Re: [GNC] Finance::Quote started multiplying prices by 100

2024-09-19 Thread Kalpesh Patel
Looks like that change took place in Version 1.58 Release back on Aug 12, 2023 where '.X' denotes scaling in effect for alphavantage. See https://github.com/finance-quote/finance-quote/releases/tag/v1.58 As a side note, Alphavantage has really tighten up ability to pull free quotes from their A

Re: [GNC] Database storage

2024-09-19 Thread R Losey
On Wed, Sep 18, 2024 at 8:54 PM Chris Miller via gnucash-user < gnucash-user@gnucash.org> wrote: > > It should be noted: GnuCash does *not* do database queries as it > processes > > transactions. > Well, that's disappointing ... and definitive. > > If this content is stored as flat XML, then I wou

Re: [GNC] Can't open saved .gnucash file

2024-09-19 Thread John Ralls
It looks like you left a report open and the option string saved in your state file has a bad value. The state file has the same name as your .gnucash file with a .gcm extension tacked on (i.e. “my-book.gnucash.gcm”) and is located in GNC_DATA_HOME/books (see https://wiki.gnucash.org/wiki/Confi

Re: [GNC] Can't open saved .gnucash file

2024-09-19 Thread Ed Reeder
Thanks! It also looks like it is also a case of RTFM. https://lists.gnucash.org/docs/C/gnucash-guide/basics-backup1.html Looks like this would be another way to recover. Thanks so much for your detailed explanation. /Ed On Thu, Sep 19, 2024, at 10:12 AM, John Ralls wrote: > It looks like you l

[GNC] Can't open saved .gnucash file

2024-09-19 Thread Chris Raesz via gnucash-user
I recently had a desktop meltdown but I had my data backed up. I am using Linux and gnucash version GnuCash 5.8, Build ID: 5.8+(2024-07-06) When I try to open it, I get a message stating some other user has the file locked. When I tell it to open read-only or open anyway, it crashes. My comman

Re: [GNC] Database storage

2024-09-19 Thread Robert Heller
At Thu, 19 Sep 2024 07:32:05 -0700 "Stan Brown (using GC 4.14)" wrote: > > On 2024-09-18 18:54, Jim DeLaHunt wrote: > > In other words, if you have GnuCash store data in a database, GnuCash > > reads all its data out of the database when it starts, and writes all > > the data back when it stops.

Re: [GNC] Database storage

2024-09-19 Thread Stan Brown (using GC 4.14)
On 2024-09-18 18:54, Jim DeLaHunt wrote: > In other words, if you have GnuCash store data in a database, GnuCash > reads all its data out of the database when it starts, and writes all > the data back when it stops. It does not write and commit each > transaction as it goes. That's true. However,

Re: [GNC] Database storage

2024-09-19 Thread Chris Miller via gnucash-user
Hi Roberts, > I found the best of both worlds is to use SQLite backend - because it is > fastest and most portable - you just need to copy the file. It allows me to > run quite complex reports from R using standard SQL approach. Even more - I > made some bash scripts with SQL queries utilizing re

Re: [GNC] Database storage

2024-09-19 Thread Michael or Penny Novack via gnucash-user
On 9/19/2024 11:16 AM, Roberts K wrote: In my experience the amount of data is relatively small (even for thousands of records) A bit of historical perspective is needed, particularly because our heads have not yet absorbed a fundamental change in technology. Back in my working days, the IBM

Re: [GNC] Credit cards - how to deal with those?

2024-09-19 Thread Ian Pilcher
On 9/18/24 4:56 PM, fromvendor wrote: Each transaction goes into the account appropriate for the card in question. When I get the statement (download, however), I reconcile the card and match up receipts. Once that is done, I "Pay" the card (check, EFT, however) from my bank account. That redu

Re: [GNC] Finance::Quote started multiplying prices by 100

2024-09-19 Thread Martin Booth via gnucash-user
Downloading UK traded stock from Alphavantage you need to add an 'X' to the symbol like CNA.L.X your prices will now be pounds. On Thursday 19 September 2024 at 13:05:05 BST, Geoff wrote: Hi Alan & Bruce Alan: I believe the cause of this problem is that CNA is quoted in Pence on the

Re: [GNC] Monthly Reports

2024-09-19 Thread Phyllis Bruce
NMichael, you may not be aware that your responses are not going to the group. The proper address is gnucash-user@gnucash.org. I had also forgotten the dash. Now to your last comments. As I stated earlier, there are times - not always - when it seems appropriate to me to detail the costs to a s

Re: [GNC] Can't open saved .gnucash file

2024-09-19 Thread Chris Raesz via gnucash-user
That sort of worked. I got the same error message after deleting that report, but it let me open it anyway. After that, I created the deleted report and closed it down. When I restarted Gnucash, no issues. Thanks very much. chris. On 9/19/24 12:12, John Ralls wrote: It looks like you left a