[GNC] New price source

[Christopher Lam]

To casual and regular users:
In addition to pricedb-nearest and pricedb-latest, there'll be a new price
source 'pricedb-nearest-before' in 4.6 onwards; this will ignore prices
*after* the report date.
e.g. a user records weekly prices e.g. on 19-dec, 26-dec, 2-jan, 9-jan etc
and runs the balance sheet report dated 31-dec.
Although the nearest price is 2-jan, we'd usually want the 26-dec price
instead (e.g. a stock-split, or a GFC may have occurred on 1-jan).
Please test and report -- recent builds 24 April 2021 onwards have this new
source.
https://code.gnucash.org/builds/flatpak/maint/ and
https://code.gnucash.org/builds/win32/maint/
Relevant bug report: https://bugs.gnucash.org/show_bug.cgi?id=743753
___
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] Mutual fund quotes in the U. S.

[farleykj]

I just did a gnc-fq-dump for one of my investments and the date reported
within the data was 2021-04-23, which makes sense, since it's a mutual fund
that had its price updated yesterday (Friday) evening. However, when I do a
price update in GnuCash it takes that quote and assigns it a date for today,
2021-04-24. It appears that GnuCash ignores the date provided with the quote
and uses todays date when storing the value in the database. How odd.

Running Version 3.8 on OSX (Version 10.12.6). Finance Quote Version 1.49.



-
Ken Farley
--
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:
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] difficulties I am having

[John Ralls]

Please copy the list on all replies unless you're including confidential 
information like a screenshot of your register.

Since you've got your file back the way you want it you should save it and make 
a copy, then consider also making a copy on a service like Dropbox or Google 
Drive so that you're protected if something should happen to your computer. Do 
that again every year after you finish entering the previous year's data.

Regards,
John Ralls

> On Apr 24, 2021, at 5:18 PM, Jay Bouxsein  wrote:
> 
> Well, I have good news and bad news, good first. I did manage to get my 
> original data entry screen, that is the one that we were using, and it seems 
> to be working just like it did when we were entering the data for tax year 
> 2020.  All of the data we entered for transactions in Jan and Feb were all 
> still where we put them and it was waiting for us to enter the new data 
> starting with March 1.  I can also print P & L for past years as well as this 
> year.
> 
> The bad news is that your suggested go back via backup will not work for me 
> because the newest back up the system has for me dates all the way back to 
> 2017.  It appears that ever since we used the system since 2017 I was simply 
> exiting the program without posting the new data ignoring any error messages 
> that may have appeared.  You know, as you get older, you start to mentally 
> age back to your youth, and I am proof of that. I really cannot tell you how 
> I got back to the setup I had, I just started punching buttons that looked 
> like they might help. I really did not want to go back and start again from 
> 2017 so I figured what the Hell.  I only remember hitting the "revert" option 
> from the file menu and nothing after that.
> 
> In any event, my plan is to get 2020 out of the way and then maybe start all 
> over again setting up a new and improved chart of accounts under a new 
> company name.  It shouldn't be too bad because we really do have a simple 
> operation here with limited vendors and limited things which only pop up 
> rarely as issues. I promise , I hope, to not need to trouble you in the 
> future, I'll make good use of the program's help feature.
> 
> I thank you and all of your mates who stepped up to try to lend a helping 
> hand. It is pleasant to run into people like you who are willing to help 
> strangers.
> 
> VTY
> 
> Jay Bouxsein
> 
> On Thu, Apr 22, 2021 at 7:45 PM John Ralls  wrote:
> That's not what I hoped to see.
> It looks like instead of changing the type of the checking account you 
> deleted it and told GnuCash to move all of its transactions to Expenses.
> 
> It's possible to fix this but it will be a little tedious. If you have a 
> backup from before all of this happened (see 
> https://wiki.gnucash.org/wiki/FAQ#Q:_What_are_all_these_.gnucash_and_.log_files_filling_up_my_directory.3F
>  if you don't know about GnuCash's automatic backups) then you can just quit 
> GnuCash without saving, rename the backup to the working name, and start over.
> 
> Otherwise you'll need to:
> 1. Leave the current Expenses account as type Expense but rename it to 
> Checking.
> 2. Make a new top level expenses account 
> 3. Edit each direct child account of Checking and change its parent to 
> Expenses.
> 4. When Checking has no more children edit it, change its type to Bank, and 
> change its parent to Assets:Current Assets.
> 
> Regards,
> John Ralls
> 
> > On Apr 22, 2021, at 5:21 PM, Jay Bouxsein  wrote:
> > 
> > Thanks so much for such a prompt reply. I have attached a couple of photos 
> > of the screens that I have up on my computer right now which should answer 
> > your question and give you more understanding about the way my system is 
> > set up.
> > 
> > I thank you again for all your help.
> > 
> > Jay BOUXSEIN
> > 
> > 
> > On Thu, Apr 22, 2021, 7:09 PM John Ralls  wrote:
> > Whether you want to change the children depends on how you've structured 
> > your accounts. What are the children?
> > 
> > Regards,
> > John Ralls
> > 
> > > On Apr 22, 2021, at 5:04 PM, Jay Bouxsein  wrote:
> > > 
> > > Thanks so much. I am at the computer right now and made the change you 
> > > recommended in the lower left hand corner of the edit account screen to 
> > > bank. I pressed OK and got a pop-up screen that says "give the children 
> > > the same type ?" And wonder whether I should accept this change. I'm 
> > > going to try to give you a screenshot of what I'm looking at right now.
> > > 
> > > No go on the screenshot I can't figure out how to do it from my phone 
> > > which is what I am using to send this email.
> > > 
> > > If you can answer based on the earlier paragraphs in this email please do 
> > > so and I'll hit okay and if it doesn't work out well I can get back to 
> > > you.
> > > 
> > > Many thanks
> > > 
> > > Jay
> > > 
> > > On Thu, Apr 22, 2021, 6:13 PM John Ralls  wrote:
> > > "IIUC" means "if I understand correctly".
> > > 
> > > No, Register2 is an attempt to rewrite of t

