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, sunfis...@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, ja...@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 <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.
_______________________________________________
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.
