Re: [GNC] Finance quote troubleshooting

2020-09-12 Thread Geoff
Windows 10 Professional) you could use a Windows 10 Sandbox to do a clean installation of both GnuCash and Perl to try and further isolate the cause of the problem. https://www.howtogeek.com/399290/how-to-use-windows-10s-new-sandbox-to-safely-test-apps/ Good luck! Geoff = P.S. What

Re: [GNC] Finance quote troubleshooting

2020-09-13 Thread Geoff
Great detective work Andreas! And thanks for sharing your solution. I hope the rest of your Gnucash voyage is plain sailing. Regards Geoff = On 13/09/2020 9:27 pm, Andreas Vyrides wrote: Dear Geoff and Ralls, I would like to let you know that I have finally realised and fixed

Re: [GNC] Finance quote troubleshooting

2020-09-11 Thread Geoff
related currency problem on Windows: http://gnucash.1415818.n4.nabble.com/GNC-Difficulty-with-online-price-retrieval-John-Ralls-tc4720222.html Regards Geoff = On 12/09/2020 7:34 am, Andreas Vyrides wrote: Dear Mr Ralls, It turn out you were able to correctly identify the issue for me since

Re: [GNC] ASX quotes not working

2020-10-14 Thread Geoff
Hmmm. I can't reproduce your problem. What version of perl are you running please John? > perl -v Thanks Geoff = On 15/10/2020 4:09 pm, John Bonnett wrote: Hi Geoff, I had an error in naming the file. I had a space between the "X" and the "."! After fixing

Re: [GNC] ASX quotes not working

2020-10-14 Thread Geoff
to "ASX.pm"? Please see attached screenshot of what the Finance::Quote directory should look like - and do send a copy of yours if you can't get it working. Regards Geoff = On 15/10/2020 12:40 pm, John Bonnett wrote: Hi Geoff, Tried your instructions but got an error when I tried to

Re: [GNC] ASX quotes not working

2020-10-13 Thread Geoff
ded currency: AUD <=== required last: 36.1 <=\ nav: <=== one of these price: 36.1 <=/ timezone: <=== optional Hope this helps. Regards Geoff = On 13/10/2020 9:16 pm, dull...@gmail.com w

Re: [GNC] ASX quotes not working

2020-10-13 Thread Geoff
://www.google.com.au/search?q=perl+finance+quote Geoff = On 13/10/2020 9:16 pm, dull...@gmail.com wrote: Okay I see this is reported here: https://github.com/finance-quote/finance-quote/issues/166 -Original Message- From: gnucash-user On Behalf Of wrd2093au Sent: Tuesday, 13 O

Re: [GNC] ASX quotes not working

2020-10-16 Thread Geoff
Thanks for confirming John. Fingers crossed the ASX don't make any more changes to their web site for another decade ;--) Geoff = On 17/10/2020 3:31 pm, John Bonnett wrote: Hi Geoff, Thanks for all your effort too, the least I can do is try to help you with good feedback. Incidentally

Re: [GNC] More Fun with Lots

2020-08-25 Thread Geoff
ain/Loss" transactions in the register. Replace the default description with some details of the Sale (eg cut and paste the description from the Sale transaction). DELETE the "Orphaned Gains-XXX" account and move its transactions to your regular Capital Gains / Losses accounts.

Re: [GNC] Difficulty with online price retrieval

2020-08-26 Thread Geoff
Hi Samantha I see nothing wrong there - the SET command does not return any output. Please try the 3rd command - it should show you your key: echo %ALPHAVANTAGE_API_KEY% Thanks Geoff = On 26/08/2020 8:10 pm, Samantha Payn wrote: Hi Geoff Thank you for this. For some reason I encounter

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
erences / Accounts" and telling us what your Default Currency setting is please? See attached screenshot for my settings - DO NOT change yours to mine. Thanks Geoff = <<< Feeel free to tell me to butt out if this isn't helpful >>> On 25/08/2020 8:04 am, John Ralls wro

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
;EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' I have attached a screenshot of the same commands on my Windows 10 PC. Fingers crossed they work on yours! Thanks for your patience. Geoff = On 25/08/2020 8:44 pm, Samantha Payn wrote: Hi Geoff My locale currency

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
o knock up some instructions for you tomorrow. Stay tuned. Geoff = On 25/08/2020 9:24 pm, Samantha Payn wrote: Hi Geoff Thanks for your suggestoins. This is what I get: PS C:\Users\User> $Env:ALPHAVANTAGE_API_KEY = 'mykey' PS C:\Users\User> echo '(currency "USD" "GBP&qu

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
Thanks John, I'll try and get Samantha's perl installation sorted out, then we will see if she still has a problem with exchange rates. Geoff = On 26/08/2020 2:33 am, John Ralls wrote: On Aug 25, 2020, at 1:42 AM, Geoff wrote: <<< Please excuse me for jumping in late on th