Re: [GNC] Duplicate Trading Account Created in V4.5

[John Ralls]

> On Apr 23, 2021, at 4:20 AM, Gal  wrote:
> 
> Demonstration:
>  


Thanks for reporting this. Mike is right, it's a mistake in the fix for Bug 
798093. I think I've fixed it and pushed the fix so it will be in tomorrow's 
nightlies for Microsoft Windows and Flatpak at 
https://code.gnucash.org/builds/win32/maint and 
https://code.gnucash.org/builds/flatpak/maint.

Please test.

Regards,
John Ralls

___
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] Mutual fund quotes in the U. S.

[Chris Good]

Hi David,

I suggest you use gnc-fq-dump to see if Finance Quote (FQ) is returning a date 
(and time?) for your mutual funds. If GnuCash does not get a date from FQ, then 
it defaults the date to today. In this case, I suggest the solution would be to 
have FQ yahoo_JSON modified to provide an appropriate date, based on the time.
It could be quite a complicated mod though. What do you do if the user time 
zone is not in the US? What about weekends and public holidays?

 An alternative may be to use a different FQ source (alphavantage?).

The problem could also be that FQ is returning a date (and time) but GnuCash is 
changing the date based on your time zone, but I think that is unlikely as I 
think it tries to default the time to 11:59 or 10:59am on all dates to avoid 
that problem just about everywhere in the world.

It may be helpful to also save your GnuCash data as uncompressed xml and see 
what the date/time is in the price database record.

You can raise a FQ issue at 
https://github.com/finance-quote/finance-quote/issues

See also https://wiki.gnucash.org/wiki/Online_Quotes

You may like to ensure you are running the latest GnuCash and FQ.

Regards,
Chris Good

