[GNC] Finance::quote YahooJSON

[jacob at larsen.net]

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 <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. 
_______________________________________________
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.