Re: [GNC] Problems with Finance::Quote and GnuCash Version: 5.0 Build ID: 5.0+(2023-03-25)

[Alun Champion]

I was also having this same problem on my M1 Mac when upgrading to Gnucash
5+ (it worked fine in 4.X). After some digging it looks like my environment
meant that gnucash 5+ was using the wrong version of cpan for the perl it
was using (there are 2 installed by default - 5.3 and 5.34, I also had 5.36
installed by HomeBrew) and I saw the logs JSON::Parse was missing but
gnc-fq-update was reporting it up-to-date.

Fixing the environment
(/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment)
meant that it started working however I was now getting this error:

* NASDAQ:GOOGL Finance::Quote reported failure with error: Error retrieving
quote for GOOGL. Attempt to fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/GOOGL?modules=price,summaryDetail,defaultKeyStatistics
resulted in HTTP response 501 (Not Implemented)

When you paste the URL directly into a browser
https://query2.finance.yahoo.com/v11/finance/quoteSummary/GOOGL?modules=price,summaryDetail,defaultKeyStatistics
it works fine.

I had chosen to use the homebrew Perl, I found that Net::SSLeay was not
installed correctly which was causing LWP::Protocol::https to fail, after
fixing (brew install openssl) everything was working again. I'm assuming
that it was silently falling back to http which was causing the 501.

Not sure if this helps anyone

On Thu, Mar 30, 2023 at 1:31 AM Outlook  wrote:

> I have the same problem with quote update on version 5.0, and now I have
> to return back to version 4.13 and it works fine.
>
> Some quotes from Taiwan stock, for example 0050.TW updated from Yahoo as
> JSON on macOS 13.3/
>
> Thanks!
>
> > David G. Pickett via gnucash-user  於
> 2023年3月29日 上午7:30 寫道：
> >
> > Poking aroun more, I see in Edit Security DIA it says "Warning: Finance
> Quote is not installed properly.".
> >
> > Checking my cron job log, it says:
> >
> > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get
> /home/dgp/GnuCash/ubuntu-DGPickett.gnucashF: X11 socket /tmp/.X11-unix/X0
> does not exist in filesystem, trying to use abstract socket instead.Missing
> data file parameter
> > gnucash-cli [options] [datafile] - GnuCash, accounting for personal and
> small business finance:
> > Common Options:  -h [ --help ]  Show this help message  -v [
> --version ]   Show GnuCash version  --debugEnable
> debugging mode: provide deep detail in the  logs.
>This is equivalent to: --log "=info" --log
> "qof=info"  --log "gnc=info"  --extra
>   Enable extra/development/debugging features.  --log arg  Log
> level overrides, of the form
> "modulename={debug,info,warn,crit,error}" Examples:
> "--log qof=debug" or "--log  gnc.backend.file.sx=info"
>This can be invoked multiple times.  --paths
> Show paths  --logto argFile to log into; defaults to
> "/tmp/gnucash.trace";  can be "stderr" or "stdout".
> > Price Quotes Retrieval Options:  -Q [ --quotes ] argExecute price
> quote related commands. The following  commands are
> supported.info: Show
> Finance::Quote version and exposed quote
> sources.get: Fetch current quotes for all
> foreign  currencies and stocks in the given
> GnuCash  datafile.
>  dump: Fetch current quotes for specified currencies
>   or stocks from a specified namespace and print
>  the results to the console.
>  This must be followed with a source and one or
>  more symbols, unless the source is "currency"
> in which case it must be followed with two or
> more symbols, the first of which is the
>   currency in which exchange rates for the rest
>   will be quoted.   --namespace arg
> Regular expression determining which namespace
> commodities will be retrieved for when using the get
>   command  -V [ --verbose ]   When using the dump command list all of
> the parameters Finance::Quote returns for the
> symbol instead of the  ones that Gnucash requires.
> > Report Generation Options:  -R [ --report ] argExecute report
> related commands. The following  commands are
> supported.list: Lists
> available reports.   show: Describe the options
> modified in the named  report. A datafile
> may be specified to  describe some saved
> options.   run: Run the named report in the given
> GnuCash datafile.
>  --name arg Name of the report to run
>  

Re: [GNC] Gnucash on MacOS 12.5 ?

[Alun Champion]

I run Gnucash on Apple MBP M1.
I don't recall what I did to make Finance::Quote work but it has been
working for quite a while.
I do have an issue with mouse clicks going through windows requiring a
couple of clicks before registering on the correct window.
But other than that working fine.

