Re: [GNC] Getting stock prices

2022-11-09 Thread John Layman
I've continued using AlphaVantage for NYSE and NASDAQ securities without any problem for years, but for the past two trading days it has returned nothing. Something does appear to have changed at AlphaVantage so I've switched price source to Yahoo as json. -Original Message- From:

Re: [GNC] Create New Gnucash File From Old One

2022-11-09 Thread Joseph Hesse
On 11/9/22 02:55, Geert Janssens wrote: Hi Joe, In order to help you, can you describe exactly what you have tried and what went wrong ? Regards, Geert Thank you for your reply. Here is what I have done. I used "File -> Export Account Tree to CSV" to create a CSV file which I then

Re: [GNC] Create New Gnucash File From Old One

2022-11-09 Thread Joseph Hesse
On 11/7/22 15:59, Derek Atkins wrote: Hi, On Mon, November 7, 2022 1:49 pm, Joseph Hesse wrote: Hello, Here is what I want to accomplish. 1. Create a new gnucash file with the same accounts as an old one but no transactions from the old one. 2. Copy the transactions from a single account

Re: [GNC] how to commit a transaction with sqlite

2022-11-09 Thread David Cousens
Jim, The transaction should be committed to the datafile immediately on pressing "Enter" in any transaction editing mode in an account register using any of the database backends. You normally use the 'Tab key to cycle through fields in the transaction as you do in the xml backend. AFAIK Enter in

[GNC] how to commit a transaction with sqlite

2022-11-09 Thread Jim McNamara via gnucash-user
Hi- The save button by design doesn't work with sqlite. How can I "commit" the transaction in sqlite when moving from current transaction or all transactions from a screen? I tried to install sqlite. I changed from xml to sqlite and my file had a .gnucash ending. I used libdbsqilte3 from the

Re: [GNC] Create New Gnucash File From Old One

2022-11-09 Thread Geert Janssens
Op woensdag 9 november 2022 20:45:34 CET schreef Joseph Hesse: > On 11/9/22 02:55, Geert Janssens wrote: > > Hi Joe, > > > > > > In order to help you, can you describe exactly what you have tried and > > what went wrong ? > > > > > > Regards, > > > > > > Geert > > Thank you for your reply.

Re: [GNC] Getting stock prices

2022-11-09 Thread R Losey
Be aware that AlphaVantage - the free version - has a built-in delay if you are updating more than five stock prices. My updates were taking over two minutes (I had somewhere between 10-20 prices to update). When I switched to something else, it now takes seconds. This is just a general reminder

[GNC] Getting stock prices

2022-11-09 Thread James Baxter via gnucash-user
OK, So I copy and past, As I don't know what this means. As I go to get my stock/Tickerprices, It cant find it, So does this matter. Go figure. It appears that AlphaVantage changed back access to the CURRENCY_EXCHANGE_RATE API. It is no longer considered premium. A feature I liked about the

Re: [GNC] Create New Gnucash File From Old One

2022-11-09 Thread Geert Janssens
Hi Joe, In order to help you, can you describe exactly what you have tried and what went wrong ? Regards, Geert Op dinsdag 8 november 2022 13:35:55 CET schreef Joseph Hesse: > On 11/7/22 15:59, Derek Atkins wrote: > > Hi, > > > > On Mon, November 7, 2022 1:49 pm, Joseph Hesse wrote: > >>