[GNC] Finance::quote YahooJSON

[sunfish62 at yahoo.com]

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