Re: [GNC] Budget-like Balance Sheet Report

2024-05-24 Thread Geoff
Hi Julian Try the Balance Sheet Multicolumn report. It has options for Monthly or Yearly balances. Regards Geoff = On 23/05/2024 1:47 am, Who The Hell Knows wrote: I'm looking for a balance sheet report similar in format to the budget report but instead of the net debit/credit per

Re: [GNC] Simultaneous access

2024-05-15 Thread Geoff
ach of those client machines. > Can I do this simultaneously? No, GnuCash is designed for exclusive single user access only. Regards Geoff = On 16/05/2024 8:02 am, Chris Miller wrote: Hi Folks, Can I store my GnuCash "books" on a server, or a NAS, and do my bookkeeping from any of

[GNC] Thank You Michael D Novack

2024-05-07 Thread Geoff
seemingly abstract concepts back to physical objects like paper ledgers and the ink entries therein. Thanks again for sharing. :--)) Regards Geoff = On 6/05/2024 12:44 am, Michael or Penny Novack wrote: On 5/4/2024 10:53 PM, flywire wrote: David, the  guide even warns that accounting debits

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread Geoff
Ctrl-F) functionality. Hope this helps. Regards Geoff = P.S. Thank you for supporting charities - it makes the world a better place! On 29/04/2024 11:26 am, hh8...@gmail.com wrote: Hi, This means a sub category for each charity. Now, if we have c categories and t tags, in Quicken we'd h

Re: [GNC] The equivalent for Quicken Tag

2024-04-28 Thread Geoff
Hi HH There are several solutions to this scenario, here is one using the chart of accounts. EXPENSES --AUTOMOBILE FUEL REPAIRS --DONATIONS CHARITY01 CHARITY02 CHARITY03 --EDUCATION BOOKS FEES etc etc Hope this helps. Regards Geoff = On 29/04/2024 11:03

Re: [GNC] Identify error transaction in QIF import

2024-04-28 Thread Geoff
Hello HH Please read this: https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html Regards Geoff = On 28/04/2024 9:43 pm, hh8...@gmail.com wrote: Hi, Thanks for the advice. I run Quicken -> Validate and Repair File and it reported a few errors that I fi

Re: [GNC] QIF imports fails in 5.6

2024-04-27 Thread Geoff
Hello Nodje Please read this: https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html Regards Geoff = On 27/04/2024 3:21 pm, coolnodje wrote: Hi, QIF imports is failing in 5.6. I had to revert to 5.5 to be able to be able ro import as usual. The error message

Re: [GNC] Is anyone else getting these malicious e-mails?

2024-04-14 Thread Geoff
details to the world at large over the years, resulting in at times an avalanche of dodgy emails. Sign of the times, the only protection is to register a new email address. }8--(( Regards Geoff = P.S. Hope you appreciate the ASCII emojis ;--)) On 15/04/2024 12:57 pm, Michael DeBusk wrote

Re: [GNC] Recording a "price margin code change"

2024-04-14 Thread Geoff
t your overall cost. [I am not an accountant.] Regards Geoff = On 14/04/2024 9:45 pm, Steven N. Severinghaus wrote: As far as I can tell, there were no associated capital gains or losses, fees, or distributions. Frustratingly, the website lists the transactions differently from what shows up

Re: [GNC] Recording a "price margin code change"

2024-04-14 Thread Geoff
or dividend/distribution? Regards Geoff = On 14/04/2024 12:35 pm, Steven N. Severinghaus wrote: Hi, all. I had an odd transaction labeled as a "price margin code change" show up on a brokerage account recently. It appears to represent having "sold" all of my shares at one

Re: [GNC] FYI Web tables, CSV, prices info and inquiry

2024-04-14 Thread Geoff
d) silently read, comprehended, bookmarked, and filed away for possible future use. Thanks for the contribution, keep them coming :--)) Geoff = On 14/04/2024 3:50 pm, sunfish62--- via gnucash-user wrote: David, My goal in the example was not pedagogical; it was to give others

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread Geoff
) Date (4) Price (5) Currency See attached. Regards Geoff = On 11/04/2024 4:41 pm, fromvendor wrote: I've tried Advantech, Motley, and Rowe. All failed (different, but fails for all of them). I put in manual entries for now. Is there a way to import data to the price database? I cou

Re: [GNC] export to csv?

