Re: [GNC] v3.8
On MacOS 10.15 with GnuCash 3.8:
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump yahoo_json AMZN
Finance::Quote fields Gnucash uses:
symbol: AMZN <=== required
date: 12/30/2019 <=== recommended
currency: USD <=== required
last: 1846.89 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
I don't remember offhand what perl shipped on Sierra, but Catalina has only
5.18 and the latest is 5.30. That's clearly not required.
There's a test program, stockdump.pl in the cpan build directory
(~/.cpan/Finance-Quote-1.47-YeicSt/Examples/stockdump.pl on my system):
~/.cpan/build/Finance-Quote-1.47-YeicSt/Examples/stockdump.pl yahoo_json AMZN
$VAR1 = {
'AMZNvolume' => 3591419,
'AMZNlast' => '1846.89',
'AMZNmethod' => 'yahoo_json',
'AMZNdate' => '12/30/2019',
'AMZNcurrency' => 'USD',
'AMZNname' => 'AMZN (Amazon.com, Inc.)',
'AMZNsymbol' => 'AMZN',
'AMZNsuccess' => 1,
'AMZNisodate' => '2019-12-30',
'AMZNexchange' => 'Sourced from Yahoo Finance (as JSON)',
'AMZNtype' => 'EQUITY'
};
That might be helpful for troubleshooting.
Regards,
John Ralls
> On Dec 30, 2019, at 8:01 PM, farleykj via gnucash-user
> wrote:
>
> Thanks, David.
> I just used the quote downloading in the 2.6 version I was running
> previously, on 2019-12-27 (Friday). After the update to 3.8 today, it no
> longer works.
> Running gnc-fq-dump yahoo_json amzn gets me nothing. Not even the date. I
> ran the gnc-fq-update module to try and get things working, but to no avail.
> That makes me think it's my Perl installation or something of the sort,
> since I don't hear any others screaming about it.
> I looked back through the old posts about this, but it always seemed to be
> an alphavantage difficulty, or some such. I have been using "Yahoo as JSON"
> for as long as that has been around, with no problems.
> Maybe I'll need to install the latest Perl or something like that. How
> tedious.
>
>
>
> -
> Ken Farley
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
Thanks, David. I just used the quote downloading in the 2.6 version I was running previously, on 2019-12-27 (Friday). After the update to 3.8 today, it no longer works. Running gnc-fq-dump yahoo_json amzn gets me nothing. Not even the date. I ran the gnc-fq-update module to try and get things working, but to no avail. That makes me think it's my Perl installation or something of the sort, since I don't hear any others screaming about it. I looked back through the old posts about this, but it always seemed to be an alphavantage difficulty, or some such. I have been using "Yahoo as JSON" for as long as that has been around, with no problems. Maybe I'll need to install the latest Perl or something like that. How tedious. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
GunCash 3.8 Builds from the tarball successfully on Linux Mint 19.3 Tina and installs without any problems (/usr/local) Thanks John and the team. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
Ken, I think you will find a number of posts in the last 6 months about updating the finace quotes which may help you with this. Search for finance quotes on the user forum should return them. If notit will be a new bug David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
I just updated from my previous 2.6 variant (can't recall the actual version, but it was near the end of the series). I cannot get any Finance::Quote data. Was using yahoo_json, but it doesn't work any more, not able to even get a quote for AMZN from gnc-fq-dump. Doesn't even return the date. Working on OS X (10.12.6, Sierra), by the way. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] HTML Chart exports are blank on MacOS/Windows browsers
Op maandag 30 december 2019 18:44:37 CET schreef Adrien Monteleone: > I’d think the optimum long term solution would be something along the lines > of generating a webp, png, or svg of the graph as part of the html > delivery. That would remove the js bloat folder. (I don’t see any reason to > have it generated on the fly each time with a now fixed set of data) Of > course, that means some work, so it would be an enhancement and not much of > a priority since it is easy enough to go the pdf route for now. You'd lose the interaction. Hovering the charts currently will provide more details on each data point. Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] HTML Chart exports are blank on MacOS/Windows browsers
Concerning PDF output, I am using Print then 'Print to File' with PDF chosen (not Postscript or SVG). I find I have to tinker with Page Setup and the Gnucash onscreen window size/shape to create a graph that fits nicely on a single page PDF (this is an Expenses bar chart). I normally run Gnucash at or near 'fullscreen' and the chart gets tiled across multiple pages unless I reduce the window size and change its shape to match the page orientation. Is it expected that the screen window affects the printing size/shape? That behavior is OK, but I would prefer to have the chart autofit onto a single page if that is possible. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deposit\Withdraw on one account, Increase\Decrease on others. Why?
Also, if you started with the wizard which creates some basic accounts for you, some of those would have been special types. Another example would be credit card accounts. You can create them as generic liability accounts but if you make them type ‘credit card’ there are special labels for those registers. I’m pretty sure Help documents each special type and the associated labels. (but I could be mistaken, I haven’t looked in some months. That info might be in the Guide instead.) Regards, Adrien > On Dec 30, 2019 w1d364, at 10:03 AM, ddhahn wrote: > > Oh wow. It was right in front of me the whole time! I guess my brain assumed > that since it was next to the chart of accounts that it had something to do > with that. > > Thank you! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] HTML Chart exports are blank on MacOS/Windows browsers
I’d think the optimum long term solution would be something along the lines of generating a webp, png, or svg of the graph as part of the html delivery. That would remove the js bloat folder. (I don’t see any reason to have it generated on the fly each time with a now fixed set of data) Of course, that means some work, so it would be an enhancement and not much of a priority since it is easy enough to go the pdf route for now. Regards, Adrien > On Dec 30, 2019 w1d364, at 9:37 AM, D via gnucash-user > wrote: > > I may be a little slow here, but it seems to me this is something of an edge > case. Isn't this analogous to sending an html file without including embedded > images? Very efficient; not very informative. > > Finally, from my perspective, a 100kb pdf is not a huge payload to be > sending, but I understand your situation may be different. > > David T. > > On December 30, 2019, at 4:06 AM, boldstripe > wrote: > > Christopher: Thanks, I confirm your method of making a Firefox webpage > creates an HTML version that works across platforms, at least from Linux to > MacOS. > > This could be useful if you really want HTML, but Firefox stores the > javascript code in a folder that is 772 kB, compared to about 8 kB for the > platform-specific HTML and about 100 kB for a PDF. > > I will study how to contribute to documentation, thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deposit\Withdraw on one account, Increase\Decrease on others. Why?
Oh wow. It was right in front of me the whole time! I guess my brain assumed that since it was next to the chart of accounts that it had something to do with that. Thank you! -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deposit\Withdraw on one account, Increase\Decrease on others. Why?
On Mon, Dec 30, 2019 at 7:25 AM ddhahn wrote: > I guess my question then is how does gnucash know an account is a bank > account vs a generic asset account? The accounts I'm referring to are indeed > bank accounts so I'd want to have that reflected in gnucash, if possible. I > don't recall specifying that one of them is a bank account and the rest are > generic asset accounts.. If you open the "Edit Account" view (where the name, description, parent account, and so on are also entered) you will see a choice of “Account Type”. Note that the available account types are also constrained by the parent account — for example, you cannot make an Expense account that is a child account of an Asset placeholder account. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] HTML Chart exports are blank on MacOS/Windows browsers
I may be a little slow here, but it seems to me this is something of an edge case. Isn't this analogous to sending an html file without including embedded images? Very efficient; not very informative. Finally, from my perspective, a 100kb pdf is not a huge payload to be sending, but I understand your situation may be different. David T. On December 30, 2019, at 4:06 AM, boldstripe wrote: Christopher: Thanks, I confirm your method of making a Firefox webpage creates an HTML version that works across platforms, at least from Linux to MacOS. This could be useful if you really want HTML, but Firefox stores the javascript code in a folder that is 772 kB, compared to about 8 kB for the platform-specific HTML and about 100 kB for a PDF. I will study how to contribute to documentation, thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deposit\Withdraw on one account, Increase\Decrease on others. Why?
Adrien Monteleone-2 wrote > Deposit/Withdraw are used for bank accounts. Generic asset accounts use > Increase/Decrease. There might be other special accounts besides bank > accounts with their own context labels, but I don’t know because I use > formal labels. > > It doesn’t make much sense to ‘deposit’ into, or ‘withdraw’ from, an asset > account that tracks, say—the value of your home. > > The only way (without custom programming) to get the same column headings > is to use formal labels. (they really aren’t that bad once you learn how > they work. I prefer them) > > Regards, > Adrien Thanks for the reply! I guess my question then is how does gnucash know an account is a bank account vs a generic asset account? The accounts I'm referring to are indeed bank accounts so I'd want to have that reflected in gnucash, if possible. I don't recall specifying that one of them is a bank account and the rest are generic asset accounts.. You're right, though, I could also just use the standard headings and get used to it :) Thanks --dave -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deposit\Withdraw on one account, Increase\Decrease on others. Why?
Deposit/Withdraw are used for bank accounts. Generic asset accounts use Increase/Decrease. There might be other special accounts besides bank accounts with their own context labels, but I don’t know because I use formal labels. It doesn’t make much sense to ‘deposit’ into, or ‘withdraw’ from, an asset account that tracks, say—the value of your home. The only way (without custom programming) to get the same column headings is to use formal labels. (they really aren’t that bad once you learn how they work. I prefer them) Regards, Adrien > On Dec 29, 2019 w1d363, at 10:47 PM, ddhahn wrote: > > Hi all, > > I'm a pretty new user to gnucash and am getting settled in. I've searched > the list for the answer to this. I found similar questions but nothing that > lead me to an answer. > > I've noticed that one of my asset accounts has deposit\withdraw columns > while my other asset accounts have increase\decrease columns. I can't figure > out why this is and where I might changed it so that all the asset accounts > have the deposit\withdrawl nomenclature. > > The "Use formal accounting" names setting changes everything to > debit\credit, so that's not it. > > Thanks for all your help and for supporting this great project! > > --dave ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