> Message: 7
> Date: Sat, 24 Apr 2021 08:57:21 -0400
> From: Jack Frillman 
> To: David Carlson 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Mutual fund quotes in the U. S.
> Message-ID: <1bc5ad5a-508d-d272-20ad-bf4951122...@me.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> It can get the prices for both stocks and mutual funds. The lookup is 
> done by ticker symbol.
> 
> GNUC's csv price importer requires a date to be present in the csv file 
> so I'm not sure what you are asking in your second question.
> 
> Below is a sample of a couple of lines from the csv file. It's has the 
> bare minimum of information the csv price importer requires.
> 
> This is the format of each line:
> TICKER,PRICE,TYPE,DATE,CURRENCY
> 
> ARSIX,15.73,Ray Jay,2021/04/22,USD
> BAFGX,35.07,Ray Jay,2021/04/22,USD
> 
> 
> On 4/24/21 2:11 AM, David Carlson wrote:
>> Jack,
>> 
>> Your scripts offer an opportunity to massage the data, if needed.? Out 
>> of curiosity, can you import both stock prices and mutual fund 
>> prices?? And can you keep the timestamps in your CSV files?
>> 
>> On Fri, Apr 23, 2021 at 8:55 PM Jack Frillman > > wrote:
>> 
>>It may be doing what I'm doing and making the date of the closing
>>price as the day the script is run.
>> 
>>I don't run it using cron. I run it manually and if I forget a day
>>I don't worry about it.
>>I just run one of these two commands from the terminal.
>> 
>>getquotes -y??? <-- ? gets the prices from Yahoo
>>..OR.
>>getquotes -m?? <-- ? gets the prices from Market Watch
>> 
>>Then I import the resulting csv file that appears on my desktop.
>> 
>>I have two places to get the quotes so if one is unreachable for
>>some reason I have a backup source.
>> 
>> 
>>On 4/23/21 9:43 PM, David Carlson wrote:
>>>I am not sufficiently comfortable with BASH, Chron jobs, etc to
>>>be willing to set up an outside utility to do that.? I manually
>>>download prices inside the GnuCash price database using Yahoo as
>>>JSON as the source.? If I forget to do it in the late evening I
>>>sometimes try to do it in the morning before the market opens as
>>>I have several stock prices that I am also tracking.? That is how
>>>I discovered the incorrect dates on the mutual funds prices,? I
>>>am not sure if, for example, GnuCash downloads a stock price
>>>during the day, does it replace it with a closing price if it
>>>downloads again after the market closes.? I suspect it may not
>>>even keep the timestamps that come with the prices, so there may
>>>not be any clue about that.
>>>On Fri, Apr 23, 2021 at 8:18 PM Jack Frillman via gnucash-user
>>>mailto:gnucash-user@gnucash.org>> wrote:
>>>I'm not sure what you are using to updated the your prices
>>>but I wrote a
>>>python script & a bash script that get the quotes and put
>>>them into a
>>>csv file for importing into GNUCash and I don't have that
>>>date issue. I
>>>run the scrips in the evening when the markets are closed.
>>>On 4/23/21 8:59 PM, David Carlson wrote:
 I noticed recently that if I download mutual fund prices
>>>after about 7 AM
 central daylight time the prices are saved in GnuCash with
>>>todays date even
 though they are still yesterday's closing NAV until
>>>sometime after the
 markets close.? To reliably get the correct price posted on
>>>the correct
 date it seems that I must wait until after 7PM Central time
>>>but before 7AM
 the following morning.
 I would like to suggest an enhancement that if GnuCash
>>>downloads a United
 States mutual fund price with a morning time stamp th

Re: [GNC] removing Appendix D; was:Chart of Account maintainers

[R. Victor Klassen]

I do.

I suspect most North America-based users of the business features write cheques 
(checks in the US).It’s just a matter of volume whether it’s worth printing 
them.  (I find it much easier to avoid missing recording them if they are 
recorded and then printed).

> On Apr 23, 2021, at 7:24 PM, David Carlson  
> wrote:
> 
> 
> Granted, not many users print checks any more, but IIRC there was a
> question quite recently about that on this maillist.

___
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] removing appendix C; was: removing Appendix D; was:Chart of Account maintainers

[Frank H. Ellenberger]

