Re: [GNC] Finance::quote YahooJSON
Gnucash most definitely *will* accept tab delimited files. You just have to tell it to use that separator in the importer. David T. On Apr 13, 2024, 12:54 AM, at 12:54 AM, ja...@larsen.net wrote: >I was playing around with this a bit, unfortunately a large part of my >investments are ETFs listed on Xetra in Germany, which is not available > >through the Google Finance services. The searching I did on it looked >like this was a "Won't fix" issue. > >But it turns out that I am able to download CSV files with historical >data from my broker, so I am back in business. The files have basically > >the full history of single instruments, so I can just download when I >get to it, and it will fill all the holes. Only challenge is that it >seems GnuCash will not accept the files directly as they are >tab-separated, but I can convert them to semi-colon separated files >through LibreOffice Calc, and then it works. > >/Jacob > >On 2024-04-11 17:16, sunfish62--- via gnucash-user wrote: > >> In the past, I have used a Google sheet that captured all my stock >> prices in one fell swoop, using Google's financial functions and a >> pasted copy of the Advanced Portfolio report. I put the AP in one >tab, >> and retrieve all quotes using references in a second tab. Save the >> sheet as CSV, which can then be quickly imported into GnuCash for >even >> hundreds of commodities. >> >> David T. >> >> On Apr 11, 2024, 2:59 PM, at 2:59 PM, Geoff > >> wrote: 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. >___ >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
Re: [GNC] Finance::quote YahooJSON
I was playing around with this a bit, unfortunately a large part of my investments are ETFs listed on Xetra in Germany, which is not available through the Google Finance services. The searching I did on it looked like this was a "Won't fix" issue. But it turns out that I am able to download CSV files with historical data from my broker, so I am back in business. The files have basically the full history of single instruments, so I can just download when I get to it, and it will fill all the holes. Only challenge is that it seems GnuCash will not accept the files directly as they are tab-separated, but I can convert them to semi-colon separated files through LibreOffice Calc, and then it works. /Jacob On 2024-04-11 17:16, sunfish62--- via gnucash-user wrote: In the past, I have used a Google sheet that captured all my stock prices in one fell swoop, using Google's financial functions and a pasted copy of the Advanced Portfolio report. I put the AP in one tab, and retrieve all quotes using references in a second tab. Save the sheet as CSV, which can then be quickly imported into GnuCash for even hundreds of commodities. David T. On Apr 11, 2024, 2:59 PM, at 2:59 PM, Geoff wrote: 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. ___ 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
Several years back, I sent this in to the list: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html Pretty sure it still works. David T. On Apr 12, 2024, 10:02 PM, at 10:02 PM, "David G. Pickett via gnucash-user" wrote: >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] gnucash-user Digest, Vol 253, Issue 33
Thanks for the offer Graham I'm getting more and more inclined towards the X11 track. I will need to do a little experimenting with having X11 and CLI on the same VM to see if they "Play nicely" together or if I'll need to run up a separate VM just for the X11 processes. For now I've been side tracked by running up a VM dedicated to MPD so I can (finally) move the radio station PC out of the house and reduce the load on my broadband, but I intend to come back to the GnuCash project in a few weeks. Just noticed on re-reading your email the word CONTAINER. Does GnuCash need to run under Docker or was that simply your choice to do so. On 12 Apr 2024 at 12:00, gnucash-user-requ...@gnucash.org wrote: I have run gnucash in a container and used x-forwarding successfully to access it from my desktop. The only functions that don't work in this mode are the help and tutorial and concepts guide. These are available separately via browser anyway, so I don't view that as a problem. If that works for your usecase, I can walk you through the details. Graham. ___ 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.
[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.
Re: [GNC] GNC will not properly import .csv file from PayPal
I suggest that if you are up against a deadline revert back to the release that works for you. On Fri, Apr 12, 2024 at 2:25 AM Jeffrey Black wrote: > I'm trying to import a .csv file from PayPal into the latest stable > version of GNC on Windoze 11 home and and/or Ubuntu 22.04 (snaphub > version 5.6.1), and neither of them will properly.. Both refuse to > import transactions properly when Notes and Memo are selected. I need > both of them so I can properly "split" transactions between my wife's > schedule C and personal expenses. > > I can only import one or the other, notes or memo, not both, AND I > need both in the same transaction. And I have always been able to in > all previous versions of GNC. > > Can anyone suggest a solution? > > I am up against the April 15th tax filing deadline, and I do not want > to have to file an extension for both my wife and and our dependent sons > separate return, so that I can manually edit every transaction manually > from the .csv file to place everything in the right account. Our > health insurance depends on it as does whether he gets the grants to > continue his college education. They want more per semester now than I > ever have made yearly in my life. I never expected college tuition to > exceed the income level of three working family members plus a Pell > grant and scholarships. His 529 account is not even adequate. > > Can anyone tell me why I cannot import a .csv file with both notes and > memo? Not one or the other. > > --Jeffrey Black M.B.A. > > ___ > 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. > -- David Carlson ___ 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] I'm looking at installing GnuCash but has a couple of questions first
On 12/04/2024 01:09, Robert Dew wrote: Thanks for the pointer John. Looks like I'm going to have to learn Python to go down this route. From what I can find with quick google searches seems to suggest that the Flask App captures the output from GnuCash and then via Flask, Python and possibly Node.JS renders an HTML output which is then severed via apache or similar web server. I will sit down later and see if a) my initial assessment is correct and b) the level of new procedures I need to get an understand of. Cheers Robert On 11 Apr 2024 at 19:22, John McKeon wrote: Hello Robert and list. There IS a Python Flask app in the GitHub repo that might work. Documentation is scant, and it requires Python bindings compiled into the binary which, I am lead to believe, is only available out-of-the-box in Linux binaries so you might be in luck. I'm sure others on this list will know if it is at all viable. Thanks and thanks for gnucash! On Tue, Apr 9, 2024 at 1:05AM Robert Dew wrote: I have a a number of small, separate, but interconnected companies that I'd like to have separate accounting systems for. Does GnuCash allow for multiple businesses, or would I need to install a separate version for each business It's a little unclear if GnuCash operates, or can be made to operate, via a remote web browser. I see references to using X-windows which would be an acceptable option, web/browser based would be my preference. Is there any restrictions on the self hosted version. ___ 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. -- John McKeon ___ 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. Robert, I have run gnucash in a container and used x-forwarding successfully to access it from my desktop. The only functions that don't work in this mode are the help and tutorial and concepts guide. These are available separately via browser anyway, so I don't view that as a problem. If that works for your usecase, I can walk you through the details. Graham. ___ 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] GNC will not properly import .csv file from PayPal
I'm trying to import a .csv file from PayPal into the latest stable version of GNC on Windoze 11 home and and/or Ubuntu 22.04 (snaphub version 5.6.1), and neither of them will properly.. Both refuse to import transactions properly when Notes and Memo are selected. I need both of them so I can properly "split" transactions between my wife's schedule C and personal expenses. I can only import one or the other, notes or memo, not both, AND I need both in the same transaction. And I have always been able to in all previous versions of GNC. Can anyone suggest a solution? I am up against the April 15th tax filing deadline, and I do not want to have to file an extension for both my wife and and our dependent sons separate return, so that I can manually edit every transaction manually from the .csv file to place everything in the right account. Our health insurance depends on it as does whether he gets the grants to continue his college education. They want more per semester now than I ever have made yearly in my life. I never expected college tuition to exceed the income level of three working family members plus a Pell grant and scholarships. His 529 account is not even adequate. Can anyone tell me why I cannot import a .csv file with both notes and memo? Not one or the other. --Jeffrey Black M.B.A. ___ 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.