Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

2022-05-05 Thread David T. via gnucash-user
If it's typing characters that has you bothered, rename "building.gnucash" "bldg.xgc", and associate xgc with GnuCash in your OS (xgc appears to only be used by one gaming platform). You'll save hundreds of keystrokes... On May 5, 2022 4:09:17 AM EDT, Chris Green wrote: >On Wed, May 04, 202

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

2022-05-09 Thread David T. via gnucash-user
>good with computers and the list of dependencies looks daunting to me.  Thank >you for your suggestions none the less. > >On 3/25/22 4:25 AM, David T. via gnucash-user wrote: >> I think it would be helpful to know a bit more about the versions of Gnucash >> on the

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread David T. via gnucash-user
Fred, To answer this question, the security editor screen can be configured to show both the Get Quotes toggle, as well as the price source. Resizing the default tiny screen bigger will show you the drop down button on the far right, which includes a number of fields for display. For the rec

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread David T. via gnucash-user
Adrien, Your experience suggests the Alphavantage throttle I mentioned in my post. I seem to recall that being an issue specifically with currencies on that source. David On May 9, 2022 12:45:04 PM EDT, Adrien Monteleone wrote: >Fred, > >See my reply in your 'Hang' thread. > >As soon as I g

Re: [GNC] List of securities with Get Online Quotes

2022-05-09 Thread David T. via gnucash-user
Your reply strongly suggests that you were getting throttled by Alphavantage retrieval limits. The fact that one Alphavantage quote was quick, but 10 took much longer supports my hypothesis. The fact that yahoo_json appears to have fixed the time lag also supports it. On May 9, 2022 2:12:07 PM

Re: [GNC] List of securities with Get Online Quotes

2022-05-10 Thread David T. via gnucash-user
::Q. > >Regards, >Adrien > >On 5/9/22 9:49 PM, David T. via gnucash-user wrote: >> Your reply strongly suggests that you were getting throttled by Alphavantage >> retrieval limits. The fact that one Alphavantage quote was quick, but 10 >> took much longer supports my

Re: [GNC] Reconcile Finish button

2022-05-11 Thread David T. via gnucash-user
I haven't tested this today, but my recollection is that the Finish button is inactive until the difference is zero. In older versions of Gnucash, this difference was clearer, but more recent gui toolkits seem to have altered how it looks, so that it isn't as obvious. My point in mentioning th

Re: [GNC] Reconcile Finish button

2022-05-11 Thread David T. via gnucash-user
gt;me so much that I will just leave it a mess. > >One of the buttons that change is the delete line/transaction button. > >I would ask for a developer to make the program behavior generally more >consistent, naming as many examples of inconsistency as possible. > >On Wed, May

Re: [GNC] Documentation changes needed

2022-05-11 Thread David T. via gnucash-user
her example that demonstrates why I gave up trying to >> help manage the documentation: the fact that when push comes to shove, it's >> Frank's way that holds final sway on how the documentation turns out. I >> thank you, Frank, for reminding me of that. I'll drop out

Re: [GNC] unrealized gain / losses for mutual funds

2022-05-18 Thread David T. via gnucash-user
A couple of points here: First, the analogy of a painting's unrealized gains to those of any other asset is perfectly valid. The only difference is that there is only one "share" of the painting, while there are many shares of a stock or mutual fund. Their change in value is going to be the unr

Re: [GNC] unrealized gain / losses for mutual funds

2022-05-18 Thread David T. via gnucash-user
I know what NFT stands for; I don't see how they have any effect on the concept of gains. You buy something at one price. You sell it at a different price. The difference is your gain (loss). Whether it's a painting, a stock, an NFT, or a parcel of land doesn't affect the idea of a gain. And w

Re: [GNC] Ctrl-G Go to Date

2022-05-21 Thread David T. via gnucash-user
If you copy the last date (Ctrl-C), you can paste it in. It's not Ctrl-G, but it *is* Ctrl-V... On May 21, 2022 7:06:24 PM EDT, Fred Tydeman wrote: >It appears that when I do Ctrl-G Go to Date, >that today's date is automatically filled in. >Is there a way to have it use the last date I entered?

Re: [GNC] error when I try to save in MySQL or sqlite3

