GNU Cash Transactions - Wiped Out

[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 Sincerely

Roy Molepo
___
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.

Recording in KRW, Reporting in USD, Budgeting in USD

[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. 

I've been using GNU cash to record all our expenses and keep a balanced
book, but I'm looking to make some progress on budgeting and reporting. Our
budgets for each account are set at the beginning of the year by our donor,
and we need to report quarterly in USD. I use a weighted average formula to
make sure that our KRW amount matches the USD amount so at the end of the
year we spend within the USD amount.

So basically, I'd like to be able to *1) see my regular KRW transactions
alongside their value in USD (set to the weighted average rate)* and *2) be
able to set my budget in USD*.

Up to this point I've just been keeping a KRW record and then manually
applying the USD exchange rates to find out how much we've spent in USD. 

There must be a better way!

I've found two possible solutions, but I'm not sure if they're workable and
would greatly appreciate the community's input!

1) Record all transactions in KRW, export reports to xml, find a way to get
the xml to display in excel and apply exchange rates there. Drawbacks here
are that I can't see my budget or spending in USD live, without a time
consuming process. 

2) Set my default currency to USD and apply my updated exchange rate at each
transaction. The downside here is that I have no easy way to see my data in
KRW, which I need to report for Korean taxes etc. 

My first post is an essay, so thanks if you made it this far. Glad to join
the community!

-Scott



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Removal of unnecessary listed Account names

