gnucash-user Digest, Vol 153, Issue 24
Lt. Goose
ltgoose at gmail.com
Fri Dec 18 06:41:54 EST 2015
Hi Jose and Eric,
Some months ago I had the same problem with MCE exchange. As I did not find
an easy solution with yahoo_europe source, I ended up coding a new F::Q
source for these quotes. I just used www.bolsamadrid.es as the source of
information and added that to my F::Q installation. I think I posted that
to the list, but I'm not sure if I attached the actual file. As I don't use
funds, it just retrieves quotes, but it should be fairly simple to modify
it to query for fund values.
If any of you is interested in the code, just let me know. It needs a
little polish and comments to be of easy use, that's why I don't attach it
right now.
Regards,
Gus
2015-12-18 12:14 GMT+01:00 <gnucash-user-request at gnucash.org>:
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
> Today's Topics:
>
> 1. Re: Balancing Register After Import (Dorel Ciornei)
> 2. Re: Can't delete Imbalance account (Liz)
> 3. RE: Tracking a 401K investment (Gary Holtum)
> 4. Re: Can't delete Imbalance account (Mike or Penny Novack)
> 5. Re: Can't delete Imbalance account (Chris Good)
> 6. Transactions involving different currencies (Miguel Guedes)
> 7. Re: Can't delete Imbalance account (David T.)
> 8. Gnucash / Finance::Quote cannot retrieve Spanish stocks and
> funds (Jose G?mez)
> 9. Re: Transactions involving different currencies (John Ralls)
> 10. Re: Gnucash / Finance::Quote cannot retrieve Spanish stocks
> and funds (Erik Colson)
> 11. Fwd: Re: Backups and recovery (David Carlson)
> 12. Re: Gnucash / Finance::Quote cannot retrieve Spanish stocks
> and funds (Jose G?mez)
>
>
> ---------- Mensaje reenviado ----------
> From: Dorel Ciornei <dorelciornei at yahoo.com>
> To: Colin Law <clanlaw at gmail.com>, Joseph Hesse <joehesse at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Date: Thu, 17 Dec 2015 18:54:22 +0000 (UTC)
> Subject: Re: Balancing Register After Import
> I had the same experience when importing from Quicken:
> - in some cases some transactions were imported twice, so even if the
> begining balance was identical, current balance was different. It was just
> a matter of finding those transactions and deleting the duplicate entries.
> After that the totals matched between quicken and GNU cash.
> - in the case of the accounts that started with the wrong balance, I just
> had to adjust the Opening Balance.
> All my credit cards, loans, etc have been balanced against the
> Equity:Opening Balances account.
>
> Perhaps there are better ways to do it, but using an "Equity:Opening
> Balances" account was the most obvious solution to me.Cheers!
> Dorel
>
> On Thursday, December 17, 2015 9:59 AM, Colin Law <clanlaw at gmail.com>
> wrote:
>
>
> On 17 December 2015 at 15:43, Joseph Hesse <joehesse at gmail.com> wrote:
> > My quicken accounts go back to 1991. I imported my quicken accounts,
> > starting with 1/1/2013 to gnucash using your instructions. No problem
> with
> > the import.
> >
> > I have open the Quicken register and the gnucash register for my credit
> > card. When I match the balance columns for the same date, I see different
> > numbers, presumably because the accounts start at a different date.
> >
> > In order to have the balance column match in both Quicken and gnucash, I
> > plan on putting a fake transaction in the credit card of 12/31/2012. Is
> > this the right approach? Does the balance column mean the same thing in
> > Quicken and gnucash?
>
> Yes, they do mean the same thing. Put the balancing transaction in by
> modifying (or adding) an Opening Balance at the beginning, I think it
> should go against an Equity acct, but I am never quite sure on this.
>
> Colin
>
> >
> > Thank you,
> > Joe
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at 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 at 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.
>
>
>
>
>
> ---------- Mensaje reenviado ----------
> From: Liz <edodd at billiau.net>
> To: gnucash-user at gnucash.org
> Cc:
> Date: Fri, 18 Dec 2015 06:46:29 +1100
> Subject: Re: Can't delete Imbalance account
> Mike or Penny Novack wrote:
>
> >
> > Personal books or small business books? You might be wanting to call or
> > send an email to your accountant or tax advisor to find out what to do.
> > Note that people are sometimes sending messages to this list asking
> > "what do I do with?". Meantime in Imbalance, yes?
> >
> > Michael
> I've just had one of these, and made an educated guess about the new
> account name. When the accountant replies to my query, I can move the
> tranasaction or rename the account because all of those options are
> available in Gnucash.
>
> Work how it's best for you, for me the appearance of "Imbalance" or
> "Orphan" says I have a bookkeeping error and need to fix the error.
>
> Liz
>
>
>
>
> ---------- Mensaje reenviado ----------
> From: Gary Holtum <diamondhranchqh at earthlink.net>
> To: "'Joseph Hesse'" <joehesse at gmail.com>, <gnucash-user at gnucash.org>
> Cc:
> Date: Thu, 17 Dec 2015 14:54:36 -0500
> Subject: RE: Tracking a 401K investment
> Changes in 401K value is not income until you draw it out. Then it becomes
> taxable income.
> Gary
>
>
> -----Original Message-----
> From: gnucash-user
> [mailto:gnucash-user-bounces+diamondhranchqh=earthlink.net at gnucash.org] On
> Behalf Of Joseph Hesse
> Sent: Monday, December 14, 2015 1:32 PM
> To: gnucash-user at gnucash.org
> Subject: Tracking a 401K investment
>
> Hi,
>
> I have a 401K account from my previous employer from which I receive
> monthly
> statements indicating whether the amount goes up or down. I am thinking of
> tracking it in the following way
>
> Create Asset:401K and Income:401K
>
> I start Asset:401K with the current value from Equity:Opening Balance.
> If it increases in value, according to my monthly statement, I treat it as
> positive income in Income:401K. if it decreases in value, I still use
> Income:401K but treat it as negative income.
>
> Is this scheme just a matter of my personal preference or should I do
> something else, like having decreases in value going to Expenses:401K?
>
> Thank you,
> Joe
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
>
>
>
> ---------- Mensaje reenviado ----------
> From: Mike or Penny Novack <mpnovack at mtdata.com>
> To: Michael Hendry <hendry.michael at gmail.com>
> Cc: gnucash-user at gnucash.org
> Date: Thu, 17 Dec 2015 17:11:43 -0500
> Subject: Re: Can't delete Imbalance account
> On 12/17/2015 11:02 AM, Michael Hendry wrote:
>
>> Isn’t the conventional way of dealing with this to set up an account
>> called Expenses:Suspense? To me, the implication of an Orphaned or
>> Imbalanced entry is that there’s been an error in the entry of data, rather
>> than a deferred decision on the proper account for the posting of a
>> transaction. Michael (another one!).
>>
>
> A "suspense" account is indeed traditional, but I have never seen one on
> the expense side. I'll come back to that later.
>
> "Suspense" isn't for items where you know what the account should be (but
> no such account exists). It's an account usually on the income side where
> money arrives but you don't know what for. Most businesses don't leave
> such checks sitting around undeposited, so deposit with the other side of
> the transaction being "suspense" and then it is somebody's job to
> investigate and resolve all items in suspense.
> An example (for my organization) say a check arrived for $50 with no
> indication what for. Was that a donation? Was that for the sale of two
> books? Was that for the sale of two tee shirts and the giving of a third
> shirt to a volunteer?
>
> The equivalent on the expense side would be say an invoice arrived from an
> unknown vendor for something you don't know was an authorized purchase. Or
> in my case, somebody is submitting a request for reimbursement, maybe they
> just tell me the amount and where purchased but forgot to specify what this
> was (and unclear from receipt). You don't need a "suspense" account for
> that because in THAT situation you didn't cut the check. You would
> investigate first (or at least I would). I would send that person an email
> "You submitted a request for reimbursement for a purchase on xx/yy/zz from
> xyz. What WAS that?" I wouldn't simply send them a reimbursement assuming
> that it was an authorized purchase.
>
> BTW, that is a not unusual situation for me. I most cases I can tell from
> the receipt (and simply cut the reimbursement check and enter the
> transaction) but in other cases I can't tell. And at least one or two times
> when there have been many items on the receipt, the person said "oops, the
> abc item was for me personally, strike from the total".
>
> Michael
>
>
>
> ---------- Mensaje reenviado ----------
> From: Chris Good <chris.good at ozemail.com.au>
> To: gnucash-user at gnucash.org
> Cc:
> Date: Fri, 18 Dec 2015 09:30:04 +1100
> Subject: Re: Can't delete Imbalance account
>
> > Message: 1
> > Date: Thu, 17 Dec 2015 06:39:54 +0000
> > From: Michael Hendry <hendry.michael at gmail.com>
> > To: Edward Doolittle <edward.doolittle at gmail.com>
> > Cc: gnucash-user <gnucash-user at gnucash.org>
> > Subject: Re: Can't delete Imbalance account
> > Message-ID: <1DA1501E-BCFD-46D2-9971-65343D407DF3 at gmail.com>
> > Content-Type: text/plain; charset=utf-8
> >
> >
> >> On 17 Dec 2015, at 02:02, Edward Doolittle <edward.doolittle at gmail.com>
> wrote:
> >>
> >> Michael,
> >>
> >> I delete my Imbalance and Orphan accounts all the time. They just get
> >> re-created the next time they're needed. I take the presence of an
> >> Imbalance or Orphan account as a sign that some transaction needs
> further
> >> attention. I fix the transaction then delete the Imbalance or Orphan
> >> account.
> >>
> >> Edward
> >
> > I?ve never deleted these accounts, and thought it very odd (perhaps
> slightly obsessional?) to do so when Edward posted this message. It hadn?t
> even occurred to me that it would be possible to delete them.
> >
> > Up to now, I have been looking out for non-zero values in Imbalance or
> Orphan as flags for errors. Now that I think more deeply about it, I
> realise that it?s possible to have a pair of errors with equal and opposite
> values, which would result in the balance of one of these accounts being
> zero.
> >
> > Perhaps I should include the periodic inspection of Imbalance and Orphan
> in my routine, and their deletion if they contain no entries.
> >
> > Michael
> >
> >
>
> Another suggestion:
>
> Don't delete them, but change the colour of the Imbalance and Orphan
> accounts so that acts as a visual reminder to check the balance is zero
> when viewing the accounts tab.
>
> Regards,
> Chris Good
>
>
>
> ---------- Mensaje reenviado ----------
> From: Miguel Guedes <miguel.a.guedes at gmail.com>
> To: gnucash-user at lists.gnucash.org
> Cc:
> Date: Thu, 17 Dec 2015 23:08:28 +0000
> Subject: Transactions involving different currencies
> Hello list!
>
> I'm trying to understand how to record transactions involving accounts
> in different currencies. For this purpose I created a new book
> containing the simple accounts subtree, one checking account in GBP and
> another in EUR. GBP is the default currency.
>
> Now, to make this simple let's say I want to make a transfer from the
> EUR account to the GBP one. I have taken the following steps:
>
> 1) Open EUR account and move to blank transaction
> 2) In first split, enter 100 withdrawal for the EUR account
> 3) Using the TAB key, navigate to second split and enter 100 deposit for
> the GBP account
> 4) Hitting TAB causes Gnucash to present me with a "transfer funds"
> dialog asking me to specify the exchange rate, which I do by hitting the
> "Fetch rate" button followed by Ok.
> 5) I then hit the ENTER key to record the transaction and the following
> splits are created:
>
> Assets:Current Assets:GBP +100.00
> Trading:CURRENCY:EUR +138.89
> Assets:Current Assets:EUR -100.00
> Imbalance-EUR -38.89
> Trading:CURRENCY:GBP +100.00
>
> The splits above are clearly wrong and that is most likely the result of
> some erroneous action on my part, but what?
>
> Using Gnucash 2.6.1 on Linux but similar issue happened with v2.6.9
> (after I temporarily upgraded via GetDeb thinking it might be a bug).
> Have attempted to follow the following guide but can't get past the
> first step describing the transfer:
>
>
> http://www.gnucash.org/docs/v2.6/C/gnucash-guide/currency_purchase1.html#currency_purchase2
>
> Would appreciate some help as I really want to make Gnucash my
> accounting tool of choice!
>
> Many thanks.
>
> Miguel
>
>
>
>
> ---------- Mensaje reenviado ----------
> From: "David T." <sunfish62 at yahoo.com>
> To: "stepbystepfarm at mtdata.com" <stepbystepfarm at mtdata.com>, Mike or
> Penny Novack <mpnovack at mtdata.com>, Michael Hendry <
> hendry.michael at gmail.com>
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Date: Fri, 18 Dec 2015 01:46:23 +0000 (UTC)
> Subject: Re: Can't delete Imbalance account
> Mike,
> I don't understand your rationale in this situation. There is no need to
> use imbalance while you determine the account, since you can create a new
> account directly from the register while entering a transaction. As Liz
> notes, the account can be renamed and relocated later on.
> Personally, I keep the imbalance account, and even keep it open all the
> time. Most of the time, transactions end up there if I do an import and
> they don't have appropriate account mappings. I use the imbalance account
> to show me what still needs my attention.
> David
>
>
>
> On Thu, Dec 17, 2015 at 17:11, Mike or Penny Novack<mpnovack at mtdata.com>
> wrote: On 12/17/2015 11:02 AM, Michael Hendry wrote:
> > Isn’t the conventional way of dealing with this to set up an account
> > called Expenses:Suspense? To me, the implication of an Orphaned or
> > Imbalanced entry is that there’s been an error in the entry of data,
> > rather than a deferred decision on the proper account for the posting
> > of a transaction. Michael (another one!).
>
> A "suspense" account is indeed traditional, but I have never seen one on
> the expense side. I'll come back to that later.
>
> "Suspense" isn't for items where you know what the account should be
> (but no such account exists). It's an account usually on the income side
> where money arrives but you don't know what for. Most businesses don't
> leave such checks sitting around undeposited, so deposit with the other
> side of the transaction being "suspense" and then it is somebody's job
> to investigate and resolve all items in suspense.
> An example (for my organization) say a check arrived for $50 with no
> indication what for. Was that a donation? Was that for the sale of two
> books? Was that for the sale of two tee shirts and the giving of a third
> shirt to a volunteer?
>
> The equivalent on the expense side would be say an invoice arrived from
> an unknown vendor for something you don't know was an authorized
> purchase. Or in my case, somebody is submitting a request for
> reimbursement, maybe they just tell me the amount and where purchased
> but forgot to specify what this was (and unclear from receipt). You
> don't need a "suspense" account for that because in THAT situation you
> didn't cut the check. You would investigate first (or at least I would).
> I would send that person an email "You submitted a request for
> reimbursement for a purchase on xx/yy/zz from xyz. What WAS that?" I
> wouldn't simply send them a reimbursement assuming that it was an
> authorized purchase.
>
> BTW, that is a not unusual situation for me. I most cases I can tell
> from the receipt (and simply cut the reimbursement check and enter the
> transaction) but in other cases I can't tell. And at least one or two
> times when there have been many items on the receipt, the person said
> "oops, the abc item was for me personally, strike from the total".
>
> Michael
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
>
>
> ---------- Mensaje reenviado ----------
> From: "Jose Gómez" <adler at dreamcoder.org>
> To: gnucash-user at gnucash.org
> Cc:
> Date: Fri, 18 Dec 2015 03:05:53 +0000
> Subject: Gnucash / Finance::Quote cannot retrieve Spanish stocks and funds
> I am trying to get the current value of a Spanish fund (INGDIRECTFNE.BC)
> from Gnucash, and it is not working.
>
> Trying with Finance::Quote directly I get:
>
> $ gnc-fq-dump -v yahoo_europe INGDIRECTFNE.BC
> Finance::Quote fields Gnucash uses:
> symbol: INGDIRECTFNE.BC <=== required
> date: ** missing ** <=== required
> currency: ** missing ** <=== required
> last: <=\
> nav: <=== one of these
> price: <=/
> timezone: <=== optional
>
> ** This stock quote cannot be used by gnucash!!
>
>
> All fields returned by Finance::Quote for stock INGDIRECTFNE.BC
>
> stock field value
> ----- ----- -----
> INGDIRECTFNE.BC ask:
> INGDIRECTFNE.BC avg_vol:
> INGDIRECTFNE.BC bid:
> INGDIRECTFNE.BC cap:
> INGDIRECTFNE.BC close:
> INGDIRECTFNE.BC currency:
> INGDIRECTFNE.BC date:
> INGDIRECTFNE.BC day_range:
> INGDIRECTFNE.BC div:
> INGDIRECTFNE.BC div_date:
> INGDIRECTFNE.BC div_yield:
> INGDIRECTFNE.BC eps:
> INGDIRECTFNE.BC errormsg: Stock lookup failed
> INGDIRECTFNE.BC ex_div:
> INGDIRECTFNE.BC last: **missing**
> INGDIRECTFNE.BC name:
> INGDIRECTFNE.BC nav: **missing**
> INGDIRECTFNE.BC net:
> INGDIRECTFNE.BC open:
> INGDIRECTFNE.BC p_change:
> INGDIRECTFNE.BC pe:
> INGDIRECTFNE.BC price: **missing**
> INGDIRECTFNE.BC success: 0
> INGDIRECTFNE.BC symbol: INGDIRECTFNE.BC
> INGDIRECTFNE.BC time:
> INGDIRECTFNE.BC volume:
> INGDIRECTFNE.BC year_range:
>
> The same happens with other Spanish funds:
>
> gnc-fq-dump -v yahoo_europe ^IBEX
> Finance::Quote fields Gnucash uses:
> symbol: ^IBEX <=== required
> date: ** missing ** <=== required
> currency: ** missing ** <=== required
> last: <=\
> nav: <=== one of these
> price: <=/
> timezone: <=== optional
>
> ** This stock quote cannot be used by gnucash!!
>
>
> All fields returned by Finance::Quote for stock ^IBEX
>
> stock field value
> ----- ----- -----
> ^IBEX ask:
> ^IBEX avg_vol:
> ^IBEX bid:
> ^IBEX cap:
> ^IBEX close:
> ^IBEX currency:
> ^IBEX date:
> ^IBEX day_range:
> ^IBEX div:
> ^IBEX div_date:
> ^IBEX div_yield:
> ^IBEX eps:
> ^IBEX errormsg: Stock lookup failed
> ^IBEX ex_div:
> ^IBEX last: **missing**
> ^IBEX name:
> ^IBEX nav: **missing**
> ^IBEX net:
> ^IBEX open:
> ^IBEX p_change:
> ^IBEX pe:
> ^IBEX price: **missing**
> ^IBEX success: 0
> ^IBEX symbol: ^IBEX
> ^IBEX time:
> ^IBEX volume:
> ^IBEX year_range:
>
> And other Spanish stocks:
>
> gnc-fq-dump -v yahoo_europe AENA
> Finance::Quote fields Gnucash uses:
> symbol: AENA <=== required
> date: ** missing ** <=== required
> currency: ** missing ** <=== required
> last: <=\
> nav: <=== one of these
> price: <=/
> timezone: <=== optional
>
> ** This stock quote cannot be used by gnucash!!
>
>
> All fields returned by Finance::Quote for stock AENA
>
> stock field value
> ----- ----- -----
> AENA ask:
> AENA avg_vol:
> AENA bid:
> AENA cap:
> AENA close:
> AENA currency:
> AENA date:
> AENA day_range:
> AENA div:
> AENA div_date:
> AENA div_yield:
> AENA eps: -12.07
> AENA errormsg: Stock lookup failed
> AENA ex_div:
> AENA last: **missing**
> AENA name:
> AENA nav: **missing**
> AENA net:
> AENA open:
> AENA p_change:
> AENA pe:
> AENA price: **missing**
> AENA success: 0
> AENA symbol: AENA
> AENA time:
> AENA volume:
> AENA year_range:
>
> These funds and stocks can be found perfectly in the finance.yahoo.com
> website, but they don't work from Finance:Quote. Note that other stocks
> work perfectly.
>
> Is there anything I can try, or is it just an incompatibility whith Spanish
> funds and stocks?
>
> Thanks.
>
>
>
> ---------- Mensaje reenviado ----------
> From: John Ralls <jralls at ceridwen.us>
> To: Miguel Guedes <miguel.a.guedes at gmail.com>
> Cc: gnucash-user at lists.gnucash.org
> Date: Thu, 17 Dec 2015 19:45:02 -0800
> Subject: Re: Transactions involving different currencies
>
> > On Dec 17, 2015, at 3:08 PM, Miguel Guedes <miguel.a.guedes at gmail.com>
> wrote:
> >
> > Hello list!
> >
> > I'm trying to understand how to record transactions involving accounts
> > in different currencies. For this purpose I created a new book
> > containing the simple accounts subtree, one checking account in GBP and
> > another in EUR. GBP is the default currency.
> >
> > Now, to make this simple let's say I want to make a transfer from the
> > EUR account to the GBP one. I have taken the following steps:
> >
> > 1) Open EUR account and move to blank transaction
> > 2) In first split, enter 100 withdrawal for the EUR account
> > 3) Using the TAB key, navigate to second split and enter 100 deposit for
> > the GBP account
> > 4) Hitting TAB causes Gnucash to present me with a "transfer funds"
> > dialog asking me to specify the exchange rate, which I do by hitting the
> > "Fetch rate" button followed by Ok.
> > 5) I then hit the ENTER key to record the transaction and the following
> > splits are created:
> >
> > Assets:Current Assets:GBP +100.00
> > Trading:CURRENCY:EUR +138.89
> > Assets:Current Assets:EUR -100.00
> > Imbalance-EUR -38.89
> > Trading:CURRENCY:GBP +100.00
> >
> > The splits above are clearly wrong and that is most likely the result of
> > some erroneous action on my part, but what?
> >
> > Using Gnucash 2.6.1 on Linux but similar issue happened with v2.6.9
> > (after I temporarily upgraded via GetDeb thinking it might be a bug).
> > Have attempted to follow the following guide but can't get past the
> > first step describing the transfer:
> >
> >
> http://www.gnucash.org/docs/v2.6/C/gnucash-guide/currency_purchase1.html#currency_purchase2
> >
> > Would appreciate some help as I really want to make Gnucash my
> > accounting tool of choice!
>
> We know this is confusing. The way you enter multiple currencies is
> different when you have trading accounts enabled from when you don't: With
> trading accounts you enter the amount in the split account's currency,
> without you enter the amount in the transaction's currency. The last will
> be the currency of the register in which you first created the transaction.
>
> Another complication is that when you're in split view you're responsible
> for inserting the right amount into each split. GnuCash won't adjust the
> split amounts, it will only create a balancing split.
>
> To fix your transaction with the existing exchange rate, change the GBP
> amount to 72.00.
>
> To create two-currency transactions more easily, either stay in basic view
> and let the transfer dialog create the other split (not including the
> trading splits, which are created automatically later) or just use the
> transfer dialog for everything with Actions>Transfer.
>
> Regards,
> John Ralls
>
>
>
>
>
> ---------- Mensaje reenviado ----------
> From: Erik Colson <eco at ecocode.net>
> To: adler at dreamcoder.org
> Cc: gnucash-user at gnucash.org
> Date: Fri, 18 Dec 2015 08:41:58 +0100
> Subject: Re: Gnucash / Finance::Quote cannot retrieve Spanish stocks and
> funds
> Jose Gómez <adler at dreamcoder.org> writes:
>
> > I am trying to get the current value of a Spanish fund (INGDIRECTFNE.BC)
> > from Gnucash, and it is not working.
>
> Hi Jose,
>
> This is a problem due to the yahoo site which is queried by the
> yahoo_europe method inside FQ.
>
> This is the data returned by yahoo in response to the query:
>
> "INGDIRECTFNE.BC",N/A,N/A,N/A,N/A,N/A,N/A,N/A,N/A
>
> not really helpfull. that's why finance::quote can't return data..
>
> However the method yahoo_json returns this data:
>
> 'INGDIRECTFNE.BCdate' => '12/14/2015',
> 'INGDIRECTFNE.BCtype' => 'mutualfund',
> 'INGDIRECTFNE.BClast' => '11.790000',
> 'INGDIRECTFNE.BCsuccess' => 1,
> 'INGDIRECTFNE.BCvolume' => '0',
> 'INGDIRECTFNE.BCname' => 'INGDIRECTFNE.BC (ING Direct FN Euro
> Stoxx 50 FI)',
> 'INGDIRECTFNE.BCexchange' => 'Sourced from Yahoo Finance (as
> JSON)',
> 'INGDIRECTFNE.BCsymbol' => 'INGDIRECTFNE.BC',
> 'INGDIRECTFNE.BCmethod' => 'yahoo_json',
> 'INGDIRECTFNE.BCisodate' => '2015-12-14'
>
> looks like what you need ! except gnucash needs a currency and therefor
> it will also fail, I wouldn't even know what currency to return for this
> extension.. Tell me and I will hardcode it in yahoo_json for the .BC
> extension.
>
> best
> --
> erik colson
>
>
>
>
> ---------- Mensaje reenviado ----------
> From: David Carlson <david.carlson.417 at gmail.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Cc:
> Date: Fri, 18 Dec 2015 03:24:08 -0600
> Subject: Fwd: Re: Backups and recovery
> Please reply to list.
>
>
> ---------- Mensaje reenviado ----------
> From: Alaric <um.167 at xtra.co.nz>
> To: "david.carlson.417 at gmail.com" <david.carlson.417 at gmail.com>
> Cc:
> Date: Thu, 17 Dec 2015 19:54:09 +1300
> Subject: Re: Backups and recovery
> Gnucash version 2-6-4. I am running Debian 8
>
> I have read the manual and viewed the tutorial. I have been using gnucash
> for several years and have never had any problem before. After a computer
> crash I had to re-install Debian and install a number of programmes,
> including gnucash, which are not automatically installed by the distro
> installer. I have had to do this before.
>
> Usually I have been able to go to the file menu and ask to open a
> file and the file I select is the head file selected when a new set of
> accounts is created. In the case of my own books it is AWW15. Every time
> I have a session with gnucash and enter up the month's transactions gnucash
> creates and stores a log file and a zip archive. I have never had to worry
> about them because opening AWW15 populated the set of accounts.
>
> This time opening AWW15 produces a chart of accounts with the
> correct balances but clicking on a particular ledger account throws up an
> empty register with the current date in place but no data entries. I
> cannot find anything in the help manual or tutorial dealing with opening a
> file.
>
> Alaric
>
> -On 17/12/15 13:14, david.carlson.417 at gmail.com wrote:
>
>>
>>
>>
>>
>>
>>
>> Alaric,
>> We would be better able to help you if you take a few minutes to read the
>> help manual then tell us exactly which steps don't work as described. It
>> also helps to know which version of GnuCash you have Installed and what
>> operating system your computer has.
>> David C.
>> Sent from my LG G Pad 7.0 LTE, an AT&T 4G LTE tablet
>>
>>
>>
>> ------ Original message------From: AlaricDate: Wed, Dec 16, 2015 3:40
>> PMTo: gnucash-user at gnucash.org;Subject:Backups and recovery
>> I have a display problem which has involved re-installing several times.
>> In the past I could open gnucash and open my accounts by using 'open' and
>> selecting the name of the account such as AWW15. When I do this now the
>> chart of accounts comes up with the correct balances but none of the
>> registers have any information. In addition to the file name, all the
>> archive and log files are in the backup copy. I need to recover this if
>> possible as I need to keep the ledger for the year as a record of the
>> year's transactions. Can anyone suggest what I should
>> do?Regards,Alaric_______________________________________________gnucash-user
>> mailing listgnucash-user at gnucash.orghttps://
>> 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.
>>
>>
>>
>
>
> ---------- Mensaje reenviado ----------
> From: "Jose Gómez" <adler at dreamcoder.org>
> To: Erik Colson <eco at ecocode.net>
> Cc: gnucash-user at gnucash.org
> Date: Fri, 18 Dec 2015 11:15:18 +0000
> Subject: Re: Gnucash / Finance::Quote cannot retrieve Spanish stocks and
> funds
> Hi Eric,
>
> The Barcelona (BC) stock exchange, and particularly this fund, uses the EUR
> currency. Note, however, my limited financial knowledge, so I cannot
> confirm if that is the case for all funds and stocks in that exchange.
>
> What about other Spanish funds and stocks, such as ^IBEX and AENA.MC in
> the
> MCE exchange? I don't personally need them, but someone else may.
>
> Regards, Jose.
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
More information about the gnucash-user
mailing list