Re: [GNC] Difficulty with online price retrieval

2020-08-26 Thread Geoff
Woo hoo! I couldn't have resolved this without John's groundwork. Enjoy your day. Regards Geoff = On 26/08/2020 8:49 pm, Samantha Payn wrote: HURRAH! Thank you so much Geoff and John for your patience while I struggled with this. Geoff seems to have found the solution and I am

Re: [GNC] recognition of unrealized gains

2020-08-18 Thread Geoff
attached copies of each of these reports for you. (5) can one control the presentation? All gnucash reports can be customised to some extent. Suggested reading: https://www.gnucash.org/docs/v4/C/gnucash-guide/ch_reports.html Hope this helps. Geoff = <http://gnucash.1415818.n4.nabble.com/f

Re: [GNC] Missing income line within Income Statement (Multicolumn)

2020-08-18 Thread Geoff
Insufficient information to diagnose properly, however the usual reasons for reports not matching account balances are: Date Ranges - are the missing transactions inside the report's period? Account Selection - have you added any sub-accounts since you saved the report? Geoff = -- Sent

Re: [GNC] Get quote - online price retrieval

2020-08-16 Thread Geoff
Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA.pm Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA_UnitTrusts.pm Appending installation info to C:\Strawberry\perl\lib/perllocal.pod ECOCODE/Finance-Quote-1.49.tar.gz C:\Strawberry\c\bin\gmake.exe install UNINST=1 -- OK C:\P

Re: [GNC] clip board paste across catagories

2020-09-30 Thread Geoff
No worries Todd. Have a look at the second last post on this thread where I included a working CSV file and matching screenshots of the import process: http://gnucash.1415818.n4.nabble.com/GNC-Tracking-cash-flows-with-balanced-transactions-tc4721056.html Good luck. Geoff = On 30/09/2020

Re: [GNC] Import transactions

2020-09-23 Thread Geoff
useful technique is to *export* some similar transactions to CSV, examine the structure of the CSV file produced by Gnucash, then try and import that file. Hope this helps. Regards Geoff = On 23/09/2020 12:39 pm, Michael Middleton wrote: I need to import bank data csv into Gnucash

Re: [GNC] Register columns: The balance column is no longer visible

2020-09-24 Thread Geoff
That's disappointing news John, I thought we had nailed this one. Would you mind sending through a couple of screenshots please? Thanks Geoff = On 24/09/2020 7:17 pm, John Mansfield wrote: Geoff, thank you so much for taking the time in providing a detailed resolution. However, having

Re: [GNC] How to upgrade from 3.8 to 4.1 on Win10?

2020-09-17 Thread Geoff
Hi Fran I recently upgraded from 3.6 to 4.1 on Windows 10 without any issues. In the event of any problems, you can always revert to 3.8 as long as you have a clean backup of your data. Good luck. Geoff = On 18/09/2020 7:36 am, Fran_3 via gnucash-user wrote: Just now getting around

Re: [GNC] How to upgrade from 3.8 to 4.1 on Win10?

2020-09-17 Thread Geoff
it for me - see attached screenshot. I guess this rules out simultaneous versions, at least on Windows. Geoff = On 18/09/2020 9:36 am, Fran_3 wrote: Did you remove 3.8 first or did the 4.1 upgrade see that you were running 3.8 and automatically do everything? Or can you have two simultaneous

Re: [GNC] 8.1.1. Find Transaction

2020-10-03 Thread Geoff
expressions. Best $60 I ever spent. Regular expressions can be a *huge* time saver. I'll add a GnuCash RegEx overview to my To Do list. But don't hold your breath, that list is a long one ;--) Regards Geoff = On 3/10/2020 1:15 pm, David Carlson wrote: There you are, I graduated college

Re: [GNC] ASX price lookup failing

2020-10-22 Thread Geoff
Hi Mark See this thread: http://gnucash.1415818.n4.nabble.com/GNC-ASX-quotes-not-working-tc4722167.html Temporary fix attached towards the end. Regards Geoff = On 21/10/2020 4:45 pm, Mark Walters wrote: Hi, Is anyone else having trouble with price lookups to the Australian stock

Re: [GNC] Simple reporting help

