GNU Cash Transactions - Wiped Out

2017-11-09 Thread Roy Molepo
Greetings I have been using GNU Cash and processed transactions for 12 months. Today when I opened the Program all my processed transactions have been wiped out / disappeared. All balances are now ZEROS. How can I recover my processed transactions? Help will be highly APPRECIATED. Yours

Recording in KRW, Reporting in USD, Budgeting in USD

2017-11-09 Thread Scott
Hello everyone, I've been reading the forum and resources online, but I can't seem to find a situation that matches mine. I work for a human rights NGO in Seoul, South Korea, so all of my transactions are in KRW. That is, except for our USD drawdown payments from one of our donors in the US.

Re: Removal of unnecessary listed Account names

2017-11-09 Thread David Carlson
Where are you seeing the multiple account names? If you actually changed the names in your chart of accounts, there should not be accounts with the old names. Similarly, in the OFX, QIF and CSV imports, you should not see the old account names when matching transactions to existing. You will

Re: Finance-Quote 1.45 released!

2017-11-09 Thread rmcasali
Hi, I changed the YahooJSON module to use the new API variables and the new URL. It is attached for anyone who wants to test. It's not a very clean code, it's just an adaptation. Unfortunately, I do not know how to update the finance-quote. I hope it helps. Rafael Casali Em qua, 2017-11-08 às

Re: F::Q 1.40 uploaded

2017-11-09 Thread Fross, Michael
One mistake I made in my email was that I am running F:Q 1.45. I ran that command on another machine and not the one running GNUCash. My apologies for any confusion. Michael On Thu, Nov 9, 2017 at 4:14 PM, rosid wrote: > Michael Fross wrote > > Hello. Happy to if it

Re: F::Q 1.40 uploaded

2017-11-09 Thread rosid
Michael Fross wrote > Hello. Happy to if it helps. I'm running Windows 10 latest version. > > > *Checking my version of F:Q* > > D:\Users\Michael>ppm query finance-quote > ┌───┬─┬─┬──┐ > │ name │ version

Re: Removal of unnecessary listed Account names

2017-11-09 Thread John Ralls
> On Nov 9, 2017, at 11:56 AM, Cliff Williams wrote: > > Gents > > After a couple of weeks using GnuCash I made a mistake and renamed some > of my accounts. In fact in most cases just changed the name from > low-case to upper-case so that I could easily identify the

Re: Finance-Quote 1.44 released!

2017-11-09 Thread David Reiser
> On Nov 8, 2017, at 7:17 PM, davel...@mac.com wrote: > > Thanks for all your work on this. A symbol I cannot get to work is QREARX (a > TIAA-CREF mutual fund). > > https://finance.yahoo.com/quote/QREARX?p=QREARX > > I don't know if it's something wrong with AlphaVantage or Finance::Quote. >

Re: Finance-Quote 1.45 released!

2017-11-09 Thread Richard Ullger
On 08/11/17 20:36, Erik Colson wrote: > New version 1.45 of Finance-Quote is available with the following changes: > > * alphavantage > * more suffix - currency pairs added > * GBP and GBX divided by 100 Many thanks for your efforts. Stocks and bonds from the

Re: F::Q 1.40 uploaded

2017-11-09 Thread Fross, Michael
Hello. Happy to if it helps. I'm running Windows 10 latest version. *Checking my version of F:Q* D:\Users\Michael>ppm query finance-quote ┌───┬─┬─┬──┐ │ name │ version │ abstract │ area │

Re: F::Q 1.40 uploaded

2017-11-09 Thread Dave H
Do you really have a semi-colon at the end of your api key in the environment file ? If you’ve set it up in the environment file you shouldn’t need to set it up in the system and user environment variables also as I think Gnucash over-writes these values with what you have in the Gnucash

Removal of unnecessary listed Account names

2017-11-09 Thread Cliff Williams
Gents After a couple of weeks using GnuCash I made a mistake and renamed some of my accounts. In fact in most cases just changed the name from low-case to upper-case so that I could easily identify the headings. What's happened now is that when I import new data and begin to match the

Re: F::Q 1.40 uploaded

2017-11-09 Thread rosid
Michael Fross wrote > Hi Rosid, > > It's been working fine for me. What version of of F:Q are you using? > > I use Activestate Perl, so I can find the version with: *ppm query > finance-quote* > > I did have to manually upgrade as Activestate is still on v1.38. > > Michael Hi Michael, I'm

Re: F::Q 1.40 uploaded

2017-11-09 Thread Fross, Michael
Hi Rosid, It's been working fine for me. What version of of F:Q are you using? I use Activestate Perl, so I can find the version with: *ppm query finance-quote* I did have to manually upgrade as Activestate is still on v1.38. Michael On Thu, Nov 9, 2017 at 10:28 AM, rosid

Re: Finance-Quote 1.44 released!

2017-11-09 Thread Cam Ellison
On 09/11/17 01:37 AM, Erik Colson wrote: Cam Ellison writes: On 08/11/17 12:40 PM, Erik Colson wrote: Please list some symbols you tried. Here you go: CMI.V MBA.TO QST.V FCEL (on NASDAQ) Hi Cam, Please try again with F::Q v1.45. It does work on my system. So I

Re: Finance-Quote 1.44 released!

