I have seen "overnight" massive gains when there's been a stock split I
wasn't aware of, a 10 to 1 reverse split, or something like that.
Usually it is the opposite effect of what you are seeing, where suddenly
I'm down a lot of net worth.
The only other thing I can think of is that maybe one
No.
Using an SQL database just means you are deciding where you are going to
save your data. The way the program works is that it loads your data
file into memory and any changes you make are done in memory. Data is
not saved anywhere until you specifically write it to wherever you store
it.
Ah yes, hex editing. Alas, gone are the days when one could utilize
skills in assembly language programming and the like, at least with
modern code. Do then even attempt to teach anyone assembly language anymore?
The other thing that makes editing binary data difficult is that it is
also
Sorry, I was being an idiot and opened the QDF file, not the QIF file.
My QIF files definitely have the date format you are seeing, something
like "11/21/97" for pre-2000 years, and " 4/ 5' 3"
It looks like the price lines you are being told about a lacking a
numeric price. All the price
Converting from Quicken seems to come up a lot here. Here's a long post
I made after I'd converted over a lot of data:
https://lists.gnucash.org/pipermail/gnucash-user/2022-October/103226.html
There is a lot of advice in the form of wiki pages and the like, too.
To address your specific
Guilty as charged. Using version 1.57. I wasn't having any troubles, so
didn't update regularly. No ice cream for me tonight.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Once I sent the last message and had a bit of time to think about it, I
realized I could try something, and it worked.
There's a line in the module that uses a few exchange names to find the
correct data on the HTML page:
$taglink = $tree->look_down(_tag => 'a', href =>
If I go directly to the Google Finance site and ask for a quote for a
mutual fund, for example SNXFX, I get all the info I am seeking.
If I try to load prices into Gnucash using the "googleweb" source,
stocks are fine, ETFs are fine, but mutual funds like the above don't
work. My suspicions
I found this information extremely enlightening. I didn't know that
there was a capability to use Google's capabilities to make a
spreadsheet and automatically include pricing data. It's as if Libre
Office Calc or Excel had an inbuilt function to retrieve pricing info.
Very useful information.
Don't know if you ever solved this, or if a solution is possible, but
these are the lines from my GTK3 CSS file that deal with the register lines.
*.gnc-class-register-primary
{
background-color: @hueRegLight ;
color: @hueTextNormal ;
}
*.gnc-class-register-secondary
{
That one has never seemed to work for very long. Perhaps they notice any
increased traffic and change, or are just the kind of folks who update
their code regularly? Oh well.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your
I believe there is something on the mailing list site (the one
referenced at the bottom of every message) that gives you a link for a
"helper" Google search that is tailored to search the archives. I find
it helpful to find "that answer I remember seeing that I can't for the
life of me
You don't mention what version of Gnucash you are using, or what
operating system. This can be important, particularly when dealing with
the idiosyncrasies of Finance::Quote.
Regardless, I'm using MacOS, Version 4.14.
When I use the shell commands provided with this version, I get the
Nah. Filters that store all that stuff are for things I need to look at.
I find it much more efficient to go to:
https://lists.gnucash.org/pipermail/gnucash-user
and browse through the messages to see the very small percentage of them
I'm interested in. That way I don't have to delete a pile
Unsubscribing isn't done by the list, it's just posts of questions like
yours.
To unsubscribe, you need to go to:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
To be honest, I don't allow the deluge of emails to come to me, either.
Too many to have to sift through every day.
Others will likely help you get going on things like downloading bank
transactions and the other things. As far as bringing Quicken data over
to Gnucash, I did a big block of that a little over a year ago, because
I wanted to have all the history available. Here's a regurgitation of a
long
A caveat about this. Any method of storing data could be used by
multiple people, as long as they have access/permissions to the data.
However, this is one person at a time. Simultaneous changing of the data
is not allowed. I believe it's a case of "whoever saves last wins". The
program reads
I'm using Gnucash on Mac OS, but I would think the file locations are
used for the same functions. The directory for "books" on my machine is
"~/Library/Application Support/Gnucash/books". Different location, same
purpose. This directory contains a bunch of files with names like
I see that my structure has been messed up, presumably because I tried
to use different fonts or whatnot.
Here's what I was trying to show
Assets
Investments
Brokerage Account
= Cash Account = <-- an account of type "Bank"
Security Account A <-- Stock or Mutual Fund
I used to have my cash balance in the Brokerage account, but somewhere
along the line I found it "cleaner" (?) to use something like the
following structure for my various investment accounts (Brokerage, IRAs,
401(k)s)
*Assets*
*Investments*
*Brokerage Account*
* = Cash Account =
My guess would be that it's because they were created as a "currency"
and can't be changed? I don't use any currencies as investments, so I
don't have any experience with this kind of thing.
If there is a way you can specify the source of the quotes (i.e. not
Alphavantage), you could take the
Oh I don't think you have to do anything terribly complicated. I've had
mutual funds change their trading symbols in the past, and it was as
simple as editing the security via
Tools-> Security Editor
Changing all the perinent information for the affected securities.
Gnucash uses that info,
Yahoo seems to use "GC=F" as the symbol for Gold. I am able to get the
price of gold as shown in the following output from gnc-fq-dump
--> gnc-fq-dump yahoo_json GC=F
Finance::Quote fields Gnucash uses:
symbol: GC=F <=== required
date: 10/04/2023 <===
I'm not sure about the process. I'm led to believe it's built into
GnuCash and relatively simple to use?
Here's a past discussion prompted by someone having difficulties and
eventually figuring it out:
https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079372.html
Hopefully this
ow have crash report.
On 17/09/2023, 15:13, "gnucash-user on behalf of Ken Farley"behalf of farle...@gmail.com> wrote:
I think you might be missing some of the steps you were asked to
perform, so here they are:
(1) Run Gnucash while telling it to save a tra
I think you might be missing some of the steps you were asked to
perform, so here they are:
(1) Run Gnucash while telling it to save a trace file. This file lists
all the actions of the program. This is done with the command (on MacOS):
/Applications/Gnucash.app/Contents/MacOS/Gnucash
I really don't see what is so difficult to understand about this.
The key equation is AMOUNT = PRICE * SHARES
Gnucash works under the philosophy that two of those terms must be
maintained precisely:
AMOUNT - the total cost of the transaction. What you ultimately paid in
the currency of your
That doesn't seem to be something the Advanced Portfolio report is made
to do. It is meant to provide a snapshot of things at a particular point
in time, based upon the cost/earnings/increase in value of investments.
I think, if I wanted to do this, I'd approach it thus, unless someone
else
I've not used this functionality but from what I read in the
documentation the command you're referencing is intended to be used to
update prices in a Gnucash data file. Presumably it's a way to execute
the task of Tools->Price Database->Get Quotes, without actually starting
up the Gnucash
Are you able to get quotes for that particular security using any of the
other sources in F::Q, like googleweb, yahooweb, yahoo_json? I get
prices from any one of those.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your
From your signature, it appears you are running on a Windows machine.
Since you're talking about installing, most likely you got the latest
version, 5.3.
If you downloaded the correct installer for Windows, you should have a
file named "gnucash-5.3.setup.exe". Windows notoriously tries to be
I don't know if this ever worked for you, but when I run it with the
verbose flag "-v", I get the following:
[ Begin try with gnc-fq-dump ]
CMD> ./gnc-fq-dump -v tiaacref QCBMPX
Finance::Quote fields Gnucash uses:
symbol: QCBMPX (deduced) <=== required
date: ** missing
My understanding of the new Yahooweb module is that it uses the current
date when reporting prices. I believe this is because the data source
from which the quote is built does not provide a "quote date" or that
sort of information. Therefore, the author of the new module had to do
something
I am running Gnucash on MacOS, but presumably the philosophy behind
customizing the look if the interface is the same. The way things look
as far as "themes" go is dictated by a file called "gtk.css". I don't
know where this particular file is saved on a Windows system, but you
could probably
I spent some time looking at lots of stuff pertaining to this and ended
up with the settings I currently use in my gtk.css file, attached. Have
a look and see if you can use any of my "tricks".
/*
* Author: Kenneth J. Farley
* Date: 2021-12-11
*
* GTK3 CSS file for use with GnuCash.
*
Where did you get the impression that you could use gunzip to uncompress
the files?
To "uncompress" the file you need to change your preferences in Gnucash
to turn off "Compress Files", then save your file. This will make the
file uncompressed.
Best practice would be to copy the
Why yes, John, that's exactly it. I've only owned foreign stocks in
mutual funds (and ETFs). So if you ask me right now, almost halfway
through the year, how much foreign taxes I've paid or had paid for me, I
just shrug. I won't know until next February. Oddly enough, one of the
past letters
Form 1116 has cost me at least a couple of iterations of filing my taxes
in the past. It would be nice if something told me I needed it...but
unless I was paying taxes to a foreign nation directly, meaning a
transaction occurs in one of my accounts, I don't see how I would have
it included in
You do not specify the version or operating system you are running.
Are you "switching to another data file" by using the File->Open menu,
or by double clicking on the file you want to open next in a file
folder? Gnucash behaves differently, as I understand it, depending on
what your
Bruce,
It's okay, I'm not an expert with Perl, but have done a lot of
programming. I used one of the methods proposed to extract the data I
need and use it. It's not elegant code, but as with all such
investigations that eventually get solved, it's so satisfying to have
done it. And I
This message from the list contains links to the development bug reports
for the Finance:Quote module:
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106863.html
If you look at those reports, there are alternate queries discussed that
could provide the data needed. They need to be
Don't know if this is going to be a periodic thing that happens, or if
it is just me, but this is going on again. Guess I'll wait a day or two
and see if it "recovers", unless someone feels it's only my setup that
is failing...
___
gnucash-user
I have my account settings on the mail list to not send me any of the
topics directly. Instead, I prefer to browse through the discussions via
the following link:
https://lists.gnucash.org/pipermail/gnucash-user/
When I see a discussion I want to reply to, I click on the e-mail
address of
I think there's a conceptual misunderstanding here.
Securities are intended to represent things like stocks, bonds, funds,
ETFs or other investments. They are not, in and of themselves, taxable
or nontaxable.
You can own shares of a security in both taxable and non-taxable
accounts. For
Security Editor
Pick your security
Use drop-down list or if you want to create a new namespace, type it in
the box.
The weirdest thing about it is being able to type a new thing into the
dropdown. Usually dropdowns are kind of a restricted list, but in
Gnucash you can add new ones there,
From the release notes:
The Online Quotes facility has been completely rewritten and the old
gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced
with finance-quote-wrapper. The functions performed by those programs
may now be accomplished by passing commands to
I just installed 4.14 (I usually wait a bit before jumping to the next
major release), and this bit of a glitch is still there. I didn't see it
as a bug that was addressed in the release notes, so no surprise. It's a
little strange, but doesn't affect the function of the program, so I
live
Turns out MacOS shows directories with specific cases, but if you cd
down one with different case characters it kind of does an "alias on the
fly". If I cd using "GNUCASH" or "GNUcash" or whatever mix of characters
I chose (i.e. "GnUcAsH") it will cd into the directory just fine and
spit back
So did the directory specification change for 4.14 and/or 5.0?
I swear my customizations are in
~/Library/Application Support/Gnucash
No capital "C" in there. This is copied directly from my shell window,
not transcribed by me.
Strange.
___
I'm still running 4.13 on MacOS, haven't updated yet. I, too notice when
I check the "About" settings, I see GnuCash in the directory
specifications, but the actual directory on the file system ends with
"Gnucash", in other words, no "GnuCash". I don't really use key
mappings, but do have
I've done this very thing to myself in the past. Turns out I wanted to
stop seeing a bunch of zero value accounts and didn't make them
"hidden", but instead unclicked the
View->Filter By..->Other->Show Zero Total Accounts checkbox.
Since new accounts have a zero balance, voila (or maybe
When I was doing a bunch of Quicken conversions using QIF files, what
happened was pretty much what you described here, I think. My original
shares were removed in one transaction, while the split amount was added
back. For example, 200 shares that needed at 2 for 1 resulted in a 200
share
"Go to a backup file" Why? You know you can change the date on a
transaction after it has been entered, right? You can use the "+" and
"-" keys to move up and down as many days as you want. The transactions
are not permanently entered and unalterable.
About 90% or more of the transactions I
This kind of thing is generally your responsibility. I can't think of a
single bit of software I use for work - be it CAD, document writing,
spreadsheet, or whatever - that does backup of my data for me. That task
is on me, and rightly so. The time my computer suffered a complete
crash, the
I think the originator of this thread was talking about file size on
disk. My guess is they're saving to uncompressed XML or something. I've
got files with 10 years of data, many accounts, lots of securities, lots
of price data. Only need ~870KB of disk space as a compressed XML file.
I'm using Gnucash on MacOS and under the menu there is File->Export
which has options to export:
Account Tree to CSV
Transactions to CSV
Active Register to CSV
Accounts
But to be honest, if you want to migrate to another system, you could
look here:
This is a common concern whenever someone (including me) is migrating to
Gnucash. As is noted elsewhere, it's a conceptual change based on
Quicken Category => Gnucash Account. What I realized when I converted
years and years of data over is just how terrible I was at maintaining
some sort of
Um, I wasn't responding to your question, but rather to the one
referenced in the Subject.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
I don't know how complicated the data you are attempting to transfer is.
I can tell you that I recently had access to an old computer with
Quicken 2011. I used this to write out 10 years of .QIF files, one file
for each year, data for that year only. I had it include everything that
it would
Yeah I just messed about a bit with my install of GnuCash (v4.12) and
Toronto Stock Exchange is grayed out.
I looked at the module and the only thing I changed was that there was a
reference to TSX.pm in the header. I changed it to TMX.pm, then ran the
quoting update script provided with
If I remember correctly, when I made my own module to grab US EE Bond
prices, in order for GnuCash to allow my module to be used, I had to add
it to the MODULES list in Quote.pm. I'm working on a Mac, so your path
might differ, but for me it's in /Library/Perl/5.30/Finance. I added a
line
I just updated to version 4.12, running on macOS 12.6.
When I have an account with a fractional shares, amount greater than
1000 (i.e. 1234.567 shares), the lines in the account list are double
the width of the rest of the lines in the list, with the extra white
space before and after the
I wrote a long post a bit ago when I first got my M1 based Mac and I had
to wrestle with getting Finance:Quote to work. I scoured the internet
and managed to put together a method for fixing it, that I also added to
the Wiki.
It's nice that folks put all their findings on how to fix stuff in
Been running on a Mac based system for a very long time, since 2011,
including my current Mac Mini M1. Runs perfectly. Have no fear. If you
run into any oddities, just check the other Mac related posts on this
forum and you'll likely find answers.
I just did this for about 12 years of old Quicken data. I've had dozens
of different accounts over the years, most of which are gone.
My technique was arrived at after trying a lot of different things,
reading the Wiki, etc.
First, I had to get my hands on an old computer that I could use to
There's been a good deal of difficulty, including for me, in getting
Finance::Quote to run properly on MacOS. Seems like the Perl stuff on
Macs gets botched up and no matter what you do it won't work. So, I did
a whole lot of searching, found a good deal of other people's
experiments and
I will concur with all the other responders to this, that it's very
common to want to customize the font and many other things about the
program to make it more appealing or readable, etc. The thing about CSS
files, if I understand things correctly, is that they are kind of a
"read thru once"
The settings are almost the same from 3.x to 4.x, but coincidentally,
the things to change Gnucash specific items (like register colors) are
different. I'm attaching my own gtk.css with my own preferred settings.
I spent a good amount of time delving into the interface settings
available in
take a look at it when I get home tonight, a bit
of wordsmithing and all that. Quite a bit more than what I originally
intended to do, but that's how it goes...maybe I'll learn something.
On Tue, Nov 16, 2021 at 7:03 AM Frank H. Ellenberger
wrote:
>
> Hi Ken,
>
> Am 16.11.21 um 02:32
Okay, so I put my findings into the Wiki. Turns out it's relatively
easy. Hopefully if something I wrote is too vague or wrong someone
correct it. The toughest part was figuring out where to put the stuff.
On 2021-11-07 10:21, Ken Farley wrote:
Hope it works out for you. I noticed
curiosity.
On Mon, Nov 8, 2021 at 4:42 AM Frank H. Ellenberger
wrote:
>
> Hi Ken,
>
> Am 07.11.21 um 16:21 schrieb Ken Farley:
> > Hope it works out for you. I noticed there are sporadic questions
> > about this kind of thing and thought it might be nice to have a place
> > w
you listed are all ones that FQ Update had issues with when I tried
> to update on BS so here goes :-)
>
> Cheers David H.
>
>
> On Fri, 5 Nov 2021 at 12:58, Ken Farley wrote:
>>
>> Not a question, just my notes on how I got Finance::Quote to work on a
>> n
Not a question, just my notes on how I got Finance::Quote to work on a
new Mac Mini M1.
Operating system is OS X 11.6 (Big Sur)
GnuCash Version is 4.8 (from the -2.dmg)
My initial install left me unable to download quotes (via
Finance::Quote). Research online eventually led to a Reddit
I don't really remember ALL the places I tried. Pretty much all the
places recommended by the Wiki about this stuff for Gnucash. Some
examples of other attempts:
~/Library/Application Support/config/themes
~/Library/Application Support/themes
~Library/Application
>> of usefulness? I don't know.
>> A beneficial side effect of this is that after digging deep into my Perl
>> code to get quotes for E/EE/I bonds, it's a lot cleaner and perhaps a bit
>> easier to read. Well, as easy as Perl gets, I suppose.
>>
>>
>>
>> -
The only CPAN-related stuff I've done was updating Finance::Quote during
the Yahoo-caused quote debacle. Other than that, I tend to leave things
as is, since OS X is allegedly pretty snotty about having things mucked
about with.
Near as I can figure the problem is solely with the
76 matches
Mail list logo