(If anyone knows how to fix the clicking through windows - that would be
greatly appreciated).

On Mon, Oct 24, 2022 at 6:24 PM Ken Farley  wrote:

> I wrote a long post a bit ago when I first got my M1 based Mac and I had
> to wrestle with getting Finance:Quote to work. I scoured the internet
> and managed to put together a method for fixing it, that I also added to
> the Wiki.
>
> It's nice that folks put all their findings on how to fix stuff in the
> Wiki, gives a good place to shop for solutions. I'll have to take a look
> at the formatting stuff sometime.
> ___
> 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.

[GNC] Account Selection in Register

[Alun Champion]

If I type an account name from the beginning e.g. Assets:...: I have it
configured to not auto-raise lists so the account list doesn't popup and I
can type the account without any issues (using tab to complete).

However, if I type a leaf account name the account list popups up but it
starts flashing and I can't type any new characters or select an account
from the list (just asks if I want to create a new account). If I
repeatedly hit keys then every 10th or so key may get taken but as you can
imagine this is unusable and very frustrating as it is hard to back out of.

I've used this leaf matching previously, but it has been an issue with 4.8
and I'm updated to 4.8-2 and no luck.

I'm on a Mac (Big Sur) running 4.8-2.

Anyone know if there is a way to configure it to not to try and match leaf
accounts, or fix the UI issue?
Cheers
   -A.
___
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] AlphaVantage deal

[Alun Champion]

Any reason not to move to the batch API (`
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,AXP,...=XXX`)
then
you could get all the current quotes with a single call. It seems
inefficient to get the stock history one stock at a time to discard all the
values but the first one to get the current quote.
   -A.

On Thu, 23 Aug 2018 at 12:22, floppy5.25  wrote:

> On Thursday, August 23, 2018 10:51:32 AM -05 Ethan Swint wrote:
> > I recently inquired with AlphaVantage about providing something between
> > their free 1 quote/20 seconds and their $20/month offering of 1 request
> / 4
> > seconds with premium support.
> >
> > I think most users here are on the once-a-day sync between GnuCash and
> the
> > markets, so I proposed a tier that would provide 128 queries/day at 2
> > queries/second before dropping back down to the free level of 1 quote /
> 20
> > seconds for a monthly fee of USD$5/month. AlphaVantage expressed
> > willingness to provide something along those lines - what do you folks
> > think? Would this be something worth $5/mo, $10/mo, or are most users
> happy
> > at the free levels?
> >
> > Regards,
> > Ethan
>
> I would gladly pay $10/mo for reliable quotes as long as I can get a wide
> range of sources. Many funds that I use are not supported by AlphaVantage.
>
> My $0.2
>
>
> ___
> 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.

[GNC] Register issues within 3.2

[Alun Champion]

OS: MacOS
Version: Gnucash 3.2

After pasting (Cmd-V) data into a register the register will no longer
receive normal keyboard input, just the annoying keyboard beep.

Enter still works, as does tab but no data entry from the keyboard in any
field in the register for that account. Other registers for other accounts
continue to receive input (unless you paste something into that register).

This is very annoying because I often paste data from online account data.
   -Alun.
___
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] autocomplete not working in 3.2

[Alun Champion]

I can confirm 3.2 has issues with completion on MacOS.
When typing in the register description the first letter completes but the
next letter inserts vs replaces the proposed completion, so if you intended
`commute`, `c` would complete to `car` and the next key would end up with
`coar`, which isn't the intended behaviour.

Also I've had an issue occur multiple times where it would start not
accepting any normal keyboard input in any field of the register, and need
to restart the application. (Note: cut and paste still works).

Regards
   -Alun.


On 4 July 2018 at 18:45, John Ralls  wrote:

