Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?
On Mon, 22 Jun 2020 20:06:05 +0800 Adrian Yong wrote: > As Gnucash is still under development, This is a place to point out a difference in view points. Lots of software is still under development. Most commercial software is, so that they can sell you a new version, rather than just an offer to give you new features. Gnucash for Android is not under development, and that's not a good thing, as it appears to be abandoned, and no updates will come. Every time there are updates, some users have some problems. For many that marks the first time they come to this mailing list for advice. You already know about us, and can ask what you need to know. Liz ___ 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] QUESTION: transaction classes (tags) like QuickBooks?
Thanks Liz.. Very valid point... I don't have much problems with GNUcash... On Tue, Jun 23, 2020 at 4:33 PM Liz Dodd wrote: > On Mon, 22 Jun 2020 20:06:05 +0800 > Adrian Yong wrote: > > > As Gnucash is still under development, > > This is a place to point out a difference in view points. > > Lots of software is still under development. Most commercial software > is, so that they can sell you a new version, rather than just an offer > to give you new features. > > Gnucash for Android is not under development, and that's not a good > thing, as it appears to be abandoned, and no updates will come. > > Every time there are updates, some users have some problems. For many > that marks the first time they come to this mailing list for advice. > You already know about us, and can ask what you need to know. > > Liz > ___ > 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.
[GNC] Finance::Quote enters previous day's price as today's
First off, I just installed GnuCash a couple weeks ago, after trying a few other options and finding they simply weren't mature enough or feature-complete enough for what I need. I can't say thank you enough to everyone who's developed this program, everyone who continues to develop it and everyone who provides support here. It's an incredible accomplishment! I have an issue with Finance::Quote. It brings in prices for my three Vanguard funds when I run the following command, and I've been planning on setting up a cron job for it: gnucash --add-price-quotes path/to/my/gnucash/file However, for one fund (VTSAX) it enters the prior day's price again as today's. This requires me to look it up and fix it manually. Its settings under Security editor are the same as the other two (VTIAX and VWELX). They're set to get online quotes from a single source, Alphavantage. Can anyone provide guidance on what may be going on here? Second question: I have a Raspberry Pi and it would make sense to run the cron job there since it's always up. I also use Syncthing for syncing files between devices. However, the latest version in their repo's is GnuCash 3.4 and Finance::Quote 1.47. Would this introduce problems to have the Pi update my GnuCash file with price quotes? Thank you, Colin ___ 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::Quote enters previous day's price as today's
I am not sure that this is your problem or not, but I have found that I need to wait several hours after the markets have closed before downloading mutual fund prices. It seems to take hours for some of them to get posted at Yahoo.com. One way to check would be to see what Yahoo.com is reporting early after hours vs later. GnuCash only keeps one downloaded price per day, and repeated prices are discarded. If you see that is what is happening, you might file a RFE to keep the last price reported instead of the first. . On Tue, Jun 23, 2020 at 2:19 PM Colin wrote: > First off, I just installed GnuCash a couple weeks ago, after trying a few > other options and finding they simply weren't mature enough or > feature-complete enough for what I need. I can't say thank you enough to > everyone who's developed this program, everyone who continues to develop it > and everyone who provides support here. It's an incredible accomplishment! > > I have an issue with Finance::Quote. It brings in prices for my three > Vanguard funds when I run the following command, and I've been planning on > setting up a cron job for it: > gnucash --add-price-quotes path/to/my/gnucash/file > However, for one fund (VTSAX) it enters the prior day's price again as > today's. This requires me to look it up and fix it manually. Its settings > under Security editor are the same as the other two (VTIAX and VWELX). > They're set to get online quotes from a single source, Alphavantage. > Can anyone provide guidance on what may be going on here? > Second question: > I have a Raspberry Pi and it would make sense to run the cron job there > since it's always up. I also use Syncthing for syncing files between > devices. However, the latest version in their repo's is GnuCash 3.4 and > Finance::Quote 1.47. Would this introduce problems to have the Pi update my > GnuCash file with price quotes? > > Thank you, > Colin > > ___ > 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. > -- 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.
Re: [GNC] Finance::Quote enters previous day's price as today's
I've actually found that sometimes it's easier to retrieve quotes and import through the CSV importer instead of trying to add price quotes on a cron job. If you have already set up and alphavantage account, I've found that with a little powershell, I can easily retrieve the historical prices going back years and import them once every 6 months or so. My powershell script downloads a CSV from alphavantage for each ticker symbol, strips out the header row, then combines all the files into a single file that can be imported using a saved import setting in Gnucash. I can probable share this if someone is interested. I also have another set of saved imports I use to bring in the prices for CIT's that are not available through any of the normal price reporting mechanisms. It might be better and more reliable than running a cron job every night to get the data. Matt On Tuesday, June 23, 2020, 03:11:19 PM CDT, David Carlson wrote: I am not sure that this is your problem or not, but I have found that I need to wait several hours after the markets have closed before downloading mutual fund prices. It seems to take hours for some of them to get posted at Yahoo.com. One way to check would be to see what Yahoo.com is reporting early after hours vs later. GnuCash only keeps one downloaded price per day, and repeated prices are discarded. If you see that is what is happening, you might file a RFE to keep the last price reported instead of the first. . On Tue, Jun 23, 2020 at 2:19 PM Colin wrote: > First off, I just installed GnuCash a couple weeks ago, after trying a few > other options and finding they simply weren't mature enough or > feature-complete enough for what I need. I can't say thank you enough to > everyone who's developed this program, everyone who continues to develop it > and everyone who provides support here. It's an incredible accomplishment! > > I have an issue with Finance::Quote. It brings in prices for my three > Vanguard funds when I run the following command, and I've been planning on > setting up a cron job for it: > gnucash --add-price-quotes path/to/my/gnucash/file > However, for one fund (VTSAX) it enters the prior day's price again as > today's. This requires me to look it up and fix it manually. Its settings > under Security editor are the same as the other two (VTIAX and VWELX). > They're set to get online quotes from a single source, Alphavantage. > Can anyone provide guidance on what may be going on here? > Second question: > I have a Raspberry Pi and it would make sense to run the cron job there > since it's always up. I also use Syncthing for syncing files between > devices. However, the latest version in their repo's is GnuCash 3.4 and > Finance::Quote 1.47. Would this introduce problems to have the Pi update my > GnuCash file with price quotes? > > Thank you, > Colin > > ___ > 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. > -- 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] Guidance request.
Adrien, Thanks for the advice and ideas. I'll play around and get the old years into version 3.96 or 4.x. Then play around with things and get the basics working again, with distributed backups across several linux systems. I guess, from what I read, is it is pretty straightforward to get data from banks now, as long as they support one of the standards/formats you use on a particular gnucash install. The old 2.4 version book for gnucash by Ashok Ramachandran, made it easy to follow and setup. Perhaps someone would write a new book, or develop a website, centric to the 4.x gnucash going forward. Surely there is already excellent existing documentation online, as well as this list. THANKS! To all for gnucash. PS, Gentoo has gotten really easy to install: https://cloveros.ga/ (runs on btrfs) or http://exgent.exton.net/ Where it has a Rasp. Pi twist "I�ve created an exGENT/Gentoo system for Raspberry Pi 4. Read more about it�" So now your gnucash accounting system can go anywhere? James On 6/22/20 7:14 PM, Adrien Monteleone wrote: James, I�ll tackle a few of those for you. (not necessarily by your same point list) First - 2.4 is several versions old. You�ll need to first install something from 2.6 (the next major version after 2.4), open your data file with it, and perform Check & Repair. Repeat this for one of the 3.x releases. (version number scheme changed w/3.x) Then do so again with 4.x. Always work on or with a backup data file of course. Second - You asked about a 4.0 beta, that is 3.906 which is a testing release, but is effectively (per the announcement) a release-candidate barring any major issues. Third - For documentation, there is a Help and a Tutorial & Concepts guide on the website, along with a Wiki. The wiki fills in some gaps in the official documentation and has some use-case advice. (as well as detailed instructions for building on Linux) You can install/build the two official docs on linux. See the build instructions on the wiki for more info. (they come with the Win version package, and I thought Mac as well, but I�ve never been able to get them to open from the app on Mac. I just visit the web version if I need them.) Fourth - Syncing is being done by some users via their own file server or a 3rd party like Drop Box. Note, there is no mechanism in place to prevent 2 people from opening the same data file at the same time other than a warning dialog. But if you�re the only one accessing it and you just want to make it portable but in one physical place, then that shouldn�t be an issue. Maybe look over a few threads here about doing this first, at least to see if there are any hiccups or issues to be aware of. Fifth - Backups are of course, on your own. Certainly rsync would work. I personally use BackInTime on my Linux systems. I like that it is somewhat similar to TimeMachine on my Mac which I prefer over other solutions I�ve tried through the years. Of course, rsync is a bit more �do it yourself� but if you are running Gentoo, I don�t expect that to be a roadblock. I once played with Bacula but found it to be way too much for what I needed. I�m not familiar with the GnuCash for Android app, and I�ve seen list threads discussing that it appears to be stalled or abandoned. You�d have to find their community and developers. It is a separate project from GnuCash. Hope some of that helps, Regards, Adrien On Jun 22, 2020 w26d174, at 5:32 PM, james via gnucash-user wrote: Hello, So I successfully used gnucash for a small S-corp, from 2012, thru 2017(September). Then several concurrent/random illnesses sidelined my gnucash usage. The small s corp trudged along and I did manage to get tax returns file (both S and personal) but the 100-200 transactions per year where not entered after July 2017. After years, I'm mostly healthy and ready to compile the latest version of gnucash on gentoo (actually 3.8b-r1 ) is already installed and looking at me, to enter data. So, I'd like to set it up on postgresql and wait until version 4.0 is at least released in beta. keeping copies on at least (2) distinct linux systems is required, and a way (methodology) to sync one to another is very important. I'd be greatly appreciative for info on how to input the data from 2012-2017, as I believe it was a 2.4 version of gnucash to gnucash 4.0+. The old 2012 lappy still runs, so I can boot it up, when the times is at hand to migrate that old data to the system running 4.0+. Once I do that, move the old data, into gnucash 4.0+, I'd then manually input the data for years 2017 (august forward) and 2018 and 2019 and 2020. The company just had a credit card, a checkbook (few written) and me accessing the data via gnucash. 1. Suggested docs/guides to read 2. upload the old data (2012-2017) lappy to lappy and test. 3.Setup/use OFX with a bank and directly download data into GNUcash. 4. Eventually input/corr
Re: [GNC] Finance::Quote enters previous day's price as today's
> On Jun 23, 2020, at 4:10 PM, David Carlson > wrote: > > I am not sure that this is your problem or not, but I have found that I > need to wait several hours after the markets have closed before downloading > mutual fund prices. It seems to take hours for some of them to get posted > at Yahoo.com. One way to check would be to see what Yahoo.com is reporting > early after hours vs later. > > GnuCash only keeps one downloaded price per day, and repeated prices are > discarded. If you see that is what is happening, you might file a RFE to > keep the last price reported instead of the first. > > On my test today, gnucash did save the most recent downloaded price for today, not the first. Fund prices can get weird, depending on data feed and intermediaries. Yahoo as JSON was reporting an 8am price for today that was slightly different from yesterday’s close for all three of these Vanguard funds. Alphavantage, as of 6:30pm today (Tuesday) was still reporting Friday’s price for these funds. Yahoo got today’s closing NAV for VTIAX and VWELX at 5:39 pm (EDT). The VTSAX price didn’t update until 6:00pm. > > . > > On Tue, Jun 23, 2020 at 2:19 PM Colin wrote: > >> First off, I just installed GnuCash a couple weeks ago, after trying a few >> other options and finding they simply weren't mature enough or >> feature-complete enough for what I need. I can't say thank you enough to >> everyone who's developed this program, everyone who continues to develop it >> and everyone who provides support here. It's an incredible accomplishment! >> >> I have an issue with Finance::Quote. It brings in prices for my three >> Vanguard funds when I run the following command, and I've been planning on >> setting up a cron job for it: >> gnucash --add-price-quotes path/to/my/gnucash/file >> However, for one fund (VTSAX) it enters the prior day's price again as >> today's. This requires me to look it up and fix it manually. Its settings >> under Security editor are the same as the other two (VTIAX and VWELX). >> They're set to get online quotes from a single source, Alphavantage. >> Can anyone provide guidance on what may be going on here? >> Second question: >> I have a Raspberry Pi and it would make sense to run the cron job there >> since it's always up. I also use Syncthing for syncing files between >> devices. However, the latest version in their repo's is GnuCash 3.4 and >> Finance::Quote 1.47. Would this introduce problems to have the Pi update my >> GnuCash file with price quotes? >> >> Thank you, >> Colin -- Dave Reiser dbrei...@icloud.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 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] Guidance request.
James For synchroniszation on Linux and Windows and MacOSX (via Macports) you might like to try the Unison File Synchronizer. I sync my files between several systems with this and find it pretty painless once it is initially setup. Requires setting up SSH certificates but that is not too hard and can be run as a cron job to automate the process David Cousens. On Mon, 2020-06-22 at 18:32 -0400, james via gnucash-user wrote: > Hello, > > So I successfully used gnucash for a small S-corp, > from 2012, thru 2017(September). > > Then several concurrent/random illnesses sidelined my gnucash usage. The > small s corp trudged along and I did manage to get tax returns file > (both S and personal) but the 100-200 transactions per year where not > entered after July 2017. > > After years, I'm mostly healthy and ready to > compile the latest version of gnucash on gentoo (actually 3.8b-r1 ) is > already installed and looking at me, to enter data. > > > So, I'd like to set it up on postgresql and wait until version 4.0 is at > least released in beta. keeping copies > on at least (2) distinct linux systems is required, and a way > (methodology) to sync one to another is very important. > > I'd be greatly appreciative for info on how to input the data from > 2012-2017, as I believe it was a 2.4 version of gnucash to gnucash 4.0+. > The old 2012 lappy still runs, so I can boot it up, when the times is at > hand to migrate that old data to the system running 4.0+. > > Once I do that, move the old data, into gnucash 4.0+, I'd then manually > input the data for years 2017 (august forward) and 2018 and 2019 and 2020. > > The company just had a credit card, a checkbook (few written) and me > accessing the data via gnucash. > > 1. Suggested docs/guides to read > > 2. upload the old data (2012-2017) lappy to lappy and test. > > 3.Setup/use OFX with a bank and directly download data into GNUcash. > > 4. Eventually input/correct 2020 data under the new 4.0* version. > > 5. have some sorts of rigorous backup system, to a different computer > (options?/suggestions?). rsync by drive to remote drive ? > > Anything else anyone can suggest? > > Oh, my phone is Android 9 but looking at an Android 20+ > in a few months... (unlocked stacks). A discussion on Security for > gnucash on Android would be most welcome. Or a place to read about > Gnucash security issue on both linux/android. > > All discussion and suggestions are welcome. > > James > ___ > 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::Quote enters previous day's price as today's
Dave R. is correct to call out the timing as a source of the issue. Just to add some additional background, I work in the financial services industry and a component part of my team's work is to ingest prices from 200+ mutual fund companies, covering tens of thousands of mutual fund prices. The best practice in the mutual fund industry calls for prices to be available by 9:00 PM Eastern Time. However, in my experience, several factors can influence how quickly prices are calculated: (1) market volatility for the day can really mess with prices for equity funds, (2) prices are often delayed during dividend/cap gain payment season, the worst is in December, but can also affect price delivery in March, June, and September, (3) industry-wide issues, there are only a handful of companies that do fund accounting, so when one of them has an issue, it can cause problems across the industry, (4) fund companies often publish corrected prices on the same day, it's possible that Alphavantage has a different price than Yahoo, for example, depending on how quickly they (or their vendor) is ingesting updated prices. My cron job for updating prices doesn't run until 5:00 AM. There are additional reasons for this, but I wouldn't set up an automated price update until 2:00 AM Eastern at the earliest for the best chance of getting the most up-to-date mutual fund prices. Robin On Tue, Jun 23, 2020 at 5:40 PM David Reiser via gnucash-user < gnucash-user@gnucash.org> wrote: > > > On Jun 23, 2020, at 4:10 PM, David Carlson > wrote: > > > > I am not sure that this is your problem or not, but I have found that I > > need to wait several hours after the markets have closed before > downloading > > mutual fund prices. It seems to take hours for some of them to get > posted > > at Yahoo.com. One way to check would be to see what Yahoo.com is > reporting > > early after hours vs later. > > > > GnuCash only keeps one downloaded price per day, and repeated prices are > > discarded. If you see that is what is happening, you might file a RFE to > > keep the last price reported instead of the first. > > > > > On my test today, gnucash did save the most recent downloaded price for > today, not the first. > > Fund prices can get weird, depending on data feed and intermediaries. > Yahoo as JSON was reporting an 8am price for today that was slightly > different from yesterday’s close for all three of these Vanguard funds. > Alphavantage, as of 6:30pm today (Tuesday) was still reporting Friday’s > price for these funds. > > Yahoo got today’s closing NAV for VTIAX and VWELX at 5:39 pm (EDT). The > VTSAX price didn’t update until 6:00pm. > > > > > > > . > > > > On Tue, Jun 23, 2020 at 2:19 PM Colin wrote: > > > >> First off, I just installed GnuCash a couple weeks ago, after trying a > few > >> other options and finding they simply weren't mature enough or > >> feature-complete enough for what I need. I can't say thank you enough to > >> everyone who's developed this program, everyone who continues to > develop it > >> and everyone who provides support here. It's an incredible > accomplishment! > >> > >> I have an issue with Finance::Quote. It brings in prices for my three > >> Vanguard funds when I run the following command, and I've been planning > on > >> setting up a cron job for it: > >> gnucash --add-price-quotes path/to/my/gnucash/file > >> However, for one fund (VTSAX) it enters the prior day's price again as > >> today's. This requires me to look it up and fix it manually. Its > settings > >> under Security editor are the same as the other two (VTIAX and VWELX). > >> They're set to get online quotes from a single source, Alphavantage. > >> Can anyone provide guidance on what may be going on here? > >> Second question: > >> I have a Raspberry Pi and it would make sense to run the cron job there > >> since it's always up. I also use Syncthing for syncing files between > >> devices. However, the latest version in their repo's is GnuCash 3.4 and > >> Finance::Quote 1.47. Would this introduce problems to have the Pi > update my > >> GnuCash file with price quotes? > >> > >> Thank you, > >> Colin > > > -- > Dave Reiser > dbrei...@icloud.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 > 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 reme