2024-04-09 Thread Geoff
File / Export / Export Active Register to CSV ... Geoff = On 10/04/2024 10:48 am, ToddAndMargo via gnucash-user wrote: Hi All, Fedora 39 gnucash-5.5-6.fc39.x86_64 I would like to do a find, then export to results to a CSV (or other) spreadsheet. How do I do this? Many thanks, -T

Re: [GNC] Import QIF files

2024-04-08 Thread Geoff
/download.phtml (2) Upgrade to the latest nightly build that contains the fix https://code.gnucash.org/builds/ (3) Wait until GnuCash 5.7 is released. Regards Geoff = On 8/04/2024 6:41 am, Beryl Lymer wrote: I have been importing QIF files into GNUcash successfully for several years

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-08 Thread Geoff
I doubt it - I am often prompted for the data format when doing QIF imports. Geoff = On 8/04/2024 6:41 pm, Joseph Keithley wrote: Just out of curiosity is the word "Discover" somehow a protected word, function, directive or key word in the Gnucash code?  Everytime I import m

Re: [GNC] Can I get help with GnuCash here

2024-04-08 Thread Geoff
to the OFX/QFX routines in GnuCash version 5 (https://gnucash.org/news.phtml) - perhaps you could try upgrading to the latest version? *Be sure to take a backup first*. Hopefully someone else on this list can chime in with further suggestions. Regards Geoff = On 8/04/2024 3:10 pm, R7

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-07 Thread Geoff
OR BE SWALLOWED LExpenses:Medical:Insurance ^ == Credit Card === NLiabilities:Credit Cards:GNC Mastercard TBank ^ !Type:Bank D02/03/24 T-12.34 PI NEVER SIT ON A FENCE. L ^ D02/03/24 T-135.79 PI AM EITHER ON ONE SIDE OR ANOTHER. LExpenses:Medical:Surgery ^ === Regards Geoff = On 7/04

Re: [GNC] Can I get help with GnuCash here

2024-04-07 Thread Geoff
noma / ...) * Your version of GnuCash (Help -> About) * Your question / problem And, to paraphrase the former president you quoted, "Do you best, the Internet will do the rest." Regards Geoff = On 8/04/2024 10:56 am, R7 wrote: >I need some help with GnuCash..is t

Re: [GNC] Multi-column reports- sort by acct code?

2024-04-06 Thread Geoff
I don't think so - there is nothing about sorting in the report options. Geoff = On 7/04/2024 4:30 am, Chris Skudder wrote: I usually do multi-column Statements of Activity and Position. I have been using Custom Multicolumn because that sorts in order of Account Code. Is there a way

Re: [GNC] Can't import .qif files from quicken since latest update

2024-04-06 Thread Geoff
rs to have blocked *banking* transactions too? Geoff = On 7/04/2024 11:44 am, Ian Cuthbertson wrote: Bryan This problem seems to be caused by the latest update (5.6) .I import direct from a bank and got the same error message but when I used an earlier version (5.4) transactions imported O

Re: [GNC] ANNOUNCE: GnuCash 5.6 Released

2024-04-02 Thread Geoff
Regards Geoff = On 2/04/2024 11:54 am, Dave parker via gnucash-user wrote: I am pretty new to Gnucash.  Do I need to uninstall and install the newer version?  Is there a link I just click on for the update?  Just don't know. What is the procedure to update to the new version of Gnucash

Re: [GNC] Updating gnucash

2024-03-26 Thread Geoff
Hi Nathan My experience is with Windows 10. Download the new version and it will uninstall the previous version for you. https://wiki.gnucash.org/wiki/Installation#Windows And always take a backup. https://wiki.c2.com/?BackupEarlyBackupOften Regards Geoff = On 25/03/2024 3:37 am

Re: [GNC] Request for help with libgnucash/engine

2024-03-23 Thread Geoff
This may (or may not) be useful: https://github.com/sdementen/piecash Regards Geoff = On 24/03/2024 3:16 am, Mark at Lorimark wrote: Hi Guys, I've started up a project to create a web-interface for GnuCash.  Been tinkering with it for a while now. I was hoping to be able to reach out

Re: [GNC] Share Records When Receivers Appointed