> This problem has been reported in the bug tracker as
> https://bugs.gnucash.org/show_bug.cgi?id=796734.
>
> For a workaround one can rename or remove Gnucash.app/Contents/
> Resources/lib/gtk-3.0/3.0.0/immodules.cache. Note that that will break
> the use of input modules so one will no longer be able to work in Asian
> languages that require input modules.
>
> Regards,
> John Ralls
>
>
> > On Jul 3, 2018, at 8:30 PM, V. Vatsal via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > I am new to GnuCash, but I can confirm that autocomplete doesn’t work
> well on Mac OS. I would expect that typing “foo” would match
> “Expenses:Food” but it doesn’t match anything unless you type the whole
> string “expenses:foo” which rather defeats the purpose.
> >
> > Nike
> >
> >> On Jul 3, 2018, at 7:45 PM, Deane Yamane 
> wrote:
> >>
> >> I have the same problems. IMHO V3.x has been buggy from the start. Some
> nice features but not worth it. I think I’ll revert to 2.26(?) and wait
> till the ‘dust clears’ :(
> >>> On Jul 1, 2018, 2:34 AM -1000, Michael Matz ,
> wrote:
> >>> I just upgraded from 3.0 to 3.2. macOs 10.13.5
> >>>
> >>> (I skipped 3.1 because 3.0 has worked well for me, with the limited
> set of
> >>> features I use.)
> >>>
> >>> When I enter a new transaction, I type the first letter in the
> description
> >>> column and GnuCash makes a suggestion but if I continue typing the
> >>> suggestion is not updated or replaced.
> >>>
> >>> For example, if I type "F" the description becomes "Food". If I then
> type
> >>> "a" then the description becomes "Faood". Or typing "Fo" becomes
> "Foood"
> >>> This worked as expected in 3.0 and previous versions, i.e. typing "Fa"
> >>> results in "Fa" (no suggestion) and typing "Fo" result in "Food".
> >>>
> >>> The same thing happens in the Transfer column
> >>>
> >>> Anybody else having this problem?
> >>>
> >>> I've switched back to 3.0 for now.
> >>>
> >>> Thanks,
> >>> Michael
> >>> ___
> >>> 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.
> > ___
> > 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.
>
___
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.

[GNC] Stock accounts displaying fractions

[Alun Champion]

Since the upgrade to 3.1 some of my stock accounts are displaying in
fractions.
Anyway to simply turn this back to decimal?
Cheers
   -A.
___
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] AlphaVantage Stock Quotes

[Alun Champion]

Hmm, that has not been my observation but I'm sure there are some nuances,
for me it shows the last price during the trading day (as in it doesn't
show after market prices) but the call can happen any time, e.g. here is
the demo linl:
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT,FB,AAPL=demo
and it shows MSFT, FB as of 16:01 yesterday. This is the same when I use my
API Key.
   -A.

On 2 June 2018 at 10:21, John Ralls  wrote:

> It’s only live when that particular issue is trading; e.g. for a US stock
> between 0930 and 1600 Eastern Time. That makes it unsuitable for F::Q.
>
> Regards,
> John Ralls
>
>
> > On Jun 2, 2018, at 6:12 AM, Alun Champion  wrote:
> >
> > Alphavantage does provide a batch stock api, which you only sends the
> > latest quote, you can send just one stock to that api call e.g. (
> > https://www.alphavantage.co/query?function=BATCH_STOCK_
> QUOTES=MSFT=),
> > which only returns the latest value.
> >-A.
> >
> > On 31 May 2018 at 20:12, prl  wrote:
> >
> >> On 31/05/2018 12:59, Dave Tapuska wrote:
> >>
> >>>> From the gnucash point of view it only uses the latest quote so even
> >>> returning the compact list (which is the last 100 days) is far
> overkill.
> >>> Perhaps a lighter weight request returning the last closing value
> would be
> >>> sufficient.
> >>>
> >> That would be ideal, but as far as I can see, the compact list (last 100
> >> days) is the smallest amount of data that can be requested using the
> >> TIME_SERIES_DAILY function in the AlphaVantage API <
> >> https://www.alphavantage.co/documentation/>. The only alternative in
> the
> >> documentation is full, which returns daily opening and closing prices
> for
> >> up to the last 20 years.
> >>
> >> Peter
> >>
> >>
> >> ___
> >> 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.
>
>
___
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] latest gnucash release (3.1) feedback

[Alun Champion]

I'm using a custom date.
And flipping back between 2.6.21 and 3.1 that date is lost (in both
directions).
   -A.

On 2 June 2018 at 09:36, Adrien Monteleone 
wrote:

