Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-04 Thread Kalpesh Patel
d to one source and > no you do not have to register with that fixed source. "get quotes" is all > you need to check. > > > -Original Message- > From: Grace > Sent: Tuesday, December 03, 2024 3:53 PM > To: gnucash-user@gnucash.org > Subject: Re: [GNC]

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-04 Thread Grace
that fixed source. "get quotes" is all you need to check. -Original Message- From: Grace Sent: Tuesday, December 03, 2024 3:53 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Get Quotes from Price Database not returning GBP and USD When I look at the Securities optio

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-03 Thread Kalpesh Patel
ubject: Re: [GNC] Get Quotes from Price Database not returning GBP and USD When I look at the Securities option, I select the currency, is this example GBP, and then I select EDIT. I have "get quotes" checked, but my choices when "Single" is selected is locked to Currency. Do

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-03 Thread Griffin
Sorry. Getting the Apadvantage to get currency quotes. e api key On 2024-12-03 3:29 p.m., kschneider bout-tyme.net wrote: Do you care to share with the rest of us “what worked”? Ken Schneider On Dec 3, 2024, at 4:02 PM, Grace wrote: Well that worked! Thanks -- This email has been chec

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-03 Thread kschneider bout-tyme . net
Do you care to share with the rest of us “what worked”? Ken Schneider > On Dec 3, 2024, at 4:02 PM, Grace wrote: > > Well that worked! Thanks > > > > -- > This email has been checked for viruses by Avast antivirus software. > www.avast.com > ___ >

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-03 Thread Grace
Well that worked! Thanks -- This email has been checked for viruses by Avast antivirus software. www.avast.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-03 Thread Grace
When I look at the Securities option, I select the currency, is this example GBP, and then I select EDIT. I have "get quotes" checked, but my choices when "Single" is selected is locked to Currency. Do I really have to register for something, just to get currency rates? -- This email has bee

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-02 Thread David H
Me again., I'm guessing you haven't applied for or setup an Alphavantage api key - Edit >> Preferences >> online quotes since the following is the result I get if I remove mine :-) You need to go to https://alphavantage.co/support/#api-key and register for a free account to get an api key then upd

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-02 Thread David H
Both work for me against the Aussie dollar and have been for yonks. What's your locale/currency ? Cheers David H. On Tue, 3 Dec 2024 at 04:39, Grace wrote: > Second times a charm!! > > > On 2024-12-01 12:31 p.m., Grace wrote: > > Me Again, > > > > I am trying to get quotes using the Price Da

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-02 Thread Murugan Mariappan
: [GNC] Get Quotes from Price Database not returning GBP and USD Second times a charm!! On 2024-12-01 12:31 p.m., Grace wrote: > Me Again, > > I am trying to get quotes using the Price Data base. This is the > message I get. What is it telling me, please? > -- If you need end-to-en

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-02 Thread Grace
Second times a charm!! On 2024-12-01 12:31 p.m., Grace wrote: Me Again, I am trying to get quotes using the Price Data base. This is the message I get. What is it telling me, please? -- If you need end-to-end encryption, I have a security key -- This email has been checked for viruses by

