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 ><cleanoutmys...@gmail.com> >> 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.