Am 24.04.21 um 18:53 schrieb Ian McFarlane:
> From a user perspective I think some explanation of the supplied account 
> hierarchies would be helpful.
> 
> So either you have to go with a full listing of all the account hierarchies 
> supplied with explanatory notes in Appendix C of the Tutorial and Concepts 
> Guide or link to the wiki for users to find the information there (from 
> Appendix C and/or from the New Account Hierarchy Setup section).
> 
> Personally I would vote for the wiki as it is the most efficient way to crowd 
> source information. I would have no problem helping with wikifying the 
> content.
> 
> Ian Mc

For de we have such a section:
https://wiki.gnucash.org/wiki/De/Referenz#In_GnuCash_enthaltene_Kontenrahmen

As you can see, there are country specific subsections for AT, CH, DE.
Unexplained are the modules of the common personal use template.
So it is restricted to business templates according governmental or
other country specific rules and contains also the year of the
implemented rules

You could start with C, en_GB, en_IN of
https://github.com/Gnucash/gnucash/tree/maint/data/accounts

Ideally the creator had put some useful info in the
 fields.

Pages for other languages were ideally written in the respective language.

Regards
Frank
___
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] removing appendix C; was: removing Appendix D; was:Chart of Account maintainers

[Ian McFarlane]

>From a user perspective I think some explanation of the supplied account 
>hierarchies would be helpful.

So either you have to go with a full listing of all the account hierarchies 
supplied with explanatory notes in Appendix C of the Tutorial and Concepts 
Guide or link to the wiki for users to find the information there (from 
Appendix C and/or from the New Account Hierarchy Setup section).

Personally I would vote for the wiki as it is the most efficient way to crowd 
source information. I would have no problem helping with wikifying the content.

Ian Mc

-Original Message-
From: gnucash-user  
On Behalf Of D. via gnucash-user
Sent: 23 April 2021 23:42
To: David Carlson 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] removing appendix C; was: removing Appendix D; was:Chart of 
Account maintainers

Yes David, appendix C. I am challenged that way. 

Frank: there isn't really any content in appendix C, except this outdated 
listing. Why not move it to the wiki, where someone (like the OP) could 
actually make changes? 


 Original Message 
From: David Carlson 
Sent: Fri Apr 23 17:38:21 EDT 2021
To: "Frank H. Ellenberger" 
Cc: "D." , Gnucash Users 
Subject: Re: [GNC] removing Appendix D; was:Chart of Account maintainers

Forgive me, I am confused.  I just looked at appendix D and I found "
D. Auxiliary
File Formats"
.  Is that what 
you want to delete?  The U.K Vat reference is in Appendix C.

On Fri, Apr 23, 2021 at 4:16 PM Frank H. Ellenberger < 
frank.h.ellenber...@gmail.com> wrote:

> David,
>
> do you know a good place for the rest of the content?
>
> Frank
>
> Am 23.04.21 um 21:11 schrieb D.:
> > Frank,
> >
> > I'm all for removing Appendix D from the Guide, since the UK entry 
> > is
> the only one there. But then, you knew I'd say that.
> >
> > David T.
> ___
> 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] Upgrade 4.4 tp 4.5 annoyances on flatpak

[Dale Alspach]

I did not make any modifications directly. I have no idea of the details of
what is modified by the system updater but I tend to let the updates pile
up for a few weeks, run the install and reboot (if there are low level
updates). This update of gnucash was in fact an unexpected side effect of
an update and reboot.

Dale

