Re: Unable to download stock quotes

[John Ralls]

> On Mar 19, 2018, at 7:53 PM, santer  wrote:
> 
> The ability to download stock quotes has been a critical feature of gnucash. 
> The yahoo resource stopped working over the last few months. A work around
> for me has been yahoo json, which is now so slow it's unusable. 
> 
> Does anyone know if something is being done to resolve this problem. What
> are some other work around options?

The only general workaround besides yahoo-json that we know of is Alphavantage, 
as explained at 
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F 
. It 
is also quite slow compared to the former Yahoo! service.

Another alternative might be Google Finance, but there’s some concern about 
their terms of service vis-a-vis screen-scraping.

GnuCash 3.0 includes a new importer for stock prices in CSV format. If you can 
arrange to download quotes from a financial institution with which you do 
business you may be able to format those downloads for import.

Beyond that, we’re pretty much stuck. Neither we nor Erik Colson, the 
maintainer of Finance::Quote, can do much about retrieving quotes without a 
service to retrieve from.

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.

Unable to download stock quotes

[santer]

The ability to download stock quotes has been a critical feature of gnucash. 
The yahoo resource stopped working over the last few months. A work around
for me has been yahoo json, which is now so slow it's unusable. 

Does anyone know if something is being done to resolve this problem. What
are some other work around options?





--
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: Intuit Mint to GnuCash

[The Manager]

That sounds like a wonderful tool.  QIF is a nightmare because of the variable,
not explicit date formats and US date format out of synch with the rest of the
world.

Have at IT : -)

