Re: [GNC] Corrupt security information

[Bruno Acklin]

Yes, this did the trick!! Thanks for the great coaching, John!

I guess the takeaway is that the origin of bug 
https://bugs.gnucash.org/show_bug.cgi?id=797512 
<https://bugs.gnucash.org/show_bug.cgi?id=797512> could be a double entry in 
the trading account.

I just found that I had other stocks with two or even three trading accounts; 
it seems that when I change the name of a stock, for instance when yahoo does 
so, eg from NESN.VX to NESN.SW, GnuCash creates another trading account, rather 
than renaming the existing one.

Now I am trying to find out why the lot scrubber sometime insists to create two 
identical Realized Gain/Loss entries..

Best regards,
Bruno

> On Jan 6, 2020, at 10:11 AM, John Ralls  wrote:
> 
> Bruno,
> 
> First delete the test transactions and the gain/loss transactions. Then 
> delete Trading:NASDAQ:INTC. Save.
> 
> You can try moving Trading:NYSE:INTC to Trading:NASDAQ:INTC (use Edit Account 
> and change the parent account to Trading:NASDAQ with the selector at the 
> bottom). While you're in the account editor check the commodity and make sure 
> that it's set to NASDAQ INTC and not NYSE INTC.
> 
> Try running the Lot scrubber. If the G/L transactions are created correctly 
> then try your test transactions.
> 
> If either fails you can quit GnuCash without saving to clear out the bad 
> transactions.
> 
> Regards,
> John Ralls
> 
>> On Jan 6, 2020, at 9:29 AM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> Yes, a great feature if it worked fully, but.. (one of its flawed features 
>> is that one does not have control over when it generated Realized Gain/Loss 
>> entries.) 
>> 
>> Sorry to confuse you. The number of transactions does not tie: I have 5 
>> trades, which are reflected in trading/NYSE/INTC, plus 2 test trades I 
>> entered using the NASDAQ/INTC security with the previously described 
>> problem. Then the lot scrubber generated 5 Gain/Loss entries also tied to 
>> the NASDAQ/NYSE account, and apparently unbalanced (same amount in 
>> Trading/NASDAQ/INTC, Orphaned Gains and (negative in Trading/Currency/USD)).
>> Strangely, the initial purchase in the asset account against /NYSE/INTC is 
>> unbalanced and is reflected once in the Trading/NYSE/INTC and twice in the 
>> Trading/NASDAQ/INC account.. - all stuck in unbalanced.
>> 
>> Do you agree that I should delete one of these trading accounts? If I delete 
>> Trading/NYSE/INTC I probably loose my correct transactions (saved). If I 
>> delete the Trading/NASDAQ/INTC account can rename the Trading/NYSE/INTC to 
>> Trading/NASDAQ/INTC?
>> 
>> Best regards,
>> Bruno
>> 
>> 
>>> On Jan 5, 2020, at 8:31 PM, John Ralls  wrote:
>>> 
>>> Bruno,
>>> 
>>> Ugh, the lot scrubber. Another variable in the problem.
>>> 
>>> Now I'm confused about the two trading accounts because you say that you've 
>>> got 5 trades in the asset account and each trading account. Do you have 
>>> splits both INTC trading accounts for one transaction? What about 
>>> Trading:CURRENCY:USD?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>>> On Jan 5, 2020, at 3:17 PM, Bruno Acklin  wrote:
>>>> 
>>>> I don’t think I have more than one asset account for INTC, and none of the 
>>>> trading accounts shows any transactions outside of the one I am using.
>>>> I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash 
>>>> would have let me), but I may have edited / moved it from NYSE to INTC in 
>>>> the security editor (which answers my last question, I guess ;-).
>>>> No worries, only about 5 trades in the asset account (and each trading 
>>>> account); I am mostly worried about loosing 20 years of pricing history, 
>>>> which is why I was looking for a way to export.
>>>> 
>>>> The issue came up when I started using Actions/View lots for calculating 
>>>> cap gains (working, but would need some work, such as an indication of the 
>>>> purchase date or lot in the automated entry, or way to define/edit a new 
>>>> lot, I think..)
>>>> 
>>>> Best regards,
>>>> Bruno
>>>> 
>>>> 
>>>> 
>>>> 
>>>>> On Jan 5, 2020, at 2:56 PM, John Ralls  wrote:
>>>>> 
>>>>> That's interesting. Do you have more than one INTC asset account, perhaps 
>>>>> with different brokers (and perhaps hidden on your Accounts page either 
>>>>> because you marked it hidden or have hide accounts w

Re: [GNC] Corrupt security information

[Bruno Acklin]

Hi John,

Yes, a great feature if it worked fully, but.. (one of its flawed features is 
that one does not have control over when it generated Realized Gain/Loss 
entries.) 

Sorry to confuse you. The number of transactions does not tie: I have 5 trades, 
which are reflected in trading/NYSE/INTC, plus 2 test trades I entered using 
the NASDAQ/INTC security with the previously described problem. Then the lot 
scrubber generated 5 Gain/Loss entries also tied to the NASDAQ/NYSE account, 
and apparently unbalanced (same amount in Trading/NASDAQ/INTC, Orphaned Gains 
and (negative in Trading/Currency/USD)).
Strangely, the initial purchase in the asset account against /NYSE/INTC is 
unbalanced and is reflected once in the Trading/NYSE/INTC and twice in the 
Trading/NASDAQ/INC account.. - all stuck in unbalanced.

Do you agree that I should delete one of these trading accounts? If I delete 
Trading/NYSE/INTC I probably loose my correct transactions (saved). If I delete 
the Trading/NASDAQ/INTC account can rename the Trading/NYSE/INTC to 
Trading/NASDAQ/INTC?

Best regards,
Bruno


> On Jan 5, 2020, at 8:31 PM, John Ralls  wrote:
> 
> Bruno,
> 
> Ugh, the lot scrubber. Another variable in the problem.
> 
> Now I'm confused about the two trading accounts because you say that you've 
> got 5 trades in the asset account and each trading account. Do you have 
> splits both INTC trading accounts for one transaction? What about 
> Trading:CURRENCY:USD?
> 
> Regards,
> John Ralls
> 
>> On Jan 5, 2020, at 3:17 PM, Bruno Acklin  wrote:
>> 
>> I don’t think I have more than one asset account for INTC, and none of the 
>> trading accounts shows any transactions outside of the one I am using.
>> I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash would 
>> have let me), but I may have edited / moved it from NYSE to INTC in the 
>> security editor (which answers my last question, I guess ;-).
>> No worries, only about 5 trades in the asset account (and each trading 
>> account); I am mostly worried about loosing 20 years of pricing history, 
>> which is why I was looking for a way to export.
>> 
>> The issue came up when I started using Actions/View lots for calculating cap 
>> gains (working, but would need some work, such as an indication of the 
>> purchase date or lot in the automated entry, or way to define/edit a new 
>> lot, I think..)
>> 
>> Best regards,
>> Bruno
>> 
>> 
>> 
>> 
>>> On Jan 5, 2020, at 2:56 PM, John Ralls  wrote:
>>> 
>>> That's interesting. Do you have more than one INTC asset account, perhaps 
>>> with different brokers (and perhaps hidden on your Accounts page either 
>>> because you marked it hidden or have hide accounts with 0 balances turned 
>>> on)? When you realized that INTC trades on NASDAQ and not NYSE did you edit 
>>> the security or make a new one?
>>> 
>>> How many transactions are in each account?
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>>> On Jan 5, 2020, at 2:34 PM, Bruno Acklin  wrote:
>>>> 
>>>> Thanks John,
>>>> 
>>>> I had a suspicion that this may be due to an ambiguous trading account: I 
>>>> had noticed that originally some transactions appeared under NYSE/INTC 
>>>> while my present security and prices are all under NASDAQ/INTC. There is 
>>>> no security defined under NYSE/INTC, but there is a trading account with 
>>>> that name (which has correct transactions and behaves normally), and one 
>>>> under Trading/NASDAQ/INTC with phony transactions ($number in the increase 
>>>> column instead of INTC shares), which is also caught in a rebalance loop.
>>>> 
>>>> Should I just delete one of the two trading accounts, and which one? I 
>>>> lean towards the NASDAQ one with the phony entries and then try to move 
>>>> INTC from NYSE to NASDAQ - how?
>>>> 
>>>> Best regards,
>>>> Bruno
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>>> On Jan 5, 2020, at 11:22 AM, John Ralls  wrote:
>>>>> 
>>>>> Bruno,
>>>>> 
>>>>> Don't do anything drastic yet, but everything is pretty independent. You 
>>>>> could change the name on the old INTC and create a new INTC security and 
>>>>> GnuCash will happily use your INTC prices for pricing the new security. 
>>>>> They're linked by the security name and namespace, not by GUID. 
>>>>> Unfortunately GnuCash won't let you reassign the account but you c