2020-10-26 Thread Geoff
Sorting tab. You should get the subtotals at the start of the report, followed by all the transactions. See attached screenshot. Hope this helps. Regards Geoff = On 26/10/2020 8:39 pm, Michelle wrote: Apologies for a newbie question. I've been using GnuCash for many years but I do little repor

Re: [GNC] Help with Column that Vanished

2020-11-30 Thread Geoff
Good luck! Geoff = On 30/11/2020 8:20 pm, Adrien Monteleone wrote: First, the Description column is *not* fixed. (more to follow) Second, when sizing columns, you can only adjust using the right-side header divider. So hover near the right side of where the Withdrawal column should be, clic

Re: [GNC] Help

2020-12-21 Thread Geoff
an appropriate date. Further details here: https://cvs.gnucash.org/docs/C/gnucash-guide/txns-puttoget1.html Regards Geoff = On 22/12/2020 3:43 am, Brian Gardner wrote: I have just had the system installed for me and I have managed to get all the accounts that I have used in my financial

Re: [GNC] Fwd: Smaller backup files: Time division, Since or Incremental?

2020-12-21 Thread Geoff
Not to my knowledge. Out of interest, how big is your XML file currently, and is it compressed or uncompressed? Edit / Preferences / General / Compress files. Thanks Geoff = On 22/12/2020 3:28 am, David G. Pickett via gnucash-user wrote: Are there options to not replicate the full

Re: [GNC] ASX quotes not working again?

2020-12-20 Thread Geoff
It also updates the price database - GnuCash 4.1 on Windows 10. I am time poor, but I hope to do a proper documented release of this next year. Regards Geoff = On 21/12/2020 12:00 pm, dull...@gmail.com wrote: I note Australian stock exchange quotes are failing again. I had a fix fro

Re: [GNC] Fwd: Smaller backup files: Time division, Since or Incremental?

2020-12-21 Thread Geoff
Have you considered only backing up the log files then? They are your incrementals... https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html Geoff = On 21/12/2020 1:28 pm, David G. Pickett wrote: Forwarded Message Subject: Smaller backup files: Time

Re: [GNC] Fwd: Smaller backup files: Time division, Since or Incremental?

2020-12-22 Thread Geoff
ash/ubuntu-DGPickett.gnucash Or, that file plus the transaction log files (which are much much smaller as they only contain the transactions you have entered in a session). Regards Geoff = On 23/12/2020 12:51 am, David G. Pickett wrote: I am sure my daily stock quotes do not help (also very

Re: [GNC] Price retrieval

2020-11-09 Thread Geoff
ram Files (x86)\gnucash\bin>perl gnc-fq-dump yahoo_json IBM Finance::Quote fields Gnucash uses: symbol: IBM <=== required date: 11/10/2020 <=== recommended currency: USD <=== required last: 115.53 <=\ n

Re: [GNC] How to treat accommodation security deposit

2020-11-22 Thread Geoff
Hi Tony I'm not an accountant, but I would treat it as an asset thus: Payment Assets:Bank: -1,600 Assets:Bond: +1,000 Expenses:Rent: +600 Refund Assets:Bank: +1,000 Assets:Bond: -1,000 The first transaction (Payment) is a "split" - it has 3 legs. Regards Geoff = On 22/11/20

Re: [GNC] GST: how to

2020-11-22 Thread Geoff
Welcome to GnuCash Lokesh There are some nice write ups on how to handle GST here: https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS https://www.gnucash.org/docs/v4/C/gnucash-guide/bus_setup.html https://wiki.gnucash.org/wiki/Alternate_Australian_GST_setup Good luck. Regards Geoff

Re: [GNC] Newby questions opening accounts

2021-01-15 Thread Geoff
mn heading, by: Account Code, Name, Description, or even Notes P.S. To expose / hide columns, click on the triangle on the far right side of the column headings. Some of the reports have sorting options too. Hope this helps. Regards Geoff = On 16/01/2021 4:53 pm, Peter S. Shenkin wrote: Hi I'v

Re: [GNC] Capital gains reporting - Australia

2021-01-18 Thread Geoff
le the results to be calculated properly in Excel. Do let us know if you find a better solution. Good luck. Geoff = P.S. The ATO uses Contract dates not Settlement dates for CGT reporting: https://www.ato.gov.au/General/Capital-gains-tax/Selling-an-asset-and-other-CGT-events/Time-of-the-CGT-

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Geoff
. Screenshot #1 attached shows an example where "BHP" is the old security, and "CBA" is the new security. Hope this helps. Geoff = On 22/01/2021 6:08 pm, Peter Lamb via gnucash-user wrote: I own some Exchange Traded Fund stocks, and one of the stocks has been restr

Re: [GNC] Configuring Automatic Retrieval Quotes error

2021-01-17 Thread Geoff
gram Files (x86)\gnucash\bin\" directory) to install the perl modules required to retrieve online quotes. [Background: GnuCash relies on another free software package (perl) to access online quotes. Perl is not part of GnuCash.] Report back here if you get stuck. Regards Geoff =

Re: [GNC] New scheduled transaction--error message--I'm stumped

2021-01-29 Thread Geoff
a Name Click on the "Template Transaction" tab Enter the details per the attached screenshot. Click on OK Regards Geoff = On 30/01/2021 10:27 am, randix wrote: So I'm running Windows 10 Pro, GnuCash Version: 4.4 Build ID: 4.4+(2020-12-28). I've used the scheduled transaction f

Re: [GNC] find and replace

2021-01-30 Thread Geoff
to tick the "Multi-split" option, see attached). Good luck. Geoff = On 31/01/2021 7:40 am, Derek Atkins wrote: Hi, On Sat, January 30, 2021 2:13 pm, gnu Gord wrote: Is it possible to find a specific split transaction based on the memo field and assign the account to transfer for that

Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-08 Thread Geoff
I'll leave that to the experts. Regards Geoff = On 9/06/2021 11:34 am, Christopher Lam wrote: Hi Geoff On Wed, 9 Jun 2021, 9:27 am Geoff, <mailto:cleanoutmys...@gmail.com>> wrote: Gnucash will permit you to run a negative balance on a stock, see attached screenshot. The UI will

