Re: [GNC] GnuCash getting worse?
Hi, I did try to read the online doc (not the context) and one of the things that would have helped was a notation on which fields were required. If that info was there, I missed it. I knew I didn't have them all so I just stubbed in something for everything and then removed them one by one until I found which one caused the commodity message. After I got the file lined out, it went very smooth. I was taking QB data and importing it. On a different import (customer data), I created some formulas which combined many QB fields into one so I wouldn't lose any data. Made the description (I think) line very long but it took it and I was pleased there was no length restriction. Looked odd however :) Anyway, as I said earlier, thanks so much for all of your efforts- a great product & a great community to go with it. Cheers! -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of John Ralls Sent: Friday, July 19, 2024 6:50 PM Cc: flywire; Gnucash Users Subject: Re: [GNC] GnuCash getting worse? As I said, I see that as a documentation issue. The column labels have to be terse and we can’t use per-item tooltips in the long run because the Gtk folks have pulled them from Gtk4. It’s not great that Geert changed the headings for the amount columns from Deposit and Withdrawal to Amount and Amount(negated) but forgot to change the intro screen to reflect it. The import dialog also lacks a help button. OTOH the context help is so clunky I wonder if anyone would use it. Would you? Even if you would the actual documentation for importing CSV doesn’t explain all of the column headers and still says Deposit and Withdrawal. Regards, John Ralls > On Jul 19, 2024, at 09:22, Greg Julius wrote: > > FWIW, I really struggled with this to figure out what was wrong with my > imports. There is a Commodity field and there is a Currency field. I had to > repeatedly fill in fields until I found the issue was Currency. > > I also think all of you that help/develop this product do a great job. > > Blessings, > -greg > > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf > Of John Ralls > Sent: Friday, July 19, 2024 10:40 AM > To: flywire > Cc: Gnucash Users > Subject: Re: [GNC] GnuCash getting worse? > > > >> On Jul 19, 2024, at 00:10, flywire wrote: >> >>> 2. An error message displayed "You must choose a commodity" is wrong and >>> should be "You must choose a Security/currency" Choose AUD >> > > That’s too narrow an interpretation of “commodity”. Both securities and > currencies are commodities, but for example widgets are commodities but are > neither securities nor currencies. The error message is correct, what’s > apparently lacking is communicating to users the meaning of “commodity”. > We’re also guilty of mixed messaging because we call the tool that manages > commodities the Security Editor. Both are a larger problem than an error > dialog in the CSV importer. > > Regards, > John Ralls > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] GnuCash getting worse?
FWIW, I really struggled with this to figure out what was wrong with my imports. There is a Commodity field and there is a Currency field. I had to repeatedly fill in fields until I found the issue was Currency. I also think all of you that help/develop this product do a great job. Blessings, -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of John Ralls Sent: Friday, July 19, 2024 10:40 AM To: flywire Cc: Gnucash Users Subject: Re: [GNC] GnuCash getting worse? > On Jul 19, 2024, at 00:10, flywire wrote: > >> 2. An error message displayed "You must choose a commodity" is wrong and >> should be "You must choose a Security/currency" Choose AUD > That’s too narrow an interpretation of “commodity”. Both securities and currencies are commodities, but for example widgets are commodities but are neither securities nor currencies. The error message is correct, what’s apparently lacking is communicating to users the meaning of “commodity”. We’re also guilty of mixed messaging because we call the tool that manages commodities the Security Editor. Both are a larger problem than an error dialog in the CSV importer. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Editing the Quicken/Quickbooks check layout
Hi Gerard, A quick google brought me this link: https://quickbooks.intuit.com/learn-support/en-us/other-questions/paycheck-alignment-for-qb-desktop/00/755600 I had done this years ago when I had my business up and running (since retired and abandoned QB) and it worked for me. Hope this helps, -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Gerard Dupczak Sent: Wednesday, July 03, 2024 8:52 AM To: gnucash-user@gnucash.org Subject: [GNC] Editing the Quicken/Quickbooks check layout Is there a way to edit the Quicken/Quickbooks 3-part check layout? My checks mostly align but the written check amount and the items below that are off by about 1/2 a line. I haven't been able to locate the file that has that layout. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Imbalance Records with zero amounts
Howdy Joe, I'll take a stab at this one I have noted when I create a transaction that has splits that if I end up with an zero amount Imbalance entry in the middle of the splits (not at the end) then saving the transaction will save it with the zero imbalance split and it will then appear in the imbalance register as you described. My solution is to right-click the zero imbalance entry and select delete-split (just the row, not the entire set of splits) and then save the transaction. I think the zero imbalance entry when on the bottom of the splits gets removed but not if it's in the middle of the split entries. Anyway, my 2 cents worth & hope it helps. Blessings, -g -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Joseph Hesse Sent: Wednesday, June 26, 2024 10:20 AM To: GNU Cash, pw = "getrich" Subject: [GNC] Imbalance Records with zero amounts Hello, I have several consecutive records in my imbalance account where the amounts in the deposit and withdrawal columns are both zero (blank). These records are split transaction records. When I examine the items in the split the imbalance shows zero. I don't see any error when I jump to the items in the split. This seems like a bug or an error in my bookkeeping. I am using the latest version of gnucash. Any help would be much appreciated. Joe Hesse ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Discovered install link for Finance Quotes in Win11 app
I’ve experienced similar. GnuCash doesn’t handle the drive reference (g:) so in your batch file/cmdline, do a cd first, then run the command without the drive reference. -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of David G. Pickett via gnucash-user Sent: Thursday, June 20, 2024 2:59 PM To: Gnucash Users Subject: Re: [GNC] Discovered install link for Finance Quotes in Win11 app I suppose there is a command to gracefully kill any running gnucash instance so it does not hit a lock file? Of course, even with auto save, with a kill, you have to clean up the lock file, and the file may lose uncommitted transactions! It'd be nicer for the running instance to run it at an appropriate time. I shut down my instance and gave it a try from a WinDOS command line, but something goes wrong: C:\Program Files (x86)\gnucash\bin>dir "g:\My Drive\LinuxDesktop\GnuCash\ubuntu-DGPickett.gnucash" Volume in drive G is Google Drive Volume Serial Number is 1983-1116 Directory of g:\My Drive\LinuxDesktop\GnuCash 06/19/2024 09:35 PM 3,356,924 ubuntu-DGPickett.gnucash 1 File(s) 3,356,924 bytes 0 Dir(s) 26,673,577,984 bytes free C:\Program Files (x86)\gnucash\bin>.\gnucash-cli.exe --quotes get "g:\My Drive\LinuxDesktop\GnuCash\ubuntu-DGPickett.gnucash"* 15:51:57 ERROR [cleanup_and_exit_with_failure()] Session Error: failed to get_backend using access method "g" C:\Program Files (x86)\gnucash\bin> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Discovered install link for Finance Quotes in Win11 app menu, but many questions in install.
I ran into this also. Additionally there were several prompts that were asked that I just took the suggested value. Finally, I had to run it three times to get it to fully finish the install due to it cancelling from a missing file or folder. -g -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of David G. Pickett via gnucash-user Sent: Sunday, June 16, 2024 8:54 AM To: Gnucash Users Subject: [GNC] Discovered install link for Finance Quotes in Win11 app menu, but many questions in install. I clicked the "Install Online Price Retrieval for GnuCash" in my new Win11 install, but had manually download install Strawberry perl as Norton blocked it. I clicked it again and it went into a long install that now is asking mysterious questions like USE_UNALIGNED or ZSTD. Shouldn't it run more unattended? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] GC now only opens a report
Hi Bruce, this has occurred to me. On the View menu, select the 'New Accounts Page' and it will open the (in my mind) the main view again. I've done this a lot and I'd love an option to always open the Accounts page when starting the program. Good Luck. -g -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Irving Sent: Tuesday, June 11, 2024 8:47 AM To: Gnucash Users Subject: [GNC] GC now only opens a report GC 5.6 under flatpack. I didn't close a report (in a separate window) before I closed the regular GC. Now, when I Try to open GC, I only get the report. How do I get to being able to enter data again? Bruce ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Can I set an option to stop auto-fill ?
Hi y'all! I get so many things from online vendors (Amazon, Microsoft, etc, etc) and they are generally different and going to various different accounts and sometimes they have splits. I am finding the auto-complete function to be more troublesome than not and I'd like a way to turn it off. I don't mind it overmuch filling in the account so much as the amount and the splits. I'd rather have none of it that have the confustion (that's confusion and frustration in a word) caused by the auto-fill. I, BTW, am loving the software. I'm sure the setting is in there somewhere, I'm just not finding it. I'm certainly open to what I'd like the software to do. I realize this is an open source project and I'm no-longer (as in ancient) in the coding world or I would attempt something myself (I wouldn't mind being able to help out but I'm a Windows and Mainframe assembly guy so no relevant skills I suspect). Anyway, what I'd like is if the "prior" transaction has splits, then simply leave the whole thing un-populated. If it doesn't have splits, go ahead and put in the account. Leave the cursor in the account field and don't fill in anything else (notes, amount, etc). That would be ideal for me. Simply turning off the auto-complete is, I expect, a simpler option and probably already there I just don't know where to turn it off. Thanks all & Blessings! -greg ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] loading a CPAN something from Windows
Hi, regarding the below I'm trying to figure out how to run the update from Widows. Where do I go to fire off cpan/cpanm? Or is it wrapped in something else on windows? What happens if I simply run the original stuffs that I used to install F::Q in the first place? -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Saturday, April 27, 2024 6:35 PM To: GnuCash User Subject: [GNC] Finance::Quote Pre-Release 1.61_02 Uploaded to CPAN Greetings, Finance::Quote v1.61_02 has been uploaded to CPAN. Changes since 1.61 * Modified yahooJSON.pm module in order handle EU consent redirects better. * TwelveData.pm - Added "last" to data being returned. The method "twelvedata" was returning a value for "close". GnuCash expects "last" or "price" in order to utilize the quote data. * BorsaItaliana.pm - New module for Borsa Italiana, Italian traded bonds using ISIN * YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes from Yahoo. Using cpan or cpanm, install "BPSCHUCK/Finance-Quote-1.61_02.tar.gz". TwelveData has data for US and foreign exchanges. It does require an API key from https://twelvedata.com/. Another option for retrieving US quotes is MarketWatch. No API key needed. I'm still trying to resurrect the Fool module. But hit another wall when getting "too many requests" after only a half dozen requests. Even when spaced out at 20 seconds per request. Thank you. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Finance Quotes Yahoo off the rails again?
WooHoo! I'll give it a go once it's out. Thanks! -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Saturday, April 13, 2024 10:08 PM To: GnuCash User Subject: Re: [GNC] Finance Quotes Yahoo off the rails again? Just a quick status. Just an FYI, I have worked on getting a PR ready using kalpesh Patel's changes. I tried applying the same logic to the CurrencyRates/YahooJSON.pm currency module with no luck. In that case I quickly modified the currency module to utilize the "v8" API. I admit, I suck at using the developer tool/console in Chrome and Firefox to figure out the magic sauce needed. Big thanks to Mr. Patel on this one. There is some miscellaneous housekeeping and cleanup that needs to be done before pushing a final release to CPAN. Plus I had some other changes that I was planning for v1.60 but haven't done yet. Instead of v1.60, I may upload v1.59_01 tomorrow so people can at least fetch the fix for YahooJSON before v1.60 is uploaded and indexed by CPAN. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] FYI Web tables, CSV, prices info and inquiry
I've just done something like that and the only trouble I had was getting the date to parse. Save the excel file as .CSV . Credit goes to Geoff. From the file menu, select import then price import and it starts the wizard. I ended up having to use the ISO format, but I'm going to try again after 4 central and see if I can't get it to work. One of my lines in the spreadsheet looks like this (details munged to protect the guilty): NASDAQ,X,2024-04-11,123.45,USD Hope that helps. Blessings, -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of David G. Pickett via gnucash-user Sent: Friday, April 12, 2024 2:01 PM To: Gnucash Users Subject: [GNC] FYI Web tables, CSV, prices info and inquiry Not all users know that the nice table of your stocks and prices that you see on so many web sites like my morningstar portfolio can be selected and pasted into a spreadsheet like Excel, Google Sheets, or LibreOffice Calc, maybe not perfectly, but so it is easy to turn them into a clean spreadsheet table. My Morningstar did something weird with the first column but it was all there and not too hard to cut and paste or paste-special it into a nice table. Then you have the option of saving it as a CSV file (Comma Separated Value), which loses any funny formatting and hypertext links and is maybe gnucash friendly. It would be a bit of an emergency, and I could do this one stock at a time, but importing this CSV to gnucash prices would be a nice backup. I have not done the research or reading above to know how to import such a table into gnucash prices. Can someone give a simple how-to? Do I need a date column? A column to say it is nav or close? Is there a web page help on this? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Finance::quote YahooJSON
Bruce, thank you for that excellent reply. Hoping the best for all the Devs. -greg -Original Message- From: Bruce Schuck [mailto:bsch...@asgard-systems.com] Sent: Thursday, April 11, 2024 9:39 PM To: gnucash-user@gnucash.org Cc: From: Terrence Branscombe; fromvendor Subject: Re: [GNC] Finance::quote YahooJSON On 4/11/24 17:29:59 +, Greg wrote: > I'm sure the Dev's are working on it, but do we have any idea what > happened? My log shows 401 type errors (Unauthorized) so I thought > I'd add some diagnostics in case it helps anyone. > Hoping for some good news (and I'm sure I'm not alone on that). > I really appreciate this great working mail list and thanks for those > who devlop/fix/maintain the program. It's important to note that these APIs are likely not meant for direct access. Which is why the previous APIs that the YahooJSON.pm all became unusable at some point. This would be why you cannot find official documentation for the APIs online like you can for APIs like the AlphaVantage which limits what you can retrieve for free. I've had less time to work on F::Q the last few months, so I'm not sure when I'll be able to either rework the module to use the v8 API or test and implement Kalpesh Patel's changes. Hopefully in the next week or so, but if someone else wants to step up and create a pull request at https://github.com/finance-quote/finance-quote that would be a great help. On 4/11/24 12:48:09 -0600 (MDT), Terrence Branscombe wrote: > I've just noticed that my last stock price update occurred on March > 28. * 11:11:36 ERROR [parse_quotesource_error()] > Unrecognized Finance::Quote Error Wide character in subroutine entry > at C:/Strawberry/perl/site/lib/Finance/Quote/Cdnfundlibrary.pm line > 80. It appears the format of page Cdnfundlibrary.pm uses to scrape the data from fundlibrary.com has had major changes. The Fundata.pm module (idata.fundata.com) has also stopped working for the same reason. See Issue https://github.com/finance-quote/finance-quote/issues/366 and discussion https://github.com/finance-quote/finance-quote/discussions/364. Unfortunately both modules are likely going to be disabled and then removed from Finance::Quote. The Fool.pm module has also recently stopped working and it will also be disabled in the next release of F::Q. Bruce S ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Finance::quote YahooJSON
Kalpesh - Thank you for the link. I took a quick gander and it seems pretty
nice. Have you used it since the Yahoo thing went south and did it work? Are
you using the query api or scraping the window?
All,
I'm sure the Dev's are working on it, but do we have any idea what happened?
My log shows 401 type errors (Unauthorized) so I thought I'd add some
diagnostics in case it helps anyone.
Here is a set of lines from the log I keep (security redacted):
Found Finance::Quote version 1.59.
* 15:30:02 WARN [GncQuotesImpl::parse_one_quote()]
Skipped NASDAQ:X - Finance::Quote returned fetch failure.
Reason Error retrieving quote for X. Attempt to fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=X=price,summaryDetail,defaultKeyStatistics
resulted in HTTP response 401 (Unauthorized)
If I try the above URL, I get what appears to be a JSON reply:
{"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid
Crumb"}}}
Dooing a bit of Google-fu, I find a 1 day old comment on reddit r/GnuCash
saying it's broke and a reply saying it's been turned off (no longer free) but
I have not found any comment from yahoo on the subject.
Hoping for some good news (and I'm sure I'm not alone on that).
I really appreciate this great working mail list and thanks for those who
devlop/fix/maintain the program.
-greg
-Original Message-
From: Kalpesh Patel [mailto:kalpesh.pa...@usa.net]
Sent: Thursday, April 11, 2024 7:44 AM
To: 'Geoff'; fromvendor; 'GnuCash User eMail List'
Subject: RE: [GNC] Finance::quote YahooJSON
You may want to review my personal project at
https://github.com/ka-patel/dl_quotes ...
-Original Message-----
From: Geoff
Sent: Thursday, April 11, 2024 7:57 AM
To: fromvendor ; 'GnuCash User eMail List'
Subject: Re: [GNC] Finance::quote YahooJSON
> Is there a way to import data to the price database? I could create a > CSV
> or the like and just update the numbers from day to day until this > gets
> resolved.
Yes, you can:-
File / Import / Import Prices from a CSV file ...
You only need 5 columns:-
(1) Namespace
(2) Symbol
(3) Date
(4) Price
(5) Currency
See attached.
Regards
Geoff
=
On 11/04/2024 4:41 pm, fromvendor wrote:
> I've tried Advantech, Motley, and Rowe. All failed (different, but fails for
> all of them).
>
> I put in manual entries for now. Is there a way to import data to the price
> database? I could create a CSV or the like and just update the numbers from
> day to day until this gets resolved.
>
> Thanks all,
> -g
>
> -Original Message-
> From: fromven...@outtacyte.com
> Sent: Thursday, April 11, 2024 1:27 AM
> To: GnuCash User eMail List
> Subject: RE: [GNC] Finance::quote YahooJSON
>
> OK, I just noticed in my log that I got bit by this. What other source do
> you recommend for the nonce? I only have 3 to get updated.
> -greg
>
> For help with any of our services, please reach out to our Helpdesk:
> helpd...@outtacyte.com
>
> OuttaCyTE / Greg's Helpdesk
> E-Mail: helpd...@outtacyte.com
> Phone: 830-672-9068, Dial ext. 852 to reach a staff person during
> office hours
>
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On
> Behalf Of Bruce Schuck
> Sent: Wednesday, April 10, 2024 4:26 PM
> To: GnuCash User eMail List
> Subject: Re: [GNC] Finance::quote YahooJSON
>
> Wed Apr 10 16:12:21 EDT 2024 Jacob Larsen wrote:
>
>> Did something happen to the YahooJSON module in Finance::Quote? Or
>> perhaps more likely the Yahoo API? I get this now, using
>> Finance::Quote version 1.59:
>
> Unfortunately Yahoo once again made some changes with respect to the
> API URLs. F::Q team is aware and an issue has been opened, but so far
> no determination if it can be corrected or when. For now the best
> suggestion is to select a different source.
>
> Regards,
>
> Bruce S.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
Re: [GNC] Finance::quote YahooJSON
I've tried Advantech, Motley, and Rowe. All failed (different, but fails for all of them). I put in manual entries for now. Is there a way to import data to the price database? I could create a CSV or the like and just update the numbers from day to day until this gets resolved. Thanks all, -g -Original Message- From: fromven...@outtacyte.com Sent: Thursday, April 11, 2024 1:27 AM To: GnuCash User eMail List Subject: RE: [GNC] Finance::quote YahooJSON OK, I just noticed in my log that I got bit by this. What other source do you recommend for the nonce? I only have 3 to get updated. -greg For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg's Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM To: GnuCash User eMail List Subject: Re: [GNC] Finance::quote YahooJSON Wed Apr 10 16:12:21 EDT 2024 Jacob Larsen wrote: > Did something happen to the YahooJSON module in Finance::Quote? Or > perhaps more likely the Yahoo API? I get this now, using > Finance::Quote version 1.59: Unfortunately Yahoo once again made some changes with respect to the API URLs. F::Q team is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Finance::quote YahooJSON
OK, I just noticed in my log that I got bit by this. What other source do you recommend for the nonce? I only have 3 to get updated. -greg For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg's Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM To: GnuCash User eMail List Subject: Re: [GNC] Finance::quote YahooJSON Wed Apr 10 16:12:21 EDT 2024 Jacob Larsen wrote: > Did something happen to the YahooJSON module in Finance::Quote? Or > perhaps more likely the Yahoo API? I get this now, using > Finance::Quote version 1.59: Unfortunately Yahoo once again made some changes with respect to the API URLs. F::Q team is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Import QIF files
Hi, I saw yesterday, I think, that there is an update to address this issue regarding regular QIF imports (vs investment ones). That would require installing the latest fix update if I understood what I read. -g -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Jim Passmore Sent: Monday, April 08, 2024 6:01 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Import QIF files Beryl, I can't help on the specifics as I only occasionally do imports. I will give the request to supply your operating system and GnuCash version when reporting a problem. Also, and the main reason I replied, is to point out two emails in the same day with that same error message while doing an import. The other user was using the recently released version 5.6. -- *Jim Passmore*j...@passmore4.com On Mon, Apr 8, 2024 at 6:38 PM Beryl Lymer wrote: > I have been importing QIF files into GNUcash successfully for several > years. However, for recent files, I am getting an error of ‘MISSING QIF > INVESTMENT ACTION FOR TRANSACTION DATED xx/xx/. The erroneous > transaction seems to be the last of those imported. The import will not > complete. I have had to manually enter all the transactions. > > I am downloading the files from Santander online banking. Not sure if it > is Santander or Gnucash that’s the issue. > > Beryl > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Using gnucash-cli for updating quotes on Windows
I'm having trouble trying to tell gnucash-cli -Q get which provider to use. I
want it to use yahoo_json, which is what I have set up in the Security Editor
("Yahoo as JSON" for single quote source)
When I do get it to run, it looks like it's getting the data from AlphaVantage
as I get the following Warning message:
WARN [GncFQQuoteSource::GncFQQuoteSource()] No Alpha Vantage
API key set, currency quotes and other AlphaVantage based quotes won't work.
It did work as I only have three securities at the moment. So, how do I
specify yahoo_json on the command line or is the warning spurious?
BTW, I really had a hard time getting the command to run properly on windows.
Perhaps I'm dumb, but the online places give no examples of what a properly
formatted command to look like. I did, however get the command to run and it
did update my file.
Here's what I discovered. Perhaps useful to someone in the future.
Apparently the datafile specification won't allow specifying the drive as I get
this error: failed to get_backend using access method "O"
I don't know if it would have handled a path specification, but since I had to
change to a different drive anyway, I changed my command window to the location
where the file resides.
Further, the datafile name wants the entire name with the suffix (so
.gnucash)
This resulted in a command line which looked like this: "C:\Program Files
(x86)\gnucash\bin\gnucash-cli.exe" -Q info <-- case matters for the -Q
This resulted in output so I did that right
Continued on to use the get and ended up with: "C:\Program Files
(x86)\gnucash\bin\gnucash-cli.exe" -Q get ".gnucash"
and that did update my datafile albeit with the warning above.
Thanks to all developers and the users of GNUcash
-greg
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
Re: [GNC] New user looking for some reporting help
Geoff, thank you!! It was the period duration that got me - I misinterpreted its meaning. Changing to One Month did the trick. Thanks again! -g -Original Message- From: Geoff [mailto:cleanoutmys...@gmail.com] Sent: Tuesday, April 02, 2024 10:02 PM To: fromvendor; 'gnucash-user@gnucash.org' Subject: Re: [GNC] New user looking for some reporting help See attached - hope this helps. Period Duration granularity is Weekly / Fortnightly / Monthly / Quarterly / Half Yearly / Annually. You can also set specific Start and End dates. Regards Geoff = On 3/04/2024 12:04 pm, fromvendor wrote: > Geoff, > That's it! However I can't get it to produce right when I try it. > > Can you send me relevant shots of your options for them? I have a couple of > months of data but I only get two columns of numbers 1/1/24 and 12/31/24. > > I'm still using 5.5 and 5.6 is new enough that I'll stay away for a bit > unless I "HAVE TO" go forward. I've lived the bleeding edge for too many > years, I want to stay away from it if I can. > > And thanks for the welcome! > > Thanks! > > -Original Message- > From: Geoff [mailto:cleanoutmys...@gmail.com] > Sent: Tuesday, April 02, 2024 7:40 PM > To: fromvendor; 'gnucash-user@gnucash.org' > Subject: Re: [GNC] New user looking for some reporting help > > And the "Income Statement (Multicolumn)" report works the same way - see > attached. > > Regards > > Geoff > = > > On 3/04/2024 11:23 am, Geoff wrote: >> Hi Greg, and welcome to the wonderful world of GnuCash! >> >> Try the "Balance Sheet (Multicolumn)" report and play around with the >> Options - see attached screenshot. >> >> Windows 10 GnuCash v5.6 Build ID: git 5.6-2-g9f998892b5+(2024-04-01) >> >> Regards >> >> Geoff >> = >> >> On 3/04/2024 9:34 am, fromvendor wrote: >>> Hi, I'm trying to figure out how to get some reports like I used to >>> get out of quickbooks. QB has made me so mad that I've abandoned them >>> for this year and I'm using GNUCash. >>> >>> I'm using Version 5.5. (probably doesn't matter but I just today got >>> the Quotes thing working (three failures to install - each one got >>> further until 3rd time charm). ) >>> >>> I'm having difficulty on a few things that I can't seem to figure out >>> how to do especially in regards to reporting. >>> >>> One set of reports I'd like is Balance and P reports with Monthly >>> columns. >>> >>> So, I'd specify the overall date range (say 1 Jan to 31 March) and >>> tell it I want columns for each month and a column for the total for >>> the selected date range. >>> >>> Is this something that already exists? Are there custom reports that >>> can do this? Are there "Add on" reports that I can get (and if so, >>> where)? >>> >>> This message also serves as my first message using a mail list in >>> about 20 years so I'm hoping I've got it set up right. >>> >>> Blessings, >>> -g >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> 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. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] New user looking for some reporting help
Geoff, That's it! However I can't get it to produce right when I try it. Can you send me relevant shots of your options for them? I have a couple of months of data but I only get two columns of numbers 1/1/24 and 12/31/24. I'm still using 5.5 and 5.6 is new enough that I'll stay away for a bit unless I "HAVE TO" go forward. I've lived the bleeding edge for too many years, I want to stay away from it if I can. And thanks for the welcome! Thanks! For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg’s Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: Geoff [mailto:cleanoutmys...@gmail.com] Sent: Tuesday, April 02, 2024 7:40 PM To: fromvendor; 'gnucash-user@gnucash.org' Subject: Re: [GNC] New user looking for some reporting help And the "Income Statement (Multicolumn)" report works the same way - see attached. Regards Geoff = On 3/04/2024 11:23 am, Geoff wrote: > Hi Greg, and welcome to the wonderful world of GnuCash! > > Try the "Balance Sheet (Multicolumn)" report and play around with the > Options - see attached screenshot. > > Windows 10 GnuCash v5.6 Build ID: git 5.6-2-g9f998892b5+(2024-04-01) > > Regards > > Geoff > = > > On 3/04/2024 9:34 am, fromvendor wrote: >> Hi, I'm trying to figure out how to get some reports like I used to >> get out of quickbooks. QB has made me so mad that I've abandoned them >> for this year and I'm using GNUCash. >> >> I'm using Version 5.5. (probably doesn't matter but I just today got >> the Quotes thing working (three failures to install - each one got >> further until 3rd time charm). ) >> >> I'm having difficulty on a few things that I can't seem to figure out >> how to do especially in regards to reporting. >> >> One set of reports I'd like is Balance and P reports with Monthly >> columns. >> >> So, I'd specify the overall date range (say 1 Jan to 31 March) and >> tell it I want columns for each month and a column for the total for >> the selected date range. >> >> Is this something that already exists? Are there custom reports that >> can do this? Are there "Add on" reports that I can get (and if so, >> where)? >> >> This message also serves as my first message using a mail list in >> about 20 years so I'm hoping I've got it set up right. >> >> Blessings, >> -g >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] New user looking for some reporting help
Hi, I'm trying to figure out how to get some reports like I used to get out of quickbooks. QB has made me so mad that I've abandoned them for this year and I'm using GNUCash. I'm using Version 5.5. (probably doesn't matter but I just today got the Quotes thing working (three failures to install - each one got further until 3rd time charm). ) I'm having difficulty on a few things that I can't seem to figure out how to do especially in regards to reporting. One set of reports I'd like is Balance and P reports with Monthly columns. So, I'd specify the overall date range (say 1 Jan to 31 March) and tell it I want columns for each month and a column for the total for the selected date range. Is this something that already exists? Are there custom reports that can do this? Are there "Add on" reports that I can get (and if so, where)? This message also serves as my first message using a mail list in about 20 years so I'm hoping I've got it set up right. Blessings, -g ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