2022-05-28 Thread David T. via gnucash-user
Gustavo, The image didn't come through, and you didn't give the version of Gnucash you're using, but the mail client tag line suggests that you are on Windows, and I'll assume it's a recent version of Gnucash. Most likely, you're using the standard download of Gnucash for Windows, which I bel

Re: [GNC] error when I try to save in MySQL or sqlite3

2022-05-28 Thread David T. via gnucash-user
Oh. Okay. Thanks for the correction. On May 28, 2022 10:42:43 AM EDT, John Ralls wrote: >You are mistaken. The Windows bundle includes everything necessary to connect >to Postgres and MySQL. > >Regards, >John Ralls > > >> On May 28, 2022, at 5:17 AM, David T.

Re: [GNC] error when I try to save in MySQL or sqlite3

2022-05-28 Thread David T. via gnucash-user
I guess the wiki page that suggests that sql drivers might not be available for Windows could be updated... On May 28, 2022 2:44:14 PM EDT, "David T. via gnucash-user" wrote: >Oh. Okay. Thanks for the correction. > >On May 28, 2022 10:42:43 AM EDT, John Ralls wrote: >

[GNC] Program suddenly very slow

2022-05-31 Thread David T. via gnucash-user
Hello, I'm a long time user, running 4.10 on Windows 10. All of a sudden, I am finding significant lag (2-4 seconds) on every action I take, whether it is changing a field or entering a transaction. I've tried killing all other applications and rebooting, but the lag remains. Has anyone else

Re: [GNC] Mass Reconcile

2022-06-03 Thread David T. via gnucash-user
Indeed. My rule of thumb in writing documentation (gnucash as well as others) has always been to include things that are specific to the application/product being described. Otherwise, it never ends. David T. On June 3, 2022 12:43:26 PM EDT, Adrien Monteleone wrote: >I suppose they could b

Re: [GNC] Program suddenly very slow

2022-06-03 Thread David T. via gnucash-user
recaite the insight. David T. On 5/31/2022 11:57 AM, john wrote: On May 31, 2022, at 7:59 AM, David T. via gnucash-user wrote: Hello, I'm a long time user, running 4.10 on Windows 10. All of a sudden, I am finding significant lag (2-4 seconds) on every action I take, whet

Re: [GNC] Zero price entries

2022-06-09 Thread David T. via gnucash-user
Fred, Technically, these are not price entries, which implies the PriceDB in GnuCash. They are transaction entries in a register. I am not sure whether Gyle's solution would work, since I'm not sure how you'd search for those entries; from your screenshot, it looks as if the entries have a nu

Re: [GNC] How to reorganize the account tree

2022-06-13 Thread David T. via gnucash-user
I use account codes in my file, and  like it quite a bit. You can add the Code to the Chart of Accounts (CoA) page and quickly sort on it as one would with any other displayed column. I'll note that the tree aspect of the CoA means that the sorting will still be hierarchical--that is, accounts

Re: [GNC] Entry Point Not Found error

2022-06-13 Thread David T. via gnucash-user
You might take a look at section 2.4 of the Guide, which is titled "Storing Your Financial Data." It goes into some detail about the different "back end" storage options. It certainly is unfortunate that the documentation uses two words, while the error uses one. Regardless, the problem wasn't

Re: [GNC] Online crypto value quote

2022-06-17 Thread David T. via gnucash-user
I'll note that Julie's first attachment stated that quotes were not returned for certain entries. Finance::Quote is returning that error, so it is installed. I see in Julie's attachment that her bitcoin entry is assigned to "Digital Cash". The screen shot for the Yahoo! suggests that their sit

Re: [GNC] Online crypto value quote

2022-06-18 Thread David T. via gnucash-user
[image: image.png] > >On Sat, 18 Jun 2022 at 12:54, David T. via gnucash-user < >gnucash-user@gnucash.org> wrote: > >> I'll note that Julie's first attachment stated that quotes were not >> returned for certain entries. Finance::Quote is returning that erro

Re: [GNC] rookie question Imbalance-USD

2022-06-18 Thread David T. via gnucash-user
Gyle, Whether you delete the imbalance account or not once it is empty is a user preference. Some dislike seeing the imbalance account in their books, and delete it if it is empty. Others (like myself and you) leave that account in place. I leave it because it just reappears again later anyways

Re: [GNC] rookie question Imbalance-USD

