CORRECTION: My latest contribution is now here:
https://wiki.gnucash.org/wiki/PostgreSQL-Requests_For_Direct_Database_Access
(Puts down fire extinguisher ;--))
Geoff
=
On 16/10/2022 12:54 pm, Geoff wrote:
Looks good to me too, thank you David.
NOTE I have just attempted another (more
Looks good to me too, thank you David.
NOTE I have just attempted another (more restrained) Wiki update here:
https://wiki.gnucash.org/wiki/SQL#Prices
(Fastens asbestos suit ;--))
Thanks
Geoff
=
On 13/10/2022 6:05 am, Frank H. Ellenberger wrote:
Thanks, David! :-)
Am 12.10.22 um 09:01
Please forgive me if this is too non-specific and generalized, I'm sure
someone else who's made the MSmoney –> GnuCash migration can lend
assistance (there are threads from the past on this subject, so it has
been done) but I'll offer some general considerations and ideas.
#1 Can MSmoney
I switched after using Quicken for about 20 years. I was never able to get
my Quicken data to import, so I just started using GnuCash with starting
balances, and then entered investment back data as I needed it. Now that
I've been on GnuCash for over six years, there is nothing I need to go back
Thank you. This will be a new experience for me - I have never even
looked at SQL, much less have any facility with it. All the included
reports don't touch the price database itself, and I don't know how to
create an appropriate one from the menu in GC. Off to look at the wiki
:) Probably
Thank you, but how I have my investments labeled make sense to me, and
not to any online databases. I personally enter the quarterly (or
monthly) prices that the statements give me (some of which are not
tracked by, say, finance:quote), so conventional tools are really
useless for me. It's
if you are looking for historical price data for analysis, you can use google
finance function in goolge sheets to get the same, for example
=GOOGLEFINANCE("AAPL", "price", DATE(2016,1,1), today(), "DAILY") will give you
daily rates from 2016 january
Saludos Cordiales
Murugan
The easiest would be to save your book to SQLite3: File>Save As..., pick
Sqlite3 from the drop-down at the top of the dialog, pick a file name and
location.
Then run a query on the prices table (see
https://wiki.gnucash.org/wiki/SQL#Prices for the schema; you may want to join
on commodities to
Asking again - is there any way to get the accumulated data copied from
the price database into a spreadsheet?
- Elmar
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
hi Richard
I went through a similar experience two years ago (not from MSmoney though). i
took an approach of taking a cutoff date and move the balances into GNUCash and
offset against equity. On the securities it will be a bit complex as you have
to arrive at the average cost. for a brief
I've been using MSmoney for my personal financial management for about 20
years. When it went 'sunset' I started looking around and found GNUcash. I
signed up & I've been following you all here ever since. I made some tentative
attempts to convert over but it has always been a disaster. I have
11 matches
Mail list logo