> Nice find.
>
> On the report start date issue, are you using a specific custom date or
> one of the presets?
>
> Mine are all set to ’start of accounting period’ and my book’s accounting
> period is set to ’start of current year’. I’m not seeing any loss of start
> dates.
>
> Perhaps some other date setting is where the issue lies.
>
> Regards,
> Adrien
>
> > On Jun 2, 2018, at 7:29 AM, Alun Champion  wrote:
> >
> > Thank you all, this gave me enough information to track down and create
> > custom styling, having the tabs down the left side meant all the top and
> > bottom margin and padding was just wasted space.
> >
> > Note: One minor issue I found when switching between 2.6.21 and 3.1 is
> that
> > any open reports seems to lose the start date, no idea why.
> >
> > I’m on a Mac, was able to run the gtk3 inspector by running
> > GTK_DEBUG=interactive
> > /Applications/Gnucash.app/Contents/MacOS/Gnucash from the command line,
> > which shows the various css nodes (and you can experiment with the
> > styling). And created a ~/Library/Application\
> Support/Gnucash/gtk-3.0.css
> > for tight tabs:
> >
> > notebook tab {
> >  min-height: 0px;
> >  margin-top: 0px;
> >  margin-bottom: 0px;
> >  padding-left: 0px;
> >  padding-right: 0px;
> > }
> >
> > notebook tab box {
> >  padding-top: 2px;
> >  padding-bottom: 2px;
> > }
> >
> > I was also able to change the colors in the reports by changing the
> > base_colors in
> > /Applications/Gnucash.app/Contents/Resources/share/
> gnucash/scm/html-utilities.scm
> > .
> > ​
> >
> > On 30 May 2018 at 07:07, Mike Evans  wrote:
> >
> >> On Wed, 30 May 2018 10:00:56 +0100
> >> Mike Evans  wrote:
> >>
> >>> On Wed, 30 May 2018 00:12:00 -0500
> >>> Alun Champion  wrote:
> >>>
> >>>> MacOS High Sierra, Gnucash 3.1-3.
> >>>>
> >>>> If anyone finds a way for reducing the padding around the tabs (left),
> >> I
> >>>> would be very interested. 3.1 uses almost twice as much space as
> >> 2.6.X. I
> >>>> keep a number of tabs open (reports, accounts, registers, etc.) and
> >> this
> >>>> comfortably fits on the screen now in 3.1 this forces scrolling. The
> >> arrows
> >>>> to scroll up and down are particularly slow and with also losing the
> >>>> ability to scroll the tabs then this becomes very awkward.
> >>>> Also it seems the stylesheets aren't working - or at a minimum there
> >> are no
> >>>> color changes between the stylesheets and the new colours are quite
> >> 'prime'.
> >>>> Changing settings also seems to be very slow, with quite a lag between
> >>>> selecting an option and for the tick to appear or disappear.
> >>>>
> >>>> I guess I will need to figure out how to change the styles - colours
> >> and
> >>>> fonts - default fonts for 2.6.X worked fine for me but the new fonts
> >> are
> >>>> too spidery.
> >>>>
> >>>> But still a fantastic piece of software - thank you all for such great
> >> work.
> >>>>-A.
> >>>>
> >>>
> >>> There's a theme here that helps a little.
> >>> https://www.gnome-look.org/p/1179399/
> >>>
> >> I went with Adwaita-Slim https://www.gnome-look.org/p/1181146/ after a
> >> little testing.
> >>
> >> If you want even narrower notebook tabs, edit
> >>
> >> ~/.themes/Adwaita Slim/gtk-3.0/gtk.css
> >>
> >> Search for "tabs" or "notebook"
> >>
> >> Mike E
> >>
> > ___
> > 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.
>
___
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] AlphaVantage Stock Quotes

[Alun Champion]

Alphavantage does provide a batch stock api, which you only sends the
latest quote, you can send just one stock to that api call e.g. (
https://www.alphavantage.co/query?function=BATCH_STOCK_QUOTES=MSFT=),
which only returns the latest value.
-A.

On 31 May 2018 at 20:12, prl  wrote:

> On 31/05/2018 12:59, Dave Tapuska wrote:
>
>> >From the gnucash point of view it only uses the latest quote so even
>> returning the compact list (which is the last 100 days) is far overkill.
>> Perhaps a lighter weight request returning the last closing value would be
>> sufficient.
>>
> That would be ideal, but as far as I can see, the compact list (last 100
> days) is the smallest amount of data that can be requested using the
> TIME_SERIES_DAILY function in the AlphaVantage API <
> https://www.alphavantage.co/documentation/>. The only alternative in the
> documentation is full, which returns daily opening and closing prices for
> up to the last 20 years.
>
> Peter
>
>
> ___
> 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] latest gnucash release (3.1) feedback

[Alun Champion]

Thank you all, this gave me enough information to track down and create
custom styling, having the tabs down the left side meant all the top and
bottom margin and padding was just wasted space.