2022-06-18 Thread David T. via gnucash-user
The confusion arises when you use "entry" for both splits and transactions in the same paragraph, as you did here. On June 18, 2022 4:57:57 PM EDT, Gyle McCollam wrote: >When I say entry, I refer to the entire transaction, but I get your point. > > > >Sent from Samsung Galaxy smartphone. > > >

Re: [GNC] Direct Adjustment of Security's Price

2022-06-19 Thread David T. via gnucash-user
Chapter 11 of the Guide. On June 19, 2022 9:56:31 AM EDT, Gao Bite wrote: >GnuCash developers & Maintainers: > >    Hello! I would like to record the unrealized profit & loss from security >investment directly into an income account. Could you please tell me whether I >am possible to do as abo

Re: [GNC] rookie question Imbalance-USD

2022-06-19 Thread David T. via gnucash-user
You're welcome. You seem to have sent it with a mysterious subtext that is impossible to decipher. For the record, improperly-used terminology on this list has resulted in epic misunderstandings that confuse newcomers when they attempt to understand the complexities of both gnucash AND double

Re: [GNC] rookie question Imbalance-USD

2022-06-21 Thread David T. via gnucash-user
I agree. I apologize for responding as I did. On June 21, 2022 12:55:15 AM EDT, Liz wrote: >On Sun, 19 Jun 2022 10:57:19 -0400 >"David T. via gnucash-user" wrote: > >> I made my comment from that perspective; your snarky comment just >> underscores for me the k

Re: [GNC] Combining Method in Chapter 11 and Standalone Security

2022-06-23 Thread David T. via gnucash-user
The concept of capital gains is the same, whether you're talking about a painting or a stock. The difference between your purchase and your sale price is the gain or loss. The only trick to consider for stocks is that different lots of stock purchases can have different cost bases, which obvious

Re: [GNC] Printing Chart of Accounts WITHOUT balances

2022-07-01 Thread David T. via gnucash-user
I remember this bug. I submitted it. As noted in the bug, I found problems with the option, but was informed that it was behaving as expected. I didn't agree, but never could determine how it actually was behaving in order to explain how it ought to behave instead. That's why I marked it NOTABUG

[GNC] Updating Flatpak on Chrome book (WAS Re: GnuCash Windows Bundle 4.11-1 Released)

2022-07-03 Thread David T. via gnucash-user
Abe, It's preferable to start a new thread, honestly. You should look at https://wiki.gnucash.org/wiki/Flatpak especially the section on installation, and see whether it addresses your issue. David T. On July 3, 2022 9:25:43 AM EDT, Abe Sternberg wrote: >I'd like to take this discussion in

Re: [GNC] Transaction report

2022-07-04 Thread David T. via gnucash-user
You can either use a generic Transaction Report and set the search parameters as you need (presumably, date, account, and description). Or you can use the Account Report from the search results register. I suspect you'll have more configuration options using the former approach. David T. On J

Re: [GNC] Transaction report

2022-07-04 Thread David T. via gnucash-user
Glad that worked. The Transaction Report has a lot of tricks hidden away that can be very useful. David On July 4, 2022 12:48:27 PM EDT, rmom...@gmail.com wrote: >David, > > > >Both worked, thanks. Did not know about the account report from the search >results register. The Transaction repor

Re: [GNC] Multiple currencies

2022-07-17 Thread David T. via gnucash-user
Norbert, Further to Paul's comments: managing multiple currency accounts can be confusing at first, but it begins to make sense after a while. If your need to track funds in the alternate currency is limited to occasional transactions (for example, you go on vacation and take out a chunk of mon

[GNC] GC4.10 on Win10 Crashing

2022-07-19 Thread David T. via gnucash-user
Hello, I'm running GC4.10 on Win10, and I've been running into numerous crashes in the last few days while trying to catch up on my finances. Ironically, many of these crashes happen when I attempt to save my file. My usual workflow when catching up is to open the pdf bank statement and work

Re: [GNC] GC4.10 on Win10 Crashing

2022-07-19 Thread David T. via gnucash-user
ve a backup, or recall at what point your file didn't crash? > >Anything holding you back from 4.11? I don't see anything particularly noted >for solving a crash of this type in the release notes, but perhaps programming >fixes were made that *might* avoid this issue. >

Re: [GNC] GC4.10 on Win10 Crashing