Re: [GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-01 Thread David H
Nothing since your image didn't come through to the mailing list :-) You need to either attach it to your email as a separate attachment or I sometimes find that I can paste an image as the very last thing in the email and it survives, try again or paste the text of the error into your email. Che

[GNC] Get Quotes from Price Database not returning GBP and USD

2024-12-01 Thread Grace
Me Again, I am trying to get quotes using the Price Data base. This is the message I get. What is it telling me, please? -- If you need end-to-end encryption, I have a security key -- This email has been checked for viruses by Avast antivirus software. www.avast.com _

Re: [GNC] Get Quotes hung

2024-08-23 Thread Kalpesh Patel
control… From: Fred Tydeman Sent: Friday, August 23, 2024 3:11 PM To: Kalpesh Patel Cc: R Losey ; Gnucash Users Subject: Re: [GNC] Get Quotes hung It appears to depend upon where one is in the world. Last week in Medellin, Colombia, it took hours on a fast internet connection. Today, in

Re: [GNC] Get Quotes hung

2024-08-23 Thread Fred Tydeman
f GNUCash, and on which type and version of OS are running > on? > > > > *From:* Fred Tydeman > *Sent:* Wednesday, August 21, 2024 7:08 PM > *To:* Kalpesh Patel > *Cc:* R Losey ; Gnucash Users > *Subject:* Re: [GNC] Get Quotes hung > > > > > > > > O

Re: [GNC] Get Quotes hung

2024-08-21 Thread Kalpesh Patel
badly enough and might need a fresh install. What version of GNUCash, and on which type and version of OS are running on? From: Fred Tydeman Sent: Wednesday, August 21, 2024 7:08 PM To: Kalpesh Patel Cc: R Losey ; Gnucash Users Subject: Re: [GNC] Get Quotes hung On Wed, Aug

Re: [GNC] Get Quotes hung

2024-08-21 Thread Fred Tydeman
On Wed, Aug 21, 2024 at 11:38 AM Kalpesh Patel wrote: > I am not seeing such delays and completes in about a minute. I do see > failures now and then and that has all to do with Yahoo performing > maintenance on their systems and is transient in nature. > > Silly question I'll ask: did you verify

Re: [GNC] Get Quotes hung

2024-08-21 Thread Kalpesh Patel
Yahoo only via yahoo_json as a single source? You aren't running any VPN session, knowingly or unknowingly, right? -Original Message- From: Fred Tydeman Sent: Wednesday, August 21, 2024 7:03 AM To: R Losey Cc: Gnucash Users Subject: Re: [GNC] Get Quotes hung I removed the get

Re: [GNC] Get Quotes hung

2024-08-21 Thread Richard Ullger via gnucash-user
On Wed, 21 Aug 2024 06:03:22 -0500 "Fred Tydeman" wrote: > I removed the get quote from stocks that have been sold, so now I > only have 35 stocks. > Last night, it took 2 hours and 45 minutes, or 165 minutes, to get > prices. That works out to 4.7 minutes per stock. > Anyone else seeing this lon

Re: [GNC] Get Quotes hung

2024-08-21 Thread Fred Tydeman
I removed the get quote from stocks that have been sold, so now I only have 35 stocks. Last night, it took 2 hours and 45 minutes, or 165 minutes, to get prices. That works out to 4.7 minutes per stock. Anyone else seeing this long time to get stock prices using yahoo_json? On Tue, Aug 13, 2024 a

Re: [GNC] Get Quotes hung

2024-08-13 Thread Fred Tydeman
yahoo_json for all the stocks On Tue, Aug 13, 2024 at 6:47 PM R Losey wrote: > From what service are you retrieving the prices? One of the services only > allows something like 5 prices, and then it puts a 1 minute delay in before > it does the next 5. So, if you have 60 stocks, it will take ov

Re: [GNC] Get Quotes hung

2024-08-13 Thread R Losey
From what service are you retrieving the prices? One of the services only allows something like 5 prices, and then it puts a 1 minute delay in before it does the next 5. So, if you have 60 stocks, it will take over 12 minutes. On Tue, Aug 13, 2024 at 3:40 PM Fred Tydeman wrote: > I ran the com

Re: [GNC] Get Quotes hung

2024-08-13 Thread Fred Tydeman
I ran the command line interface to update the stock prices on the file/book that crashed from the GUI. No crash with CLI. It ran for about 18 hours! Anyone have any idea why so long? Two weeks ago, using the GUI, it took about 10 minutes. All the prices are coming from yahoo_json OS: Linux Fedo

Re: [GNC] Get Quotes hung

2024-08-12 Thread Fred Tydeman
After reading the wiki, I have tried: gnucash-cli --log gnc.price-quotes=debug --quotes get tybor.gnucash It finished after 6.5 hours! Why so long now? As before, it took about 5 minutes. With this book, it did not crash (the crash I got before was with another book). It did find 5 securities wi

Re: [GNC] Get Quotes hung

2024-08-12 Thread Fred Tydeman
The currency problem was my fault. In moving to a newer Linux and Gnucash, I forgot to set the Alphavantage key. That part is working OK now. On Sun, Aug 11, 2024 at 7:47 AM Fred Tydeman wrote: > Fedora Linux 40 > Gnucash 5.8 > > Trying this on another file/book that has no stocks, but does have

Re: [GNC] Get Quotes hung

2024-08-11 Thread Fred Tydeman
I found an app to capture the screen (but not the window), so now have a screen shot if it helps anyone On Sun, Aug 11, 2024 at 4:05 PM Fred Tydeman wrote: > After several hours, I got (in the Price Database window): > Price retrieval failed: Failed to parse result returned by Finance::Quote >

Re: [GNC] Get Quotes hung

2024-08-11 Thread Fred Tydeman
After several hours, I got (in the Price Database window): Price retrieval failed: Failed to parse result returned by Finance::Quote Error message: (1): expected value Result: then comes lines and lines of text that exceeds the screen I have tried to capture that window with PrtSc key Alt-

[GNC] Get Quotes hung

2024-08-11 Thread Fred Tydeman
Fedora Linux 40 Gnucash 5.8 Running Tools: Price Database: Get Quotes hangs or runs "forever" All my stocks are setup to get prices via Yahoo_Jason Today I am in Medellin, Colombia, and my internet is very fast. Clicking on the X in the top right of Price Database window gets a popup about window

Re: [GNC] get quotes via gnucash-cli for unknown quote source

2023-08-24 Thread Jascha K via gnucash-user
> On Aug 24, 2023, at 05:59, john via gnucash-user gnucash-user@gnucash.org > wrote: > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user > > gnucash-user@gnucash.org wrote: > > > > Hi, > > > > I've been trying to get quotes via gnucash-cli with the following command: > > > > gnucash-cl

Re: [GNC] get quotes via gnucash-cli for unknown quote source

2023-08-23 Thread Steve Butler
Not on this thread. Create a new subject and ask. On Wed, Aug 23, 2023, 21:08 jackielou wong wrote: > Hello there > > Can i ask for importing 100 transactions using csv. > > On Thu, Aug 24, 2023, 12:00 PM john wrote: > > > > > > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user < > > gn

Re: [GNC] get quotes via gnucash-cli for unknown quote source

2023-08-23 Thread jackielou wong
Hello there Can i ask for importing 100 transactions using csv. On Thu, Aug 24, 2023, 12:00 PM john wrote: > > > > On Aug 23, 2023, at 02:26, Jascha K via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > Hi, > > > > I've been trying to get quotes via gnucash-cli with the following > co

Re: [GNC] get quotes via gnucash-cli for unknown quote source

2023-08-23 Thread john
> On Aug 23, 2023, at 02:26, Jascha K via gnucash-user > wrote: > > Hi, > > I've been trying to get quotes via gnucash-cli with the following command: > > gnucash-cli --quotes get mysql:// > > However, I get the following message when executing the command and no quotes > are fetched: 'Pr

[GNC] get quotes via gnucash-cli for unknown quote source

2023-08-23 Thread Jascha K via gnucash-user
Hi, I've been trying to get quotes via gnucash-cli with the following command: gnucash-cli --quotes get mysql:// However, I get the following message when executing the command and no quotes are fetched: 'Price retrieval failed: GncQuotes::Fetch called with no commodities.' All of my quote so

Re: [GNC] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

2023-06-27 Thread Steve Miller
That worked perfectly. Thank you. Your brief instruction should be added to the GnuCash help manual. On Mon, Jun 26, 2023 at 8:58 PM David H wrote: > It's a perl script - basically a text file which you can open with Notepad > if you want to look at the contents. Run it in a command prompt wind

Re: [GNC] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

2023-06-26 Thread David H
It's a perl script - basically a text file which you can open with Notepad if you want to look at the contents. Run it in a command prompt window using perl as follows - perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update" - you need double quotes around the file path as it contains a space. O

Re: [GNC] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

2023-06-26 Thread Steve Miller
Ok, from searching around it appears your suggestion is indeed what I need to do, eg run gnc-fq-update. In the gnucash bin directory I see a file with that name, but how on earth do I run it? It appears to just be a text file. Also, when I go to the start menu, there is no longer a folder for gnu

Re: [GNC] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

2023-06-26 Thread David H
Steve, Try running C:\Program Files (x86)\gnucash\bin\gnc-fq-update, I seem to recall that fixed it for me on Windows when I initially went to version 5.0. Cheers David H. On Tue, 27 Jun 2023 at 10:21, Steve Miller wrote: > *So I'm running Windows 11, for years have used GnuCash version 4.14.

[GNC] Get Quotes under Ver 4.14 v 5.0 or 5.1 or 5.2 or 5.3

2023-06-26 Thread Steve Miller
*So I'm running Windows 11, for years have used GnuCash version 4.14. It also shows I'm using Finance:Quote 1.53. When I go to prices, to "Get Quotes" and click the button, it works fine, always has, still does.* *BUT, when I install any GnuCash 5.0 version, the "Get Quotes" button is grayed out

[GNC] Get Quotes

2023-06-21 Thread Tyler Carrol
Hi, I am having trouble using the Get Quotes feature. I have installed Finance::Quote. I am running Windows 10. Running the following command works: C:\Program Files (x86)\gnucash\bin>gnucash-cli -V --quotes dump alphavantage IBM I have tried setting alphavantage as the source, but when I run “G

Re: [GNC] "Get Quotes" from the price database feedback

2023-01-20 Thread Kalpesh Patel
order, the first is the file name to read the tickers symbols from and second is number of days of historical quotes to download. From: Fred Tydeman Sent: Tuesday, January 10, 2023 10:54 AM To: Kalpesh Patel Cc: Geoff ; gnucash-user@gnucash.org Subject: Re: [GNC] "Get Quotes"

Re: [GNC] "Get Quotes" from the price database feedback

2023-01-10 Thread Fred Tydeman
Have you considered using a Google spreadsheet along with: GOOGLEFINANCE("NASDAQ:GOOG", "price", DATE(2014,1,1), DATE(2014,12,31), "DAILY") GOOGLEFINANCE("NASDAQ:GOOG","price",TODAY()-30,TODAY()) It lets you get the prices on a range of dates. > > ___

Re: [GNC] "Get Quotes" from the price database feedback

2023-01-10 Thread Kalpesh Patel
off Sent: Monday, January 09, 2023 5:25 PM To: Kalpesh Patel ; gnucash-user@gnucash.org Subject: Re: [GNC] "Get Quotes" from the price database feedback Hi Kalpesh > Also is there a way to tell to get limited historical range of days' > worth > of quotes rather than a

Re: [GNC] "Get Quotes" from the price database feedback

2023-01-09 Thread Geoff
Hi Kalpesh > Also is there a way to tell to get limited historical range of days' > worth > of quotes rather than a single day? See this post: https://lists.gnucash.org/pipermail/gnucash-user/2022-December/104498.html Regards Geoff = On 10/01/2023 9:21 am, Kalpesh Patel wrote: GNC User

[GNC] "Get Quotes" from the price database feedback

2023-01-09 Thread Kalpesh Patel
GNC User community - question for you. On Windows OS, when the "Get Quotes" button is pressed from the "Price Database" window, it creates a new CMD windows that I assume calls Strawberry Perl which executes the Perl script to retrieve prices. That windows does not display any feedback while ex

Re: [GNC] Get Quotes hangs

2022-05-09 Thread Adrien Monteleone
I had similar problems on MacoS BigSur just before and after the release of 4.10, and it would hang either via GnuCash or via CLI. I figured it was just a F::Q or Alphavantage problem. And indeed, it cleared up, but I haven't tried it lately. Regards, Adrien On 5/8/22 9:17 PM, Fred Tydeman w

[GNC] Get Quotes hangs

2022-05-08 Thread Fred Tydeman
Linux: Fedora 35 64-bit GnuCash 4.10 Finance::Quote 1.51 Online Quote: Alpha Vantage API key: has a value gnc-fq-check: installed gnc-fq-dump: installed gnc-fq-helper: installed gnc-fq-update: missing gnucash Tools Price database Get Quotes gets me a spinning circle. System Monitor shows

Re: [GNC] Get quotes problem with testing version 3.905

2020-06-19 Thread John Bonnett
On 17/06/2020 10:39 am, Chris Good wrote: Message: 8 Date: Wed, 17 Jun 2020 08:53:24 +0930 From: John Bonnett To: gnucash-user@gnucash.org Subject: Re: [GNC] Get quotes problem with testing version 3.905 Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed Here is my previous

Re: [GNC] Get quotes problem with testing version 3.905

2020-06-16 Thread Chris Good
Message: 8 Date: Wed, 17 Jun 2020 08:53:24 +0930 From: John Bonnett To: gnucash-user@gnucash.org Subject: Re: [GNC] Get quotes problem with testing version 3.905 Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed Here is my previous email with the graphics replaced by some

Re: [GNC] Get quotes problem with testing version 3.905

2020-06-16 Thread John Bonnett
Here is my previous email with the graphics replaced by some relevant text. I installed v3.905 to help with testing. I have a problem with getting online quotes which worked fine with the latest release version. Everything else has been OK so far. I get this message now: ERROR:: ALPHAVANTAGE_

[GNC] Get quotes problem with testing version 3.905

2020-06-16 Thread John Bonnett
I installed v3.905 to help with testing. I have a problem with getting online quotes which worked fine with the latest release version. Everything else has been OK so far. I get this message now: None of my active stocks, for which I am trying to get online quotes, are using Alphavantage. I d

[GNC] Get Quotes Fails from GnuCash

2018-10-28 Thread Jonathan Rosenberg
I am a newish user running GC (3.3) on Windows 10. I have set up the quotes apps so that I can pull quotes from bthe command line (i.e., gnc-fq-dump). Until about a week ago, I could also update quotes from GC. Now, it is failing regularly, but with various error messages: - sometimes it fails i