Re: Finance-Quote 1.45 released!

[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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Currency Quotes

[Alun Champion]

Alphavantage supports currencies, e.g.:

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

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

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

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

Re: Can gnucash add Virtual currency?

[Alun Champion]

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

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

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

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

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

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

RE: Asian Stocks and Multiple Currencies Not Updated

[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: Erik Colson [mailto:e...@ecocode.net] 
Sent: Thursday, November 9, 2017 4:30 AM
To: ? ?? 
Cc: gnucash-user@gnucash.org
Subject: Re: Asian Stocks and Multiple Currencies Not Updated


? ??  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 Asian stocks, such as Hong Kong stock (.HK), 
> China stock (xx.SZ, xx.SS), and Taiwan stock (.TW, .TWO).

Please check those again with F::Q v1.45

> Even the currencies (USD, CNY, HKD, TWD, EUR) cannot be updated. Shall I 
> change the update source to AlphaVantage for currencies?

currencies are not yet supported but will come probably next weekend

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: Adding Fixed Assests

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

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



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

has GnuCash code been reviewed for security?

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

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



> On Nov 8, 2017, at 6:02 PM, ? ??  wrote:
> 
> 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, November 9, 2017 3:16 AM
> To: ? ?? 
> Cc: finance-quote-n...@lists.sourceforge.net; gnucash-user@gnucash.org
> Subject: Re: Finance-Quote 1.44 released!
> 
> 
> ? ??  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 for updating currency and Asian stock price?
> 
> Currency support will probably be added during next weekend.
> 
> Concerning asian stocks: I can check it out if you send the symbols as you 
> retrieved them from yahoo.
> 
> 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.

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

[? ??]

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, November 9, 2017 3:16 AM
To: ? ?? 
Cc: finance-quote-n...@lists.sourceforge.net; gnucash-user@gnucash.org
Subject: Re: Finance-Quote 1.44 released!


? ??  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 for updating currency and Asian stock price?

Currency support will probably be added during next weekend.

Concerning asian stocks: I can check it out if you send the symbols as you 
retrieved them from yahoo.

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!

[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 exchange):
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c52344200 FCEL into nsp=0x562c516ae120 NASDAQ
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c52343fe0 VPLM into nsp=0x562c5233a860 OTC
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c523458b0 AVO.TO into nsp=0x562c5233a760 TSX
* 11:54:34  INFO  [gnc_commodity_table_insert] insert 
0x562c52348a30 ALV.V into nsp=0x562c5233a4c0 TSX.V


I'm not sure whether this is just part of the setup as gnucash loads, or 
whether this shows gnucash attempting to get quotes.


gnc-fq-dump gives this return:
Finance::Quote fields Gnucash uses:
    symbol: ALV.V    <=== required
  date: 11/08/2017   <=== recommended
  currency: ** missing **    <=== required
  last: 0.2000   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by GnuCash!

Anything else I can provide?

Thank you

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.

batch edit security editor

[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 quote source 'alphavantage'.


!!!  Warning unapproved and possibly dangerous (but it worked for me). !!!

The heart of this is the sed command.  This was my workflow from a 
unix/linux shell:


close gnucash

If your gnucash file is called file.gnucash

cd to the directory where file.gnucash exists

cp file.gnucash file.gnucash.bak  # back it up in case things go wrong

mkdir Temp

cd Temp

cp ../file.gnucash file.gnucash.gz   # the gnucash file is compressed

gunzip file.gnucash.gz  # because gunzip likes the suffix to be there

sed 's;;;' file.gnucash > temp

mv temp file.gnucash

gzip file.gnucash

mv file.gnucash.gz ../file.gnucash




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

> 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 --add-price-quotes with debugging (extra)
> enabled shows that the attempt is made to load all the quotes, but
> nothing is recorded and there is no error message.
>
> If you can give me some direction as to additional analysis I can do,
> I'm willing to try it.

Please list some symbols you tried.

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.

Finance-Quote 1.45 released!

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

Re: Asian Stocks and Multiple Currencies Not Updated

[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 Asian stocks, such as Hong Kong stock (.HK), 
> China stock (xx.SZ, xx.SS), and Taiwan stock (.TW, .TWO).

Please check those again with F::Q v1.45

> Even the currencies (USD, CNY, HKD, TWD, EUR) cannot be updated. Shall I 
> change the update source to AlphaVantage for currencies?

currencies are not yet supported but will come probably next weekend

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!

[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 for updating currency and Asian stock price?

Currency support will probably be added during next weekend.

Concerning asian stocks: I can check it out if you send the symbols as
you retrieved them from yahoo.


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 --add-price-quotes with debugging (extra) 
enabled shows that the attempt is made to load all the quotes, but 
nothing is recorded and there is no error message.


If you can give me some direction as to additional analysis I can do, 
I'm willing to try it.


Cheers

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: alpha vantage with non-US exchanges

[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 stock prices:

You need v1.44 for .TO symbols.
--
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: F::Q 1.39 with support for AlphaVantage released to CPAN

[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 appears that some people are having success with Funds - what are
you using for the symbol - is it just the ISIN or the ISIN with the suffix?



--
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: Can gnucash add Virtual currency?

[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.
> Gnucash bases its currencies list on the ISO standard, which does not
> include bitcoin. That said, treating it like any other commodity should
> work, except that the ongoing valuation will require manual entry.
> David
>
>
>   On Wed, Nov 8, 2017 at 13:55, 陳 志昌 wrote:   It can
> be added in Security Editor as a user-defined currency.
>
> I know it's doable, but I never try this.
>
> Thank you, jctchen
>
> -Original Message-
> From: gnucash-user [mailto:gnucash-user-bounces+jctchen=
> outlook@gnucash.org] On Behalf Of 林威儒
> Sent: Wednesday, November 8, 2017 12:37 AM
> To: gnucash-user@gnucash.org
> Subject: Can gnucash add Virtual currency?
>
> I need to use virtual currency in gnucash,like Bitcoin how can I add new
> currency?
> Thank you.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
>
> https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7Cjctchen%40outlook.com%7Cedc5323fb4494e1031e108d52684f73b%7C84df9e7fe9f640afb435%7C1%7C0%7C636457274877633125=7Xiz8sH%2FHtwn0xeMb%2BdSSu2bbsbHyqVtqeULk554blQ%3D=0
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-- 

Sent from the Google Inbox Android app. GnuPG encryption available upon
request.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: F::Q 1.40 uploaded

[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 backup of the data file.
2) Save the data file in an SQL format.
3) Close GnuCash.
4) Open the data file in a database app.
5) Execute “UPDATE commodities SET quote_source = ‘alphavantage’ WHERE 
quote_source = ‘yahoo’;”
6) Reopen GnuCash.
7) Check that things still work.
8) Re-save into xml.

David


> On Nov 7, 2017, at 3:17 AM, brad  wrote:
> 
> alphavantage works with the few funds that I tried.
> 
> Anybody have a quick way to change all quote sources from yahoo to 
> alphavantage?
> 
> 
> On 11/05/2017 12:44 PM, Erik Colson wrote:
>> ...
>> Please note that while AlphaVantage does appear to offer quite a bunch
>> of quotes, it doesn't seem to support funds nor currencies.
>> 
>> 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.

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

[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 module for finance quote:
> https://github.com/alex314159/PerlFinanceQuoteBloomberg
> I added the file to the finance quote directory (on my Windows 10 system:
> C:\Strawberry\perl\site\lib\Finance\Quote) and added Bloomberg to the
> modules in the file Quotes.pm and changed the account delimiter in GnuCash
> to from ":" to "\" (as described in the Readme file in the above link).
> Using gnc-fq-dump and gnc-fq-helper via command line I was able to get a
> quote for REMCIEE:LX.
> After that, I was able to select Bloomberg as an online source for my
> fund. 
> Then I tried to get the online quotes for all my shares, but the only
> thing
> that happened ist the black Strawberry Perl window popping up and never
> closing (I let it run for more than 1 hour). After that I aborted (closed
> the Strawberry Perl window) and got an error message from GnuCash about a
> system error. 

[...]

I had to edit the Bloomberg.pm file and change the following entries in the
lines 47, 49 and 51:

@price_array[0] --> $price_array[0]
@curr_array[0] --> $curr_array[0]
@date_array[0] --> $date_array[0]

After doing that I was able to successfully retrieve a quote for REMCIEE:LX
within GnuCash.

You will have to change the ticker symbol of your stocks to the bloomberg
standard (like GOOG:US) for it to work.
I tested it successfully with 5 of my funds.


Daniel




--
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: Stock quotes working?

[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 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
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: Can gnucash add Virtual currency?

[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 will require manual entry. 
David
 
 
  On Wed, Nov 8, 2017 at 13:55, 陳 志昌 wrote:   It can be 
added in Security Editor as a user-defined currency.

I know it's doable, but I never try this.

Thank you, jctchen

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+jctchen=outlook@gnucash.org] On Behalf Of 林威儒
Sent: Wednesday, November 8, 2017 12:37 AM
To: gnucash-user@gnucash.org
Subject: Can gnucash add Virtual currency?

I need to use virtual currency in gnucash,like Bitcoin how can I add new  
currency?
Thank you.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7Cjctchen%40outlook.com%7Cedc5323fb4494e1031e108d52684f73b%7C84df9e7fe9f640afb435%7C1%7C0%7C636457274877633125=7Xiz8sH%2FHtwn0xeMb%2BdSSu2bbsbHyqVtqeULk554blQ%3D=0
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.  
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance-Quote 1.43 released!

[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 big as
> > pence rather than pounds. For example, a price of £7.329 is being
> > returned as £732.90. This is making stock values 100 times too big in
> > gnucash.
> 
> Probably F::Q should return GBp instead of GBP as currency.  However I
> can force division by 100 for .L quotes in alpavantage, maybe gnucash
> can handle GBp to GBP conversion?
> Can GnuCash developers tell which option would be appropriate?
> 
> best
> --
> erik colson

Hi Eric,

There is no facility in gnucash to handle conversions from GBp to GBP 
unfortunately. So I believe the quickest solution to this issue would be for 
Finance::Quote to do the conversion internally.

Thanks for your hard work the last couple of days!

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: Can gnucash add Virtual currency?

[陳 志昌]

It can be added in Security Editor as a user-defined currency.

I know it's doable, but I never try this.

Thank you, jctchen

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+jctchen=outlook@gnucash.org] On Behalf Of 林威儒
Sent: Wednesday, November 8, 2017 12:37 AM
To: gnucash-user@gnucash.org
Subject: Can gnucash add Virtual currency?

I need to use virtual currency in gnucash,like Bitcoin how can I add new  
currency?
Thank you.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user=02%7C01%7Cjctchen%40outlook.com%7Cedc5323fb4494e1031e108d52684f73b%7C84df9e7fe9f640afb435%7C1%7C0%7C636457274877633125=7Xiz8sH%2FHtwn0xeMb%2BdSSu2bbsbHyqVtqeULk554blQ%3D=0
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Stock quotes working?

[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
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: How to track mortgage (liability) payments as part of expense reports (2006)

[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 found your post with,

For example:
Equity:Opening Balances   -> Assets:House   $100,000.00
Equity:Opening Balances   -> Liabilities:Home loan  $80,000.00

I love GC and realized what those "Adjustments" meant because of your post.
You made it so easy for an undergraduate physics major to realize how
Liability, Asset, and Equity interact. It's also a testament to how
classical GC is!

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

alpha vantage with non-US exchanges

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

https://www.alphavantage.co/query?function=TIME_SERIES_DAILY
 =bce.to=MYKEY

 

However, when using the Security Editor, I've correctly entered the stock
symbol (bce.to or BCE.TO) and have tried each of the security "types" (AMEX,
EUREX, FUND, NASDAQ, NYSE). Is there a way to change F::Q to be more generic
in passing the stock symbol or change the security type? Or is there
something else that I can do to make it work?

 

Thanks,

Doug

 

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

Can gnucash add Virtual currency?

[林威儒]

I need to use virtual currency in gnucash,like Bitcoin
how can I add new  currency?
Thank you.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://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.