Note: One minor issue I found when switching between 2.6.21 and 3.1 is that
any open reports seems to lose the start date, no idea why.

I’m on a Mac, was able to run the gtk3 inspector by running
GTK_DEBUG=interactive
/Applications/Gnucash.app/Contents/MacOS/Gnucash from the command line,
which shows the various css nodes (and you can experiment with the
styling). And created a ~/Library/Application\ Support/Gnucash/gtk-3.0.css
for tight tabs:

notebook tab {
  min-height: 0px;
  margin-top: 0px;
  margin-bottom: 0px;
  padding-left: 0px;
  padding-right: 0px;
}

notebook tab box {
  padding-top: 2px;
  padding-bottom: 2px;
}

I was also able to change the colors in the reports by changing the
base_colors in
/Applications/Gnucash.app/Contents/Resources/share/gnucash/scm/html-utilities.scm
.
​

On 30 May 2018 at 07:07, Mike Evans  wrote:

> On Wed, 30 May 2018 10:00:56 +0100
> Mike Evans  wrote:
>
> > On Wed, 30 May 2018 00:12:00 -0500
> > Alun Champion  wrote:
> >
> > > MacOS High Sierra, Gnucash 3.1-3.
> > >
> > > If anyone finds a way for reducing the padding around the tabs (left),
> I
> > > would be very interested. 3.1 uses almost twice as much space as
> 2.6.X. I
> > > keep a number of tabs open (reports, accounts, registers, etc.) and
> this
> > > comfortably fits on the screen now in 3.1 this forces scrolling. The
> arrows
> > > to scroll up and down are particularly slow and with also losing the
> > > ability to scroll the tabs then this becomes very awkward.
> > > Also it seems the stylesheets aren't working - or at a minimum there
> are no
> > > color changes between the stylesheets and the new colours are quite
> 'prime'.
> > > Changing settings also seems to be very slow, with quite a lag between
> > > selecting an option and for the tick to appear or disappear.
> > >
> > > I guess I will need to figure out how to change the styles - colours
> and
> > > fonts - default fonts for 2.6.X worked fine for me but the new fonts
> are
> > > too spidery.
> > >
> > > But still a fantastic piece of software - thank you all for such great
> work.
> > > -A.
> > >
> >
> > There's a theme here that helps a little.
> > https://www.gnome-look.org/p/1179399/
> >
> I went with Adwaita-Slim https://www.gnome-look.org/p/1181146/ after a
> little testing.
>
> If you want even narrower notebook tabs, edit
>
> ~/.themes/Adwaita Slim/gtk-3.0/gtk.css
>
> Search for "tabs" or "notebook"
>
> Mike E
>
___
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: Currency Quotes

[Alun Champion]

Yes, I was looking at the F::Q Currencies.pm, unfortunately I’m not
proficient enough in Perl to do that confidently.

Alphavantage also has a the separate API for currencies which will be more
efficient because it only returns the current exchange rate (vs this daily
history for stocks), e.g.:

$ curl 
"[https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=GBP_currency=USD=XXX](https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=GBP_currency=USD=XXX)"

This API call also works for Crypto Currencies, e.g.:

$ curl 
"[https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=BTC_currency=USD=XXX](https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=BTC_currency=USD=XXX)"

It just happens that ‘function=TIME_SERIES_DAILY’ with ‘symbol=GBPUSD=X’
also returns currency exchange rates for daily history, e.g.:

$ curl 
"[https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=compact=GBPUSD=X=XXX](https://www.alphavantage.co/query?function=TIME_SERIES_DAILY=compact=GBPUSD=X=XXX)"

Which allowed gnc-fq-dump to work.
-A.

On 9 November 2017 at 03:51, Erik Colson <e...@ecocode.net> wrote:


> Alun Champion <l...@achampion.net> writes:
>
> > Alphavantage supports currencies, e.g.:
> >
> > $ export ALPHAVANTAGE_API_KEY=XXX
> > $ gnc-fq-dump alphavantage GBPUSD=X
> > Finance::Quote fields Gnucash uses:
> > symbol: GBPUSD=X <=== required
> >   date: 11/09/2017   <=== recommended
> >   currency: USD  <=== required
> >   last: 1.3139   <=\
> >nav:  <=== one of these
> >  price:  <=/
> >   timezone:  <=== optional
> >
> > Haven't quite figured out how to get Gnucash to use this yet.
>
> F::Q has a different API for currencies.  The source has to be moved to
> alphavantage which will probably be done next weekend.  Till then,
> GnuCash will probably not have currency rates anymore..
>
> best
> --
> erik colson
>
​
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Re: Currency Quotes

