Re: [GNC] Import Format
Thanks Dave, that's one of the four main banks: https://commbank.simplify.com/commerce/docs/misc/dataexport Interestingly there's a developer's link on that page too. -- 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] Transparent background on selected Transfer choice
Message: 11 Date: Sat, 15 May 2021 10:50:17 +0100 From: Eric Coates To: Chris Good , gnucash-user@gnucash.org Cc: dgpick...@aol.com Subject: Re: [GNC] Transparent background on selected Transfer choice Message-ID: <4f4a5131-ceb7-c176-f877-c6c8d6e55...@talktalk.net> Content-Type: text/plain; charset=utf-8; format=flowed Good Morning In response to Chris Good's enquiry: At initial startup this morning the theme selected was Light and the transparency effect was apparent; Changed the theme to Dark and rebooted, the transparency effect was still apparent; Changed the theme to Standard and rebooted, the transparency effect was still apparent; Changed the theme back to Light and rebooted , the transparency effect was still apparent. As earlier reported I upgraded Ubuntu to 21.04, what I hadn't noticed was that GnuCash had been upgraded to 4.4 (Finance Quote is at 1.49). probably inconsequential but ... just for completeness. Take care Eric = On 14/05/2021 22:50, Chris Good wrote: > Message: 4 >> Date: Fri, 14 May 2021 14:19:49 + (UTC) >> From: "David G. Pickett" >> To: "gnucash-user@gnucash.org" >> Subject: Re: [GNC] Transparent background on selected Transfer choice >> Message-ID: <399211476.334118.1621001989...@mail.yahoo.com> >> Content-Type: text/plain; charset=UTF-8 >> >> Yes, I am 'as out of the box', and no, dark and light have the same problem. >> >> >> -Original Message- >> From: David G. Pickett >> To: gnucash-user@gnucash.org >> Sent: Thu, May 13, 2021 9:45 am >> Subject: Transparent background on selected Transfer choice >> >> I run GNUCash on Ubuntu LTS Linux, and when I select a transfer choice, the background under the choice goes transparent, showing the transaction screen below, see attached; not at all helpful! >> >> -- > Hi, > > David: what version of Ubuntu? > > David + Eric (twistedw...@talktalk.net), are you restarting GnuCash after changing the theme? > > Regards, Chris good Hi David (dgpick...@aol.com) + Eric (twistedw...@talktalk.net), Can you please test the fix Geert found in https://bugs.gnucash.org/show_bug.cgi?id=797493#c12 and let us know how you go? Can you reconfirm the Linux distro and version too please so I can document in the bug. Regards, Chris Good ___ 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] Import Format
On a related note, I wish Gnucash supported export formats besides CSV. -p On Thu, May 27, 2021 at 9:39 PM DaveC49 wrote: > The CBA in Australia offers CSV, OFX and QIF (2 variants) downloads from > the > bank website. They only offer direct connect OFX downloads via MYOB or > Quicken where these companies have a software deal/agreement with the bank > about security. i have approached them about direct connect access but > received a blanket no for open access software. Not sure about other > Australian banks and what they offer. > > > > -- > 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. > ___ 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] Import Format
The CBA in Australia offers CSV, OFX and QIF (2 variants) downloads from the bank website. They only offer direct connect OFX downloads via MYOB or Quicken where these companies have a software deal/agreement with the bank about security. i have approached them about direct connect access but received a blanket no for open access software. Not sure about other Australian banks and what they offer. -- 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.
[GNC] Import Format
The documentation could offer users more guidance in choosing the import format. Most banks allow account transactions to be downloaded (usually as files) and most financial software (including GNUCash) allows the transactions to be imported. GnuCash offers six options but in reality the user might only have one or two formats available from the bank. I understand OFX/QFX is the preferred format but likely only available in USA. It seems MT940 and MT942 SWIFT and DTAUS format (DTAUS has not been supported by banks since 1 February 2016) would also be a preferred option if available. In Australia and probably most other parts of the world the likely options are CSV and/or QIF. QIF is probably the preferred of the two and although the date format can never be known it's probably reasonable to assume it matches the locale setting. (Note: GnuCash does not support date formats with Mmm.) CSV is a loose format the user will need to specify. One advantage of these formats is they are fairly easy to manipulate, particularly CSV. A last resort worth mentioning is extracting data from pdf files, probably manipulating in a spreadsheet and converting into CSV format. Users would need to work this process out themselves. References: https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-MT940-MT942-DTAUS https://gnucash.org/viewdoc.phtml?rev=4=C=help https://gnucash.org/viewdoc.phtml?rev=4=C=guide https://en.wikipedia.org/wiki/Open_Financial_Exchange https://en.wikipedia.org/wiki/Quicken_Interchange_Format https://en.wikipedia.org/wiki/Comma-separated_values -- 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] gnucash-cli --quotes get
On 2021-05-27 10:50 a.m., John Ralls wrote: On May 27, 2021, at 10:35 AM, Cam Ellison wrote: On 2021-05-27 10:08 a.m., mike823 wrote: Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to avoid this behavior? I mean, if you re-run it, it should just update the quote for the day, not create a new one. Thanks. And for those who do day trading, for example, and want to track prices at different times of day? It does what it should, which is to create a record each time it is run. But that's not what GnuCash is designed for and if you try to use it that way you'll pretty quickly run into performance problems. You're much better off getting a portfolio management tool for that kind of thing. Of course - I should have added that disclaimer. Not many of us have unlimited bandwidth. Cheers Cam ___ 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] gnucash-cli --quotes get
I’m also only interested in the market closing price. The question is how will GnuCash handle multiple quotes for one day. Which one will actually be used to valuate the portfolio? -- 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] gnucash-cli --quotes get
It’s probably possible, but getting the script this far is at the far frontier of my Python abilities. Plus, for my purposes, I’m only interested in the market closing price so I only run the script once per day, Tues-Sat. I don’t need an intraday level of granularity. Cheers, Robin On Thu, May 27, 2021 at 12:08 PM mike823 wrote: > Hi Robin, > > I used your code to load quotes and I've noticed that when runs multiple > times, it will create multiple quote records for the same day. Any way to > avoid this behavior? I mean, if you re-run it, it should just update the > quote for the day, not create a new one. > > Thanks. > > > > -- > 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. > -- --- Typed with my thumbs and sent from my iPad. ___ 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] gnucash-cli --quotes get
> On May 27, 2021, at 10:35 AM, Cam Ellison wrote: > > On 2021-05-27 10:08 a.m., mike823 wrote: >> Hi Robin, >> >> I used your code to load quotes and I've noticed that when runs multiple >> times, it will create multiple quote records for the same day. Any way to >> avoid this behavior? I mean, if you re-run it, it should just update the >> quote for the day, not create a new one. >> >> Thanks. >> > And for those who do day trading, for example, and want to track prices at > different times of day? > > It does what it should, which is to create a record each time it is run. But that's not what GnuCash is designed for and if you try to use it that way you'll pretty quickly run into performance problems. You're much better off getting a portfolio management tool for that kind of thing. 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] gnucash-cli --quotes get
On 2021-05-27 10:08 a.m., mike823 wrote: Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to avoid this behavior? I mean, if you re-run it, it should just update the quote for the day, not create a new one. Thanks. And for those who do day trading, for example, and want to track prices at different times of day? It does what it should, which is to create a record each time it is run. Cheers Cam ___ 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] gnucash-cli --quotes get
Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to avoid this behavior? I mean, if you re-run it, it should just update the quote for the day, not create a new one. Thanks. -- 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] Cancel Transaction Interface Oddity
HI, On Thu, May 27, 2021 10:34 am, D. via gnucash-user wrote: > Hello, > > GC4.5 (Build ID 4.5+ (2021-03-27)) Windows 10 > > I have noticed that while entering a new transaction, that if I click the > Cancel button, the cursor remains in whatever field had the focus at the > time of cancelation. For the record, I most commonly cancel a transaction > from the amount field because autofill puts the same amount into the > transaction, which tells me I already entered that transaction. In this > circumstance, the amount field remains the active field after the > transaction has been canceled. > > This is disconcerting, as it means that my next action MUST be to relocate > the cursor back to the date field in order to create a new transaction. > Typing at this point puts information into the amount field, and pressing > enter creates a spurious transaction. > > Given these points, I think it is a UI error to leave the cursor at this > location after canceling, and I will file a bug if others agree with me. I agree it is a UI bug. It's never bothered me enough to file a report or try to fix it; I just Shift-Tab back to the date column. > > David T. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Cancel Transaction Interface Oddity
Hello, GC4.5 (Build ID 4.5+ (2021-03-27)) Windows 10 I have noticed that while entering a new transaction, that if I click the Cancel button, the cursor remains in whatever field had the focus at the time of cancelation. For the record, I most commonly cancel a transaction from the amount field because autofill puts the same amount into the transaction, which tells me I already entered that transaction. In this circumstance, the amount field remains the active field after the transaction has been canceled. This is disconcerting, as it means that my next action MUST be to relocate the cursor back to the date field in order to create a new transaction. Typing at this point puts information into the amount field, and pressing enter creates a spurious transaction. Given these points, I think it is a UI error to leave the cursor at this location after canceling, and I will file a bug if others agree with me. 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.