2022-07-19 Thread David T. via gnucash-user
most >likely anyway. > >Regards, >Adrien > >On 7/19/22 1:41 PM, David T. via gnucash-user wrote: >> Adrien, >> >> Thanks for the suggestions. >> >> It would seem to me that Finish/Ctrl-S is pretty reduced. >> >> I currently have ab

Re: [GNC] Revising an old Gnucash file

2022-07-19 Thread David T. via gnucash-user
If you set an account to Hidden, it will be... hidden in the chart of accounts. Assuming that your messed up account is a catch-all account from which you hope to move transactions, I'd actually keep that account visible, and change the messed up transactions to reflect my current intention-- f

[GNC] Memory demands and system performance of Gnucash (Was Re: GC4.10 on Win10 Crashing)

2022-07-20 Thread David T. via gnucash-user
>> GnuCash without using swap space and grinding down to a crawl. Even on my >> highest performance machines it takes several seconds to save but I usually >> do it before starting any activity that will take more than a few minutes. >> >> On Tue, Jul 19, 2022 at 1:4

[GNC] Evil Lots Behavior

2022-07-20 Thread David T. via gnucash-user
Hello, In the course of catching up with my accounting, I've been working extensively with mutual fund holdings, and their buys and sells. I have found a disturbing bug in the way that the lots feature handles existing gains. Specifically, the software recalculates ALL gains in a lot the mome

Re: [GNC] Hidden accounts still visible

2022-07-20 Thread David T. via gnucash-user
You have set your view preferences to display hidden accounts. View->Filter by {Other tab} Show hidden accounts To hide an account in the drop down list, set the account to Placeholder. On July 20, 2022 4:03:40 PM GMT+03:00, Stan Brown wrote: >On 2022-07-19 23:40, David T. via gnucas

Re: [GNC] Hidden accounts still visible

2022-07-20 Thread David T. via gnucash-user
BTW, this is covered in 5.4 of the Guide. On July 20, 2022 4:57:15 PM GMT+03:00, "David T. via gnucash-user" wrote: >You have set your view preferences to display hidden accounts. View->Filter by >{Other tab} Show hidden accounts > >To hide an account in the drop d

Re: [GNC] Evil Lots Behavior

2022-07-20 Thread David T. via gnucash-user
at all. > >Important Lots tip: >Lots calculations are fully reversible - just delete all the Capital >Gains/Losses transactions it created and start matching Buys and Sells again. >Rinse and repeat. > > >Hope this helps. > >Regards > >Geoff >= > > &g

Re: [GNC] What is the intended effect of hiding an account ?

2022-07-21 Thread David T. via gnucash-user
You would be advised to read https://wiki.gnucash.org/wiki/Documentation_Improvement On July 22, 2022 12:18:37 AM GMT+03:00, Tom Browder wrote: >On Thu, Jul 21, 2022 at 15:53 David Carlson >wrote: > >> Perhaps another user misunderstood your question. John R is a major >> developer and he has

Re: [GNC] Lost 4 hours of data input