2024-03-01 Thread Geoff
as deferred income against another contingent asset account. Hope this helps. Regards Geoff = On 2/03/2024 3:16 pm, john wrote: I think that's a question for a local licensed tax or accounting professional. It's true that the accounting value of an asset is what you paid for it (modulo

Re: [GNC] Report filter Syntax

2024-02-29 Thread Geoff
ve. Hope this helps. Regards Geoff = On 1/03/2024 5:08 am, Grace wrote: Hi, Can anyone point me in the direction of the syntax for the report filters. I need to select particular transaction from an account, and I don't see any guidance in the help. A google search didn't get me anywhere eith

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

2024-02-22 Thread Geoff
I got it from here: https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/5.5/gnucash-5.5-1.setup.exe/download After being redirected from here: https://gnucash.org/ There's a link for the Windows version in the "Download GnuCash 5.5" panel at the top of the pag

Re: [GNC] gnucash-5.5-1.setup.exe

2024-02-20 Thread Geoff
the reports looked OK and there was no unexpected behaviour. Thanks again Geoff = On 21/02/2024 4:46 pm, John Ralls wrote: Having finally beaten WebKitGtk on Windows into submission so that it runs JavaScript without crashing, at least in my not very extensive tests, I've built a new

Re: [GNC] Popup shows wrong acnt

2024-02-08 Thread Geoff
Fred, I reckon that's a "feature" not a "bug", GnuCash is retaining the history of where you moved that account *from* just in case you decided to move it back again. ;--)) Geoff = On 9/02/2024 11:46 am, Fred Tydeman wrote: OS: Linux GC 4.14 I have some accounts o

Re: [GNC] Receipt scanners and software

2024-01-26 Thread Geoff
ile with a Transaction: https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-assoc.html > I would also like to get barcode access as well. I am afraid that I cannot help you with that. Regards Geoff = On 27/01/2024 3:30 pm, W. Neal Lewis wrote: What receipt scanners and softwa

Re: [GNC] QIF import ignore account

2024-01-20 Thread Geoff
Conjecture - Edge is also the default app for opening XML files on Windows? Repeating the import in debug mode, the trace file contains lots of information, no obvious (to me) error messages, and no mention of Edge: https://bugs.gnucash.org/attachment.cgi?id=374989 Geoff = On 21/01/2024

Re: [GNC] QIF import ignore account

2024-01-20 Thread Geoff
Beats me - apart from being the default Windows browser??? I have run this again in debug mode and lodged a bug report with detailed trace file: https://bugs.gnucash.org/show_bug.cgi?id=799225 Geoff = On 21/01/2024 10:20 am, Adrien Monteleone wrote: Why is Edge involved at all

Re: [GNC] QIF import ignore account

2024-01-20 Thread Geoff
' for package #38 (`Microsoft.MicrosoftEdge.Stable_92.0.902.67_neutral__8wekyb3d8bbwe'): error code 0x2 As I said in my previous reply, when it comes to investment transactions, cut your losses with the QIF Importer and use the CSV Importer instead. It just works. Regards Geoff = P.S. You

Re: [GNC] Windows x64 release builds are missing

2024-01-18 Thread Geoff
rt 32 bit applications (like GnuCash). And Windows 12 is looming, but the rumour mills are not predicting any major architectural changes: https://www.google.com.au/search?q=windows+12 Geoff = On 19/01/2024 8:30 am, John Ralls wrote: An x64 build will work only on 64-bit PCs, a 32-bit b

Re: [GNC] F::Q Interface to GNC for pricing update

2024-01-17 Thread Geoff
Yes, GnuCash / Finance::Quote fetches the "latest" price for each security, there is no provision to retrieve historical prices (although you can enter them manually via the Price Editor, or import them from a CSV file - see attached). Geoff = On 18/01/2024 2:20 pm, Adrien

Re: [GNC] QIF import Failed

2024-01-07 Thread Geoff
Balance' in the 'P' field (POpening Balance). In this case, the brackets need to be left in place, and the account name between the brackets must exactly match the account name in the 'N' field. https://en.wikipedia.org/wiki/Quicken_Interchange_Format Geoff = On 8/01/2024 12:02 pm, Derek

Re: [GNC] QIF import Failed

2024-01-07 Thread Geoff
Hi Fred At a guess I think the problem is the square brackets "[]" surrounding the Account Names - try removing them. This: > L[Expenses:fees] Should be: > LExpenses:fees Regards Geoff = On 7/01/2024 2:01 pm, Fred Tydeman wrote: Running GC 4.14 on Linux During an

Re: [GNC] GnuCash getting worse?

2023-12-28 Thread Geoff
a version of Windows in the Virtual Machine that you create. https://www.virtualbox.org/ Geoff = On 29/12/2023 12:09 pm, Adrien Monteleone wrote: I'm fairly certain you can create a VM of a running instance of Win10 though I can't speak to how that works for licensing. MS does allow some

