Re: [GNC] Import transactions with expenses in a different currency
I had similar problems and I solved it by turning on "trading accounts" . This way there are no exchange rates involved in individual transactions, but instead each transaction is balanced to a currency trading account. To correct any existing transactions I then had to click on it and accept gnucash auto correction, I don't know if that can be done with one global correction or not. Either way don't turn on trading accounts before you read up on it as it is quite fundamental and not reversabel as far as I known,and if you do decide it is for you, at least take a backup before trying it out. On Tue, 8 Sep 2020, 15:44 andrepd via gnucash-user, < gnucash-user@gnucash.org> wrote: > In the latest version of gnucash (4.1-2 from flathub) I noticed that, when > importing transactions in .ofx/.csv into a GBP-denominated bank account, > and > matching them to expense accounts in EUR, I get the following error > message: > > The account 'Electronics' has a different commodity from the one > required, > Pound Sterling. Please choose a different account. > > Now, I haven't seen that error message before, when importing my > transactions, > so I'm assuming this behaviour changed recently. However, I also realised > that, for all the transactions like this that I imported in the past (when > that message didn't appear), that the exchange rate used was always > 1GBP => 1EUR! This is also not good for me. > > So I have two questions: > > * How do I import transactions where the debits and credits are in > different > currencies (in this example, I have a debit from a GBP bank account and a > credit to an EUR expense account)? This should ideally use the correct > exchange rate from the price database. > > * How do I fix the exchange rates for the previous transactions, without > going > manually through _thousands_ of transactions and going `right-click > > edit exchange rate > paste > OK`? I have the correct historical exchange > rates, > for the period where the transactions took place, entered in the price > database, so I'd like to use the "most-recent-at-transaction-date" exchange > rate. I don't see how I can do this for all transactions, and doing so > manually > for 2 years worth of transactions would take upwards of 8 or 9 hours I > reckon. > Perhaps a python script could do it (or even edit the xml directly, I don't > know)? > > Thanks for the help. > > > > > -- > 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.
[GNC] Short cuts for things
Is there a quick way to: Get to the 'Accounts' tab, in order to select the next account for entering a transaction. 'Enter' a transaction - i.e. a key to hit instead of having to click on the + sign. -- Chris Green ___ 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] Finance quote troubleshooting
Dear Sir, I have been having some trouble retrieving currency quotes from Perl using Finance::Quote. I am only interested in currency exchange rates (have not attempted using anything else). I have been going through all steps of the wiki, such as running "Install online price Retrieval", even changing my alpha-vantage key by requesting a new one. I have also tried to get quotes from outside gnucash by using the terminal with the following result " C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --quotes get file://C:\Users\EoL\Documents\gnuCash\test\test.gnucash Found Finance::Quote version 1.49. * 14:35:49 WARN Unable to retrieve quotes for these items: CURRENCY:USD CURRENCY:EUR Continuing with good quotes. " In my attempts to get a single exchange rate from the terminal I get the following results " C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency EUR GBP 1 EUR = GBP " I would like to ensure that I have tried using both API keys in the appropriate "online quote" in the preferences settings, but every time I try to get quotes I get an error with "unable to retrieve quotes for these items: Currency: USD, Currency:EUR" I am currently using F::Q v1.49, and gnucash v4.1 Thank you for your time and all your support Kind Regards DNR ___ 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] Can't input alphabet under Windows 10 (Japanese)
Hello. I'm using Gnucash with Japanese enviroment under Windows 10. From version 4.0, I can't input alphabet due to this bug. https://bugs.gnucash.org/show_bug.cgi?id=797860 This bug is critical for me. MinGW-w64's GTK+ package is updated to version 3.24.23. https://packages.msys2.org/package/mingw-w64-x86_64-gtk3?repo=mingw64 But maint branch build log shows Gnucash is built with GTK+ version 3.24.20 that contains problem. Of course, I tried the newest maint build and found that bug occured. Should I build Gnucash from source? Thanks for the help. ___ 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] Is there an 'easy' way to have a transaction with 'sub-transactions' as it were?
On 9/8/2020 5:25 PM, Adrien Monteleone wrote: Yes, View > Transaction Journal Now all transactions in that register will always show all splits. It is not only helpful when learning GnuCash, but I use it exclusively because I don't want to have to click each transaction to see the splits. Less clicking, more visual inspection. The layout is also, to me, less cluttered looking, even though more info is on the screen. The 'Auto Split' view only shows them when it is selected, but saves you having to click to see the splits explicitly like in Basic view. Also consider View > Double Line which will add make the Notes field visible. I like to use Notes for comments about the entire transaction and Memos where info is specific just to that split line. Just to explain to those who never learned old fashioned pen and ink on paper bookkeeping. THIS is what the transaction would look like in the "journal". A date ordered record of transactions. They would then be "posted" to the ledger, where only the part affecting that account visible. Gnucash allows you to enter transactions directly into the ledger from any of the accounts affected by that transaction (always at least two, this is double-entry bookkeeping). The journal is virtual. But as Adrien indicated, gnucash will show you the transaction in that view of you ask it to. Michael D Novack ___ 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] Be careful with `petty cash'
On 9/8/2020 11:32 PM, Adrien Monteleone wrote: I've seen suggestions in accounting texts (and use myself) an account called 'Undeposited Funds' as a Current Asset. Checks and currency destined to the bank (but not there yet) are recorded here when received. Regards, Adrien Yes, the term "petty cash" has traditionally had a different meaning. In a very small business, might actually be currency but in a large one likely its own bank account. And a subsidiary set of books. The idea was to reduce the load on the treasurer/chief accountant and not clutter the main books with trivial detail. In the petty cash books would be each transaction, each box of pencils, box of reams of paper, flowers for the boss's reception room, etc. Then say once a month the petty cash account would be "refreshed" with the total spent and each category of expense closed to the main books. Thus the parent "office supplies", "postage", etc. and not each box of pencils or roll of stamps. Michael D Novack ___ 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] Short cuts for things
On 9/9/20 7:07 AM, Chris Green wrote: Is there a quick way to: Get to the 'Accounts' tab, in order to select the next account for entering a transaction. I could be wrong, but I don't think there is one built-in. You might be able to set a custom accelerator for it. (see the wiki) However, you can use Ctrl+Alt+PgUp/PgDn to cycle through open tabs. (I find it odd that there isn't a built-in shortcut for the Accounts tab, or one for simply opening an account via a pop-up search from anywhere) If you are already on the Accounts tab, you can expand/collapse sections of the tree with +/- and navigate with the up/down arrows. Pressing Enter will open that register. If you keep *all* of the tree expanded, you can simply start typing the name of an account and GnuCash will search your tree for you, highlight the account and then you can simply press Enter to open it. 'Enter' a transaction - i.e. a key to hit instead of having to click on the + sign. When you open a register, you should automatically be in a blank transaction. (focus is on the date field) If you were editing or focused on a previous (or future) transaction and want to enter a new one, you can jump to the Blank Transaction via Shift+PgDn. There is also Preferences > Register > Actions > 'Enter' moves to blank transaction if you like. Regards, Adrien ___ 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] Be careful with `petty cash'
> On 9 Sep 2020, at 15:25, Michael or Penny Novack > wrote: > > On 9/8/2020 11:32 PM, Adrien Monteleone wrote: >> I've seen suggestions in accounting texts (and use myself) an account called >> 'Undeposited Funds' as a Current Asset. Checks and currency destined to the >> bank (but not there yet) are recorded here when received. >> >> Regards, >> Adrien > > Yes, the term "petty cash" has traditionally had a different meaning. In a > very small business, might actually be currency but in a large one likely its > own bank account. And a subsidiary set of books. The idea was to reduce the > load on the treasurer/chief accountant and not clutter the main books with > trivial detail. > > In the petty cash books would be each transaction, each box of pencils, box > of reams of paper, flowers for the boss's reception room, etc. Then say once > a month the petty cash account would be "refreshed" with the total spent and > each category of expense closed to the main books. Thus the parent "office > supplies", "postage", etc. and not each box of pencils or roll of stamps. > > Michael D Novack In my past life as an NHS GP, most of our income came from our NHS contracts, but we received some income directly from patients for non-NHS work such as foreign travel immunisation, certificates and employment-related examinations (e.g. for heavy goods vehicle drivers). We recorded this in a petty-cash book and a cheques-received book. Drawings from petty cash for sundries and refreshments seldom exceeded the contents of the cash box, which was being topped up by cash income with the excess being periodically paid into the bank along with incoming cheques. Our accountant never complained about this way of working, so I assumed it was acceptable. In the context of a small Rotary Club, cash income is received at community events and there rarely a need for cash expenditure on the day. Occasionally, though, someone has to nip out for supplies part of the way through an event, and it’s convenient to be able to deal with that in cash on the day. This probably won’t be an issue for Chris Green, who would be better served by an Undeposited Funds asset account. Regards, Michael Hendry ___ 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] reindex?
Fedora 32 gnucash-4.1-1.fc32.x86_64 Without going into the particulars of why, is there a way to re-index the database on one of my accounts? Or is there some integrity check on the data that I can run? ___ 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] Negative numbers
Fedora 32 gnucash-4.1-1.fc32.x86_64 I have a number of program that accept negative numbers with the minus sign at the end `123.45-` or inside parenthesis `(123.56)`. Is there a way to tell GnuCash to do this also? I keep entering it the other way and having to go back and put the minus sign in the front. Many thanks, -T ___ 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] Short cuts for things
On 2020-09-09 09:36, Adrien Monteleone wrote: > ... > However, you can use Ctrl+Alt+PgUp/PgDn to cycle through open tabs. > ... > If you are already on the Accounts tab, [and] > If you keep *all* of the tree expanded, you can simply start typing the > name of an account and GnuCash will search your tree for you, highlight > the account and then you can simply press Enter to open it. Thanks for these, Adrien! Both are new to me, and both are helpful. (I'm sure they're in the manual, but it's a while since I read it and somehow I didn't start using those shortcuts so they dropped out of my memory. So the reminder is nice!) -- Regards, Stan Brown Tehachapi, CA, USA https://BrownMath.com https://OakRoadSystems.com ___ 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] Short cuts for things
Another trick that I accidentally discovered is to hover in the account tab bar then with the mouse wheel you can scroll quickly through the open tabs.. I think down goes right and up goes left, but I have trouble remembering that part when it is so easy to switch directions I suppose that might change if you put your tab bar on the side anyway. On Wed, Sep 9, 2020 at 1:05 PM Stan Brown wrote: > > On 2020-09-09 09:36, Adrien Monteleone wrote: > > ... > > However, you can use Ctrl+Alt+PgUp/PgDn to cycle through open tabs. > > ... > > If you are already on the Accounts tab, [and] > > If you keep *all* of the tree expanded, you can simply start typing the > > name of an account and GnuCash will search your tree for you, highlight > > the account and then you can simply press Enter to open it. > > Thanks for these, Adrien! Both are new to me, and both are helpful. > > (I'm sure they're in the manual, but it's a while since I read it and > somehow I didn't start using those shortcuts so they dropped out of my > memory. So the reminder is nice!) > > -- > Regards, > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com > https://OakRoadSystems.com > ___ > 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. > -- David Carlson ___ 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] Short cuts for things
On 2020-09-09 11:26, David Carlson wrote:
> Another trick that I accidentally discovered is to hover in the account
> tab bar then with the mouse wheel you can scroll quickly through the
> open tabs.. I think down goes right and up goes left, but I have trouble
> remembering that part when it is so easy to switch directions I suppose
> that might change if you put your tab bar on the side anyway.
Presumably, then, up would go up and down would go down. :-)
{pause to check}
Yes, it does (or they do). That particular one isn't my fave because I
try to do as much as possible on the keyboard, but it's still interesting.
--
Regards,
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
https://OakRoadSystems.com
___
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] Short cuts for things
I often use ctrl+i tab,tab to get to the entry box (it would be nice if it
defaulted to that) and then start typing. This quickly limits to matching
accounts, then it is easy to tab again and hit enter to go to the account.
Written out like this it sounds like a lot of work but in practice I find
it is quick.
David
On Wed, 9 Sep 2020, 19:37 Stan Brown, wrote:
>
> On 2020-09-09 11:26, David Carlson wrote:
> > Another trick that I accidentally discovered is to hover in the account
> > tab bar then with the mouse wheel you can scroll quickly through the
> > open tabs.. I think down goes right and up goes left, but I have trouble
> > remembering that part when it is so easy to switch directions I suppose
> > that might change if you put your tab bar on the side anyway.
>
> Presumably, then, up would go up and down would go down. :-)
>
> {pause to check}
>
> Yes, it does (or they do). That particular one isn't my fave because I
> try to do as much as possible on the keyboard, but it's still interesting.
>
> --
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.com
> ___
> 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] reindex?
Actions > Check & Repair > then: Check & Repair All Check & Repair Account Check & Repair Subaccounts if you are viewing the accounts tab, otherwise, if viewing a particular register: Check & Repair All transactions Check & Repair this transaction as you think you need. Note, Check & Repair All should be done when upgrading between major versions after first opening the data file in the higher version, like from 3.x > 4.x. But if you haven't done so yet, it would be good to go ahead with that now. Of course, always have a backup file handy just in case something goes wrong or unexpectedly. Regards, Adrien On 9/9/20 12:28 PM, ToddAndMargo via gnucash-user wrote: Fedora 32 gnucash-4.1-1.fc32.x86_64 Without going into the particulars of why, is there a way to re-index the database on one of my accounts? Or is there some integrity check on the data that I can run? ___ 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] Negative numbers
Not that I'm aware of, but just tab or shift-tab to the other column. A negative credit is a positive debit and vice versa. If you try entering a negative, you'll see GnuCash moves it to the other column as a positive anyway. Regards, Adrien On 9/9/20 12:31 PM, ToddAndMargo via gnucash-user wrote: Fedora 32 gnucash-4.1-1.fc32.x86_64 I have a number of program that accept negative numbers with the minus sign at the end `123.45-` or inside parenthesis `(123.56)`. Is there a way to tell GnuCash to do this also? I keep entering it the other way and having to go back and put the minus sign in the front. ___ 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] Short cuts for things
Thanks David. I recalled there was some sort of account search but couldn't remember how to bring it up. (I don't think it has a menu entry) This does help find matching accounts, but it does require a few extra keys to open the desired register. However, it is accessible from anywhere (not just the Accounts tab) and you don't have to have your account tree entirely expanded. With a little practice one can quickly open the desired account. (note, that would be cmd+i on a Mac, and it would be nice if the focus were automatically in the search box and if hitting Enter after selecting the account would just open the register rather than bringing you to the Accounts tab) Regards, Adrien On 9/9/20 1:41 PM, david whiting wrote: I often use ctrl+i tab,tab to get to the entry box (it would be nice if it defaulted to that) and then start typing. This quickly limits to matching accounts, then it is easy to tab again and hit enter to go to the account. Written out like this it sounds like a lot of work but in practice I find it is quick. ___ 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] Negative numbers
You may also enter an enhancement request in bugzilla. On 9/9/20 1:05 PM, Adrien Monteleone wrote: > Not that I'm aware of, but just tab or shift-tab to the other column. > A negative credit is a positive debit and vice versa. If you try > entering a negative, you'll see GnuCash moves it to the other column > as a positive anyway. > > Regards, > Adrien > > On 9/9/20 12:31 PM, ToddAndMargo via gnucash-user wrote: >> Fedora 32 >> gnucash-4.1-1.fc32.x86_64 >> >> I have a number of program that accept negative numbers >> with the minus sign at the end `123.45-` or inside >> parenthesis `(123.56)`. >> >> Is there a way to tell GnuCash to do this also? I >> keep entering it the other way and having to go back >> and put the minus sign in the front. > > ___ > 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. -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ 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] Finance quote troubleshooting
> On Sep 9, 2020, at 6:44 AM, Andreas Vyrides wrote: > > Dear Sir, > > I have been having some trouble retrieving currency quotes from Perl using > Finance::Quote. I am only interested in currency exchange rates (have not > attempted using anything else). I have been going through all steps of the > wiki, such as running "Install online price Retrieval", even changing my > alpha-vantage key by requesting a new one. I have also tried to get quotes > from outside gnucash by using the terminal with the following result > > " > > C:\Program Files (x86)\gnucash\bin>gnucash-cli.exe --quotes get > file://C:\Users\EoL\Documents\gnuCash\test\test.gnucash > Found Finance::Quote version 1.49. > * 14:35:49 WARN Unable to retrieve quotes for these items: > CURRENCY:USD > CURRENCY:EUR > Continuing with good quotes. > > " > > In my attempts to get a single exchange rate from the terminal I get the > following results > > " > > C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency EUR GBP > 1 EUR = GBP > > " > > I would like to ensure that I have tried using both API keys in the > appropriate "online quote" in the preferences settings, but every time I try > to get quotes I get an error with "unable to retrieve quotes for these items: > Currency: USD, Currency:EUR" > > I am currently using F::Q v1.49, and gnucash v4.1 > > Thank you for your time and all your support Have you read https://wiki.gnucash.org/wiki/Online_Quotes, in particular https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting? Regards, John Ralls ___ 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.