Re: [GNC] Enable Online Stock Price Updating in GnuCash

2021-06-07 Thread Geoff
erl script. (4) Wait patiently, it takes a long time! See attached screenshot for details. Hope this helps. Regards Geoff = On 4/06/2021 2:37 pm, Jai Rao wrote: Sir / Madam, I am trying to enable Online Stock Price Updating in GnuCash - (in Windows 10). * I have installed Strawbe

Re: [GNC] multi-split CSV import

2021-05-14 Thread Geoff
Hi Mike Yes, this is easy to do. Please see the 5th post in this thread, which includes screenshots and a sample CSV file: http://gnucash.1415818.n4.nabble.com/GNC-Tracking-cash-flows-with-balanced-transactions-td4721056.html Regards Geoff = On 15/05/2021 9:09 am, mike823 wrote

Re: [GNC] Online quotes for a mutual fund

2021-05-16 Thread Geoff
=== required last: 237.96 <=\ nav: 237.96 <=== one of these price: 237.96 <=/ timezone: <=== optional Regards Geoff = On 17/05/2021 7:35 am, Jacob Larsen wrote: Hi I am trying to get online

Re: [GNC] Associate a file with the selected transaction.

2021-05-15 Thread Geoff
Hi David Carlson You may find some useful information in this thread: http://gnucash.1415818.n4.nabble.com/GNC-multiple-attachments-td4724034.html Regards Geoff = On 16/05/2021 9:37 am, David Carlson wrote: David H, I cannot find any help for that setting either. Is that mandatory

Re: [GNC] Proposed: "Realized Gain/Loss" transactions considered harmful

2021-05-25 Thread Geoff
s just my 20 cents (I am not an accountant), let's see what others think. Regards Geoff = On 25/05/2021 12:02 pm, peterb wrote: Hi. I've been thinking a lot over the past year about how GnuCash's standard workflow accounts for capital gains and losses, and I'm coming around to the idea

Re: [GNC] GnuCash sqlite backend on windows and linux

2021-05-26 Thread Geoff
bases are portable across 32-bit and 64-bit machines and between big-endian and little-endian architectures." https://www.sqlite.org/onefile.html Regards Geoff = On 27/05/2021 8:43 am, mike823 wrote: Hi everyone, Is the gnucash sqlite backend compatible between windows and linux? If,

Re: [GNC] how to import a csv of transactions?

2021-07-12 Thread Geoff
-transactions-td4721056.html Good luck! Geoff = On 12/07/2021 10:01 pm, Arman Schwarz wrote: I've tried on both 4.4 and 4.6 but it seems that importing csv transactions is broken. Before I continue down this path, is csv importing an actually supported feature or are the issues with it known