> 
> JFYI: About year ago I start working on small python script to import my
> credit card transactions from Mint to my GnuCash. It works fine for simple
> transactions (aka no splits), but I have not found good way to avoid some
> of the collisions. More specifically if you have two splits at same store
> on the same date.
> 
> 
> 
> I was planning to upload my code to my GitHub (
> https://github.com/SAL-e/mint2gnucash ), unfortunately my laptop crashed.
> But seeing this thread I'm going to restore my project and share my code if
> there is interest.
> 
> 
> 
> Best regards,
> 
> Svetoslav Trochev
> 
> 
> 
> On Mon, Mar 19, 2018 at 6:35 AM John Ralls  wrote:
> 

___
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: Intuit Mint to GnuCash

[SAL-e]

Hi,



JFYI: About year ago I start working on small python script to import my
credit card transactions from Mint to my GnuCash. It works fine for simple
transactions (aka no splits), but I have not found good way to avoid some
of the collisions. More specifically if you have two splits at same store
on the same date.



I was planning to upload my code to my GitHub (
https://github.com/SAL-e/mint2gnucash ), unfortunately my laptop crashed.
But seeing this thread I'm going to restore my project and share my code if
there is interest.



Best regards,

Svetoslav Trochev



On Mon, Mar 19, 2018 at 6:35 AM John Ralls  wrote:

>
>
> > On Mar 19, 2018, at 4:35 AM, DaveC49  wrote:
> >
> > Transferring data out of Intuit Mint will depend upon whether that
> > program/app has the ability to export data in a suitable form like OFX or
> > Excel CSV format. Gnucash can import OFX file data if correctly
> structured
> > and the current Gnucash versions can import CSV with some limitations
> (the
> > developers are working on a more general csv import capability). If
> > importing from Excel, it is generally better to edit the format to suit
> the
> > import capability/expected structure in Excel, i.e. until it imports
> > correctly . Better to get it working on a small data set and then import
> the
> > data in batches rather than try and do a mass import -  less to fix up if
> > there is a problem. can't comment more specifically about Intuit Mint.
>
> More correctly, GnuCash 3.0, now in beta testing as GnuCash 2.7.7, has a
> greatly enhance CSV import capability.
>
> 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.
>
___
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: GnuCash 2.7.7 Released

[Adrien Monteleone]

The Github links provided point to 2.7.7 files allegedly residing in 2.7.6 
folders. They return a 404 of course. Change the parent folder once you paste 
the link and you’ll get your download.


Regards,
Adrien

> On Mar 18, 2018, at 5:41 PM, John Ralls  wrote:
> 
> The Gnucash Development Team is pleased to release Gnucash 2.7.7, the eighth 
> release of an unstable series leading to Gnucash 3.0
> 
> Notice that we've decided that beginning with the upcoming major release we 
> will use two-digit release numbers and that the next stable release will be 
> 3.0. Maintenance releases will be 3.1, 3.2, etc. The next unstable release 
> will be 3.900 and will lead to 4.0.
> 
> This release is UNSTABLE and SHOULD NOT BE USED in production.
> 
> This release changes file locations, binding APIs, report options, and can 
> make your data file no longer compatible with previous versions. See the 
> Update Notes Page for details.
> 
> See the KNOWN PROBLEMS list at the bottom of the announcement.
> 
> New Features for Users:
> 
> None in this release.
> For Developers and Distro packagers:
> 
>   • The Python Bindings and Console are now for Python 3.
>   • It's now possible to create a GncPrice from the Python bindings with 
> "gnc_price_create(book)", removing the need to clone an existing GncPrice 
> object and modify it.
>   • Compilation of GLib Schemas during build and installation can be 
> disabled by setting -DCOMPILE_GSCHEMAS=OFF. This is intended only for 
> distribution packaging scripts that run glib-compile-schemas themselves.
> Bugs fixed in this release:
> 
>   • Bug 787439 - Segmentation Fault in Transfer dialog after clearing 
> Date field and pressing escape.
>   • Bug 791831 - Add python3 support.
>   • Bug 794242 - Remove keep above setting for assistant hierarchy
> Some other fixes not associated with reported bugs:
> 
>   • Fix date corruption in SQL load. Four date elements were affected: 
> GncEntry::date, GncEntry::date_entered, GncInvoice::opened, and 
> GncInvoice::posted. This does not affect the stored values of the dates.
>   • Fix lost Bayesian matches in SQL backend. The import-map-bayes uses a 
> three-part key that uses the same delimiter as a path and the SQL backend was 
> throwing away everything except the account guid.
>   • More transient-window fixes and other Gtk3 cleanups.
>   • Add xmlns namespace declarations to all of the accounts templates 
> that lacked it and remove the emacs mode-setting comments at the end of them.
> KNOWN PROBLEMS:
> 
>   • Bug 789594 - Unable to overwrite sqlite3 database file
>   • Bug 791823 - There is no Gtk3 theme-setting tool for Windows.
>   • Bug 791825 - Accounting period dates off-by-1
>   • Bug 793220 - Can't input CJK characters in the transaction 
> description field
> Updated Translations:
> 
> Spanish
> 
> 
> Getting GnuCash for Windows and MacOS
> 
> GnuCash is provided for both Microsoft Windows XP® and later and MacOS X 10.9 
> (Mavericks)® and later in pre-built, all-in-one packages. An installer is 
> provided for Microsoft Windows® while the MacOS X® package is a disk image 
> containing a drag-and-drop application bundle.
> SourceForge:
> 
>  Download GnuCash for Win32: 
> https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.7.7.setup.exe
>  Download GnuCash for Mac-Intel: 
> https://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-Intel-2.7.7-1.dmg
> 
> Github
> 
>  Download GnuCash for Win32: 
> https://github.com/Gnucash/gnucash/releases/download/2.7.6/gnucash-2.7.7.setup.exe
>  Download GnuCash for Mac-Intel: 
> https://github.com/Gnucash/gnucash/releases/download/2.7.6/Gnucash-Intel-2.7.7-1.dmg
> 
> Getting GnuCash as source code
> 
> If you want to compile GnuCash 2.7.7 for yourself, the source code can be 
> downloaded from:
> 
>  Sourceforge: 
> http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.7.7.tar.bz2
> http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.7.7.tar.gz
>  Github:
> 
> https://github.com/Gnucash/gnucash/releases/download/2.7.7/gnucash-2.7.7.tar.bz2
> 
> https://github.com/Gnucash/gnucash/releases/download/2.7.7/gnucash-2.7.7.tar.gz
> WARNING Do not try to use the github-generated files labelled "Source 
> Code". They have not been processed with
> swig and will not build.
>  You can also checkout the sources: git clone 
> https://github.com/Gnucash/gnucash.
> 
> The SHA256 Hashes for the downloadable files are:
> 
>  ad91fc1ce1742489bca43f292b928e3106749dcbeb8d44a2a9295817d24892ed  
> gnucash-2.7.7.tar.bz2
>  809f275578f09fdc8bb4dd99ac643505e594c791196b0264deff27e1a562a82d  
> gnucash-2.7.7.tar.gz
>  2a0d31fe09c5bee4a8977844ed1839c74e0e93d7f09c8ae1c185f6dbccd3dd36  
> gnucash-2.7.7.setup.exe
>  16eac23a6ee89b6f44defa56ede1114aa9f62497f7ea813122958e1199d772aa  
> GnuCash-Intel-2.7.7-1.dmg
> 
> Please consult the README.dependencies file in the sources for the 

Re: Intuit Mint to GnuCash

[John Ralls]

> On Mar 19, 2018, at 4:35 AM, DaveC49  wrote:
> 
> Transferring data out of Intuit Mint will depend upon whether that
> program/app has the ability to export data in a suitable form like OFX or
> Excel CSV format. Gnucash can import OFX file data if correctly structured
> and the current Gnucash versions can import CSV with some limitations (the
> developers are working on a more general csv import capability). If
> importing from Excel, it is generally better to edit the format to suit the
> import capability/expected structure in Excel, i.e. until it imports
> correctly . Better to get it working on a small data set and then import the
> data in batches rather than try and do a mass import -  less to fix up if
> there is a problem. can't comment more specifically about Intuit Mint.

More correctly, GnuCash 3.0, now in beta testing as GnuCash 2.7.7, has a 
greatly enhance CSV import capability.

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: Average of transactions

[Muhammad Bashir Al-Noimi]

   On 03/19/2018 03:35 PM, Rick Copple wrote:

 I don't believe there is. The easiest way I know to accomplish that
 is to create a transaction report restricting it to that day and
 account, then make sure the create a table box is checked. Once you
 run the report, you can copy and paste the results into a
 spreadsheet. From there you should be able to get your average.

   Thanks Rick
   Usually I do it manually by getting number of days (from first
   transaction day to current day) using the following link then apply the
   average manually (this is really exhausting procedure because I've many
   accounts like this)
   [1]https://www.timeanddate.com/date/durationresult.html
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi

References

   1. https://www.timeanddate.com/date/durationresult.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: Average of transactions

[Rick Copple]

I don't believe there is. The easiest way I know to accomplish that is to 
create a transaction report restricting it to that day and account, then make 
sure the create a table box is checked. Once you run the report, you can copy 
and paste the results into a spreadsheet. From there you should be able to get 
your average.

Rick Copple


On Mar 19, 2018, 6:49 AM, at 6:49 AM, Muhammad Bashir Al-Noimi 
 wrote:
>   Hi,
>  I've a liabilities account and I want to get the daily average of its
>   transactions. Is there any report can calculate this value.
>--
>Best Regards,
>Muhammad Bashir Al-Noimi
>Skype+Telegram+GMail: mbnoimi
>___
>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.

Average of transactions

[Muhammad Bashir Al-Noimi]

   Hi,
   I've a liabilities account and I want to get the daily average of its
   transactions. Is there any report can calculate this value.
--
Best Regards,
Muhammad Bashir Al-Noimi
Skype+Telegram+GMail: mbnoimi
___
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: Intuit Mint to GnuCash

[DaveC49]

Transferring data out of Intuit Mint will depend upon whether that
program/app has the ability to export data in a suitable form like OFX or
Excel CSV format. Gnucash can import OFX file data if correctly structured
and the current Gnucash versions can import CSV with some limitations (the
developers are working on a more general csv import capability). If
importing from Excel, it is generally better to edit the format to suit the
import capability/expected structure in Excel, i.e. until it imports
correctly . Better to get it working on a small data set and then import the
data in batches rather than try and do a mass import -  less to fix up if
there is a problem. can't comment more specifically about Intuit Mint.

David Cousens



-
David Cousens
--
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: GNUcash setup

[Liz]

On Sun, 18 Mar 2018 12:53:40 -0700 (MST)
kbrown  wrote:

> Further:
> After reviewing the info and links, it seems it may be possible to
> have two or more different root trees in one file to accomplish what
> I want, however that appears to be non standard or supported and may
> not work in the future. So I've decided to track each of my entities
> in a separate file and cross post as required for such as expensing a
> portion of utilities for my home office business expenses. There
> should only be a few items like that and it seems there can be more
> than one file open at the same time for copy and paste between.
>Ken

I've not succeeded in copy and paste between files (Debian, XFCE).
However, I do keep parallel entries in several books. Copying isn't
usually what is required, because the direction of the transaction is
changed. What is a credit in Book A, becomes a debit in Book B.

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: Downloading Bank Transactions into Gnucash

[CyAg70 Personal]

Thanks!

> On Mar 18, 2018, at 10:58 AM, John Ralls  wrote:
> 
> 
> 
>> On Mar 17, 2018, at 11:43 AM, Kathleen Hubbard  
>> wrote:
>> 
>> Is it possible to download bank transactions into Gnucash without having 
>> Quicken ?  I read that it will using a QIF file.  So sounds like the user 
>> needs Quicken to be able to download bank transactions into Gnucash.  Is 
>> this correct?
> 
> No.
> 
> GnuCash can import QIF, QFX, and OFX files, and most financial institution 
> websites can make downloads in one or more of those formats. No Quicken 
> required, though some websites will offer the option of downloading in 
> “Quicken Format”, meaning either QIF or QFX at the whim of the webmaster, or 
> “Microsoft Money Format”, meaning OFX.
> 
> Some institutions also proved a connection service called “OFX Direct 
> Connect”, and GnuCash’s Online Banking Module can connect to that service and 
> retrieve transactions directly. N.B. that there is a similar service called 
> “OFX Web Connect” that GnuCash cannot use.
> 
> 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: Downloading Bank Transactions into Gnucash

[ptimlick]

Bank of America has an option on the display transactions screen "download
transactions".  You must select the format, I have always used qif files,
but just tried "web connect for quicken" which downloaded a file stmt.qfx
which appears to work, and appears also to have a more robust interface. 
Either way, their is still work to do in getting the transactions properly
balanced, at least in my experience, at least the numbers are correct. 



--
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: 2.7.6 - Scrolling in Accounts-Tabs

[Anthony Hepple]

Ctrl Shift PageUp/PageDown

On Sun, 18 Mar 2018 13:27 D via gnucash-user, 
wrote:

> I usually point at the tab I want and click on it.
>
> On March 18, 2018, at 2:10 PM, Catscrash  wrote:
>
> Also: There seems to be no other way to get quickly through the Tabs -
> how do you do it? Ctrl+Tab doesn't work, ctrl+page down doesn't work...
> There certainly must be something?
>
> thanks!
>
>
> Am 18.03.2018 um 10:04 schrieb Catscrash:
> > Am 17.03.2018 um 18:12 schrieb Maf. King:
> >> Hi,
> >>
> >> you must have missed John Ralls' reply at 22:56 (GMT) on tuesday where
> he said
> >> it wasn't available in the toolkit...
> >>
> >> Maf.
> >>
> > Indeed, somehow that didn't reach me, thanks!
> >
> > But that's terrible, is this something permanent? Why did they remove it
> > from the toolkit? Can gnucash implement it without the toolkit?
> >
> > ___
> > 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.
> ___
> 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.