Re: Finance-Quote 1.47 released!

I probably missed this somewhere but is there anyway to get quotes on Alphavantage for funds? I am using the same fund id that I used on yahoo but get no quotes. This is the ISIN code followed by .L for the LSE. Also I successfully get all the company stocks quotes OK with the exception of RELX

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

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

Re: Finance-Quote 1.45 released!

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

Please remove me from the mailing list

Tried to do it myself but going around in circles! -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user -

[GNC] Quote seems to have stopped working

I have been unable to retrieve quotes since July 31st. It did not work perfectly since the change away from Yahoo and there was usually a few quotes that were not retrieved but by running it regularly I was able to keep most stocks up to date. It always completed and came back with a message

Re: [GNC] Get Quote is Not Working?

I have just run Get Quotes for 4 hours and eventually I killed it by closing the window and it came up with the message "There was a system error while retrieving price quotes." I am not sure if this is because I shut it down or if it had an error at some point in the 4 hours. Can anyone help with

Re: [GNC] Get Quote is Not Working?

I am using GnuCash 2.6.18 and I am not sure what version of F:Q I was using but I reinstalled it a couple of days ago to ensure it was the latest version. Still not getting any quotes at all. Have updated manually but at more than 50 stocks that is quite arduous. It appears to me that the

Re: [GNC] GC 3.2 Import Price File CSV

I will try to show my problem with screenshots - hopefully it will work but never tried this before. This is my entry in the database: This is the single line in my CSV vile: ABF,12/08/2018,25,GBP And this is my import form:

Re: [GNC] GC 3.2 Import Price File CSV

That is what I have done. I am testing now with only one commodity - Associated British Food. I have the id set in the security editor as ABF.L. I have tried setting this on the CSV file to ABF.L. I have also tried ABF. Still get the message "Commodity From could not be recognised". I have changed

Re: [GNC] GC 3.2 Import Price File CSV

I was specifically referring to the the CSV price import tool in Version 3.2. I am trying to import the stock prices using this tool. Cannot get the Share ID to be recognised whatever I do. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: [GNC] Get Quote is Not Working?

I have been trying to follow the thread on this problem but I get very confused. Has someone found a work around? Should I just leave Perl running until it completes? I have left it for over 90 minutes and still I get a rotating pointer. I have not had any quotes since July 31st. -- Sent from:

[GNC] GC 3.2 Import Price File CSV

Very pleased to see this feature in 3.2 as I have been getting problems importing with F:Q. Unfortunately I am having a problem with getting the tool to recognise the stock ID. I have tried the normal version eg ABF. GVC, ITV etc and I get the reddish colour with the message Commodity From could

Re: [GNC] GC 3.2 Import Price File CSV

I have checked the CSV file and there are no spaces. I tried initially to import a number of shares and none or them were recognised by the import tool. It must be a fault in my security definitions I think. When F::Q was working it would import the prices from Alphavantage so it was happy with

Re: [GNC] GC 3.2 Import Price File CSV

There are no spaces in the stock definition. Also in answer to your question about the date format. I have tried all the date formats and I never get a failure to read the date correctly. When I import data in quicken format from my bank it tends to be in M-D-Y format for some reason. I have

Re: [GNC] GC 3.2 Import Price File CSV

SUCCESS!!! It turns out that I was very carefully ensuring that I was saving the file from Excel in "CSV UTF-8 (Comma delimited)" format as I thought this was the closest match to the Encoding required for the import tool. Changing to the option "CSV (comma delimited)" works. Or, as you

Re: [GNC] GC 3.2 Import Price File CSV

Thanks for the response, Deva. I have tried every combination of date format, and security ID with no luck. Unfortunately my screenshots were taken from different times so I agree - if I had tried to use those particular settings I would have had an error. I have followed your instructions to the

Re: [GNC] Stock & Mutual Fund Quotes Fail

When I open the AlphaVantage.pm file in Notepad the lines do not neatly wrap around as shown in your example so the are you show looks like - ; select(undef, undef, undef, .7) if ($quantity); } return wantarray() ? %info : \%info; } I have had to take out some spaces to stop it wrapping

Re: [GNC] Stock & Mutual Fund Quotes Fail

Went ahead and edited the file as suggested and it works better for me now than it ever has since we moved to Alphvantage. I only had one security out of around 50 that did not work - before the recent problems I used to get around 4 to 8 that failed to update. Thanks for a very simple and, so

Re: [GNC] PriceQuotes and AlphaVantage assistance request

I do not know how to link to a previous message but the workaround posted on Sep 08 by Ameet Sengar, where he provides instructions to delay the requests to Alphavantage, works very well and I am now consistently getting 100% of my 50 plus quotes. Hopefully this link works -

Re: [GNC] Unable to install Financial Quotes

I am having the same problem. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: