Re: [GNC] Mutual fund quotes in the U. S.

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

Re: [GNC] Mutual fund quotes in the U. S.

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

Re: [GNC] ETF's in GnuCash?

An ETF is traded like a stock, so I choose to treat it as one. It behaves exactly the same. I see no difference in how any of them are handled as far as tracking my accounts, price retrieval, etc. The only thing I've ever had to handle differently in decades is when I sold an ETF based on gold. In

Re: [GNC] How do I get back the cursor highlight for rows on the account page using CSS file on Windows 10?

I listed my gtk.css file in a previous topic about formatting the register header (something you can't do with CSS). Here's a link to that: http://gnucash.1415818.n4.nabble.com/GNC-Formatting-the-Register-header-td4715551.html#a471 The Wiki is just what I found using a typical search with

Re: [GNC] How do I get back the cursor highlight for rows on the account page using CSS file on Windows 10?

You e-mailed me directly about more stuff, but I don't generally check that stuff. You should always use Reply All so further messages come here. Anyway, I somewhat recently posted my full gtk.css file that I use for GnuCash, which has all my "discoveries" about different formatting that are

Re: [GNC] is there a transaction limit on converting xml to mysql

This is just a guess, based upon other things I've seen in the past, but I seem to recall that in some versions of GnuCash there was a problem with the format of dates? Maybe the large file you're trying to process has some dates that are in a format that conflicts with what MySQL is expecting.

Re: [GNC] How do I get back the cursor highlight for rows on the account page using CSS file on Windows 10?

The thing you're looking to set, I think, is #account_tree:selected { background_color: teal ; color:white ; font-weight: bold ; } I like to have the bar inverted, you can fiddle with the colors to your liking. - Ken Farley -- Sent from:

Re: [GNC] Gnucash logs

I see by the response(s) that it's not as simple as a setting. However, there's no reason you couldn't do a move of the file(s) with some sort of script. Depends on the operating system you're working under. For example, if you're running on Windows, you could add a command or two to the shortcut

Re: [GNC] GnuCash 3.8 font size too small

I'm running 3.8 on my Mac. If the directory structure is the same for you as it is for me (highly likely), perhaps my setup would work. I set the styling stuff, which includes the font, with a file called "gtk.css". It's in the directory: /Users//Library/Application

Re: [GNC] Need CSS help for 1 line

I've done a bit of investigation of this and found what you're looking for. Here's the lines from my gtk.css file that change the very line you're asking about: .GncRegisterPage { background-color: @hueBGMain ; } .GncRegisterPage label { font-family: "CopperPlate", sans-serif ;

Re: [GNC] Stock account. Entering transacction.

When I do stock transactions that involve shares being bought or sold, I always do them in the investment account for that "holds" the shares for that specific stock. For example, the account structure might be something like: Investments:My Brokerage Account:XYZ Stock So I open the account "XYZ

Re: [GNC] Formatting the Register header?

I don't run Gnucash in full size window either, but the Inspector apparently thought I should...or something I hit in my debugging play triggered the full-screen in the horizontal direction. The things I'd most like to change on the register header: * Make the text-align on the columns "center".

Re: [GNC] Formatting the Register header?

Yeah, I thought about building the app myself, but it would be a huge undertaking to figure out where to set things up, i.e. where are the gui elements built and assembled? Plus, next time there's an update to a new version, I'd have to do all the hacking I did all over again in order to upgrade.

Re: [GNC] Formatting the Register header?

I tested the theme I wanted to use by copying all the GTK3 related files from the theme into the Gnucash config directory (~\Appplication Support\Gnucash\config\gtk-3.0 on MacOS). It worked fine, but as expressed elsewhere, the Register Header formatting was immune to all but the background color

Re: [GNC] Custom Gtk theme (was: Formatting the Register header?)

Yes, I've been through the Wiki a few times. Put the files every place it recommends, and to no avail. That's why I asked what someone's actual working configuration was. I guess there must be something botched up on my system. Oh well. As for the other stuff, I thought I "replied all" on any

[GNC] Formatting the Register header?

Hello. I've been whacking away at a bit of GTK3 css formatting to make things a bit more stylish for me. Gnucash 3.8, MacOS 10.12.6 The question I have is: Can I do any formatting or other modifications to the header bar entries in the register? I'd like to be able to do the following items: (1)

[GNC] Using GTK3 Themes with Gnucash 3.X on MacOS

I've seen discussions that imply I should be able to apply a GTK3 theme to Gnucash, but despite my best efforts, am unable to do so. Is this possible? My Setup MacOS 10.12 (Sierra), Gnucash 3.8 I've gone through the Wiki about this stuff, but nothing I try works. If anyone has got this to work,

Re: [GNC] v3.8

Well, that was the clue that fixed things for me. I was able to do a wee bit of cpan updating and it apparently fixed the conflict that was causing me all the failures. Everything works nicely. Also, if i might add, the latest 3.8 version seems to start up a bit quicker than its elder predecessor.

Re: [GNC] v3.8

Hi John, Seems like I'm always dealing with Perl troubles on here. I found the utility script you described, and the results I get with it are as expected: < --- Begin Test --- > $VAR1 = { 'AMZNerrormsg' => 'Error retrieving quote for AMZN. Attempt to fetch the URL

Re: [GNC] v3.8

Thanks, David. I just used the quote downloading in the 2.6 version I was running previously, on 2019-12-27 (Friday). After the update to 3.8 today, it no longer works. Running gnc-fq-dump yahoo_json amzn gets me nothing. Not even the date. I ran the gnc-fq-update module to try and get things

Re: [GNC] v3.8

I just updated from my previous 2.6 variant (can't recall the actual version, but it was near the end of the series). I cannot get any Finance::Quote data. Was using yahoo_json, but it doesn't work any more, not able to even get a quote for AMZN from gnc-fq-dump. Doesn't even return the date.

Re: [GNC] Setting up existing investments in new GnuCash file

As far as moving accounts into a nested position later, I think you can use the "Edit Account" functionality to change the Parent Account setting. Found this out after carelessly creating an account in the wrong place. You don't need to delete anything. The program automatically updates all the

Re: Price Editor/Database lag

You don't necessarily have to update manually. The original Yahoo source has been ruined, but you can (and I do) use "yahoo_json" as a source. It's worked fine for me. As for your actual question, I'm sorry but I've no idea. I'm running on Mac OSX. People might have some inquiries about the

Re: Upgrading to 2.7 series

As I understand it, the 2.7 series is an unstable developmental version of the program, not intended for production use. By its very nature it will have bugs, 'cause that's part of the process of testing it and making improvements. In short, if you're just using the program, I'd not fiddle with

Re: Finance::Quote for EE Savings Bonds

David, I'm not sure which item you're referring to, so I'll say a bit about each: (1) As far as I can figure, if I want to add a quote source, like US EE/E/I savings bonds, I have to write my own Perl code to get it done. The existing Finance::Quote modules just don't work, or at least not when I

Re: Finance::Quote for EE Savings Bonds

Yeah, I've found that one of the philosophical differences in how to track these things seems to be that some accounting systems want you to put the bonds in as a share-per-USD relationship. And, since there is no actual universal "symbol" for EE or other bonds of the type, there are lots of

Re: Online quotes fetching the wrong price

You could also, without any alphavantage stuff, obtain quotes from the "yahoo_json" source, again using NAB.AX as the symbol. Hopefully yahoo won't kill off this source, too. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: Finance::Quote for EE Savings Bonds

Robin, Were you able to get quotes for your bonds? - 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

Re: Finance::Quote for EE Savings Bonds

USBonds.pm Here's the Perl code. It was my first Perl program, so it's likely not going to win any awards and such, but it works for me for my old EE bonds. - Ken Farley -- Sent from:

Re: Has the Treasury Direct interface changed?

So, after trying different methods of communicating with the treasurydirect site, I finally bit the bullet and updated my Perl modules (via a cpan "upgrade" command) and the problem has been fixed. Don't know which module was mucked up or how it got that way, but things are working fine, now. I

Re: gnc-fq-update download

I don't know where the gnc-fq-* files are put on a Linux installation, but they are just short Perl scripts that do the stuff for you. I'm on OS X, and on there the files are in /Applications/Gnucash.app/Contents/Resources/bin Either way, here the text from "gnc-fq-update". You can copy this into

Re: Running balance stops working

You've not mentioned the operating system you are running on, which can be helpful if other people want to try and duplicate your problem. Either way, first off, I've got lots of added namespace entries for the securities, like ETF, ESOP, etc. They are just placeholders for categorizing, they

Re: Has the Treasury Direct interface changed?

John, I get the results you get from "curl". A whole lot of code. So this narrows my troubles down to the use of Perl for requests? I'm currently using version 5.18. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: Has the Treasury Direct interface changed?

I'm not using a proxy. I tried using identification strings for a few other browers, like Chrome, Internet Explorer, Safari, etc. and to no avail. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

Re: Has the Treasury Direct interface changed?

Well, that really does me in, I guess. Odd that I can use their on-site tools to get values of things, but can't via Perl. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: Has the Treasury Direct interface changed?

I did try this. The only effect from changing it is to get a different number at the end of the failure message, i.e. it goes from "Can't connect to www.treasurydirect.gov:80 (Connection refused)" to "Can't connect to www.treasurydirect.gov:443 (Connection refused)" This is rather mysterious

Re: Has the Treasury Direct interface changed?

The API is documented, but again, attempts to communicate with it yield the same message: Can't connect to www.treasurydirect.gov:80 (Connection refused) It just seems that the site doesn't want to accept any communications. I'd be interested if someone else was able to get anything out of the

Re: Has the Treasury Direct interface changed?

Hi Frank. I substituted the definition of the URL with the following my $urlSite = "https://www.treasurydirect.gov/; ; But I still get the same message about the connection being refused. Going by the normal browser activity, I can get to the ..BC/SBCPrice page and get prices, etc. It just

Re: Has the Treasury Direct interface changed?

I'm using the bond quote grabbing code I wrote in 2012 which has been serving me faithfully since 2016-04-04. I am using https in the url, here's the full contents I get from the post request: Can't connect to www.treasurydirect.gov:443 (Connection refused) LWP::Protocol::https::Socket: connect:

Re: Has the Treasury Direct interface changed?

Well, it appears that the only data being returned by quote requests is: "Can't connect to www.treasurydirect.gov:80 (Connection refused)" Don't have any idea why - my Perl experience is rather limited. Definitely throws a wrench into the works for me, though. - Ken Farley -- Sent from:

Has the Treasury Direct interface changed?

I've been able to obtain quotes from the Treasury Direct (treasurydirect.gov) for a while, until 2017-12-12. Does anyone know if the interface of this site has changed lately? I know I'll have to investigate to update my Perl code to get these, but just thought I'd check if anyone has clues that

Re: how to get aex quotes

I just tried to obtain a quote for this symbol with yahoo_json, and it seems to be giving prices. The results I get for gnc-fq-dump yahoo_json rdsa.as is Finance::Quote fields Gnucash uses: symbol: rdsa.as <=== required date: 11/16/2017 <=== recommended

Re: No stock quote for LU1233758587

I made a quick shell script to try to get quotes for this symbol (LU1233758587) on all the sources available. Running gnc-fq-check gives all the sources, and sending an inquiry to gnc-fq-dump LU1233758587 for each source checks them. None of the sources yielded anything. Some possibilities I can