[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
need to re-train the bayesian matching.

David C

On Thu, Nov 9, 2017 at 1:56 PM, 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 headings.
> What's happened now is that when I import new data and begin to match
> the incoming sub accounts with mine in GnuCash I now have two sets of
> headings to sort through, one in upper-case the other in lower.  The
> issue also appears when manually inputting or changing a transaction; In
> my case the dropdown list in account shows, one name in upper-case the
> other in lower.
>
> Is there a way of deleting all the lower case account headings to make
> the importing of data easier.  I do recognise that this is a short term
> issue as over time the accounts will automatically match the headings
> correctly but it is a bit of a pain at the moment.
>
> I've not been able to find any related information in your support
> documentation.
>
> Any assistance would be much appreciated.
>
> Thanks
>
> Cliff Williams
>
>
> ___
> 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: Finance-Quote 1.45 released!

[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 21:36 +0100, Erik Colson escreveu:
> 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
> 
> Authors:
>   - Dj Padzensky , PadzNet, Inc.
>   - Linas Vepstas 
>   - Yannick LE NY 
>   - Paul Fenwick 
>   - Brent Neal 
>   - Volker Stuerzl 
>   - Keith Refson 
>   - Rob Sessink 
>   - Leigh Wedding 
>   - Tobias Vancura 
>   - James Treacy 
>   - Bradley Dean 
>   - 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.

YahooJSON.pm
Description: Perl program
___
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: F::Q 1.40 uploaded

[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 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 │
> > ├───┼─┼─
> ┼──┤
> > │ Finance-Quote │ 1.38│ Get stock and mutual fund quotes from various
> > exchanges │ site │
> > └───┴─┴─
> ┴──┘
> >  (1 package installed matching 'finance-quote')
> >
> >
> > *Environment Variable*
> >
> > D:\Users\Michael>set | grep -i alpha
> > ALPHAVANTAGE_API_KEY=XXX
> >
> >
> > *GNUCash Test*
> >
> > C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v alphavantage MSFT
> > Finance::Quote fields Gnucash uses:
> > symbol: MSFT <=== required
> >   date: 11/09/2017   <=== recommended
> >   currency: USD  <=== required
> >   last: 83.6850  <=\
> >nav:  <=== one of these
> >  price:  <=/
> >   timezone:  <=== optional
> >
> > All fields returned by Finance::Quote for stock MSFT
> >
> > stock   field  value
> > -   -  -
> > MSFTclose: 83.6850
> > MSFT currency: USD
> > MSFT   currency_set_by_fq: 1
> > MSFT date: 11/09/2017
> > MSFT high: 84.2700
> > MSFT  isodate: 2017-11-09
> > MSFT last: 83.6850
> > MSFT  low: 82.9000
> > MSFT   method: alphavantage
> > MSFT open: 84.1100
> > MSFT  success: 1
> > MSFT   symbol: MSFT
> > MSFT   volume: 12859991
>
> Thank you very much! That really helped. It is working now in GnuCash and
> using gnc-fq-dump.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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: F::Q 1.40 uploaded

[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 │ abstract
> │ area │
> ├───┼─┼─┼──┤
> │ Finance-Quote │ 1.38│ Get stock and mutual fund quotes from various
> exchanges │ site │
> └───┴─┴─┴──┘
>  (1 package installed matching 'finance-quote')
> 
> 
> *Environment Variable*
> 
> D:\Users\Michael>set | grep -i alpha
> ALPHAVANTAGE_API_KEY=XXX
> 
> 
> *GNUCash Test*
> 
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v alphavantage MSFT
> Finance::Quote fields Gnucash uses:
> symbol: MSFT <=== required
>   date: 11/09/2017   <=== recommended
>   currency: USD  <=== required
>   last: 83.6850  <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
> 
> All fields returned by Finance::Quote for stock MSFT
> 
> stock   field  value
> -   -  -
> MSFTclose: 83.6850
> MSFT currency: USD
> MSFT   currency_set_by_fq: 1
> MSFT date: 11/09/2017
> MSFT high: 84.2700
> MSFT  isodate: 2017-11-09
> MSFT last: 83.6850
> MSFT  low: 82.9000
> MSFT   method: alphavantage
> MSFT open: 84.1100
> MSFT  success: 1
> MSFT   symbol: MSFT
> MSFT   volume: 12859991

Thank you very much! That really helped. It is working now in GnuCash and
using gnc-fq-dump.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Removal of unnecessary listed Account names

[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 headings. 
> What's happened now is that when I import new data and begin to match 
> the incoming sub accounts with mine in GnuCash I now have two sets of 
> headings to sort through, one in upper-case the other in lower.  The 
> issue also appears when manually inputting or changing a transaction; In 
> my case the dropdown list in account shows, one name in upper-case the 
> other in lower.
> 
> Is there a way of deleting all the lower case account headings to make 
> the importing of data easier.  I do recognise that this is a short term 
> issue as over time the accounts will automatically match the headings 
> correctly but it is a bit of a pain at the moment.
> 
> I've not been able to find any related information in your support 
> documentation.
> 
> Any assistance would be much appreciated.

You filed a bug[1] on this and I answered there. In future please use one or 
the other.

Regards,
John Ralls

[1] https://bugzilla.gnome.org/show_bug.cgi?id=790141



___
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: Finance-Quote 1.44 released!

[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.
> 
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump  alphavantage 
> qrearx
> 
> Finance::Quote fields Gnucash uses:
>symbol: qrearx (deduced) <=== required
>  date: ** missing **<=== recommended
>  currency: ** missing **<=== required
>  last:  <=\   
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> ** This stock quote cannot be used by GnuCash!
> 
> Thanks,
> Dave
> 
 
Use the Tiaacref module of Finance-Quote, but use “TIAAreal” as the ticker 
symbol. Upper/lower case matters.

It looks to me that symbols of the form QzzzRX are the new(er), public pseudo 
symbols associated with TIAA-CREF funds that existed in the days when the only 
quote source was TIAA-CREF themselves using internally generated pseudo symbols 
(like CREFstok, CREFequi, TIAAreal). For the funds that survived the TIAA-CREF 
explosion of choice, Finance-Quote still uses the original pseudo symbols to 
look up the 6-10 digit numeric fund ID that FQ now feeds to TIAA’s data server 
to get current quotes. [And then FQ reconverts the return data, which uses the 
newer symbols, to match the old style pseudo symbols.] Somewhat inefficient, 
but it does maintain compatibility for gnucash users with long-term data sets.

The real estate fund may be the only one that kicks this up. All of the other 
older funds have split into multi-class families [(R1), (R2), and (R3)], with 
even relatively small schools getting their old (R1) funds upgraded to lower 
admin cost (R2) and (R3) units. All the newer ticker symbols that start with Q 
have something other than R as the next to last character.


David Reiser
dbrei...@icloud.com


___
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: Finance-Quote 1.45 released!

[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 alphavantage
quote source are working for me now.

Regards,

Richard.






signature.asc
Description: OpenPGP digital signature
___
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: F::Q 1.40 uploaded

[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 │
├───┼─┼─┼──┤
│ Finance-Quote │ 1.38│ Get stock and mutual fund quotes from various
exchanges │ site │
└───┴─┴─┴──┘
 (1 package installed matching 'finance-quote')


*Environment Variable*

D:\Users\Michael>set | grep -i alpha
ALPHAVANTAGE_API_KEY=XXX


*GNUCash Test*

C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v alphavantage MSFT
Finance::Quote fields Gnucash uses:
symbol: MSFT <=== required
  date: 11/09/2017   <=== recommended
  currency: USD  <=== required
  last: 83.6850  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock MSFT

stock   field  value
-   -  -
MSFTclose: 83.6850
MSFT currency: USD
MSFT   currency_set_by_fq: 1
MSFT date: 11/09/2017
MSFT high: 84.2700
MSFT  isodate: 2017-11-09
MSFT last: 83.6850
MSFT  low: 82.9000
MSFT   method: alphavantage
MSFT open: 84.1100
MSFT  success: 1
MSFT   symbol: MSFT
MSFT   volume: 12859991



On Thu, Nov 9, 2017 at 12:13 PM, rosid  wrote:

> 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 using F::Q 1.45 with Strawberry Perl 5.24.1.1.
> The API key is also valid, I tested it on the Alphavantage site getting a
> csv with my key (using one of the demo links and changing that part of the
> URL to my key).
> I think I might be doing something wrong. Could you maybe please send a few
> screenshots of your setup (environment file and system or user variables)?
>
> Thanks
>
> Rosid
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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: F::Q 1.40 uploaded

[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 environment file.

Also you don’t need to set it up as both system and user environment
variables unless the user variable you want to use a different value for a
user for some reason.

Cheers Dave H

On Fri, 10 Nov 2017 at 2:30 am, rosid  wrote:

>
> >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 variable to the environment file (ALPHAVANTAGE_API_KEY=;
> I just added it at the end, is that correct?) as described here:
> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
>
> Then I set up a system and a user variable pointing to the above file
> (C:\Program Files (x86)\gnucash\etc\gnucash\environment).
>
> When I try to quote goog.us using gnc-fq-dump -v alphavantage goog.us I
> get
> the following error: errormsg: Please make sure your API key is valid.
> Alternatively, claim your free API key on
> (https://www.alphavantage.co/support/#api-key). It should take less than
> 20
> seconds, and is free permanently.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

Removal of unnecessary listed Account names

[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 incoming sub accounts with mine in GnuCash I now have two sets of 
headings to sort through, one in upper-case the other in lower.  The 
issue also appears when manually inputting or changing a transaction; In 
my case the dropdown list in account shows, one name in upper-case the 
other in lower.

Is there a way of deleting all the lower case account headings to make 
the importing of data easier.  I do recognise that this is a short term 
issue as over time the accounts will automatically match the headings 
correctly but it is a bit of a pain at the moment.

I've not been able to find any related information in your support 
documentation.

Any assistance would be much appreciated.

Thanks

Cliff Williams


___
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: F::Q 1.40 uploaded

[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 using F::Q 1.45 with Strawberry Perl 5.24.1.1. 
The API key is also valid, I tested it on the Alphavantage site getting a
csv with my key (using one of the demo links and changing that part of the
URL to my key).
I think I might be doing something wrong. Could you maybe please send a few
screenshots of your setup (environment file and system or user variables)?

Thanks

Rosid



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: F::Q 1.40 uploaded

[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  wrote:

>
> >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 variable to the environment file (ALPHAVANTAGE_API_KEY=;
> I just added it at the end, is that correct?) as described here:
> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
>
> Then I set up a system and a user variable pointing to the above file
> (C:\Program Files (x86)\gnucash\etc\gnucash\environment).
>
> When I try to quote goog.us using gnc-fq-dump -v alphavantage goog.us I
> get
> the following error: errormsg: Please make sure your API key is valid.
> Alternatively, claim your free API key on
> (https://www.alphavantage.co/support/#api-key). It should take less than
> 20
> seconds, and is free permanently.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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: Finance-Quote 1.44 released!

[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 did that. When I use the Get Quotes button on the Price Editor, I 
get a termination with this error: /There was an unknown error while 
retrieving the price quotes/. Closing GnuCash and running gnucash 
--get-price-quotes from the command line fails to produce any entries in 
the Price Editor - at least none are displayed. I have a debug trace but 
have no clue what I'm looking for. I'm using version 2.6.15 if that 
makes a difference.


Thank you again for your efforts.

Cam

___
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: Finance-Quote 1.44 released!

[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 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 alphavantage API.  So we'll need to
>> find another source for it. Anyone?
>> 
>> best
>> --
>> erik colson
> 
> Thanks. I emailed alphavantage through the support option on their website so 
> we'll see what they say. It's strange that all the other TIAA-CREF funds I 
> have work fine.
> 
> Dave
> ___
> 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: F::Q 1.40 uploaded

[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 variable to the environment file (ALPHAVANTAGE_API_KEY=;
I just added it at the end, is that correct?) as described here:
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

Then I set up a system and a user variable pointing to the above file
(C:\Program Files (x86)\gnucash\etc\gnucash\environment).

When I try to quote goog.us using gnc-fq-dump -v alphavantage goog.us I get
the following error: errormsg: Please make sure your API key is valid.
Alternatively, claim your free API key on
(https://www.alphavantage.co/support/#api-key). It should take less than 20
seconds, and is free permanently.




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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: Mac OS

[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 problem?

What version of MacOS?

Regards,
John Ralls

___
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: Finance-Quote 1.45 released!

[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. It takes CPAN’s bots a few hours to notice and update 
the indexes.

Regards,
John Ralls

___
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.

Bank reconciliation

[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 as one transaction. 

>From googling I had come to the conclusion that I should set up a temporary 
>holding 
account (Account type: Asset), have that transaction pay into said account and 
then make 
three different transactions to Assets:Checking Account and use them to pay the 
invoices. 
However, when I (using the right click menu option while viewing all 
transactions in said 
holding account) assigned these 
transactions as payments for the invoices the transaction was moved to 
Accounts Receivable automatically and moving it back (by editing the 
other end of the transaction in Assets:Checking Account) causes the 
invoices to become unpaid.

Clearly I am doing something wrong, quite possibly by not even using the 
right solution to begin with and I don't think banging my head against 
the problem/google any more will be productive, what should I do?

In short, what is the proper way to handle the case where a single paying-in 
transaction 
needs to be reconciled against several invoices for multiple customers?  

We try to encourage people to pay electronically, then none of this happens, 
and in future 
if we can not find a solution to this we will ensure that cheques are paid in 
individually, but 
we need to handle these historic transactions.

David
___
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: has GnuCash code been reviewed for security?

[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 application.  You should treat it as
such.  The developers work hard to ensure that the program wont crash
based on bogus inputs, but of course bugs still happen.

Any further development-related question should be redirected to
gnucash-devel.

Thanks,

-derek

Marcus Winston  writes:

> OK, sure. That's fine. 
>
> So Gnucash takes as input data from some other program that has connected to
> the internet. Does GnuCash validate this data before accepting it as input?
> (one example of a security protection). Does GnuCash manage its own input
> buffers or does it allow the external program to manipulate the buffers (the
> latter being a security risk). Just a couple examples.
> -marcus
>
> On Wed, Nov 8, 2017 at 5:56 PM, Derek Atkins  wrote:
>
> None of that happens in gnucash..  That is all done by GnuTLS, controlled
> by AqBanking.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
> On November 8, 2017 8:54:36 PM Marcus Winston <
> mar...@thechocolatehouse.net> wrote:
>
> I'm thinking mainly of the connection to banks, downloading
> transactions. I assume its done over https or something similar. Has a
> code review of that portion been conducted, to make sure it's secure
> (at least, as secure as folks know how to make it)? Security
> vulnerabilities abound everywhere these days...
>
> Thanks.'
> -marcus
>
> On Wed, Nov 8, 2017 at 5:43 PM, Derek Atkins  wrote:
>
> Hi,
> What specifically would such a code review be looking for?
> GnuCash is a financial application. It specifically does not
> provide security services like encryption, leaving that to
> security specific applications (like True Crypt).  Passwords to
> online banking are never stored. All other security is from
> external providers.
>
> So what are you looking for?
>
> -derek
> Sent using my mobile device. Please excuse any typos.
>
> On November 8, 2017 8:36:31 PM Marcus Winston <
> mar...@thechocolatehouse.net> 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
> done for
> TrueCrypt...?
> ___
> 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.
>

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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: has GnuCash code been reviewed for security?

[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 thinking along these lines, but I wasn't sure enough to actually say
it does no network access. For instance, it can access a remote mysql
database? But perhaps this is also delegation to a mysql driver so wouldn't
count? Anyway, delegation is truly the gist of it.
___
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: Finance-Quote 1.44 released!

[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 something wrong with AlphaVantage or Finance::Quote.
> 
> This symbol isn't supported by the alphavantage API.  So we'll need to
> find another source for it. Anyone?
> 
> best
> --
> erik colson

Thanks. I emailed alphavantage through the support option on their website so 
we'll see what they say. It's strange that all the other TIAA-CREF funds I have 
work fine.

Dave
___
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: has GnuCash code been reviewed for security?

[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 done for
> TrueCrypt...?


There aren't many angles for Gnucash security. Data can be stored in xml or
SQL. The SQL storage security is up to the provider: mysql, sqlite,
postgres. XML is in plain text, so you'll need to secure it physically or
using your operating system.

As Derek asks: what else would you like to know?
___
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]

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  wrote:


> 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   <=== 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.

Mac OS

[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 remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Mac OS

[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



___
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

[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   <=== 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: Asian Stocks and Multiple Currencies Not Updated

[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.  I've sent a mail to alphavantage to figure this out...

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: Finance-Quote 1.44 released!

[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 alphavantage API.  So we'll need to
find another source for it. Anyone?

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: Finance-Quote 1.44 released!

[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
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: Finance-Quote 1.44 released!

[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
___
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: Updated Finance-Quote to 1.44; GnuCash still not retrieving quotes

[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 2017 at 23:32, Justin Smith  wrote:

> 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 source. After upgrading F::Q,
> setting the GnuCase quotge source to either of "Australian Stock Exchange,
> AU", or "alphavantage" or anything else does not work.
>
> However, if I run F::Q using a simple perl script (below), it works fine...
>
> #!/usr/bin/perl
> use Finance::Quote;
> my $q = Finance::Quote->new();
> my %data = $q->fetch('ASX', 'NAB');
> print "NAB price is " . $data{'NAB', 'price'} . "\n";
>
> So what source is F::Q using by default and how can I set this in GnuCash?
>
> I'm running GnuCash 2.6.17 on Ubuntu 17.04, installed using the getdeb
> repository.
>
> I'm mostly interested in stocks on the ASX.
>
>
> Cheers,
> Justin.
> ___
> 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.

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

[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 source. After upgrading F::Q,
setting the GnuCase quotge source to either of "Australian Stock Exchange,
AU", or "alphavantage" or anything else does not work.

However, if I run F::Q using a simple perl script (below), it works fine...

#!/usr/bin/perl
use Finance::Quote;
my $q = Finance::Quote->new();
my %data = $q->fetch('ASX', 'NAB');
print "NAB price is " . $data{'NAB', 'price'} . "\n";

So what source is F::Q using by default and how can I set this in GnuCash?

I'm running GnuCash 2.6.17 on Ubuntu 17.04, installed using the getdeb
repository.

I'm mostly interested in stocks on the ASX.


Cheers,
Justin.
___
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.