[GNC] Finance::quote YahooJSON

Sat Apr 13 11:47:49 EDT 2024

I might be concluding wrong on this one. Libre Office Calc will accept 
them, and I just saved them again. But I think there might be more 
variables. It is detected as UTF16 by Libre Office Calc, so it might be 
a character set issue. Also, I do need to get my Gnucash upgraded, I am 
on 4.5 at the moment, so it might just be old. Would like to try out the 
Flatpak, but I can see that I need to do this the long way around.

/Jacob

On 2024-04-13 07:21, sunfish62 at yahoo.com wrote:

> 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, at 12:54 AM, jacob at 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 <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.