2022-07-22 Thread David T. via gnucash-user
It's too bad that the responses to "Gnucash has crashed and I lost X hours of work" are: 1. Save more often. 2. Don't use a cloud service except as an offline backup. 3. Use the db backend (which is basically a technological alternative to #1). On July 22, 2022 8:51:01 PM GMT+03:00, Phyllis

Re: [GNC] Another crash

2022-07-24 Thread David T. via gnucash-user
Phyllis, Although I haven't used the importer in recent years, I know that in the past it has been known to take a LONG time to process. Perhaps it was still working on the import when you went to Task Manager and killed the process. Also, I know that when I've been creating new accounts on t

Re: [GNC] Another crash

2022-07-24 Thread David T. via gnucash-user
A couple of additions to Adrien's information: 1) Searching using "site:lists.gnucash.org" will also include all the documentation and other gnucash resources. This may be useful, of course! But if you want *just* the list archives, use "site:lists.gnucash.org/pipermail" 2) Unfortunately, Alt-T

[GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
Hello, I'm seeking advice from the group about the best way to handle a ticker/name change for a held stock. For example, Facebook renamed itself Meta a while back, and in June they changed their ticker from FB to META. Naturally, I wish the Gnucash books to reflect these changes; I also wan

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
Thanks John. I appreciate it. On July 25, 2022 6:58:12 PM GMT+03:00, john wrote: > > >> On Jul 25, 2022, at 5:58 AM, David T. via gnucash-user >> wrote: >> >> Hello, >> >> I'm seeking advice from the group about the best way to handle a ticke

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
he GnuCash lots feature as I prefer to track lots >manual ly, so I don't know how that would fit in. > >On Mon, Jul 25, 2022, 8:00 AM David T. via gnucash-user < >gnucash-user@gnucash.org> wrote: > >> Hello, >> >> I'm seeking advice from the group a

Re: [GNC] Trading accounts

2022-07-26 Thread David T. via gnucash-user
David C. Trading accounts are not the same as lots. Different concept, different code. Just a for instance: trading accounts are turned on by book; lots can be enabled by account. David T. On July 27, 2022 3:33:37 AM GMT+03:00, David Carlson wrote: >I believe that you are witnessing first

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
The thread I started, with the title "Evil Lots Behavior" was about the Gnucash *Lots* feature, which is designed to "assist" users in the management of individual lots of stock and mutual fund shares. (For the record, the lots feature will change reconciled gains transactions without notificati

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
Geoff, Changing values of reconciled transactions without notice renders a book completely unreliable for any accounting purpose. If that's not evil, what is? David T. On July 27, 2022 2:46:34 PM GMT+03:00, Geoff wrote: >Lots. > >(And they aren't really evil, just wilful). > >;--)) > >Geoff

Re: [GNC] Stock Split - am I doing this right?

2022-07-31 Thread David T. via gnucash-user
Depending on your situation, the built in mechanisms for calculating your basis and subsequently your gain may or may not generate accurate results. The lot feature is great when it works, which for me has been about 80%of the time. But if it doesn't get the right numbers (for whatever reason)

[GNC] Random List Maintenance Question: Regarding Nabble

2022-08-01 Thread David T. via gnucash-user
Hello, Since the Nabble mirror of Gnucash lists went down (last year?) and doesn't seem to be getting up again, is it time to remove references to it on the wiki and in every message filter? TIA, David T. ___ gnucash-user mailing list gnucash-user@g

Re: [GNC] Gnu.cash user

2022-08-01 Thread David T. via gnucash-user
Adrien, Good call. Of special interest perhaps are the Asset Chart and Liabilities Chart reports, in which the user can (a) select specific accounts to include (under Assets & Liabilities, respectively), and (b) select Show Table to list the account values below. One can even (I believe) s

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-01 Thread David T. via gnucash-user
For the record, there's a Reload button on the toolbar that will... reload the current report. On August 2, 2022 6:56:17 AM GMT+03:00, davidcousen...@gmail.com wrote: > perhaps then rerun the Transaction Report. The >latter doesn't rerun automatically . You have to edit the report options and >t

Re: [GNC] Random List Maintenance Question: Regarding Nabble

2022-08-01 Thread David T. via gnucash-user
t;What filters are you referring to? > >Regards, >Adrien > >On 8/2/22 12:14 AM, David T. via gnucash-user wrote: >> Hello, >> >> Since the Nabble mirror of Gnucash lists went down (last year?) and doesn't >> seem to be getting up again, is it time to r

Re: [GNC] Gnu.cash user

2022-08-01 Thread David T. via gnucash-user
ts you want. (note, you *can* >technically select Liability accounts on an Asset Chart, and likely vice >versa, but they simply will be ignored) > >This is also a use case for a specific option to suppress the chart outright >rather than hack it by sizing constraints. > > &

Re: [GNC] Random List Maintenance Question: Regarding Nabble

2022-08-02 Thread David T. via gnucash-user
the >Wiki. > >Regards, >Adrien > >On 8/2/22 1:19 AM, David T. via gnucash-user wrote: >> "If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information." >> >> On August 2, 2022 8:26:38 AM GMT

Re: [GNC] Random List Maintenance Question: Regarding Nabble

2022-08-02 Thread David T. via gnucash-user
/. You can't edit or >submit a postfrom them but I find it helpful when following and replying a >discussion in a thread to have them open in my browser. I don't know if they >are >mentioned in the Wiki or not. > >David Cousens > > > >On Tue, 2022-08-02 at

Re: [GNC] Stumped on Mortgage Asst - Screenshots