Re: [GNC] Corrupt security information

[Bruno Acklin]

I don’t think I have more than one asset account for INTC, and none of the 
trading accounts shows any transactions outside of the one I am using.
I am pretty sure I did not create a 2nd asset INTC (and doubt Gnucash would 
have let me), but I may have edited / moved it from NYSE to INTC in the 
security editor (which answers my last question, I guess ;-).
No worries, only about 5 trades in the asset account (and each trading 
account); I am mostly worried about loosing 20 years of pricing history, which 
is why I was looking for a way to export.

The issue came up when I started using Actions/View lots for calculating cap 
gains (working, but would need some work, such as an indication of the purchase 
date or lot in the automated entry, or way to define/edit a new lot, I think..)

Best regards,
Bruno




> On Jan 5, 2020, at 2:56 PM, John Ralls  wrote:
> 
> That's interesting. Do you have more than one INTC asset account, perhaps 
> with different brokers (and perhaps hidden on your Accounts page either 
> because you marked it hidden or have hide accounts with 0 balances turned 
> on)? When you realized that INTC trades on NASDAQ and not NYSE did you edit 
> the security or make a new one?
> 
> How many transactions are in each account?
> 
> Regards,
> John Ralls
> 
>> On Jan 5, 2020, at 2:34 PM, Bruno Acklin  wrote:
>> 
>> Thanks John,
>> 
>> I had a suspicion that this may be due to an ambiguous trading account: I 
>> had noticed that originally some transactions appeared under NYSE/INTC while 
>> my present security and prices are all under NASDAQ/INTC. There is no 
>> security defined under NYSE/INTC, but there is a trading account with that 
>> name (which has correct transactions and behaves normally), and one under 
>> Trading/NASDAQ/INTC with phony transactions ($number in the increase column 
>> instead of INTC shares), which is also caught in a rebalance loop.
>> 
>> Should I just delete one of the two trading accounts, and which one? I lean 
>> towards the NASDAQ one with the phony entries and then try to move INTC from 
>> NYSE to NASDAQ - how?
>> 
>> Best regards,
>> Bruno
>> 
>> 
>> 
>> 
>> 
>>> On Jan 5, 2020, at 11:22 AM, John Ralls  wrote:
>>> 
>>> Bruno,
>>> 
>>> Don't do anything drastic yet, but everything is pretty independent. You 
>>> could change the name on the old INTC and create a new INTC security and 
>>> GnuCash will happily use your INTC prices for pricing the new security. 
>>> They're linked by the security name and namespace, not by GUID. 
>>> Unfortunately GnuCash won't let you reassign the account but you can create 
>>> a new one and transfer the balance with a transaction.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>>> On Jan 5, 2020, at 9:37 AM, Bruno Acklin  wrote:
>>>> 
>>>> Hi John,
>>>> 
>>>> Thanks for the impressively quick reply - and yes, I agree this looks like 
>>>> the same problem!
>>>> Unfortunately there does not seem to be another fix than recreating the 
>>>> stock, account and transactions..
>>>> 
>>>> Do you know of a way I might preserve the 20 years of price data I have on 
>>>> that stock? I saw a suggestion to create a suitable report and reimport 
>>>> the resulting file, but I dd not see any report that would allow me to 
>>>> save price information.
>>>> 
>>>> Best regards,
>>>> Bruno Acklin
>>>> (408) 425 4753
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>>> On Jan 4, 2020, at 7:43 PM, John Ralls  wrote:
>>>>> 
>>>>> 
>>>>> 
>>>>>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin  wrote:
>>>>>> 
>>>>>> Best wishes for 2020!
>>>>>> 
>>>>>> I am struggling with a stock account, where I am unable to enter any 
>>>>>> valid transactions, and suspect the security information may be 
>>>>>> corrupted:
>>>>>> 
>>>>>> Whenever I enter a trade from the account (declared as stock for an 
>>>>>> existing security INTC) and press return, Gnucash completes a 
>>>>>> transaction (cf attachment), which looks ok, except there is no shares 
>>>>>> traded and there is no way to enter any quantity on the trading account. 
>>>>>> Gnucash insists on balancing the transaction, after which there is a 
>>>>>> huge number

Re: [GNC] Corrupt security information

[Bruno Acklin]

Thanks John,

I had a suspicion that this may be due to an ambiguous trading account: I had 
noticed that originally some transactions appeared under NYSE/INTC while my 
present security and prices are all under NASDAQ/INTC. There is no security 
defined under NYSE/INTC, but there is a trading account with that name (which 
has correct transactions and behaves normally), and one under 
Trading/NASDAQ/INTC with phony transactions ($number in the increase column 
instead of INTC shares), which is also caught in a rebalance loop.

Should I just delete one of the two trading accounts, and which one? I lean 
towards the NASDAQ one with the phony entries and then try to move INTC from 
NYSE to NASDAQ - how?

Best regards,
Bruno