On Sat, Apr 24, 2021 at 8:28 AM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hello again,
>
> forget my previous mail. I mixed up the release and the nightlies. The
> release got the 3.38 runtime, which was already in use almost a half
> year in the nightlies – without complains.
>
> There must be another reason. Did you by chance delete something in
> ~/.var/app or another place mentioned for flatpak in
> wiki.gnucash.org/wiki/Configuration_Locations?
>
> Regards
> Frank
>
> Am 24.04.21 um 00:01 schrieb Frank H. Ellenberger:
> > Hello Dale,
> >
> > it seems most of the points are based on the loss of your previous
> settings.
> >
> > The Gnome devs tricked us here by offering a platform 40 as successor of
> > 3.38. You can think, 40 is the successor of 38, that should be a minor
> > ungrade. But in fact it goes from 3.x to 40, a major jump with changes
> > like moving the dconf location, gtk 3 -> 4 …
> >
> > Still undecided what to do: redo the bundle with runtime 3.38, John?
> >
> > Regards
> > Frank
> >
> > Am 23.04.21 um 22:42 schrieb Dale Alspach:
> >> My install was upgraded this week (flathub) from gnucash 4.4 to 4.5 on
> >> Linux Mint 20.
> >> I think some of these have been reported by others.
> >> 1. First gnucash opened as though I was a new user and needed a new
> account
> >> setup. I was able to stop this and get to the file menu and my last
> >> saved version. The load of my file takes a while and there was no
> >> indication that it was actually working and not hung. It did finally
> finish
> >> loading.
> >> 2. Autosave was not working. Though after three days and quitting and
> >> restarting it asked me a few minutes ago whether I wanted autosave to
> work.
> >> Now it appears to be working (fingers crossed).
> >> 3. Some settings/preferences were lost. Examples: blank transaction
> before
> >> future transactions, my open tabs
> >> 4. The memory of past transactions was odd. In one account it seemed to
> be
> >> fine but in another it would complete the description but not the other
> >> account or amount. Now it seems to be working correctly.
> >> 5. It defaulted to fractional presentation  for some columns for
> >> investments. Changing the decimal preferences fixed this.
> >> 6. Apparently a new feature was implemented which is annoying me. In the
> >> past I was able to open a credit card account and clear several
> >> transactions without hitting "enter". Now I am having to retrain myself
> to
> >> click the "n" and then hit "enter" to avoid getting a discard/save
> popup. I
> >> can see that trying to change "y" to "n" or "c" might trigger the
> dialogue
> >> but I would prefer that switching between "n" and "c" not.
> >>
> >> I wonder whether it was necessary to quit and restart to get gnucash
> >> working correctly with my data file.
> >>
> >> Dale
> >> ___
> >> 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] Mutual fund quotes in the U. S.

[farleykj]

I'd imagine one could do something like this with a Perl script that uses
another script, like the Yahoo JSON one, to get the price, then "adjusts"
the date based upon the time of day, etc.
You'd have to do a bit of searching to figure out how to add your own module
to the quoting functions of Perl, but that's not terribly difficult. Except
that I find Perl a bit opaque, but that's a religious argument...



-
Ken Farley
--
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:
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] Upgrade 4.4 tp 4.5 annoyances on flatpak

[Frank H. Ellenberger]

Hello again,

forget my previous mail. I mixed up the release and the nightlies. The
release got the 3.38 runtime, which was already in use almost a half
year in the nightlies – without complains.

There must be another reason. Did you by chance delete something in
~/.var/app or another place mentioned for flatpak in
wiki.gnucash.org/wiki/Configuration_Locations?

Regards
Frank

Am 24.04.21 um 00:01 schrieb Frank H. Ellenberger:
> Hello Dale,
> 
> it seems most of the points are based on the loss of your previous settings.
> 
> The Gnome devs tricked us here by offering a platform 40 as successor of
> 3.38. You can think, 40 is the successor of 38, that should be a minor
> ungrade. But in fact it goes from 3.x to 40, a major jump with changes
> like moving the dconf location, gtk 3 -> 4 …
> 
> Still undecided what to do: redo the bundle with runtime 3.38, John?
> 
> Regards
> Frank
> 
> Am 23.04.21 um 22:42 schrieb Dale Alspach:
>> My install was upgraded this week (flathub) from gnucash 4.4 to 4.5 on
>> Linux Mint 20.
>> I think some of these have been reported by others.
>> 1. First gnucash opened as though I was a new user and needed a new account
>> setup. I was able to stop this and get to the file menu and my last
>> saved version. The load of my file takes a while and there was no
>> indication that it was actually working and not hung. It did finally finish
>> loading.
>> 2. Autosave was not working. Though after three days and quitting and
>> restarting it asked me a few minutes ago whether I wanted autosave to work.
>> Now it appears to be working (fingers crossed).
>> 3. Some settings/preferences were lost. Examples: blank transaction before
>> future transactions, my open tabs
>> 4. The memory of past transactions was odd. In one account it seemed to be
>> fine but in another it would complete the description but not the other
>> account or amount. Now it seems to be working correctly.
>> 5. It defaulted to fractional presentation  for some columns for
>> investments. Changing the decimal preferences fixed this.
>> 6. Apparently a new feature was implemented which is annoying me. In the
>> past I was able to open a credit card account and clear several
>> transactions without hitting "enter". Now I am having to retrain myself to
>> click the "n" and then hit "enter" to avoid getting a discard/save popup. I
>> can see that trying to change "y" to "n" or "c" might trigger the dialogue
>> but I would prefer that switching between "n" and "c" not.
>>
>> I wonder whether it was necessary to quit and restart to get gnucash
>> working correctly with my data file.
>>
>> Dale
>> ___
>> 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] Mutual fund quotes in the U. S.