Re: [GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread Geoff
\gnucash\bin\" directory - and send a screenshot if it is still hanging after 30 minutes. Thanks Geoff = On 5/05/2021 5:09 pm, Sudesh Chandar via gnucash-user wrote: Hello  Group, I am a new user of GNU cash and have recently downloaded and installed Gnucash ver 4.5 on a windo

Re: [GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread Geoff
uote module. You should be skiing downhill from here on. Good luck. Geoff = On 5/05/2021 8:18 pm, Sudesh Chandar wrote: Hello Geoff, Many thanks for the fast reply. Actually the Perl scripts ran longer than 30 minutes much closer to 3 hours and after all that It threw up an error ab

Re: [GNC] Finance::Quote sort of works, almost

2021-02-04 Thread Geoff
Otherwise, you might be able to find some assistance on the Finance::Quote web site here: http://finance-quote.sourceforge.net/ Regards Geoff = On 5/02/2021 9:16 am, Andrea Borgia wrote: Il 04/02/21 01:13, Geoff ha scritto: Re (1). Next, in GnuCash, I set up the security to retri

Re: [GNC] weird price for LU0067412154

2021-03-18 Thread Geoff
/SecuritySearchResults.aspx?search=LU0067412154 Hope this helps. Regards Geoff = On 19/03/2021 11:00 am, Peter West wrote: Can you provide the html again, as is, without any inserted linefeeds? Peter — p...@ehealth.id.au “…you refuse to come to me that you may have life.” On 19 Mar 2021, at 3:45 am, Andrea Borgia

Re: [GNC] Online quotes for currencies not working anymore

2021-03-10 Thread Geoff
-03-10 08:40:01") (last . #e0.72002) (currency . "GBP"))) C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") (last . #e4.8841) (c

Re: [GNC] Totals On Expense Chart

2021-03-19 Thread Geoff
ions: Year / Half-year / Quarter / Month / Fortnight / Week. This will give you the total for all (or selected) Expenses for each of the Periods in the Date Range you specify. Hope this helps. Regards Geoff = On 19/03/2021 12:26 pm, Jack Frillman via gnucash-user wrote: Is there anyway

Re: [GNC] How To Remove All Transactions

2021-03-20 Thread Geoff
How about: . Export the Accounts . Delete each Account (and its transactions) . Import the Accounts. Geoff = On 21/03/2021 12:23 pm, Keith Fetterman wrote: I’ve tried that, and you are correct. I creates the same chart of accounts, but the tax tables, customers/vendors, etc. are missing

Re: [GNC] Mystery per-security Opening Balances accounts appearing

2021-03-17 Thread Geoff
counts. It's a minor nuisance. Regards Geoff = On 18/03/2021 4:00 am, peterb wrote: I've been using Gnucash for well over a year and a half. Sometime within the past few months, I have seen a number of completely empty Opening Balances equity accounts opening themselves for certain securities

Re: [GNC] weird price for LU0067412154

2021-03-18 Thread Geoff
xtract the 4 fields separately. I don't use this data source and currently don't have time to fix it. Geoff = On 18/03/2021 3:22 pm, Peter West wrote: Here’s the RE. m[NAV/>([0-9]{2}/[0-9]{2}/[0-9]{4}).*([A-Z]{3}).([0-9\.]+).*>([0-9\.\-]+)] There is no trailing modifier, so this has

Re: [GNC] Account Sort Order

2021-02-25 Thread Geoff
Hope this helps. Regards Geoff = On 26/02/2021 5:40 am, David T. via gnucash-user wrote: Hello, I'm using GnuCash 4.4 under Windows 10, and I am wondering how GnuCash sorts accounts in the Chart of Accounts window. My chosen sort order is by Account Code; however, I choose not to assig

Re: [GNC] Volunteer

2021-02-24 Thread Geoff
> Item 2 is a video that disrespected my device settings by playing > music. Cannot find out why silently. Beware! > ... or turn on closed captions. ;--) Geoff = On 24/02/2021 11:12 pm, David Carlson wrote: Item 2 is a video that disrespected my device settings  by playi

Re: [GNC] Volunteer

2021-02-23 Thread Geoff
Hi Richard Welcome to the wonderful world of GnuCash. (1) Great! (2) https://www.youtube.com/watch?v=_EMZ1u__LUc (3++) https://wiki.gnucash.org/wiki/Contributing_to_GnuCash :--)) Regards Geoff = On 21/02/2021 12:11 am, Richard via gnucash-user wrote: I am very interested in supporting

Re: [GNC] Advanced portfolio report - same stock in multiple investment accounts

2021-04-08 Thread Geoff
to select their individual sub-accounts. Then, if you want to see all people's reports on the same page (without grand totals) you can use the Custom Multicolumn Report. Hope this helps. Regards Geoff = On 9/04/2021 12:58 am, mike823 wrote: Hi everyone, I am using the advanced

Re: [GNC] Changing Currency in Price Data

2021-04-11 Thread Geoff
as separate derivatives (eg options etc). You can bet your bottom dollar/euro/yen that there will be market makers sitting in front of each of them taking a clip. Regards Geoff = On 12/04/2021 2:57 am, David Carlson wrote: Isn't it possible that a stock can be quoted in more that one currency

Re: [GNC] Finance::Quote not Working on Macbook

2021-02-15 Thread Geoff
dependencies and install them. I have no experience with MacOS, but Google is your friend: https://bioinformaticsonline.com/blog/view/29479/how-to-install-perl-modules-on-mac-os-x-in-easy-steps Good luck, and report back with more details if you get stuck. Geoff = On 16/02/2021 3:55 pm, bdp3

Re: [GNC] installling online quotes in Windows 10

2021-02-05 Thread Geoff
Hi David Have a read of this thread: http://gnucash.1415818.n4.nabble.com/GNC-Configuring-Automatic-Retrieval-Quotes-error-tc4723859.html You may need to do the installs running as Administrator. Regards Geoff = On 6/02/2021 7:38 am, David Carlson wrote: I just tried to install online

Re: [GNC] installling online quotes in Windows 10

2021-02-05 Thread Geoff
Also this person was experiencing a problem with internet access from the command line - read the second last post in the thread for their solution. http://gnucash.1415818.n4.nabble.com/GNC-Finance-quote-troubleshooting-tc4721374.html#a4721479 Good luck! Geoff = On 6/02/2021 7:38 am

Re: [GNC] Trouble getting stock quotes from TSX

2021-02-05 Thread Geoff
Hi Gord You are not doing anything wrong. The data sources / web pages used by Finance Quote are constantly changing, and unless someone rolls up their sleeves and puts in the work to fix it, we end up in this situation with a number of sources broken, including TSX. Regards Geoff

Re: [GNC] Copying reports from one machine to another

2021-02-19 Thread Geoff
Hi Richard I'm running GnuCash 4.4 on Windows 10 Pro, and they are in AppData / Roaming, but previous versions stored them in the ".gnucash" subfolder of your account. See attached screenshot. Regards Geoff = On 20/02/2021 3:48 pm, Richard Gaede via gnucash-user wrote: H

Re: [GNC] Creating new file and accounts

2021-02-19 Thread Geoff
n use the arrow keys to select the account that you want." https://www.gnucash.org/news.phtml So don't delay, upgrade today, and give your tired typing fingers a well earned rest! Regards Geoff = P.S. THANK YOU to the crew that delivered this feature, it has made a huge difference to

Re: [GNC] Expense Over Time report

2021-02-20 Thread Geoff
nce you master it, people will come from near and afar to admire your garden. Until then, make sure you backup your orchard often. Enjoy your weekend ;--) Regards Geoff = On 21/02/2021 10:32 am, gnu Gord wrote: Thank you to everyone that replied. I'm still a bit confused as to why I can selec