> On Jan 5, 2020, at 11:22 AM, John Ralls  wrote:
> 
> Bruno,
> 
> Don't do anything drastic yet, but everything is pretty independent. You 
> could change the name on the old INTC and create a new INTC security and 
> GnuCash will happily use your INTC prices for pricing the new security. 
> They're linked by the security name and namespace, not by GUID. Unfortunately 
> GnuCash won't let you reassign the account but you can create a new one and 
> transfer the balance with a transaction.
> 
> Regards,
> John Ralls
> 
>> On Jan 5, 2020, at 9:37 AM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> Thanks for the impressively quick reply - and yes, I agree this looks like 
>> the same problem!
>> Unfortunately there does not seem to be another fix than recreating the 
>> stock, account and transactions..
>> 
>> Do you know of a way I might preserve the 20 years of price data I have on 
>> that stock? I saw a suggestion to create a suitable report and reimport the 
>> resulting file, but I dd not see any report that would allow me to save 
>> price information.
>> 
>> Best regards,
>> Bruno Acklin
>> (408) 425 4753
>> 
>> 
>> 
>> 
>> 
>>> On Jan 4, 2020, at 7:43 PM, John Ralls  wrote:
>>> 
>>> 
>>> 
>>>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin  wrote:
>>>> 
>>>> Best wishes for 2020!
>>>> 
>>>> I am struggling with a stock account, where I am unable to enter any valid 
>>>> transactions, and suspect the security information may be corrupted:
>>>> 
>>>> Whenever I enter a trade from the account (declared as stock for an 
>>>> existing security INTC) and press return, Gnucash completes a transaction 
>>>> (cf attachment), which looks ok, except there is no shares traded and 
>>>> there is no way to enter any quantity on the trading account. Gnucash 
>>>> insists on balancing the transaction, after which there is a huge number 
>>>> in the trading/share account, but still no quantity of shares traded, and 
>>>> no way to complete the transaction, other than closing the account tab.
>>>> 
>>>> I checked the security and my price information which looks ok and updates 
>>>> w/ finance::quote. If I have to recreate the account and reenter all 
>>>> transactions, I’d like to save the historic price information, but don’t 
>>>> know of a way to export it.
>>>> 
>>> 
>>> That sounds like a variation on 
>>> https://bugs.gnucash.org/show_bug.cgi?id=797512.
>>> 
>>> Regards,
>>> John Ralls
>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Corrupt security information

[Bruno Acklin]

Hi John,

Thanks for the impressively quick reply - and yes, I agree this looks like the 
same problem!
Unfortunately there does not seem to be another fix than recreating the stock, 
account and transactions..

Do you know of a way I might preserve the 20 years of price data I have on that 
stock? I saw a suggestion to create a suitable report and reimport the 
resulting file, but I dd not see any report that would allow me to save price 
information.

Best regards,
Bruno Acklin
(408) 425 4753





> On Jan 4, 2020, at 7:43 PM, John Ralls  wrote:
> 
> 
> 
>> On Jan 4, 2020, at 6:39 PM, Bruno Acklin  wrote:
>> 
>> Best wishes for 2020!
>> 
>> I am struggling with a stock account, where I am unable to enter any valid 
>> transactions, and suspect the security information may be corrupted:
>> 
>> Whenever I enter a trade from the account (declared as stock for an existing 
>> security INTC) and press return, Gnucash completes a transaction (cf 
>> attachment), which looks ok, except there is no shares traded and there is 
>> no way to enter any quantity on the trading account. Gnucash insists on 
>> balancing the transaction, after which there is a huge number in the 
>> trading/share account, but still no quantity of shares traded, and no way to 
>> complete the transaction, other than closing the account tab.
>> 
>> I checked the security and my price information which looks ok and updates 
>> w/ finance::quote. If I have to recreate the account and reenter all 
>> transactions, I’d like to save the historic price information, but don’t 
>> know of a way to export it.
>> 
> 
> That sounds like a variation on 
> https://bugs.gnucash.org/show_bug.cgi?id=797512 
> <https://bugs.gnucash.org/show_bug.cgi?id=797512>.
> 
> Regards,
> John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Corrupt security information

[Bruno Acklin]

Best wishes for 2020!

I am struggling with a stock account, where I am unable to enter any valid 
transactions, and suspect the security information may be corrupted:

Whenever I enter a trade from the account (declared as stock for an existing 
security INTC) and press return, Gnucash completes a transaction (cf 
attachment), which looks ok, except there is no shares traded and there is no 
way to enter any quantity on the trading account. Gnucash insists on balancing 
the transaction, after which there is a huge number in the trading/share 
account, but still no quantity of shares traded, and no way to complete the 
transaction, other than closing the account tab.

I checked the security and my price information which looks ok and updates w/ 
finance::quote. If I have to recreate the account and reenter all transactions, 
I’d like to save the historic price information, but don’t know of a way to 
export it.

Thanks for any suggestions,
Bruno




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Thanks David,