2022-08-02 Thread David T. via gnucash-user
Steve, I expect others will give you ideas on how or what is mistaken on the mortgage assistant. I, however, am going to suggest a different approach, which is to forego using the scheduled transactions/mortgage assistant altogether, and simply enter the monthly payments manually. The rea

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread David T. via gnucash-user
I can't imagine having so many transactions that the time it took to program the process would in the end save me time in doing the accounting. My method for processing pdf statements is to open the pdf statement in one window and enter my transactions in GnuCash in another-- the old fashioned

Re: [GNC] Order of accounts, auto numbering transactions.

2022-08-09 Thread David T. via gnucash-user
To use a different sort order, assign account codes to your accounts, add the Account Codes column to the Chart of Accounts screen, and click that column header to sort on it. For further references, each of these is covered in various places in the documentation and the lists. On Aug 9, 2022,

Re: [GNC] What is the difference between Account types "Stock" and "Mutual fund"?

2022-08-13 Thread David T. via gnucash-user
And I designate ETFs as Mutual Funds... On August 14, 2022 5:44:55 AM GMT+03:00, Derek Atkins wrote: >Pretty much the only distinction is the UI labels. >-derek >Sent using my mobile device. Please excuse any typos. >On August 13, 2022 21:53:17 Jim DeLaHunt wrote: > >> Hello, folks: >> >> I am

Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

2022-08-13 Thread David T. via gnucash-user
Jim, I'll address a little of this from my non-technical, non-accountant perspective. I don't know the rationale behind those intermediate accounts, and I don't use them. That said, each investment type behaves a little differently, and perhaps separating them makes some operations easier to

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
Geoff's suggestion (to use an external automation tool) would best be placed on the Using Gnucash page (https://wiki.gnucash.org/wiki/Using_GnuCash) that Adrien suggested. Flywire suggested Piecash, which is already listed on the Published tools page. On 8/16/2022 12:05 AM, Frank H. Ellenber

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
flywire, You're crossing up threads here. Jim specifically needs to create Security entries in his GnuCash file (and has stated this on several occasions) so that he can add transactions for those securities later. Your advice regarding adding commodity transactions using csv import tools is

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
Jim, As you continue down this project, consider how you want to handle various aspects of accounting for stocks and mutual funds--particularly, how you want to manage tax-related transactions, such as dividend income, capital gains income, etc. With that many commodities, you will want to ge

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
Actually, it was clear to me. Jim's point was that if you do these steps 130 times in a row, your brain will explode. Certainly it would be nice to be able to import them. On Aug 16, 2022, 14:05, at 14:05, flywire wrote: >Obviously it wasn't clear that the post copied below identifies the >keys

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
Since there is no import option otherwise, the only choices left are to create them manually, or take the risk of editing the data file directly. Regards, Adrien On 8/16/22 2:52 AM, David T. via gnucash-user wrote: flywire, You're crossing up threads here. Jim specifically needs

[GNC] Saving a New Book doesn't allow format selection

2022-08-16 Thread David T. via gnucash-user
Hello, I was just testing something out with a new book, and when I went to save this new book, I was unable to select the storage format for the new book. I would have imagined that I would be able to tell GnuCash to use a specific format (like SQLite3) when I save a new book, but this optio

Re: [GNC] Saving a New Book doesn't allow format selection

2022-08-17 Thread David T. via gnucash-user
file. When I >created the play file I just saved my GnuCash file with a new name so I >could test scenarios. >>> >>>>> On Aug 16, 2022, at 3:16 PM, John Ralls >wrote: >>>> >>>>  >>>> >>>>> On Aug 16, 2022

Re: [GNC] Copy/Paste Transaction Issue

2022-08-18 Thread David T. via gnucash-user
Liz, I think the issue really boils down to "what exactly is getting copied and pasted?" I don't know the specifics, but as far as I understand it, a transaction in GnuCash looks unitary to the end user, but actually consists of a strange hybrid: a Transaction entry with (at least) two subsid

Re: [GNC] Copy/Paste Transaction Issue