2017-11-09 Thread David T. via gnucash-user
Does the TIAA-CREF module not work? David > On Nov 9, 2017, at 7:31 PM, davel...@mac.com wrote: > > >> On Nov 9, 2017, at 4:46 AM, Erik Colson wrote: >> >> >> davel...@mac.com writes: >> >>> Thanks for all your work on this. A symbol I cannot get to work is QREARX >>> (a

Re: F::Q 1.40 uploaded

2017-11-09 Thread rosid
>I'm just trying this out now, but for windows, setting an environment >variable is easy. In control panel, select "SYSTEM" then "Advanced System >Settings" on the left. There is an environment variables button (poke >that). Has anybody been able to get this to work on Windows? I added the

Re: Mac OS

2017-11-09 Thread John Ralls
> On Nov 9, 2017, at 4:02 AM, Les wrote: > > I just updated my Mac to the latest version and now GC will not open. I get > a message that GC is incompatible with this version of Mac OS. > > Any workarounds or solutions? > > Running GC 2.6.17. Would 2.6.18 solve this

Re: Finance-Quote 1.45 released!

2017-11-09 Thread John Ralls
> On Nov 8, 2017, at 11:13 PM, Megagrumpy wrote: > > Just ran the online retrieval update and it is still picking up 1.44. Do I > have to download 1.45? - using Windows. No, just be patient. Erik posts the release notice as soon as he puts the tarball on SourceForge.

Bank reconciliation

2017-11-09 Thread David Goodenough
I imported transactions from my bank using "import ofx" which has populated an account called "Imbalance-GBP" with various transactions. One of the transactions represents paying in three cheques we had received as payments for ads from three different customers which the bank lumped together

Re: has GnuCash code been reviewed for security?

2017-11-09 Thread Derek Atkins
Hi, Please be sure to CC gnucash-user on all your replies using your mailer's Reply-To-List or Reply-All functionality. You're now getting more into topics for the development list and not the user list, but suffice it to say that GnuCash is NOT a security application, it is a financial

Re: has GnuCash code been reviewed for security?

2017-11-09 Thread Aaron Laws
On Thu, Nov 9, 2017 at 9:24 AM, Buddha Buck wrote: > GnuCash also doesn't do any network access, either as a client or server. > For things like financial quote lookup, it calls 3rd-party tools. That's > another way that GnuCash minimizes its security footprint. > I was

Re: Finance-Quote 1.44 released!

2017-11-09 Thread davelist
> On Nov 9, 2017, at 4:46 AM, Erik Colson wrote: > > > davel...@mac.com writes: > >> Thanks for all your work on this. A symbol I cannot get to work is QREARX (a >> TIAA-CREF mutual fund). >> >> https://finance.yahoo.com/quote/QREARX?p=QREARX >> >> I don't know if it's

Re: has GnuCash code been reviewed for security?

2017-11-09 Thread Aaron Laws
On Wed, Nov 8, 2017 at 8:35 PM, Marcus Winston wrote: > I've searched the web and mailing list archives for this one, but didn't > find it. I'm just curious if GnuCash has ever gone through a code review > specifically for security? Perhaps something like what was

Re: Currency Quotes

2017-11-09 Thread 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.: $

Mac OS

2017-11-09 Thread Les
Update, I just upgrade GC to 2.6.18 and that solved the problem of incompatibility with Mac OS High Sierra 10.13.1. Les ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please

Mac OS

2017-11-09 Thread Les
I just updated my Mac to the latest version and now GC will not open.  I get a message that GC is incompatible with this version of Mac OS. Any workarounds or solutions? Running GC 2.6.17.  Would 2.6.18 solve this problem? Regards, Les ___

Re: Currency Quotes

2017-11-09 Thread Erik Colson
Alun Champion 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 <===

Re: Asian Stocks and Multiple Currencies Not Updated

2017-11-09 Thread Erik Colson
Chen Thomas writes: > Hi Erik, > > Thank you. > > I just tried F::Q v1.45 with AlphaVantage source. > > Everything but currency is working good. great! > But it's very high possibility to get system error message while getting > quotes. I have to try many times. Yep.

Re: Finance-Quote 1.44 released!

2017-11-09 Thread Erik Colson
davel...@mac.com writes: > Thanks for all your work on this. A symbol I cannot get to work is QREARX (a > TIAA-CREF mutual fund). > > https://finance.yahoo.com/quote/QREARX?p=QREARX > > I don't know if it's something wrong with AlphaVantage or Finance::Quote. This symbol isn't supported by the

Re: Finance-Quote 1.44 released!

2017-11-09 Thread Erik Colson
? ?? writes: > Hi Erik, > > Below are some symbols for Asian stocks: > Hong Kong: 0700.HK > China: 000636.SZ > Taiwan: 5880.TW, 6638.TWO Hi They all work with F::Q v1.45 best -- erik colson ___ gnucash-user mailing list

Re: Finance-Quote 1.44 released!

2017-11-09 Thread Erik Colson
Cam Ellison writes: > On 08/11/17 12:40 PM, Erik Colson wrote: > >> Please list some symbols you tried. >> >> > Here you go: > > CMI.V > MBA.TO > QST.V > FCEL (on NASDAQ) Hi Cam, Please try again with F::Q v1.45. It does work on my system. best -- erik colson

Re: Updated Finance-Quote to 1.44; GnuCash still not retrieving quotes

2017-11-09 Thread Dave H
Tommy Trussell posted the following link to the updated faq earlier (thanks Tommy), it should give you everything you need ?... A good place to start is the GnuCash FAQ (recently updated): https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F Cheers Dave H. On 8 November

Updated Finance-Quote to 1.44; GnuCash still not retrieving quotes

2017-11-09 Thread Justin Smith
Hi, After experiencing the same Yahoo-related issues retrieving stock quotes has many others in this group, I upgraded Finance-Quote to version 1.44. So this, on it's own, didn't fix the issue, but I'm confused about how GnuCash uses Finance-Quote. In GnuCash you need to select the quote