Re: [GNC] ANNOUNCE: GnuCash 5.5 Released

2023-12-17 Thread Geoff
zombie processes left behind when GnuCash is closed (#799092), and QIF files with "ambiguous" dates are imported correctly. Thanks again for your great work! Geoff = On 18/12/2023 8:45 am, John Ralls wrote: The GnuCash development team announces GnuCash 5.5, the sixth release in

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

2023-12-04 Thread Geoff
Eric, see attached. Try making your screen wider - or maximising it. Regards Geoff = On 5/12/2023 12:29 pm, Eric Chapman wrote: Stan, Could you please take a screenshot of the down arrow you are talking about and attach it? I can't seem to find it. Thanks! Eric On 12/4/23 20:25

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

2023-12-04 Thread Geoff
Eric, you can still do this if you close the books each year: > OK it looks as if it's just as good not to close the books if, e.g., I > might want to run an income statement comparing 2022 and 2023. Be brave! Try it and see for yourself ;--) Regards Geoff = On 5/12/2023 12:07 pm

Re: [GNC] Why or why not to do year-end closing journal entries? (Close Books?)

2023-12-04 Thread Geoff
transactions it generates in the Equity account you nominated, or closing without saving. If you are interested in what other people do, this topic is discussed periodically: https://lists.gnucash.org/pipermail/gnucash-user/2022-January/099274.html Regards Geoff = On 5/12/2023 11:32 am, Eric

Re: [GNC] Finance::Quote upgrade

2023-12-04 Thread Geoff
Hi James You don't need a compiler to install Perl modules like Finance::Quote but you do need a working "make" utility, which is normally included by default. Some troubleshooting information here: https://www.phind.com/search?cache=xbbtjpvwn5ifzh8wmo7htxet Hope this hel

Re: [GNC] Have code run when a new invoice is posted.

2023-09-25 Thread Geoff
FYI AutoHotKey can do that (and much more) on Windows: https://www.autohotkey.com/ Geoff = On 26/09/2023 9:00 am, Adrien Monteleone wrote: On 9/25/23 3:19 PM, Adrien Monteleone wrote: If I'm not mistaken, there is an app listed on 'Using GnuCash' on the wiki that can record and execute

Re: [GNC] Transaction regex help

2023-02-08 Thread Geoff
a series of Searches, remember that you can:- * Refine the results of a previous Search * Add results to the current Search * Delete results from the current Search ) then you can produce a Transaction Report by choosing:- Reports / Account Report. Hope this helps. Regards Geoff = On 8/02/20

Re: [GNC] Importing csv files

2023-01-18 Thread Geoff
Geoff = On 19/01/2023 12:29 pm, rudy beuc wrote: Hello, I'm trying to migrate from Quickbooks to GnuCash. I'd like to keep as much information as I can for record keeping. To that end I've first been trying to import my accounts structure in via a csv file and failing badly. Pre Christmas

Re: [GNC] "Get Quotes" from the price database feedback

2023-01-09 Thread Geoff
Hi Kalpesh > Also is there a way to tell to get limited historical range of days' > worth > of quotes rather than a single day? See this post: https://lists.gnucash.org/pipermail/gnucash-user/2022-December/104498.html Regards Geoff = On 10/01/2023 9:21 am, Kalpesh Patel wrote:

Re: [GNC] Will adding a transaction dated earlier than the last reconciliation cause a problem?

2023-01-07 Thread Geoff
hat you do best - running your business. (Not so long ago this would have been accounted for out of a bucket called "petty cash" and reconciled once every month or so.) Regards Geoff = On 8/01/2023 4:24 am, Dr. David Kirkby wrote: On Sat, 7 Jan 2023 at 14:37, Maf. King wrote:

Re: [GNC] NEw user assistance

2023-01-05 Thread Geoff
Welcome to GnuCash Karl! > Specifically, I am trying to set-up the online pricing list for stock > quotes. Have a read of these topics: https://wiki.gnucash.org/wiki/Stocks/add_stock https://wiki.gnucash.org/wiki/Online_Quotes Regards Geoff = On 6/01/2023 12:30 pm, Karl wrote:

Re: [GNC] How to "Get Quotes" for a specific day?