[Jack Frillman via gnucash-user]

It can get the prices for both stocks and mutual funds. The lookup is 
done by ticker symbol.


GNUC's csv price importer requires a date to be present in the csv file 
so I'm not sure what you are asking in your second question.


Below is a sample of a couple of lines from the csv file. It's has the 
bare minimum of information the csv price importer requires.


This is the format of each line:
TICKER,PRICE,TYPE,DATE,CURRENCY

ARSIX,15.73,Ray Jay,2021/04/22,USD
BAFGX,35.07,Ray Jay,2021/04/22,USD


On 4/24/21 2:11 AM, David Carlson wrote:

Jack,

Your scripts offer an opportunity to massage the data, if needed.  Out 
of curiosity, can you import both stock prices and mutual fund 
prices?  And can you keep the timestamps in your CSV files?


On Fri, Apr 23, 2021 at 8:55 PM Jack Frillman > wrote:


It may be doing what I'm doing and making the date of the closing
price as the day the script is run.

I don't run it using cron. I run it manually and if I forget a day
I don't worry about it.
I just run one of these two commands from the terminal.

getquotes -y    <--   gets the prices from Yahoo
..OR.
getquotes -m   <--   gets the prices from Market Watch

Then I import the resulting csv file that appears on my desktop.

I have two places to get the quotes so if one is unreachable for
some reason I have a backup source.


On 4/23/21 9:43 PM, David Carlson wrote:

I am not sufficiently comfortable with BASH, Chron jobs, etc to
be willing to set up an outside utility to do that.  I manually
download prices inside the GnuCash price database using Yahoo as
JSON as the source.  If I forget to do it in the late evening I
sometimes try to do it in the morning before the market opens as
I have several stock prices that I am also tracking.  That is how
I discovered the incorrect dates on the mutual funds prices,  I
am not sure if, for example, GnuCash downloads a stock price
during the day, does it replace it with a closing price if it
downloads again after the market closes.  I suspect it may not
even keep the timestamps that come with the prices, so there may
not be any clue about that.

On Fri, Apr 23, 2021 at 8:18 PM Jack Frillman via gnucash-user
mailto:gnucash-user@gnucash.org>> wrote:

I'm not sure what you are using to updated the your prices
but I wrote a
python script & a bash script that get the quotes and put
them into a
csv file for importing into GNUCash and I don't have that
date issue. I
run the scrips in the evening when the markets are closed.

On 4/23/21 8:59 PM, David Carlson wrote:
> I noticed recently that if I download mutual fund prices
after about 7 AM
> central daylight time the prices are saved in GnuCash with
todays date even
> though they are still yesterday's closing NAV until
sometime after the
> markets close.  To reliably get the correct price posted on
the correct
> date it seems that I must wait until after 7PM Central time
but before 7AM
> the following morning.
>
> I would like to suggest an enhancement that if GnuCash
downloads a United
> States mutual fund price with a morning time stamp that it
presume it to be
> yesterday's closing NAV price.  I would like comments from
others about
> this.
>

-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous

___
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


-- 
Old Unix programmers never die, they just mv to /dev/null

- Anonymous



--
David Carlson


--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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.