2022-08-19 Thread David T. via gnucash-user
m in any way wanting to go back to Quicken but I'm thinking that >it was never an issue to Copy/Paste To/From any type of account. > >On Fri, Aug 19, 2022 at 1:46 AM David T. via gnucash-user < >gnucash-user@gnucash.org> wrote: > >> Liz, >> >> I think

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread David T. via gnucash-user
The thread at https://lists.gnucash.org/pipermail/gnucash-user/2019-March/083442.html goes into quite a discussion about how to import multi line csv files. On August 21, 2022 6:26:24 PM GMT+03:00, Jon Schewe wrote: >David, > >I'm using GnuCash 4.11 from FlatPak. I have all of my transactions

Re: [GNC] Saved Report Configurations Missing After Upgrade to v3

2022-08-23 Thread David T. via gnucash-user
Neville, You've responded to a thread from four years ago, referencing a problem with upgrading from version 2.4 to version 3.0 (on Windows, I believe). Gnucash is now up to version 4.11, so whatever problem you've been having is far in most users' rear view mirrors. Geert probably remembers t

Re: [GNC] GC 3.11 crashes during "Check & Repair"

2022-08-28 Thread David T. via gnucash-user
I'm not an expert, but I'm pretty sure the price db doesn't have splits; it's just a list of commodities, prices, and dates (asking with some other housekeeping info). I believe that "113 of 304" is in reference to the splits within a given account, so you'd need to know which account might hav

[GNC] Fwd: Re: Saved Report Configurations Missing After Upgrade to v3

2022-08-28 Thread David T. via gnucash-user
t copied either. They are less important though. And certainly not now any more that you have been using gnucash 3.x already. No doubt you have already reopened registers and reports to you likings. Regards, Geert Op dinsdag 23 augustus 2022 13:02:51 CEST schreef David T. via gnucash-

Re: [GNC] Can someone tell me how A-L=Eq+(I-Ex) is correct?

2022-08-31 Thread David T. via gnucash-user
I'm surprised no one has mentioned https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-accounting1.html#basics-accountingequation2 That's the Tutorial & Guide page that explains the concept. David T. On August 31, 2022 10:15:04 AM GMT+03:00, Gyle McCollam wrote: >Neal, >Your welcome. I se

Re: [GNC] Change Linked Document Path

2022-09-02 Thread David T. via gnucash-user
Norbert, John is discussing a technical aspect of a migration of an existing data file, whereas you are asking about a brand new installation not presenting you with apparent next steps. In other words, not the same at all. Your question received two answers: one terse but highly accurate; th

Re: [GNC] A new start - somewhat strange

2022-09-04 Thread David T. via gnucash-user
Save to a folder in your personal workspace. Just like you'd do with your personal word processing files. David T. On Sep 4, 2022, 14:24, at 14:24, Norbert Klein wrote: >Thanks - that helped me to do the next step: > >Just create a new file: > >File -> New File > >I followed the recomme

Re: [GNC] A new start - somewhat strange

2022-09-05 Thread David T. via gnucash-user
Norbert, You are remembering a thread where the suggestion was to create accounts in the second currency for the major areas you anticipate tracking find in Riel. To wit: Expenses - Groceries - - USD - - RIEL Best, David T. On Sep 5, 2022, 06:45, at 06:45, Norbert Klein wrote: >Thanks – movin

Re: [GNC] Mutual Fund Dividend After Sale

2022-09-06 Thread David T. via gnucash-user
Jack: DRIP="Dividend Re-Investment Plan" It seems to me that you've decided, in your frustration, to lash out at the people who are trying to understand your problem and offer you help. That's not a good look. You've testily confirmed that you haven't received shares from this dividend, and d

Re: [GNC] Move transactions from one account to another

2022-10-08 Thread David T. via gnucash-user
Or simply delete account A, and you'll be asked the same question. ⁣David T. ​ On Oct 8, 2022, 4:02 AM, at 4:02 AM, "Carl S." wrote: > > >*From:* David Carlson [mailto:david.carlson@gmail.com] >*Subject:* [GNC] Move tra

Re: [GNC] Price update not working

2022-10-08 Thread David T. via gnucash-user
While it's always best to try to use the latest versions, Richard's error message doesn't sound like one that has to do with currency rate retrieval (which I believe is the major bug that F::Q1.53 is meant to fix). I would personally check to see what quote sources are selected for each securi

Re: [GNC] Reconciling subaccounts

2022-10-08 Thread David T. via gnucash-user
John, I don't know about "typically." There are any of a number of ways that someone might use placeholder accounts. In my own books, I have placeholder accounts for brokerage holdings, where the placeholder represents an institution's account and the leaf accounts represent individual securit