2022-12-29 Thread Geoff
No. As far as I know the Finance::Quote module that GnuCash uses has no provision to fetch historical prices. If you are into scripting and web scraping, checkout Selenium which has a nice Python interface. Good luck! Geoff = P.S. Always include gnucash-user@gnucash.org on all

Re: [GNC] How to "Get Quotes" for a specific day?

2022-12-29 Thread Geoff
/ Regards Geoff = On 30/12/2022 3:06 pm, gnucash_2...@michaelaltfield.net wrote: How can I tell GNU Cash to update its "Price Database" for all known currencies, stocks, bonds, mutual funds, etc for a *specific* day? I'm trying trying to prepare a report for a date in the past

Re: [GNC] Scrubbing workflow

2022-12-29 Thread Geoff
Correct. You need to scrub each Account separately. Geoff = On 30/12/2022 1:57 pm, m...@tgr66.me wrote: Assuming one creates a separate account to track each stock (for example, “Joint Brokerage:AAPL” and “Joint Brokerage:AMZN” doesn’t a user have to scrub for each symbol? Or am I

Re: [GNC] Scrubbing workflow

2022-12-29 Thread Geoff
sales next time you run it. **The other method is to manually match your sales to your buys one lot at a time. Hope this helps. Regards Geoff = On 30/12/2022 11:00 am, m...@tgr66.me wrote: I searched the mailing list and didn’t really get any hits from the past six years, so I’m s

Re: [GNC] Changing registers in the middle of entering or editing a transaction

2022-12-27 Thread Geoff
I disagree, I find this feature quite useful from time to time. Regards Geoff = On 28/12/2022 12:05 pm, William Prescott wrote: Let me guess: you looked in the other register before you had committed the transaction. Yes, you are probably right That highlights a point about

Re: [GNC] Finance::Quote v1.54 Released

2022-12-26 Thread Geoff
Thank you Bruce! Geoff = On 27/12/2022 2:28 pm, Bruce Schuck wrote: Finance::Quote v1.54 has been released and uploaded to CPAN. https://metacpan.org/release/BPSCHUCK/Finance-Quote-1.54 https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.54.tar.gz https://github.com/finance

Re: [GNC] Seeking report

2022-12-16 Thread Geoff
easy to understand when you run it. Regards Geoff = On 17/12/2022 12:17 pm, R Losey wrote: >I find the reports the hardest part of GnuCash to understand, so I'm >seeking help here... I'm willing to read good, clear documentation, but >someone may be able to point me in the right direc

Re: [GNC] Phishing Website Google Search Ad

2022-12-13 Thread Geoff
Thanks very much Matthew. Regards Geoff = On 14/12/2022 4:25 am, Matthew Ickstadt wrote: I originally wrote and sent this on November 28, but I wasn't subscribed to the mailing list yet so I don't think it went through. Since then I have contacted DigiCert and they have revoked the code

Re: [GNC] Reconciling PayPal

2022-12-13 Thread Geoff
esh the page and download the generated CSV file 8. Tear out whatever remaining hair you have trying to make sense of these 10 columns in the file: Date, Time, Time zone, Name, Type, Status, Currency, Amount, Receipt ID, Balance Good luck! Regards Geoff = On 13/12/2022 6:09 pm, Dr.

Re: [GNC] Installing or updating Finance::Quote

2022-12-09 Thread Geoff
an.org/pod/Finance::Quote Good luck! Regards Geoff = On 10/12/2022 6:01 am, aeg via gnucash-user wrote: Murugan, Thank you for your suggestion.There is no folder named "Finance" at that location, but I searched for quote.pm within Strawberry and found it at each of these loc

Re: [GNC] Net Worth Barchart

2022-12-05 Thread Geoff
Hi Liz I think the other side of that liability entry should be something like "Expenses:Company Tax". Regards Geoff = On 6/12/2022 5:01 pm, Liz wrote: On Tue, 6 Dec 2022 15:40:06 +1100 Chris Grinton wrote: The charts suggest that you have *negative* liabilities. That

Re: [GNC] Stock spinoff

2022-12-03 Thread Geoff
gains/losses crystallised or carried forward? ABC should have sent you information about this, otherwise Google it. You may find this article helpful:- https://www.henssler.com/spin-offs/ Once you have all the details, we can suggest how to record it in GnuCash. Regards Geoff = On 4/12/2022

Re: [GNC] Automatic payments and interest during reconciliation?

2022-10-27 Thread Geoff
Maybe the Google indexing robots are behind with their homework? The post, and Adrian's reply the next day, both show up here: https://lists.gnucash.org/pipermail/gnucash-user/2022-August/thread.html Regards Geoff = On 28/10/2022 3:31 pm, David T. via gnucash-user wrote: Odd. I tried

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-16 Thread Geoff
Ditto, thanks. Geoff = On 17/10/2022 8:35 am, David T. wrote: That works for me! Thanks, John. David T. On Oct 16, 2022, at 10:34 PM, john <mailto:jra...@ceridwen.us>> wrote: I've renamed that page to GnuCash SQL Examples. Regards, John Ralls On Oct

Re: [GNC] Price database

2022-10-16 Thread Geoff
David - good idea! Elmar - please see updated SQL here: https://wiki.gnucash.org/wiki/PostgreSQL-Requests_For_Direct_Database_Access#Extract_prices_and_associated_descriptions Thanks Geoff = On 16/10/2022 5:50 pm, David T. wrote: Geoff, Good advice/help! I do think it would be necessary

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-15 Thread Geoff
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

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-15 Thread Geoff
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

Re: [GNC] Printing problem

2022-10-14 Thread Geoff
Welcome to the wonderful world of GnuCash! Since you are just starting out, please use the latest and greatest version (4.12) - 3.4 is about 4 years old. Regards Geoff = On 14/10/2022 7:33 am, Lester and Joanna wrote:  I am a newbie with Gnucash.  I have been using Quicken for 12

Re: [GNC] transaction images and failed hard drives

2022-10-14 Thread Geoff
luck Geoff = On 14/10/2022 5:24 pm, Jeff wrote: I know that this question has been asked many times but I am asking again. I just had 2 hard drive failures back to back, both of which just happened to have images attached to GNC transactions.  Bad luck on my part, they also happened

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread Geoff
have a chance:- https://wiki.gnucash.org/wiki/File:Gnc_jb1_Add_Security.jpg https://wiki.gnucash.org/wiki/File:Gnc_jb2_Link_Account_to_Security.jpg Thanks Geoff = On 12/10/2022 1:52 am, David T. wrote: Here are a few images for the page. I don't have upload capability. I am also including

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread Geoff
Well David, I am happy to defer to your experience, however the screenshots contain GnuCash labels in the same language, so I am not sure how that works? I'll clean them up this week. Stay tuned. Geoff = On 11/10/2022 10:02 pm, David T. wrote: GnuCash is a multilingual application

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread Geoff
text is a bit loud, and could be toned down as "captions". Coincidentally, they are the only text you can actually read unaided when viewing on a phone. I'll keep this in mind for the next one. Thanks once again. Regards Geoff = ** Yes I know that not everyone agrees with t

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread Geoff
a single, wide image makes it easier to follow the workflow and see the complete story in one glance. But, hey, it's a Wiki. I'm sure that the next person who comes along (average edits are ~4 years apart) will have different views again. Thanks again for the review. Regards Geoff = O

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread Geoff
at the Help, however the requirements to edit it are rather daunting, so I am starting my very modest contributions in the Wiki. Regards Geoff = On 11/10/2022 6:33 pm, David T. wrote: Geoff, As it's a wiki, you just go for it. I was going to do just that, because your image width causes

[GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-10 Thread Geoff
rg/wiki/Stocks/add_stock https://wiki.gnucash.org/wiki/Using_GnuCash This is my first Wiki update - is there a peer review process, or do we just go for it? :--)) Thanks Geoff = ___ gnucash-user mailing list gnucash-user@gnucash.org To

Re: [GNC] How to include images in the Wiki?

2022-10-10 Thread Geoff
, for the following reason: The action you have requested is limited to users in one of the groups: Administrators, uploadaccess. So, how do I go about obtaining "uploadaccess", or finding a friendly and patient Administrator to upload images on my behalf? Thanks Geoff = On 11/10/202

[GNC] How to include images in the Wiki?

2022-10-10 Thread Geoff
//wiki.gnucash.org/wiki/Stocks/add_stock But I can't figure out how to upload an image that I can link to. Does anyone know how to do this? Or do I need to host images on a third party site? If so, can anyone recommend one? Thanks Geoff = ___ gnu

Re: [GNC] Stock/tickers

2022-10-10 Thread Geoff
You are welcome James. Have a great day. Regards Geoff = On 11/10/2022 1:59 am, James Baxter wrote: Geoff. I don't know if I can thanks you enough. Also David Carlson was in here as well. I have 12 pices of Stock/tickers in Gnucash. I enter each into the stock, But I am finding that I

Re: [GNC] Price update changed from Alpha Vantage to Yahoo as JSON

2022-10-10 Thread Geoff
Woo hoo! Thanks for confirming. Regards Geoff = On 10/10/2022 6:04 pm, Ismael Smajli wrote: I have changed the 'Quote Source Information' for all of my securities (22 securities) from 'Alpha Vantage' to 'Yahoo as Jason'. Result: Duration for price update reduced from 5 minutes

Re: [GNC] Price update not working - Alpha Vantage's limit is five (5) API requests per one (1) minute

2022-10-10 Thread Geoff
Thanks for letting us know Ismael. Richard - this looks like the explanation for the delays you are seeing. Alpha Vantage are gently tightening the screws on their free service... Geoff = On 10/10/2022 4:50 pm, Ismael Smajli wrote: Hello Alpha Vantage's standard API usage is limited

Re: [GNC] Price update not working

2022-10-09 Thread Geoff
securities, and this will eliminate Alpha Vantage as the cause, although if gnc-fq-dump is fast then this is unlikely to make a difference. As a last resort, you can try running GnuCash in debug mode and see if anything useful emerges. I don't know how to do this, but Google is probably your friend. Good lu

Re: [GNC] stocks/tickers

2022-10-09 Thread Geoff
for some reason your allotted time has expired, and no further correspondence will be entered into. kindest regards, Geoff = P.S. Your email address reminds me to recommend for your leisure time (if you can snatch an hour or so away from being enthralled with GnuCash) the film "Kan

Re: [GNC] Price update not working

2022-10-08 Thread Geoff
d luck! Regards Geoff = On 8/10/2022 6:29 pm, R Losey wrote: Hi... yes, I did not have al ALPHAVANTAGE_API_KEY and that was the issue. Things now seem to be updating properly. It is supposed to take so long? There is a long (7 minute) delay before the update finishes... I've been using the gnuca

Re: [GNC] Price update not working

2022-10-08 Thread Geoff
:- https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz Hope this helps. Regards Geoff = On 8/10/2022 4:58 pm, R Losey wrote: I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8

Re: [GNC] CSV transaction import settings

2022-10-06 Thread Geoff
, on Linux you will need to find that file using something like this: sudo find / -name {BOOK_NAME}.gnucash.gcm -print Hope this helps. Regards Geoff = On 7/10/2022 12:49 am, David Carlson wrote: Where are the settings stored? I thought I copied all the GnuCash stuff from one computer to another

Re: [GNC] Fwd: Price Source "Last up through Report Date" issue

2022-09-26 Thread Geoff
of the day to test this conjecture. Regards Geoff = On 27/09/2022 2:17 pm, David Carlson wrote: This is odd. While prices that were picked by GnuCash for the Tuesday, May 31 dated account balance sheet report were actually the last prices in the data before May 31, possibly several days

Re: [GNC] Finance::Quote in GC 4.11 Flatpak

2022-09-26 Thread Geoff
! Geoff = On 27/09/2022 1:43 am, rsbrux via gnucash-user wrote: I have installed my free AlphaVantage API key in /etc/environment, but when I try to "Get Quotes", I get the well-known message "Unable to retrieve quotes for these items:, CURRENCY: ...". I presume that this i

Re: [GNC] Expense chart matching description

2022-09-24 Thread Geoff
Hi Rares Sadly, no. That report permits you to select which Accounts to include, but does not allow you to filter the Transactions in those Accounts. Regards Geoff = On 24/09/2022 9:25 am, Rares Vernica wrote: Hello, Is it possible to get an Expense Bar Chart of transactions

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread Geoff
generated a 100MB log file before I terminated the process. This is a long shot, but you could try saving the report with hard coded dates to see if that makes any difference. Regards Geoff = On 21/09/2022 9:39 pm, William Starrs wrote: That's exactly what I was doing, hence this thr

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread Geoff
ultiple Balance Sheet reports, I had to specify the report name using its GUID as I encountered an error when I used: -R run --name "Balance Sheet", however the error message kindly gave me the GUID. Hope this helps. Regards Geoff = On 21/09/2022 8:48 pm, William Starrs wrote:

Re: [GNC] Date error running report from gnucash-cli, report runs fine in GUI

2022-09-21 Thread Geoff
are au courant with Python you could probably achieve a transaction list for a custom date range fairly easily using PieCash: https://github.com/sdementen/piecash Good luck! Regards Geoff = On 21/09/2022 9:38 am, William Starrs wrote: Update: I tried also setting a fixed Start Date

Re: [GNC] new to Gnucash - help with general information

2022-09-11 Thread Geoff
You make a good point Fred, and I have seen people on this list who keep their GnuCash data in the cloud too. Although this changes the risk profile, it does not eliminate the need for a backup system. Regards Geoff = On 12/09/2022 5:07 am, Fred Bone wrote: On 11 September 2022 at 9

Re: [GNC] More UI downgrades

2022-09-10 Thread Geoff
, as you observed, SPACE will select / deselect the current transaction, but not move to the next transaction. As Gyle mentioned, using Ctrl-A and SPACE makes for a very speedy reconciliation. Regards Geoff = On 11/09/2022 12:43 am, Russell Gadd wrote: It seems every time I upgrade

Re: [GNC] Change Linked Document Path

2022-09-03 Thread Geoff Storer
Docs". Q: What do the preferences say now? Ans: As per "linked files" screenshot "Path Head for linked files Relative Path" with option "GNU Invoices" (the name of my invoices folder) Q: What version of GnuCash are you using? Ans: I am using ver 4.11 Build

Re: [GNC] gnucash reconcile doesn't respect "Decimal places"

2022-09-02 Thread Geoff
That is not my experience with version 4.8 on Windows 10 - see attached screenshot. Regards Geoff = On 2/09/2022 10:42 pm, rsbrux via gnucash-user wrote: In version 3.11 running under Windows 10 21H2, the reconcile window only displays non-zero figures after the decimal point

Re: [GNC] Display report values in whole curremcy units

2022-09-02 Thread Geoff
Hi Richard No, nothing has changed since you last asked this question: https://lists.gnucash.org/pipermail/gnucash-user/2019-January/082136.html Regards Geoff = On 2/09/2022 3:43 pm, Richard Gaede via gnucash-user wrote: I would like to be able to print reports which display numbers

Re: [GNC] Change Linked Document Path

2022-09-01 Thread Geoff Storer
Ok, thanks. This is my first post!! On Fri, Sep 2, 2022 at 8:16 AM Jim DeLaHunt wrote: > Geoff: > > One tenet of GnuCash-user email list etiquette is to cc the gnucash-user > email list on all replies. We want this discussion to take place on the > list. > > Thus

Re: [GNC] Online quotes for a mutual fund

2022-09-01 Thread Geoff
://www.londonstockexchange.com/stock/TR29/united-kingdom/company-page However none of the Finance Quote modules currently use the LSX as a data source. Regards Geoff = On 24/08/2022 6:59 pm, Ruaraidh Sackville Hamilton wrote: Finding the right source and symbol seems a challenge

Re: [GNC] Saving Gnucash data and back ups

2022-08-16 Thread Geoff
an overview: https://www.computerworld.com/article/3658132/how-to-use-file-history-windows-10-windows-11.html Regards Geoff = On 17/08/2022 11:00 am, Adrien Monteleone wrote: On 8/16/22 1:33 PM, dsamo...@shaw.ca wrote: I am new to Gnucash and have a few questions regarding saving data.  I

Re: [GNC] AutoHotKey: Date Arithmetic Example

2022-08-14 Thread Geoff
Nice work Glenn! (I still think AutoHotKey would have been a better choice than KeePass for your keystroke automation though.) I wasn't aware of UI.Vision - looks interesting, thanks for sharing. Regards Geoff = On 15/08/2022 1:00 pm, Glenn Fowler wrote: Hi, Automating the GUI

[GNC] AutoHotKey: Date Arithmetic Example

2022-08-14 Thread Geoff
Google) Raku: https://raku.land/github:azawawi/Selenium::WebDriver Hope this helps. Regards Geoff = On 15/08/2022 12:50 am, Tom Browder wrote: On Sun, Aug 14, 2022 at 00:40 Geoff <mailto:cleanoutmys...@gmail.com>> wrote: Hi Jim I don't have any experience manipulating Gn

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-13 Thread Geoff
/?platform=linux Hope this helps. Regards Geoff = On 14/08/2022 11:28 am, Jim DeLaHunt wrote: Hello, folks: I am a long-time GnuCash user, and for all those years I have pretty much not attempted to track my investments in GnuCash. But now I want to start.  My first goal is to import

  1   2   3   >