Re: Finance-Quote 1.45 released!

2017-11-08 Thread Megagrumpy
Just ran the online retrieval update and it is still picking up 1.44. Do I have to download 1.45? - using Windows. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: Currency Quotes

2017-11-08 Thread 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

Re: Can gnucash add Virtual currency?

2017-11-08 Thread 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

RE: Asian Stocks and Multiple Currencies Not Updated

2017-11-08 Thread Chen Thomas
Hi Erik, Thank you. I just tried F::Q v1.45 with AlphaVantage source. Everything but currency is working good. But it's very high possibility to get system error message while getting quotes. I have to try many times. Really appreciate your efforts. jctchen -Original Message- From:

Re: Adding Fixed Assests

2017-11-08 Thread DaveC49
Kevin, If you are entering an existing asset rather than a new paurchase the credit entry should be to an Equity Account:Opening Balances rather than to a Cash or bank account and the debit entry to thr Fixed asset account. David Cousens - David Cousens -- Sent from:

Re: has GnuCash code been reviewed for security?

2017-11-08 Thread Derek Atkins
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

has GnuCash code been reviewed for security?

2017-11-08 Thread Marcus Winston
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

Re: Finance-Quote 1.44 released!

2017-11-08 Thread davelist
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

RE: Finance-Quote 1.44 released!

2017-11-08 Thread ? ??
Hi Erik, Below are some symbols for Asian stocks: Hong Kong: 0700.HK China: 000636.SZ Taiwan: 5880.TW, 6638.TWO Price update for above stocks used to work well with Yahoo. Thanks for your checking, jctchen -Original Message- From: Erik Colson [mailto:e...@ecocode.net] Sent: Thursday,

Re: Finance-Quote 1.44 released!

2017-11-08 Thread Cam Ellison
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) I ran gnucash --add-price-quotes with debugging on and logged it. There are entries for currencies and for  stocks etc of this form (selected lines to show each

batch edit security editor

2017-11-08 Thread brad
Since it sounds like alphavantage is going to be slower than yahoo and I have quite a few securities that I don't need to get quotes for anymore I turned off 'get online quotes' for everything with a script edit of the xml file.   Then I can update the relatively few securities I need with

Re: Finance-Quote 1.44 released!

2017-11-08 Thread Erik Colson
Cam Ellison writes: > While you're at it - and thank you very much for all your time and > effort on this - I can't seem to get any TSXV (TSX Venture) stocks > through alphavantage. gnc-fq-dump shows currency missing for the ones > I've tried. Running gnucash

Finance-Quote 1.45 released!

2017-11-08 Thread Erik Colson
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

Re: Asian Stocks and Multiple Currencies Not Updated

2017-11-08 Thread Erik Colson
? ?? writes: > Hi, > > We all know there are lots of efforts since Yahoo! stopped service on Nov. > 1st. Thank you all. > > I've got F::Q updated to 1.44, and set everything OK with AlphaVantage > source, it only works for my US stock. > > But it is not working for my

Re: Finance-Quote 1.44 released!

2017-11-08 Thread Cam Ellison
On 08/11/17 11:15 AM, Erik Colson wrote: ? ?? writes: Right now it works well with updating prices of my US stock. But for my Asian stocks, such as Hong Kong stock, China stock, and Taiwan stock, it's still not working now. Currency is not updated either. Is there a way

Re: alpha vantage with non-US exchanges

2017-11-08 Thread Erik Colson
Bye writes: > First off, thanks to those involved in getting things working again with > F::Q. > > > > I'm using v1.43 successfully with US stocks, but not for Canadian stocks. I > see alpha vantage should work for stocks on the TSX as the following > successfully returns

Re: F::Q 1.39 with support for AlphaVantage released to CPAN

2017-11-08 Thread Megagrumpy
Thanks for all the work done so far. it must be very time consuming indeed and I apologise for raising other issues! Can anyone confirm if .L linked to GBP? Currently quotes appear to be in pence from Alphavantage but Gnucash works in GBP. Can the division by 100 be done automatically? Also it

Re: Can gnucash add Virtual currency?

2017-11-08 Thread Kurt Padilla
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. >

Re: F::Q 1.40 uploaded

2017-11-08 Thread David T. via gnucash-user
If I were going to try to change all my quote sources quickly, I would do it with SQL. ! NOTE THAT THIS SUGGESTION IS NOT/NOT PROMOTED BY THE DEVELOPMENT TEAM BECAUSE IT CHANGES YOUR DATA FROM OUTSIDE THE GNUCASH API!! !!! USE AT YOUR OWN RISK 1) Make a

RE: finance-quote error

2017-11-08 Thread rosid
Hi, the Bloomberg perl module for F::Q should be able to get some stocks and funds. As I wrote here http://gnucash.1415818.n4.nabble.com/Re-No-stock-quote-for-LU1233758587-td4693298.html#none I was able to import the Bloomberg module into f:q in Windows: > Then I found this Perl Bloomberg

Re: Stock quotes working?

2017-11-08 Thread Fross, Michael
Hello David, Tons of conversation on this since Yahoo shutdown their service Check out the conversations from the last week. Erik and the Finance-quote guys have been really helpful. Michael On Nov 8, 2017 2:50 AM, "David Moriarty" wrote: > Are stock quotes broken

RE: Can gnucash add Virtual currency?

2017-11-08 Thread David T. via gnucash-user
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

Re: Finance-Quote 1.43 released!

2017-11-08 Thread Geert Janssens
Op woensdag 8 november 2017 07:19:32 CET schreef Erik Colson: > Richard Ullger writes: > > On 06/11/17 22:43, Erik Colson wrote: > >> New version 1.43 of Finance-Quote is available with the following changes: > > All prices from AlphaVantage are being returned 100 times too

RE: Can gnucash add Virtual currency?

2017-11-08 Thread 陳 志昌
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

Stock quotes working?

2017-11-08 Thread David Moriarty
Are stock quotes broken as of this past weekend? I had everything working for the past 4 years and this past week started getting the following message There was an unknown error while retrieving the price quotes. ___ gnucash-user mailing list

Re: How to track mortgage (liability) payments as part of expense reports (2006)

2017-11-08 Thread Art
I hope I'm not at odds with GC policy, but I wanted to thank you for your post which I found via a Google search trying to straighten out my home accounting after retiring and buying a house. I am not an accountant (but I played one in college - :->) While looking for certainty in my cash flow, I

alpha vantage with non-US exchanges

2017-11-08 Thread Bye
First off, thanks to those involved in getting things working again with F::Q. I'm using v1.43 successfully with US stocks, but not for Canadian stocks. I see alpha vantage should work for stocks on the TSX as the following successfully returns stock prices:

Can gnucash add Virtual currency?

2017-11-08 Thread 林威儒
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://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all