Re: [GNC] Problem with missing balance in a parent account

2022-10-08 Thread David T. via gnucash-user
That account register doesn't have any transactions in it, so it won't have any value either. Is it possible that in the past, you used a report to see the parent account balances, or even the Chart of Accounts? And if the account in the screen shot is a placeholder account, then you a) wouldn

Re: [GNC] Mac Installation 4.12 issue

2022-10-08 Thread David T. via gnucash-user
Hylton, The main GnuCash page includes a link for installation, and on that installation page, the section for macos states: "Once you have downloaded the disk image, double click to open it, and then drag the app icon into your Applications folder (or anywhere else on your system that you choo

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
Geoff, As it's a wiki, you just go for it. I was going to do just that, because your image width causes the browser page to shrink everything else on screen, making it incredibly hard for old eyes to read the (now miniscule) text. But, you've aggregated all the steps into one wide image. If

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
"Security/Currency" field Choose "NASDAQ" as type and "(AMZN) Amazon" as security Set Parent Account to an account in the Assets branch of your chart Click "Ok" ⁣David T. ​ On Oct 11, 2022, 10:37 AM, at 10:37 AM, "David T. via gnucash-user"

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
I'm opening the page on Android devices in Chrome. I still feel that each of the windows should be placed in a separate image, in the actual instructional sequence. ⁣David T. ​ On Oct 11, 2022, 11:05 AM, at 11:05 AM, Geoff wrote: >Hi David > >Thanks for the review. > >I tested this (on Windo

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
;> >> >> Click on the "Select" button for the "Security/Currency" field >> >> Choose "NASDAQ" as type and "(AMZN) Amazon" as security >> >> Set Parent Account to an account in the Assets branch of your chart >

Re: [GNC] How to include images in the Wiki?

2022-10-11 Thread David T. via gnucash-user
John, sunfish62 (that's me) is also asking for such access. On 10/11/2022 6:38 AM, john wrote: On Oct 10, 2022, at 9:01 PM, Geoff wrote: So, how do I go about obtaining "uploadaccess", or finding a friendly and patient Administrator to upload images on my behalf? Just ask! What's your wi

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
ount name" field     Choose "Stock" as Account type     [Image of New account window with circles)]     Click on the "Select" button for the "Security/Currency" field     Choose "NASDAQ" as type and "(AMZN) Amazon&quo

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-12 Thread David T. via gnucash-user
Frank, I've just rewritten the page extensively, and in the course of doing so, I added back your category and headers. ⁣David T. ​ On Oct 12, 2022, 2:31 AM, at 2:31 AM, "Frank H. Ellenberger" wrote: > > >Am 12.10.22 um 01:17 schrieb Geoff: >> I have reverted all of my changes. > >… and my

Re: [GNC] transaction images and failed hard drives

2022-10-14 Thread David T. via gnucash-user
Geoff, Jeff is asking a more specific question related to the image linking feature. It's not his book data that he's looking for guidance on; it's whether he can link his images using a different mechanism than to a file directly. Jeff, I don't profess to fully understand your solution, but I

Re: [GNC] Price database

2022-10-15 Thread David T. via gnucash-user
Geoff, Good advice/help! I do think it would be necessary to add the currency to the result, to inform the resulting prices. ⁣David T. ​ On Oct 16, 2022, 4:38 AM, at 4:38 AM, Geoff wrote: >Hi Elmar > >To elaborate on John's reply, this SQL statement should do the trick: > > >select c.namespac

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-15 Thread David T. via gnucash-user
Looks good. And this is definitely a better placement. Now, one wonders whether the name of the page ("PostgreSQL- Requests For Direct Database Access") would be better as "SQL For Direct Access to GnuCash Data"... Alas,  the power to rename pages reside with only an anointed few... ⁣David T.

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-16 Thread David T. via gnucash-user
That works for me! Thanks, John. ⁣David T. ​ On Oct 16, 2022, 10:34 PM, at 10:34 PM, john wrote: >I've renamed that page to GnuCash SQL Examples. > >Regards, >John Ralls > > >> On Oct 15, 2022, at 11:54 PM, David T. via gnucash-user > wrote: >> >>

  1   2   3   4   5   6   7   >