Re: [GNC] Expense Over Time report

2021-02-19 Thread Geoff
against the lowest level children accounts in your hierarchy (the "leaves" and not the "branches"). Hope this helps. Regards Geoff = On 20/02/2021 10:07 am, gnu Gord wrote: I'm trying to understand this report and it just isn't working the way I expect. Below is a screens

Re: [GNC] CVS import success/issues

2021-08-17 Thread Geoff
ding transactions. Good luck! Regards Geoff = On 16/08/2021 9:42 am, Lisa Rowell wrote: In preparation for a move from Mac to Linux, I went to move from my circa 2015 version of Quicken for Mac to GnuCash. Sadly that version lacks QIF support and couldn't even be imported correctly into the l

Re: [GNC] Search with subtotals

2021-08-17 Thread Geoff
Hi Jeff From the Search Results window, choose Reports / Account Report. It will generate a report showing all the searched for transactions, with Debit and Credit totals at the end. Windows 10 / GnuCash 4.4 See attached screenshot. Regards Geoff = On 17/08/2021 4:06 pm, Jeff wrote

Re: [GNC] Find transaction with totals

2021-09-06 Thread Geoff
of transactions is to copy and paste the report into a spreadsheet. See attached screenshot. Hope this helps. Regards Geoff = On 6/09/2021 4:58 pm, Jeff wrote: I'm sure this has been asked before but I can not find an answer. I frequently need to do a search (alt-f) for specific transactions

Re: [GNC] Finance::Quote on Mac M1

