[GNC] Finance::quote YahooJSON

[sunfish62 at yahoo.com]

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 <cleanoutmyshed at 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: fromVendor at 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: 
>helpdesk at outtacyte.com
>> 
>> OuttaCyTE / Greg's Helpdesk
>> E-Mail: helpdesk at 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.com at 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 at 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 at 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 at 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.