2023-07-16 GnuCash IRC logs
00:04:08 *** cproo13 has joined #gnucash
00:04:08 *** ChanServ sets mode: +v cproo13
00:04:28 *** cproo13 has quit IRC
01:36:22 *** jralls_afk has joined #gnucash
01:37:35 *** jralls has quit IRC
01:51:31 *** fell has quit IRC
01:52:50 *** fell has joined #gnucash
01:52:50 *** ChanServ sets mode: +o fell
01:56:50 *** sunyibo has joined #gnucash
01:56:50 *** ChanServ sets mode: +v sunyibo
02:03:15 *** Aussie_matt has joined #gnucash
02:03:51 *** sunyibo has quit IRC
02:06:08 *** sunyibo has joined #gnucash
02:06:08 *** ChanServ sets mode: +v sunyibo
02:09:12 *** sunyibo has quit IRC
02:14:00 *** gandalf has joined #gnucash
02:22:46 *** sunyibo has joined #gnucash
02:22:46 *** ChanServ sets mode: +v sunyibo
04:10:25 *** sunyibo has quit IRC
04:11:18 *** bertbob has quit IRC
04:13:27 *** bertbob has joined #gnucash
04:13:27 *** ChanServ sets mode: +v bertbob
04:22:20 *** jiffe has quit IRC
04:22:33 *** jiffe has joined #gnucash
05:58:08 *** gjanssens has joined #gnucash
05:58:08 *** ChanServ sets mode: +o gjanssens
06:44:51 *** chris has joined #gnucash
06:44:51 *** ChanServ sets mode: +v chris
06:44:55 *** gncbot sets mode: +o chris
06:47:50 *** sunyibo has joined #gnucash
06:47:50 *** ChanServ sets mode: +v sunyibo
07:02:49 *** sunyibo has quit IRC
07:05:34 *** sunyibo has joined #gnucash
07:05:35 *** ChanServ sets mode: +v sunyibo
07:14:03 *** chris has quit IRC
07:32:30 *** sunyibo has quit IRC
07:45:21 *** chris has joined #gnucash
07:45:21 *** ChanServ sets mode: +v chris
07:45:25 *** gncbot sets mode: +o chris
09:10:29 *** chris has quit IRC
09:14:12 *** mikonos has joined #gnucash
09:19:42 *** mikonos_1 has joined #gnucash
09:20:58 *** mikonos has quit IRC
09:26:58 *** mikonos_1 has quit IRC
09:33:36 *** jiffe has quit IRC
09:33:49 *** jiffe has joined #gnucash
09:37:47 *** chris has joined #gnucash
09:37:47 *** ChanServ sets mode: +v chris
09:37:47 *** gncbot sets mode: +o chris
09:58:07 *** jiffe has quit IRC
09:58:23 *** jiffe has joined #gnucash
10:01:25 *** jiffe has quit IRC
10:01:38 *** jiffe has joined #gnucash
10:04:40 *** jiffe has quit IRC
10:04:53 *** jiffe has joined #gnucash
10:08:18 *** Aussie_matt has quit IRC
10:15:53 *** jiffe has quit IRC
10:19:06 *** jiffe has joined #gnucash
10:24:51 *** jervin has joined #gnucash
10:39:54 *** jervin has quit IRC
11:14:22 *** jiffe has quit IRC
11:14:27 *** gandalf1 has joined #gnucash
11:14:36 *** jiffe has joined #gnucash
11:14:54 *** gandalf has quit IRC
11:14:54 *** gandalf1 is now known as gandalf
11:18:36 *** jiffe has quit IRC
11:18:51 *** jiffe has joined #gnucash
11:26:55 *** jiffe has quit IRC
11:27:08 *** jiffe has joined #gnucash
11:33:35 *** jiffe has quit IRC
11:33:50 *** jiffe has joined #gnucash
11:36:42 *** NoobAlice has joined #gnucash
11:36:42 *** ChanServ sets mode: +v NoobAlice
11:37:13 *** jiffe has quit IRC
11:37:54 *** jralls_afk is now known as jralls
11:38:52 *** ChanServ sets mode: +o jralls
11:38:57 <jralls> jiffe, it should, ofxhome.com works.
11:47:46 *** raghavgururajan has joined #gnucash
11:47:47 *** ChanServ sets mode: +v raghavgururajan
12:29:10 *** palerider has joined #gnucash
12:29:13 *** palerider has left #gnucash
12:55:29 *** sunyibo has joined #gnucash
12:55:29 *** ChanServ sets mode: +v sunyibo
13:30:26 *** sunyibo has quit IRC
13:53:20 <CDB-Man> dis something happen to F:Q again?
13:54:00 <CDB-Man> running the F:Q update script it complains that my alphavantage key is not set, even though it hasnt changed in my gnucash settings
13:54:24 <CDB-Man> also when running update on priceDB, it looks like yahoo finance is returning 404
13:55:48 *** chris has quit IRC
13:57:31 <CDB-Man> EVEN WHEN I MANUALLY DEFINE THE ENVIRONMENT VARIABLE WITH THE KEY, IT DOESN'T PICKUP ON IT
13:57:34 <CDB-Man> whoops caps lock
15:06:33 *** jervin has joined #gnucash
16:04:54 *** sunyibo has joined #gnucash
16:04:54 *** ChanServ sets mode: +v sunyibo
16:14:23 <jralls> CDB-Man, https://github.com/finance-quote/finance-quote/issues/318
16:15:09 <jralls> Not sure what's going on with your api key. What update script do you mean?
16:25:17 *** gandalf has quit IRC
16:36:39 *** jervin has quit IRC
16:54:38 <CDB-Man> on the windows package, there's a start menu shrotcut called "Install Online Price Retrieval for GnuCash"
16:55:06 <CDB-Man> it does 2 things when run: install/update the FQ package, install/update any dependencies in strawberry perl
16:55:45 <CDB-Man> * Check Perl
16:55:45 <CDB-Man> * Check Perl version
16:55:45 <CDB-Man> * Install required perl modules
16:55:45 <CDB-Man> Database was generated on Sun, 16 Jul 2023 17:42:23 GMT
16:55:45 <CDB-Man> Test2 is up to date (1.302195).
16:55:47 <CDB-Man> Finance::Quote is up to date (1.57).
16:55:51 <CDB-Man> JSON::Parse is up to date (0.62).
16:55:54 <CDB-Man> * Check environment variable ALPHAVANTAGE_API_KEY
16:55:56 <CDB-Man> ***
16:55:58 <CDB-Man> *** You need an API key (from https://www.alphavantage.co)
16:56:00 <CDB-Man> *** to run the Perl module Finance::Quote.
16:56:02 <CDB-Man> ***
16:56:05 <CDB-Man> *** Make it available to GnuCash by
16:56:07 <CDB-Man> *** - setting the environment variable ALPHAVANTAGE_API_KEY or
16:56:09 <CDB-Man> *** - starting GnuCash and adding the Alpha Vantage api key in
16:56:11 <CDB-Man> *** Edit->Preferences->Online Quotes
16:56:13 <CDB-Man> ***
16:56:16 <CDB-Man> * Installation succeeded
16:56:18 <CDB-Man> Press any key to continue . . .
16:56:22 <CDB-Man> t====
16:56:24 <CDB-Man> that's the console output
16:56:28 <CDB-Man> unless my key expired? i thought they did not, unless that chagned
16:57:38 <CDB-Man> [2023.07.16 16:14:23] <jralls> CDB-Man, https://github.com/finance-quote/finance-quote/issues/318 <-- yep that's it, followed the ticket, thanks
17:00:22 <Simon> I assume the variable will not be set when you run that, if it's in the GnuCash settings
17:00:48 <CDB-Man> the 2nd option right there says it reads it off gnucash...
17:01:03 <Simon> no, it implies the quote retrieval will do that
17:01:06 <CDB-Man> and it's always worked this way for the past 7 years, so something must have changed recently
17:01:07 <Simon> it does not mean the script can do that
17:01:22 <CDB-Man> the script always calls quote retrieval as a test as part of the script
17:01:45 <CDB-Man> this is the first time the script's call of quote retrieval test failed with this messag
17:01:55 <CDB-Man> eusually my console prints "test successful" or some version of that
17:05:22 <CDB-Man> jralls: confirming the quick fix in the FQ ticket works
17:10:01 *** fell has quit IRC
17:20:38 *** fell has joined #gnucash
17:20:38 *** ChanServ sets mode: +o fell
18:15:35 <jralls> CDB-Man, not only do they not expire, they're largely bogus. You can pass just about any ASCII string and as long as you're not trying to access a premium service Alphavantage will do your bidding.
18:15:45 <CDB-Man> heh
18:16:00 <CDB-Man> so, should i go get a new key and try again? or you think it's a different issue
18:21:16 <jralls> If there's an issue it isn't that you need a new key. It's probably about the CMD script disagreeing with you about the environment variable.
18:23:19 <jralls> Or maybe that I broke it when I took out the checks for gnc-fq-check and gnc-fq-helper.
18:24:04 <jralls> https://github.com/Gnucash/gnucash-on-windows/commit/71b2988dd814e214950ad65e2181f0f579a72a31
18:29:15 <CDB-Man> Well, FWIW, I mentioned earlier I added the environment variable for the key and it still gave the same error
18:30:12 <CDB-Man> That commit of yours was back in March, but I only noticed the issue in this week's nightly
18:30:18 <CDB-Man> I download a new nightly every week
18:30:22 <CDB-Man> And run the script every week
18:31:37 <jralls> That's the latest commit to that script.
18:32:26 <CDB-Man> Hmm, well then, what should I do next?
18:33:25 <jralls> Ignore the problem. It looks to me like that bit of script doesn't do anything anyway except unconditionally echo what you pasted here.
18:33:47 <CDB-Man> Interesting
18:34:04 <jralls> There's only one line of actual code in that section and it doesn't do anything: if not [%ALPHAVANTAGE_API_KEY%] == [] set "done=(done) "
18:34:07 <CDB-Man> Well before, it would definitely pay the fq check and confirm that it went on
18:34:09 <CDB-Man> Ok*
18:34:29 <jralls> pay?
18:34:40 <CDB-Man> Display*
18:35:58 <CDB-Man> I see in the commit you test ping Amazon, and that result was printing before
18:37:28 <jralls> Well, before that commit it would run gnc-fq-check and (alphavantage "AMZN") | perl -w gnc-fq-helper, but those got removed in GnuCash 5.0 so I removed the section.
18:38:42 <jralls> That's what that last commit does. I guess I could run `gnucash-cli -Q info` and `gnucash-cli -Q dump alphavantage AMZN` so that it would make output.
18:48:52 *** chris has joined #gnucash
18:48:52 *** ChanServ sets mode: +v chris
18:48:57 *** gncbot sets mode: +o chris
18:49:34 *** cproo13 has joined #gnucash
18:49:34 *** ChanServ sets mode: +v cproo13
18:51:32 *** sunyibo has quit IRC
19:16:43 *** cproo13 has quit IRC
19:47:31 *** jervin has joined #gnucash
20:09:56 *** chris has quit IRC
20:18:19 *** chris has joined #gnucash
20:18:19 *** ChanServ sets mode: +v chris
20:18:23 *** gncbot sets mode: +o chris
20:34:54 *** cproo13 has joined #gnucash
20:34:54 *** ChanServ sets mode: +v cproo13
20:49:21 *** chris has quit IRC
20:56:14 *** chris has joined #gnucash
20:56:14 *** ChanServ sets mode: +v chris
20:56:18 *** gncbot sets mode: +o chris
21:20:11 *** jervin has quit IRC
21:36:59 *** chris has quit IRC
22:38:42 *** palerider has joined #gnucash
22:41:27 *** sunyibo has joined #gnucash
22:41:27 *** ChanServ sets mode: +v sunyibo
23:55:46 <sunyibo> How would I make bonds show that they are worth more after a while because of interest?