[Alun Champion]

Alphavantage supports currencies, e.g.:

$ export ALPHAVANTAGE_API_KEY=XXX
$ gnc-fq-dump alphavantage GBPUSD=X
Finance::Quote fields Gnucash uses:
symbol: GBPUSD=X <=== required
  date: 11/09/2017   <=== recommended
  currency: USD  <=== required
  last: 1.3139   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

Haven't quite figured out how to get Gnucash to use this yet.

On 5 November 2017 at 21:30, Plutocrat  wrote:

> gnucash-user-requ...@gnucash.org wrote on Monday, 06 November, 2017 05:14
> AM:
> > Please note that while AlphaVantage does appear to offer quite a bunch
> > of quotes, it doesn't seem to support funds nor currencies.
> >
> > I hope someone will come up with one or more sites offering those info
> > so I can work on that part too.  However, my freetime is sparse and I
> > already took some time I should have put on real world work.  So more
> > coding might take more time to happen...
>
> I've been using OpenExchangeRates for Currency rates. It works pretty
> well. Needs an API id too.
>
> https://openexchangerates.org/
>
> URL format is pretty simple to return info in json.
>
> https://openexchangerates.org/api/latest.json?app_id=
> 12372uyjhkjh123hk1h2k31
>
> P.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.

Re: Can gnucash add Virtual currency?

[Alun Champion]

I've setup digital currencies as regular commodities and haven't come
across any particular issues for my use.
Downloading exchange rates works, just set the Symbol to 'BTCUSD=X' and
source `alphavantage' (with APIKEY), e.g.:

$ export ALPHAVANTAGE_API_KEY=XX
$ ./gnc-fq-dump alphavantage BTCUSD=X
Finance::Quote fields Gnucash uses:
symbol: BTCUSD=X <=== required
  date: 11/09/2017   <=== recommended
  currency: USD  <=== required
  last: 7407.4077<=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

I work in USD so don't know if it an issue, if you use another currency,
e.g. BTCGBP=X it still reports the currency as USD but does return the
right exchange rate:

$ ./gnc-fq-dump alphavantage BTCGBP=X
Finance::Quote fields Gnucash uses:
symbol: BTCGBP=X <=== required
  date: 11/09/2017   <=== recommended
  currency: USD  <=== required
  last: 5639.0371<=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

On 8 November 2017 at 11:14, Kurt Padilla  wrote:

> Here's how someone did it:
> https://bitcointalk.org/index.php?topic=29884.msg549693#msg549693
>
> On Wed, Nov 8, 2017, 06:25 David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> > Technically, adding bitcoin as a security isn't the same as adding it as
> a
> > currency,  which the OP requested.
> > Gnucash bases its currencies list on the ISO standard, which does not
> > include bitcoin. That said, treating it like any other commodity should
> > work, except that the ongoing valuation will require manual entry.
> > David
> >
> >
> >   On Wed, Nov 8, 2017 at 13:55, 陳 志昌 wrote:   It
> can
> > be added in Security Editor as a user-defined currency.
> >
> > I know it's doable, but I never try this.
> >
> > Thank you, jctchen
> >
> > -Original Message-
> > From: gnucash-user [mailto:gnucash-user-bounces+jctchen=
> > outlook@gnucash.org] On Behalf Of 林威儒
> > Sent: Wednesday, November 8, 2017 12:37 AM
> > To: gnucash-user@gnucash.org
> > Subject: Can gnucash add Virtual currency?
> >
> > I need to use virtual currency in gnucash,like Bitcoin how can I add new
> > currency?
> > Thank you.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> >
> > https://eur01.safelinks.protection.outlook.com/?url=
> https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%
> 2Fgnucash-user=02%7C01%7Cjctchen%40outlook.com%
> 7Cedc5323fb4494e1031e108d52684f73b%7C84df9e7fe9f640afb435
> %7C1%7C0%7C636457274877633125=7Xiz8sH%2FHtwn0xeMb%
> 2BdSSu2bbsbHyqVtqeULk554blQ%3D=0
> > -
> > 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
> > 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
> > 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.
>
> --
>
> Sent from the Google Inbox Android app. GnuPG encryption available upon
> request.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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.