I am a retired Physicist - so likely even further from solving this ;-(
My use is similar, trying to update quotes weekly - for now forcedly connecting 
to my neighbors network..

Gnucash is phantastic SW and well maintained and supported (THANKS to John and 
others !!!), even if so far unsuccessful.

Best, Bruno

> On Apr 26, 2019, at 10:52 AM, David Carlson  
> wrote:
> 
> Bruno,
> 
> I am a retired Electrical Engineer with no formal training in modern 
> programming languages but I am passionate about safe use of the Internet and 
> environmental stewardship.  I also use GnuCash for personal financial record 
> keeping.
> 
> With that background I depend on the GnuCash developers to continue to 
> improve it, which they have been successfully doing for several years with 
> very limited resources.
> 
> I have not worked 'under the hood' very much with GnuCash due to my limited 
> expertise.  I don't know about curl or how it might be useful.
> 
> Coercing for me consisted mainly in getting Perl installed and working to use 
> F::Q with GnuCash in Windows 7 and in Ubuntu 16.04 and later Ubuntu 18.04.  
> For some reason I have not gotten it to work in both direct and remote 
> environments, but I quit trying when I had one method working as other 
> projects demanded my attention.  I only download prices once every month.
> 
> Good luck with solving your networking problems.
> 
> David Carlson
> 
> On Fri, Apr 26, 2019 at 11:36 AM Bruno Acklin  <mailto:back...@gmail.com>> wrote:
> Thanks David,
> 
> Does the corresponding curl command work from your other computers as well?
> Any suggestions what “coercing” involved in your case?
> 
> Best, Bruno
> 
>> On Apr 22, 2019, at 6:48 PM, David Carlson > <mailto:david.carlson@gmail.com>> wrote:
>> 
>> I too use ATT Uverse as my ISP and i know they do have some strange 
>> settings in their router, but the basic firewall and TCP port settings out 
>> of the box are fine for most users without tinkering with pinholes or other 
>> firewall settings.  In my neighborhood they now set IPV6 as preferred 
>> addressing protocol.  I have several Windows and Linux real or virtual 
>> computers including a few with GnuCash 2.6.17 or 19, but I have only managed 
>> to coerce one of them to download price quotes, and then only when running 
>> in a local desktop but not in a remote terminal.
>> 
>> I do not know enough about networking to be able to say whether you have a 
>> problem with your router or firewall.
>> 
>> David Carlson 
>> 
>> 
>> On Mon, Apr 22, 2019, 3:16 PM Bruno Acklin > <mailto:back...@gmail.com>> wrote:
>> Wow, thanks all for your thoughts, although unfortunately this remains an 
>> unsolved mystery to me!
>> 
>> Tools/"Price Editor"/"Get Quotes" still works smoothly when I disconnect the 
>> ethernet cable to my router (standard ATT Uverse DSL router and 
>> configuration with DNS 68.94.156.1 and ..157.1) and use wifi to my neighbors 
>> router (cable based), and vice versa not if I reconnect my ethernet.
>> 
>> [@David] So definitely different ISP, DNS, etc for the two paths.
>> 
>> [@AC] I did not see any proxy information on my routers broadband status.
>> <"LWP apparently will also self report a 500 status if the connection fails 
>> for any reason"> I also “interpreted" the 500 error as a sort of timeout 
>> error, because the response comes only after a second or two while it is 
>> instantaneous with curl or browser.
>> 
>> [@Ronal, ..] I checked for open TCP ports using loopback address 127.0.0.1 
>> (Is this the right way?). Received identical responses for both paths, 
>> including Port 88 (but not 80!).
>> 
>> In looking at my firewall settings I noticed that “the computer that will 
>> host applications through the firewall” is still set to my old Time Machine 
>> router (which I assume still runs its own firewall which used to work fine 
>> for gnc-fc before). Should that be set to my desktop?
>> 
>> I am assuming that a server response to an http: call is governed by 
>> “outgoing protocol control” rules, and does not need any inbound protocol 
>> control enabled, correct? 
>> 
>> Thanks and best,
>> Bruno
>> 
>> > On Apr 13, 2019, at 12:41 PM, Adrien Monteleone 
>> > mailto:adrien.montele...@lusfiber.net>> 
>> > wrote:
>> > 
>> > It doesn’t make any sense to me either. But curl works, perl doesn’t. What 
>> > does that perl script actually do when it tries to pull that URL?
>> > 

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Thanks David,

Does the corresponding curl command work from your other computers as well?
Any suggestions what “coercing” involved in your case?

Best, Bruno

> On Apr 22, 2019, at 6:48 PM, David Carlson  
> wrote:
> 
> I too use ATT Uverse as my ISP and i know they do have some strange 
> settings in their router, but the basic firewall and TCP port settings out of 
> the box are fine for most users without tinkering with pinholes or other 
> firewall settings.  In my neighborhood they now set IPV6 as preferred 
> addressing protocol.  I have several Windows and Linux real or virtual 
> computers including a few with GnuCash 2.6.17 or 19, but I have only managed 
> to coerce one of them to download price quotes, and then only when running in 
> a local desktop but not in a remote terminal.
> 
> I do not know enough about networking to be able to say whether you have a 
> problem with your router or firewall.
> 
> David Carlson 
> 
> 
> On Mon, Apr 22, 2019, 3:16 PM Bruno Acklin  <mailto:back...@gmail.com>> wrote:
> Wow, thanks all for your thoughts, although unfortunately this remains an 
> unsolved mystery to me!
> 
> Tools/"Price Editor"/"Get Quotes" still works smoothly when I disconnect the 
> ethernet cable to my router (standard ATT Uverse DSL router and configuration 
> with DNS 68.94.156.1 and ..157.1) and use wifi to my neighbors router (cable 
> based), and vice versa not if I reconnect my ethernet.
> 
> [@David] So definitely different ISP, DNS, etc for the two paths.
> 
> [@AC] I did not see any proxy information on my routers broadband status.
> <"LWP apparently will also self report a 500 status if the connection fails 
> for any reason"> I also “interpreted" the 500 error as a sort of timeout 
> error, because the response comes only after a second or two while it is 
> instantaneous with curl or browser.
> 
> [@Ronal, ..] I checked for open TCP ports using loopback address 127.0.0.1 
> (Is this the right way?). Received identical responses for both paths, 
> including Port 88 (but not 80!).
> 
> In looking at my firewall settings I noticed that “the computer that will 
> host applications through the firewall” is still set to my old Time Machine 
> router (which I assume still runs its own firewall which used to work fine 
> for gnc-fc before). Should that be set to my desktop?
> 
> I am assuming that a server response to an http: call is governed by 
> “outgoing protocol control” rules, and does not need any inbound protocol 
> control enabled, correct? 
> 
> Thanks and best,
> Bruno
> 
> > On Apr 13, 2019, at 12:41 PM, Adrien Monteleone 
> > mailto:adrien.montele...@lusfiber.net>> 
> > wrote:
> > 
> > It doesn’t make any sense to me either. But curl works, perl doesn’t. What 
> > does that perl script actually do when it tries to pull that URL?
> > 
> > Regards,
> > Adrien
> > 
> >> On Apr 13, 2019, at 9:17 AM, John Ralls  >> <mailto:jra...@ceridwen.us>> wrote:
> >> 
> >> The URL is given several times in the thread, it's http, port 80. That 
> >> aside, get real: A firewall that blocks a port when perl's LWP is the 
> >> agent but not when curl or a web browser is?
> >> 
> >> Besides, the request isn't blocked, it's munged so that Yahoo! returns a 
> >> 500--server error response. So we have to imagine that the router can 
> >> somehow tell that the packets are coming from curl and not messing with 
> >> them or perl LWP and messing with them? That's a pretty amazing firewall.
> >> 
> >> Regards,
> >> John Ralls
> >> 
> >>> On Apr 13, 2019, at 2:32 AM, Adrien Monteleone 
> >>> mailto:adrien.montele...@lusfiber.net>> 
> >>> wrote:
> >>> 
> >>> More likely a blocked port though since the OP said curl works to 
> >>> retrieve the same URL, but not perl. A look at the perl script will 
> >>> probably expose the issue.
> >>> 
> >>> Regards,
> >>> Adrien
> >>> 
> >>>> On Apr 13, 2019, at 4:29 AM, David Carlson  >>>> <mailto:david.carlson@gmail.com>> wrote:
> >>>> 
> >>>> A different router could also mean a different ISP, a different DNS, and
> >>>> that is just the starting point...
> >>>> 
> >>>> David Carlson
> >>>> 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
> > To update your

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Wow, thanks all for your thoughts, although unfortunately this remains an 
unsolved mystery to me!

Tools/"Price Editor"/"Get Quotes" still works smoothly when I disconnect the 
ethernet cable to my router (standard ATT Uverse DSL router and configuration 
with DNS 68.94.156.1 and ..157.1) and use wifi to my neighbors router (cable 
based), and vice versa not if I reconnect my ethernet.

[@David] So definitely different ISP, DNS, etc for the two paths.

[@AC] I did not see any proxy information on my routers broadband status.
<"LWP apparently will also self report a 500 status if the connection fails for 
any reason"> I also “interpreted" the 500 error as a sort of timeout error, 
because the response comes only after a second or two while it is instantaneous 
with curl or browser.

[@Ronal, ..] I checked for open TCP ports using loopback address 127.0.0.1 (Is 
this the right way?). Received identical responses for both paths, including 
Port 88 (but not 80!).

In looking at my firewall settings I noticed that “the computer that will host 
applications through the firewall” is still set to my old Time Machine router 
(which I assume still runs its own firewall which used to work fine for gnc-fc 
before). Should that be set to my desktop?

I am assuming that a server response to an http: call is governed by “outgoing 
protocol control” rules, and does not need any inbound protocol control 
enabled, correct? 

Thanks and best,
Bruno

> On Apr 13, 2019, at 12:41 PM, Adrien Monteleone 
>  wrote:
> 
> It doesn’t make any sense to me either. But curl works, perl doesn’t. What 
> does that perl script actually do when it tries to pull that URL?
> 
> Regards,
> Adrien
> 
>> On Apr 13, 2019, at 9:17 AM, John Ralls  wrote:
>> 
>> The URL is given several times in the thread, it's http, port 80. That 
>> aside, get real: A firewall that blocks a port when perl's LWP is the agent 
>> but not when curl or a web browser is?
>> 
>> Besides, the request isn't blocked, it's munged so that Yahoo! returns a 
>> 500--server error response. So we have to imagine that the router can 
>> somehow tell that the packets are coming from curl and not messing with them 
>> or perl LWP and messing with them? That's a pretty amazing firewall.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Apr 13, 2019, at 2:32 AM, Adrien Monteleone 
>>>  wrote:
>>> 
>>> More likely a blocked port though since the OP said curl works to retrieve 
>>> the same URL, but not perl. A look at the perl script will probably expose 
>>> the issue.
>>> 
>>> Regards,
>>> Adrien
>>> 
 On Apr 13, 2019, at 4:29 AM, David Carlson  
 wrote:
 
 A different router could also mean a different ISP, a different DNS, and
 that is just the starting point...
 
 David Carlson
 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Hi John,

Thanks, confirmed that it’s nothing to do with Perl and gnucash / financequote.

I connected to my neighbors Wifi and finance quote works like a charm. When I 
go back through my router I times out again.
Any suggestion if it is a DNS or a TCP, or UDP poor I should look for and 
configure?

Best, Bruno

> On Mar 30, 2019, at 8:02 PM, John Ralls  wrote:
> 
> Stockdump.pl isn't misinterpreting anything. You can pass it multiple symbols 
> and it prepends the symbol to each message so that you know which message 
> goes with which symbol.
> 
> It seems unlikely that it's a DNS issue, but you could take the laptop 
> somewhere where there's public wifi and try from there. An Apple Store might 
> be a good choice, because then you can show the problem to a "Genius" and see 
> what they think.
> 
> I'm out of ideas for what could be borked with perl. You might try creating a 
> new user and running stock dump as that user (you'll need to adjust 
> permissions in your home directory) just to make sure that it isn't something 
> goofy in your environment.
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Mar 30, 2019, at 3:59 PM, Bruno Acklin  wrote:
>> 
>> John,
>> 
>> Thanks for your help and patience!
>> 
>> I did just that and updated Net::HTTP, as well as LWP, Date::Manip and 
>> Finance::Quote again. All of them are confirmed up to date now.
>> 
>> But calling …/stockdump.pl still yields an "internal server error” 500:
>> 
>> Brunos-MacBook-Pro:~ backlin$ 
>> ~/.cpan/build/Finance-Quote-1.47-FVw_VE/Examples/stockdump.pl yahoo_json aapl
>> $VAR1 = {
>>  'aaplsymbol' => 'aapl',
>>  'aaplsuccess' => 0,
>>  'aaplerrormsg' => 'Error retrieving quote for aapl. Attempt to 
>> fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl 
>> resulted in HTTP response 500 (Internal Server Error)'
>>};
>> 
>> Why is stockdump.pl misinterpreting the parameters and prepending apple to 
>> ‘symbol’ and ‘success’ and 'error msg’?
>> 
>> Still, calling the very URL in the error message using curl works instantly:
>> Brunos-MacBook-Pro:~ backlin$ curl 
>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
>> {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq
>>  Real Time 
>> Price","currency":"USD","fullExchangeName":"NasdaqGS","longName":"Apple ..
>> 
>> Could Perl address another "internal server” which times out? A DNS issue?
>> Do you have any other suggestions to try, or can point out the program 
>> hierarchy to trace these calls?
>> (Again reminding that I have this problem on two independent installations, 
>> and it appeared overnight, while gnucash on Desktop, and Perl Terminal 
>> window on Laptop were open and running.)
>> 
>> Thanks, Bruno
>> 
>>> On Mar 28, 2019, at 6:15 PM, John Ralls  
>>> wrote:
>>> 
>>> ~/.cpan/build/Finance-Quote-1.47-X/Examples/stockdump.p
>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

   John,
   Thanks for your help and patience!
   I did just that and updated Net::HTTP, as well as LWP, Date::Manip and
   Finance::Quote again. All of them are confirmed up to date now.
   But calling …/stockdump.pl still yields an "internal server error” 500:
   Brunos-MacBook-Pro:~ backlin$
   ~/.cpan/build/Finance-Quote-1.47-FVw_VE/Examples/stockdump.pl
   yahoo_json aapl
   $VAR1 = {
 'aaplsymbol' => 'aapl',
 'aaplsuccess' => 0,
 'aaplerrormsg' => 'Error retrieving quote for aapl. Attempt
   to fetch the URL
   [1]https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
   resulted in HTTP response 500 (Internal Server Error)'
   };
   Why is stockdump.pl misinterpreting the parameters and prepending apple
   to ‘symbol’ and ‘success’ and 'error msg’?
   Still, calling the very URL in the error message using curl works
   instantly:
   Brunos-MacBook-Pro:~ backlin$ curl
   [2]https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
   {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteTyp
   e":"EQUITY","quoteSourceName":"Nasdaq Real Time
   Price","currency":"USD","fullExchangeName":"NasdaqGS","longName":"Apple
   ..
   Could Perl address another "internal server” which times out? A DNS
   issue?
   Do you have any other suggestions to try, or can point out the program
   hierarchy to trace these calls?
   (Again reminding that I have this problem on two independent
   installations, and it appeared overnight, while gnucash on Desktop, and
   Perl Terminal window on Laptop were open and running.)
   Thanks, Bruno

   On Mar 28, 2019, at 6:15 PM, John Ralls
   <[3]jra...@ceridwen.fremont.ca.us> wrote:

   ~/.cpan/build/Finance-Quote-1.47-X/Examples/stockdump.p

References

   1. https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
   2. https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
   3. mailto:jra...@ceridwen.fremont.ca.us
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Hi John,

Sorry if I was unclear: the sudo cpan -i Finance::Quote install seemed to have 
succeeded without error messages, but execution still fails as before.

I upgraded Xcode to 10.2 and there seems no longer an option to add command 
line tools from Preferences.
My Library/Developer only contained /PrivateFrameworks/CoreSimulator.framework 
and /ROCKit.framework.
So I followed instructions from the link 
https://donatstudios.com/MojaveMissingHeaderFile 
<https://donatstudios.com/MojaveMissingHeaderFile>
to install /CommandLineTools, where I found and installed the 
macOS_SDK_headers_for_macOS_10.14.pkg you suggested. 

I would not know where to look if this fixed ExtUtils::MakeMaker, as other than 
for the /CommandLineTools my /Library/Developer and /Library/Perl folders 
looked unchanged. So I deleted Finance-Quote* and Date-Manip* again in 
Library/Perl and ~/.cpan/build, and reinstalled Date::Manip and Finance::Quote 
from clan.
Now my Library/Perl/5.18 contains: /CPAN, /Date, /Devel, /ExtUtils, /Finance, 
/HTML, /JSON, /Mozilla, /Parse, /Pod, /Test, /Darwin-thread-multi-2level, as 
well as AppendToPath and JSON.pm, butno /LWP /DateTime (still at 10.14.3, but 
like your new 10.14.4 install) or a /Perl/Extras/5.18 folder.

Unfortunately, again no success:
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v yahoo_json aapl
Still fails and returns:
..
All fields returned by Finance::Quote for stock aapl

stock   field  value
-   -  -
aapl errormsg: Error retrieving quote for aapl. Attempt to fetch the 
URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted in 
HTTP response 500 (Internal Server Error)
aapl last: **missing**
aapl  nav: **missing**
aaplprice: **missing**
aapl  success: 0
aapl   symbol: aapl

Interestingly though, calling the same URL from the Safari browser instantly 
returns successful quotes..

I am still stuck with the fact that selecting “Get Quotes” from the "Price 
Editor” in Gnucash worked fine one week, and not a week later from the same 
Gnucash instance still open and running on my desktop, without closing the 
program, installing any software, or modifying my system, other than installing 
a new router… Does that not point to something outside the OSX and Perl 
installation?

Thanks and Best,
Bruno


> On Mar 25, 2019, at 10:44 PM, John Ralls  
> wrote:
> 
> Bruno,
> 
> It turns out that Apple decided to put the perl headers exclusively in the 
> Xcode SDK but their perl patch doesn't quite work. Gory details may be read 
> at https://rt.cpan.org/Public/Bug/Display.html?id=127028.
> 
> The work-around in the last post to that bug, installing command-line tools 
> and then installing 
> /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg
>  got me a clean ExtUtils::MakeMaker install without the whining about 
> EXTERNAL.h. With that in place Date::Manip will also install correctly.
> 
> I just found /System/Library/Perl/Extras/5.18/. It has DateTime and LWP, 
> explaining why F::Q doesn't complain about not finding them when they're not 
> in /Library/Perl. In fact in the course of installing Command Line Tools I 
> also got a system upgrade (from 10.14.4beta to 10.14.4) and that removed 
> DateTime and LWP from /Library/Perl/5.18 on my system. It didn't break 
> Finance::Quote, so I guess LWP is ruled out as the source of your problem.
> 
> When you say that Finance::Quote seems to work without problem does that mean 
> that stockdump.pl works but gnc-fq-dump still reports a 500 error?
> 
> Regards,
> John Ralls
> 
> 
> 
>> On Mar 25, 2019, at 4:37 PM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> I was referring to MacHD/Library/Perl, so proceeded following your 
>> suggestions.
>> 
>> The rm commands worked.
>> Tried installing Date::Manip, as you suggested, which generated a long log 
>> (attached in full), but seems to have failed for the following reasons (I 
>> noticed):
>> 'YAML' not installed, will not store persistent state
>> ..
>> # Test.xs:1:10: fatal error: 'EXTERN.h' file not found
>> # #include "EXTERN.h"
>> #  ^~
>> # 1 error generated. (several times)
>> ..
>> Test Summary Report
>> ---
>> t/02-xsdynamic.t(Wstat: 3072 Tests: 72 Failed: 12)
>> Failed tests:  4, 10, 16, 22, 28, 34, 40, 46, 52, 58, 64
>>   70
>> Non-zero exit status: 12
>> Files=67, Tests=1335, 42 wallclock secs ( 0.34 usr  0.15 sys + 25.66 cusr  
>> 9.00 csys = 35.15 CPU)
>> Result: FAIL
>> Failed 1/67 test programs. 12/1335 subtests failed.
>> make: *** [test_dynamic] Error 255
>> BINGOS/ExtUtils-Mak

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Hi John,

I was referring to MacHD/Library/Perl, so proceeded following your suggestions.

The rm commands worked.
Tried installing Date::Manip, as you suggested, which generated a long log 
(attached in full), but seems to have failed for the following reasons (I 
noticed):
'YAML' not installed, will not store persistent state
..
# Test.xs:1:10: fatal error: 'EXTERN.h' file not found
# #include "EXTERN.h"
#  ^~
# 1 error generated.(several times)
..
Test Summary Report
---
t/02-xsdynamic.t(Wstat: 3072 Tests: 72 Failed: 12)
  Failed tests:  4, 10, 16, 22, 28, 34, 40, 46, 52, 58, 64
70
  Non-zero exit status: 12
Files=67, Tests=1335, 42 wallclock secs ( 0.34 usr  0.15 sys + 25.66 cusr  9.00 
csys = 35.15 CPU)
Result: FAIL
Failed 1/67 test programs. 12/1335 subtests failed.
make: *** [test_dynamic] Error 255
  BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports BINGOS/ExtUtils-MakeMaker-7.34.tar.gz
Running make install
  make test had returned bad status, won't install without force
Running make for S/SB/SBECK/Date-Manip-6.76.tar.gz
Warning: Prerequisite 'ExtUtils::MakeMaker => 6.67_01' for 
'SBECK/Date-Manip-6.76.tar.gz' failed when processing 
'BINGOS/ExtUtils-MakeMaker-7.34.tar.gz' with 'make_test => NO'. Continuing, but 
chances to succeed are limited.

  CPAN.pm: Building S/SB/SBECK/Date-Manip-6.76.tar.gz

ExtUtils::MakeMaker version 6.6701 required--this is only version 6.66 at 
Makefile.PL line 8.
BEGIN failed--compilation aborted at Makefile.PL line 8.
Warning: No success on command[/usr/bin/perl Makefile.PL]
  SBECK/Date-Manip-6.76.tar.gz
  /usr/bin/perl Makefile.PL -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install
Could not read metadata file. Falling back to other methods to determine 
prerequisites.

sudo cpan -i Finance::Quote seems to work fine and complete w/o errors, but 
gc-fnc-helper and -dump keep failing with same results as before.

I may have screwed up this sandbox installation, but checked contents of my 
desktop which worked before but fails now as well and has not been changed to 
the best log my knowledge: (It contains date Date, Finance, but apparently 
lacks DateTime, LWP, LWP.pm)

5.18
CPAN
Darwin-thread-multi-2level
Date
ExtUtils
Finance
HTML
JSON
Mozilla
Parse
Test
AppendToPath
JSON.pm
Updates
5.18.2
Darwin-thread-multi-2level

Best, Bruno

> On Mar 24, 2019, at 3:08 PM, John Ralls  wrote:
> 
> Bruno,
> 
> No, there's no reason to install a fake-linux package manager.
> 
> You said "Library/Perl", does that mean /Users/backlin/Library/Perl or 
> /Library/Perl? It should be the latter. If it's the former, what's in 
> /Library/Perl?
> 
> Assuming that it *is* /Library/Perl, there are several packages that should 
> be there and aren't. I suggest
>  sudo rm -rf /Library/Perl/5.18/Finance
>  sudo rm -rf ~/.cpan/build/Finance-Quote*
>  sudo rm -rf -/.cpan/build/Date-Manip*
>  sudo cpan -i Date::Manip
>  sudo cpan -i Finance::Quote
> 
> Check the output of those last two to make sure that they complete 
> successfully. Reinstalling Finance::Quote should pull in the other packages. 
> After it's done /Library/Perl/5.18 should contain Date, DateTime, Finance, 
> LWP, and LWP.pm in addition to the modules already there.
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 24, 2019, at 2:36 PM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> Sorry for the omission and delay.
>> 
>> No, I have none of these “fake-Linux package managers”(?) installed - should 
>> I?
>> 
>> The reply to backlin$ which perl is
>> /usr/bin/perl
>> 
>> In usr/bin I find two entries:
>> perl and
>> perl5.18
>> 
>> The directory Library/Perl contains
>> /5.18
>>  /Darwin-thread-multi-2level
>>  /Finance
>>  /HTML
>>  /JSON
>>  /Mozilla
>>  /AppendToPath
>>  /JSON.pm
>> /Updates
>>  /5.18.2
>>  /Darwin-thread-multi-2level
>> 
>> Looking up contents of 
>> ~/.cpan/build/ :
>> Date-Manip-6.75-JzZ9Wt   ExtUtils-MakeMaker-7.34-_6iXcq
>> Date-Manip-6.76-9mWyaN   Finance-Quote-1.47-_BUlzK
>> Date-Manip-6.76-NE8c76   Finance-Quote-1.47-nChsgf
>> Date-Manip-6.76-QNnn65   HTML-TableExtract-2.15-dP4w2A
>> ExtUtils-MakeMaker-7.34-695wh2   JSON-4.02-RrPsdw
>> ExtUtils-MakeMaker-7.34-DVwu8U   Mozilla-CA-20180117-TgJL7x
>> ExtU

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Hi John,

Sorry for the omission and delay.

No, I have none of these “fake-Linux package managers”(?) installed - should I?

The reply to backlin$ which perl is
/usr/bin/perl

In usr/bin I find two entries:
perl and
perl5.18

The directory Library/Perl contains
/5.18
/Darwin-thread-multi-2level
/Finance
/HTML
/JSON
/Mozilla
/AppendToPath
/JSON.pm
/Updates
/5.18.2
/Darwin-thread-multi-2level

Looking up contents of 
~/.cpan/build/ :
Date-Manip-6.75-JzZ9Wt  ExtUtils-MakeMaker-7.34-_6iXcq
Date-Manip-6.76-9mWyaN  Finance-Quote-1.47-_BUlzK
Date-Manip-6.76-NE8c76  Finance-Quote-1.47-nChsgf
Date-Manip-6.76-QNnn65  HTML-TableExtract-2.15-dP4w2A
ExtUtils-MakeMaker-7.34-695wh2  JSON-4.02-RrPsdw
ExtUtils-MakeMaker-7.34-DVwu8U  Mozilla-CA-20180117-TgJL7x
ExtUtils-MakeMaker-7.34-U01uzs

Trying your suggestion with /stockdump.pm for both fnq builds I get a delayed, 
identical result, even if I misspell aap(l) for a non-existing ticker:

backlin$ ~/.cpan/build/Finance-Quote-1.47-_BUlzK/Examples/stockdump.pl 
yahoo_json aapl
$VAR1 = {
  'aaplsymbol' => 'aapl',
  'aaplsuccess' => 0,
  'aaplerrormsg' => 'Error retrieving quote for aapl. Attempt to fetch 
the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted 
in HTTP response 500 (Internal Server Error)'

and
backlin$ ~/.cpan/build/Finance-Quote-1.47-nChsgf/Examples/stockdump.pl 
yahoo_json aap
$VAR1 = {
  'aapsymbol' => 'aap',
  'aapsuccess' => 0,
  'aaperrormsg' => 'Error retrieving quote for aap. Attempt to fetch 
the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=aap resulted 
in HTTP response 500 (Internal Server Error)'
};

I am hoping this might give you a clue. I have no idea what could have gone 
wrong. Just that finance quote stopped working on my desktop and my laptop the 
same week, when I did not do anything on my system, not even reboot, other than 
changing the network access updating the router configuration.

Thanks, and best, Bruno


> On Mar 22, 2019, at 7:46 PM, John Ralls  wrote:
> 
> Please remember to copy the list on all replies.
> 
> Curl and your browser working exonerates your router.
> 
> *Re*-installing perl would I think be challenging; it's provided as part of 
> MacOS so I'd think that the only safe way to do it would be to reinstall the 
> OS.
> 
> That said, do you have any of the fake-Linux package managers--Homebrew, 
> MacPorts, or Fink--installed?
> 
> What's the output of running
>  which perl
> from the command line?
> How about 
>  ~/.cpan/build/Finance-Quote-1.47-XX/Examples/stockdump.pl yahoo_json aapl
> (the XX bit is random characters that depends on the installation).
> 
> Regards,
> John Ralls
> 
>> On Mar 22, 2019, at 3:31 PM, Bruno Acklin  wrote:
>> 
>> No, I get an instant reply with content:
>> {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq
>>  Real Time Price","currency":"USD","regularMarketPrice":191.05,..
>> 
>> Same if I use the fnc query from my browser:
>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
>> 
>> Any other ideas, especially related to the router change?
>> 
>> Is there a point and safe way in reinstalling all of PERL on MacOS Mojave?
>> 
>> Best, Bruno
>> 
>>> On Mar 22, 2019, at 12:05 PM, John Ralls  
>>> wrote:
>>> 
>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Thanks John,

I deleted Library/Perl/Finance and reinstalled finance::quote using the sudo 
command.
Installed ok, but no change on errors and messages.

The only change I made between finance::Quote running and now failing was 
replacing my router from an old Apple TimeCapsule to a U-verse PACE 5268AC 
modem..

Is there a TCP or UDP port, or another router setting that FQ, respectively 
JSON needs, which may not be set properly by default?

Thanks, Bruno


> On Mar 21, 2019, at 12:17 PM, John Ralls  
> wrote:
> 
> Probably not. What would change is the Perl version and consequently what 
> folders @INC points to, but that hasn't changed in the last 5 versions, it's 
> been 5.18 since Yosemite.
> 
> gnc-fq-dump doesn't use Date::Manip, but if your Date::Manip is broken it's 
> quite possible that your Finance::Quote is too. They should be installed in 
> /Library/Perl/5.18. I suggest deleting them and running the Finance Quote 
> Update again; if you're comfortable with the command line you can just use 
> `sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update` from 
> there, that's all that Finance Quote Update does.
> 
> Regards,
> John Ralls
> 
>> On Mar 21, 2019, at 10:54 AM, Bruno Acklin  wrote:
>> 
>> Hi John,
>> 
>> Thanks so much for all the work you do supporting us and your diligent test 
>> of the Yahoo_json script!
>> 
>> I have restarted my Mac and Gnucash. The price quote keeps failing on my 
>> desktop and laptop test systems.
>> 
>> I keep getting the 500 server error when I use the Terminal command:
>> gnc-fq-dump -v yahoo_json aapl
>> 
>> But I get another message and hint when I use the helper command:
>> gnc-fq-helper yahoo_json aapl
>> 
>> Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip 
>> module) (@INC contains: /Library/Perl/5.18/darwin-thread-multi-2level 
>> /Library/Perl/5.18 /Network/Library/Perl/5.18/darwin-thread-multi-2level 
>> /Network/Library/Perl/5.18 
>> /Library/Perl/Updates/5.18.2/darwin-thread-multi-2level 
>> /Library/Perl/Updates/5.18.2 
>> /System/Library/Perl/5.18/darwin-thread-multi-2level 
>> /System/Library/Perl/5.18 
>> /System/Library/Perl/Extras/5.18/darwin-thread-multi-2level 
>> /System/Library/Perl/Extras/5.18 .) at 
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper line 29.
>> BEGIN failed--compilation aborted at 
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper line 29.
>> 
>> Did a MacOS update change something in.my working Perl configuration, and do 
>> you have any recommendations on how to fix this?
>> 
>> Thanks, Bruno
>> 
>>> On Mar 20, 2019, at 5:26 PM, John Ralls  
>>> wrote:
>>> 
>>> Bruno,
>>> 
>>> I just tested, works fine for me:
>>> $ Argus:/Users/john> gnc-fq-dump yahoo_json AAPL
>>> Finance::Quote fields Gnucash uses:
>>>   symbol: AAPL <=== required
>>> date: 03/20/2019   <=== recommended
>>> currency: USD  <=== required
>>> last: 188.16   <=\
>>>  nav:  <=== one of these
>>>price:  <=/
>>> timezone:  <=== optional
>>> 
>>> A 500 server error means a glitch at Yahoo!, not anything to do with 
>>> Finance::Quote. They'd obviously resolved it by the time you used your 
>>> browser.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>>> On Mar 20, 2019, at 3:43 PM, Bruno Acklin  wrote:
>>>> 
>>>> Hi John, et all,
>>>> 
>>>> I am adding to this string as I experience a similar, possibly related 
>>>> problem:
>>>> 
>>>> I am using Gnucash on OSX Mojave 10.14.3. Alphavantage never really worked 
>>>> for me and importantly, crashed Gnucash instead of reporting stocks that 
>>>> could not be retrieved.
>>>> 
>>>> Then in February I switched all my stocks tickers to yahoo_json, verifying 
>>>> them with the fnc-gc-dump procedure and it worked great, last on 3/8/19.
>>>> 
>>>> Now, since 3/17/19, it suddenly fails all tickers, and fnc-gc-dump reports 
>>>> this error:
>>>> Error retrieving quote for aapl. Attempt to fetch the URL 
>>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted in 
>>>> HTTP response 500 (Internal Server Error)
>>>> 
>>>> But, a browser call to the same website
&g

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Hi John,

Thanks so much for all the work you do supporting us and your diligent test of 
the Yahoo_json script!

I have restarted my Mac and Gnucash. The price quote keeps failing on my 
desktop and laptop test systems.

I keep getting the 500 server error when I use the Terminal command:
gnc-fq-dump -v yahoo_json aapl

But I get another message and hint when I use the helper command:
gnc-fq-helper yahoo_json aapl

Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip 
module) (@INC contains: /Library/Perl/5.18/darwin-thread-multi-2level 
/Library/Perl/5.18 /Network/Library/Perl/5.18/darwin-thread-multi-2level 
/Network/Library/Perl/5.18 
/Library/Perl/Updates/5.18.2/darwin-thread-multi-2level 
/Library/Perl/Updates/5.18.2 
/System/Library/Perl/5.18/darwin-thread-multi-2level /System/Library/Perl/5.18 
/System/Library/Perl/Extras/5.18/darwin-thread-multi-2level 
/System/Library/Perl/Extras/5.18 .) at 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper line 29.
BEGIN failed--compilation aborted at 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper line 29.

Did a MacOS update change something in.my working Perl configuration, and do 
you have any recommendations on how to fix this?

Thanks, Bruno

> On Mar 20, 2019, at 5:26 PM, John Ralls  wrote:
> 
> Bruno,
> 
> I just tested, works fine for me:
> $ Argus:/Users/john> gnc-fq-dump yahoo_json AAPL
> Finance::Quote fields Gnucash uses:
>symbol: AAPL <=== required
>  date: 03/20/2019   <=== recommended
>  currency: USD  <=== required
>  last: 188.16   <=\
>   nav:  <=== one of these
> price:  <=/
>  timezone:  <=== optional
> 
> A 500 server error means a glitch at Yahoo!, not anything to do with 
> Finance::Quote. They'd obviously resolved it by the time you used your 
> browser.
> 
> Regards,
> John Ralls
> 
> 
>> On Mar 20, 2019, at 3:43 PM, Bruno Acklin  wrote:
>> 
>> Hi John, et all,
>> 
>> I am adding to this string as I experience a similar, possibly related 
>> problem:
>> 
>> I am using Gnucash on OSX Mojave 10.14.3. Alphavantage never really worked 
>> for me and importantly, crashed Gnucash instead of reporting stocks that 
>> could not be retrieved.
>> 
>> Then in February I switched all my stocks tickers to yahoo_json, verifying 
>> them with the fnc-gc-dump procedure and it worked great, last on 3/8/19.
>> 
>> Now, since 3/17/19, it suddenly fails all tickers, and fnc-gc-dump reports 
>> this error:
>> Error retrieving quote for aapl. Attempt to fetch the URL 
>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted in 
>> HTTP response 500 (Internal Server Error)
>> 
>> But, a browser call to the same website
>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
>> 
>> returns the data properly:
>> {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq
>>  Real Time 
>> Price","currency":"USD","priceHint":2,"postMarketChangePercent":-0.09571613,"postMarketTime":1553116993,"postMarketChange":-0.18009949,"regularMarketChangePercent":0.873857,"regularMarketDayRange":"184.73
>>  - 
>> 189.49","regularMarketPreviousClose":186.53,"bid":187.83,"ask":187.98,"bidSize":13,"askSize":13,"messageBoardId":"finmb_24937","fullExchangeName":"NasdaqGS","longName":”Apple
>>  ...
>> 
>> I surmise that the URL response may have changed so the yahoo_json parser 
>> does not recognize the information, but I am not a SW person familiar with 
>> PERL..
>> Any suggestion what might have changed, and what to fix?
>> 
>> Thanks, Bruno
>>> On Feb 22, 2019, at 7:11 AM, John Ralls  wrote:
>>> 
>>> 
>>> 
>>>> On Feb 20, 2019, at 7:06 AM, GB  wrote:
>>>> 
>>>> Thank you John Ralls, I think I've narrowed down the problem.
>>>> 
>>>> I unchecked all of the securities that had source of "tsp" and I was able 
>>>> to
>>>> get all the quotes from yahoo_json.  Then I used a terminal window to run
>>>> "./gnc-fq-dump -v tsp c" and received response of:
>>>> "No results found for stock C."  The funds are C,S,I.  I have used this for
>>>> at least se

Re: [GNC] Finance::Quotes stopped working for me

[Bruno Acklin]

Hi John, et all,

I am adding to this string as I experience a similar, possibly related problem:

I am using Gnucash on OSX Mojave 10.14.3. Alphavantage never really worked for 
me and importantly, crashed Gnucash instead of reporting stocks that could not 
be retrieved.

Then in February I switched all my stocks tickers to yahoo_json, verifying them 
with the fnc-gc-dump procedure and it worked great, last on 3/8/19.

Now, since 3/17/19, it suddenly fails all tickers, and fnc-gc-dump reports this 
error:
Error retrieving quote for aapl. Attempt to fetch the URL 
https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted in HTTP 
response 500 (Internal Server Error)

But, a browser call to the same website
https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl 


returns the data properly:
{"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq
 Real Time 
Price","currency":"USD","priceHint":2,"postMarketChangePercent":-0.09571613,"postMarketTime":1553116993,"postMarketChange":-0.18009949,"regularMarketChangePercent":0.873857,"regularMarketDayRange":"184.73
 - 
189.49","regularMarketPreviousClose":186.53,"bid":187.83,"ask":187.98,"bidSize":13,"askSize":13,"messageBoardId":"finmb_24937","fullExchangeName":"NasdaqGS","longName":”Apple
 ...

I surmise that the URL response may have changed so the yahoo_json parser does 
not recognize the information, but I am not a SW person familiar with PERL..
Any suggestion what might have changed, and what to fix?

Thanks, Bruno
> On Feb 22, 2019, at 7:11 AM, John Ralls  wrote:
> 
> 
> 
>> On Feb 20, 2019, at 7:06 AM, GB  wrote:
>> 
>> Thank you John Ralls, I think I've narrowed down the problem.
>> 
>> I unchecked all of the securities that had source of "tsp" and I was able to
>> get all the quotes from yahoo_json.  Then I used a terminal window to run
>> "./gnc-fq-dump -v tsp c" and received response of:
>> "No results found for stock C."  The funds are C,S,I.  I have used this for
>> at least several years and have not had any problems, this has been
>> appearing recently.  When I include the tsp funds in the security editor, it
>> causes all of the other security quotes to fail, even those from other
>> sources.
>> 
>> Any clues as to what I should do next?  
> 
> It looks like 
> https://www.tsp.gov/investmentfunds/shareprice/sharePriceHistory.shtml has an 
> invalid redirect, so there's nothing to retrieve. Unless that's fixed you 
> won't be able to use Finance::Quote to retrieve prices. I found 
> https://www.tsp.gov/InvestmentFunds/FundPerformance/index.html where you can 
> download a CSV that you might be able to import into GnuCash.
> 
> Regards,
> John Ralls
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.