2021-08-04 Thread Geoff
Hi Peter How about sending through some diagnostics please? Screenshot or error log. Thanks Geoff = On 4/08/2021 5:03 pm, Peter West wrote: I have been trying to get Finance::Quote installed on my Mac M1, without success. I have tried installing using cpan -i Date::Manip cpan -i

Re: [GNC] Finance::Quote on Mac M1

2021-08-04 Thread Geoff
to install Finance::Quote normally. Good luck. Geoff = On 4/08/2021 6:38 pm, Peter West wrote: It sill reports the same failure, even though I run sudo cpan -f -i B::Keywords — Peter West p...@ehealth.id.au <mailto:p...@ehealth.id.au> But immediately Jesus spoke to them, saying, “Take

Re: [GNC] Finance::Quote on Mac M1

2021-08-04 Thread Geoff
Try and force the installation of B::Keywords: cpan> force install B::Keywords From: https://www.thegeekstuff.com/2013/06/cpan-force-install-perl-module/ If that works, try to reinstall Finance::Quote normally. Fingers crossed. Geoff = On 4/08/2021 5:24 pm, Peter West wrote: Her

Re: [GNC] Dividend payout entry

2021-10-11 Thread Geoff
Foad, that DropBox link requires a login - see attached screenshot. As David suggested, try attaching your image to an email. (David - both your images came through to my email as attachments.) Regards Geoff = On 12/10/2021 8:54 am, Foad Kasiri wrote: Hi David: Thanks

Re: [GNC] save as sqlite3 error

2021-10-19 Thread Geoff
Good pickup David - Thunderbird dropped the attachment, but I can see it via Gmail {:--( Not that it helps much PA, as John said, please check the trace file. Geoff = On 20/10/2021 2:04 pm, David Carlson wrote: It is odd that PA's screenshot made it to my Gmail account in Windows OS

Re: [GNC] save as sqlite3 error

2021-10-20 Thread Geoff
it quicker to type them in yourself - you can import price data from CSV once the securities themselves are set up. Hope this helps. Regards Geoff = On 20/10/2021 7:25 pm, Public Address wrote: Thank you all.  Someone last night pointed me to the trace file.  I tried to save as sqlit

Re: [GNC] Help with Install Finance::Quote

2021-12-31 Thread Geoff
ur* GunCash programs are installed, and run the installation script - see attached screenshot. Be patient - the installation sometimes appears to freeze up and can take up to 30 minutes to complete successfully. Regards Geoff = On 1/01/2022 1:13 pm, kb1912 wrote: Sorry, running Windows

Re: [GNC] Help with Install Finance::Quote

2021-12-31 Thread Geoff
Hi Kiel What happens when you run this command: perl gnc-fq-dump yahoo_json IBM See attached screenshot for the expected result. P.S. It helps to mention your operating system and GnuCash version. Happy New Year! Geoff = On 31/12/2021 8:56 am, kb1912 via gnucash-user wrote: I have

Re: [GNC] Stock transaction research

2021-11-27 Thread Geoff
and Fees. I have been down this path myself, and found it easier to use a spreadsheet to compute the cost base for tax purposes using the transaction data recorded in my GnuCash portfolio. Regards Geoff = On 28/11/2021 12:01 am, Tom Browder wrote: I have been browsing various Gnucash

Re: [GNC] Using Gnucash to access file over flaky network

2021-11-27 Thread Geoff
r". Solutions, depending on you operating system(s), include: * Windows Remote Desktop * VNC - Viewer & Server https://www.realvnc.com/en/connect/pricing/ https://www.tecmint.com/best-remote-linux-desktop-sharing-software/ Regards Geoff = On 27/11/2021 1:30 am, Chris Mitchell wro

Re: [GNC] Using Gnucash to access file over flaky network

2021-11-25 Thread Geoff
ution will usually work better in that scenario." https://www.sqlite.org/draft/useovernet.html Good luck! Regards Geoff = On 25/11/2021 6:38 am, Chris Mitchell wrote: On Wed, 24 Nov 2021 09:30:29 -0800 "Stephen M. Butler" wrote: On 11/24/21 07:54, Chris Green wrote: On Wed, Nov 24

Re: [GNC] save as sqlite3 error

2021-10-22 Thread Geoff
Looks like that approach could work, but I'm afraid I don't know enough about the inner workings of GnuCash to advise you authoritatively. Good luck! Regards Geoff = On 22/10/2021 11:52 pm, Public Address wrote: Thanks, interesting that deleting the “NULL” text and leaving it empty

Re: [GNC] Trouble installing Strawberry perl

2021-10-31 Thread Geoff
Files (x86)\gnucash\bin\ Hope this helps. Regards Geoff = On 1/11/2021 6:49 am, David Carlson wrote: Thank you David. I tried the Install online price retrieval for GnuCash script again and it still gives the error about the missing .vbs file. Do you know how that file is supposed to be c

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-18 Thread Geoff
am Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") (last . #e4.8841) (currency . "RON"))) Also, it is normal to get the blank command windo

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-19 Thread Geoff
Hmmm, something is definitely broken there. Let me know what you get with my second email. Geoff = On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote: Sorry Geoff, I was pasting from my troubleshooting notes not what I typed. I’ve attached the screenshot Best regards, David

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-19 Thread Geoff
a suggestion. Regards Geoff = On 19/07/2021 10:04 pm, david.rom...@davidjromano.com wrote: I think your right - does not look good - no output at all C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q = Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/)

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-19 Thread Geoff
-no-zone . "2021-07-19 21:27:37") (last . #e0.72922) (currency . "GBP"))) See attached screenshot. Hope this helps. Regards Geoff = On 19/07/2021 7:08 pm, david.rom...@davidjromano.com wrote: Good morning Geoff - I'm now back in the office and have run through your su

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-19 Thread Geoff
/USD/,q/GBP/);" Expected result: 0.72953 [Note to other readers - the above is the syntax for Windows] See attached screenshot. Hope this helps. Regards Geoff = On 19/07/2021 9:04 pm, david.rom...@davidjromano.com wrote: Good Morning Chris, Many thanks for this, which I've jus

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-22 Thread Geoff
David, x64 is fine. I agree with Bruce - completely uninstall and reinstall. Regards Geoff = On 23/07/2021 4:46 am, david.rom...@davidjromano.com wrote: Bruce, I'll give this a try in the morning---but just a thought. I've been using the x64 Strawberry install because the system is x64

