Re: [GNC] Getting stock prices
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: gnucash-user On Behalf Of R Losey Sent: Wednesday, November 9, 2022 3:12 PM To: James Baxter Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Getting stock prices 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 (I know it does not answer the question). The text below only matters if you are dealing in stocks not based on US currency. There was a problem with getting updates from AlphaVantage if a conversion had to be done because the exchange rate info that used to be part of the free program was moved to the pay-for (premium) version. The notice states that it has been moved back to the free version. What stock price were you trying to update? I haven't had any problem getting it to work -- but if you are using AlphaVantage, you need a (free) ID code for it to work. On Wed, Nov 9, 2022 at 1:06 PM James Baxter via gnucash-user < gnucash-user@gnucash.org> wrote: > 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 CURRENCY_EXCHANGE_RATE API over the FX_DAILY > API ThanksJames baxterkangaro...@yahoo.com > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Create New Gnucash File From Old One
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 imported into a new file. The new file is the same as the old one I exported from but it has no transactions. This is what I expected. I then opened the old file and did "File -> Export Transactions to CSV". I chose the single account I wanted to export and got my exported CSV file. Although not necessary, I opened the CSV with LibreOffice Calc to verify I had the desired transactions. I next opened the new file with no transactions and did "File -> Import Transactions from CSV". On the Import Preview Screen I chose GnuCash Export Format and changed the date format to mdy. Doing this allowed me to go to the next screen. At this point I am stuck. I am supposed to Match Import and GnuCash accounts but no amount of trial and error allowed me to go to the next screen. How do I proceed? Joe ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Create New Gnucash File From Old One
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 from the old gnu cash file to the new one. I can accomplish 1. by exporting the account tree from the old one to a csv file and then importing the csv file to the new one. There is an even easier way: File -> Export -> Export Accounts This will create a new data file with just the account tree, so all you need to do is File -> Open the "exported" file. I tried to accomplish 2. by exporting the transactions from the desired account on the old file to a csv file and then import the csv to the the new file. I can export the transactions but no amount of fiddling or trying options allows me to successfully import the csv file. What version of GnuCash? I *THOUGHT* that we fixed the issue where exported data could not be imported. Any help you can give me would be appreciated. Thank you, Joe Hesse Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek Derek. I all of a sudden am having a problem with creating a new data file with just the account tree. I created a new user on my linux system and copied my data file to a folder in the new user's account and set the file permissions correctly. I then opened the copied data file and did "File -> Export -> Export Accounts". When I tried to open the exported data file I got the error message "No suitable backend was found" I am using gnucash version 4.12 on Fedora 36 linux. Thank you, Joe ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] how to commit a transaction with sqlite
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 the xml backend only commits the transaction to a copy in memory but not to the file on disk. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html https://wiki.gnucash.org/wiki/SQL David Cousens On Thu, 2022-11-10 at 02:11 +, Jim McNamara via gnucash-user wrote: > 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 package manager. > My version I am running is Version: 4.8Build ID: 4.8a+(2021-09-28) > Linux O/S > Thanks for any tips you can provide. > Thanks > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] how to commit a transaction with sqlite
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 package manager. My version I am running is Version: 4.8Build ID: 4.8a+(2021-09-28) Linux O/S Thanks for any tips you can provide. Thanks ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Create New Gnucash File From Old One
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. > > Here is what I have done. > > I used "File -> Export Account Tree to CSV" to create a CSV file which I > then imported into a new file. The new file is the same as the old one I > exported from but it has no transactions. This is what I expected. > > I then opened the old file and did "File -> Export Transactions to > CSV". I chose the single account I wanted to export and got my exported > CSV file. Although not necessary, I opened the CSV with LibreOffice > Calc to verify I had the desired transactions. > > I next opened the new file with no transactions and did "File -> Import > Transactions from CSV". On the Import Preview Screen I chose GnuCash > Export Format and changed the date format to mdy. Doing this allowed me > to go to the next screen. At this point I am stuck. I am supposed to > Match Import and GnuCash accounts but no amount of trial and error > allowed me to go to the next screen. How do I proceed? > On that screen you have to create a mapping between the names of the accounts as they appear in the csv file and the accounts in your empty gnucash book. There are two columns in that page. The first holds the names of accounts as found in the csv file. In the second column you have to add matching names from your list of accounts for each line that has "No linked account" in that column. You can alter the cells of the second column by double-clicking a line, or by selecting a line and then clicking on the button at the bottom right. Once there's a matching account from your book next to each account from the csv file you should be able to proceed. Note that for your particular use case this is a bit cumbersome as the names of your accounts match exactly with the names in the csv files. But gnucash can't know that for sure in all situations, hence it asks. It will remember your selections for future imports though. Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Getting stock prices
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 (I know it does not answer the question). The text below only matters if you are dealing in stocks not based on US currency. There was a problem with getting updates from AlphaVantage if a conversion had to be done because the exchange rate info that used to be part of the free program was moved to the pay-for (premium) version. The notice states that it has been moved back to the free version. What stock price were you trying to update? I haven't had any problem getting it to work -- but if you are using AlphaVantage, you need a (free) ID code for it to work. On Wed, Nov 9, 2022 at 1:06 PM James Baxter via gnucash-user < gnucash-user@gnucash.org> wrote: > 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 CURRENCY_EXCHANGE_RATE API over the FX_DAILY > API > ThanksJames baxterkangaro...@yahoo.com > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Getting stock prices
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 CURRENCY_EXCHANGE_RATE API over the FX_DAILY API ThanksJames baxterkangaro...@yahoo.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Create New Gnucash File From Old One
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: > >> 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 from the old gnu cash > >> file to the new one. > >> > >> I can accomplish 1. by exporting the account tree from the old one to a > >> csv file and then importing the csv file to the new one. > > > > There is an even easier way: File -> Export -> Export Accounts > > This will create a new data file with just the account tree, so all you > > need to do is File -> Open the "exported" file. > > > >> I tried to accomplish 2. by exporting the transactions from the desired > >> account on the old file to a csv file and then import the csv to the the > >> new file. I can export the transactions but no amount of fiddling or > >> trying options allows me to successfully import the csv file. > > > > What version of GnuCash? I *THOUGHT* that we fixed the issue where > > exported data could not be imported. > > > >> Any help you can give me would be appreciated. > >> > >> Thank you, > >> Joe Hesse > >> Please remember to CC this list on all your replies. > >> You can do this by using Reply-To-List or Reply-All. > > > > -derek > > Derek, > > Thank you for your reply. > > I had no problem creating a new gnucash file with the same accounts as > the old one but with no transactions. > > My problem is when I "File->Export Transactions to CSV" and choose a > single account to export, I can not successfully import this account. I > am using gnucash 4.12 on Fedora 36 linux. > > Joe > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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@gnucash.org To update your subscription preferences or to unsubscribe: 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.
