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.