Re: [GNC] Difficulties entering share purchases

2021-07-27 Thread Geoff
and asking me "Which value would you like to have recalculated?" Shares / Price / Value. See attached screenshot. Hope this helps. Regards Geoff = On 28/07/2021 1:23 am, Eric Coates via gnucash-user wrote: In January this year,whilst running Ubuntu 20.10 and GnuCash 3.x, I p

Re: [GNC] Australian cash residuals - Non- GnuCash question

2021-07-27 Thread Geoff
; address) match up. For example:- https://www.nabtrade.com.au/investor/support/faqs/getting-started/transfer-issuer-sponsored-shares Hope this helps. Regards Geoff = On 27/07/2021 6:28 pm, Chris Good wrote: Hi, I apologize in advance for this non GnuCash question but I searched the

Re: [GNC] Simple Update Question

2021-07-28 Thread Geoff
n't remember when they were released. I am currently using release 4.4, and they are under the Reports / Experimental menu. Regards Geoff = On 28/07/2021 1:23 am, sc wrote: Hello. I successfully transferred from Quicken to GnuCash years ago, with no troubles.  I'm a home user, not

Re: [GNC] Difficulties entering share purchases

2021-07-28 Thread Geoff
! Geoff = On 28/07/2021 6:13 pm, Eric Coates wrote: Geoff Thanks for responding. The sequence of events that you describe is what I would expect but not only do the numbers disappear (see Fig 8) but the dialogue you mention just doesn't happen (see the description of Fig 9) Take care Eric

Re: [GNC] Period Ends

2022-01-07 Thread Geoff
are back at square one. Hope this helps. Regards Geoff = On 7/01/2022 8:40 pm, Mike Stillingfleet wrote: Dear All, Several years ago I attempted to close off at end of year and it didn't end well. I am revisiting this topic and trying to work out if there is any benefit to it. 1.

Re: [GNC] dit not run

2022-03-14 Thread Geoff
version of Perl that GnuCash is seeing when it runs - from a *WINDOWS* Command prompt (not a mingw shell) type in "SET PATH" Regards Geoff = On 13/03/2022 12:07 pm, xuhengx...@outlook.com wrote: Dir Sir / Madam, Finance::Quote module is installed and working kerwin@KERWIN-PC D:\Pro

Re: [GNC] 回复: dit not run

2022-03-14 Thread Geoff
Finance::Quote from a Windows Command Prompt (not a mingw or any other shell) using gnc-fq-dump (f) Use a local GnuCash data store on your C: drive. (g) Invoke GnuCash via Windows, not the command line Good luck! Geoff = On 14/03/2022 11:46 pm, 徐 恒晓 wrote: Dear Mr. Geoff , The previous

  1   2   3   >