Re: [GNC] Thank You Michael D Novack (Geoff)
Hi Michael, I'd like to second Geoff's comments about your regular contributions to the list being not only interesting, but also very helpful. My mother is a bookkeeper and she always reiterates how important it is to know why you are doing something in principle before attempting to do it electronically. Your paper-to-computer explanations do this by helping us all remember and understand the fundamentals underpinning our electronic accounts systems, so we can therefore find the appropriate accompanying functionality in Gnucash (whereas in other tutorials for other programs you mostly get 'how' to force your numbers into the system in order to make them 'fit' and 'appear' correctly. Kind regards, Clare Vanessa (Chapman) Freelance Web Designer & Copywriter e: cont...@clarevanessa.com.au p: 61 (0) 2 6644 9869 w: www.clarevanessa.com.au -Original Message- RE: Thank You Michael D Novack (Geoff)Date: Wed, 8 May 2024 11:24:28 +1000 From: Geoff To: stepbystepf...@comcast.net, gnucash-user@gnucash.org Subject: [GNC] Thank You Michael D Novack Message-ID: <9fc6f698-196f-4cda-a445-40c0eba46...@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Hello Michael Thank you very much for this little history lesson and your many other erudite responses on this mailing list. I always look forward to reading your answers knowing that I will both be entertained and learn something new. I particularly enjoy the way you often relate 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 and credits are >> used contrary to the way most people understand them. The average >> punter will be wrong, and if they get it right the next punter will >> likely bet they are wrong. > > Yes, depends on perspective, your point of view or the bank's. > > But also? and explaining where YOUR point of view comes from (the origin > of the terms) think of who in say 1200 CE would be needing to keep > books. What sort of business would you be in? A moneylender, of course. > And keep in mind that in 1200 in Europe, if literate, probably Latin not > a strange language (especially not when dealing across multiple local > languages). > > Debit comes from "he owes" (me). In other words, your assets are debts > owed to you as well as cash on hand available to be loaned out. Thus the > money you have on deposit at some bank is a debit because the bank owes > you that money. > > Credit comes from "he trusts" (me). In other words, your liabilities. > Money you owe somebody else that they are trusting you can pay back. > It's why on the statement from the bank your account balance is a credit > (you are trusting the bank will give you this money of you ask for it) > but in your books a debit because the bank owes this money to you. > > Initially (way back then) there were no special accounts of type > "income" and "expense" so the other side of a transaction we would call > income or expense was equity. Immediately entered against equity. That > made it easy to see at any moment what to see what total equity was but > hard to look up the totals for any particular expense. Had to do work to > answer questions like "how much was our interest income last month?" > (remember, we are moneylenders). So a couple hundred years ago (I don;t > know exactly when) somebody got the bright idea to have TEMPORARY > accounts of type "income" and "expense" of fundamental type "equity". > Instead of the other side of the transactions immediately being main > equity use these "temporarily" and only every so often transfer to main > equity through a process known as "close thew books" with this process, > along the way, creating a report called "profit and loss" << originally > this was another temporary account, closed to equity by the net profit > or loss amount >> > > BTW, a moneylender WOULD be wanting to have liabilities. These would > have come into being by exchange with another moneylender in some other > town/country. These documents were useful in TRADE, serving as a way of > transporting money without the risk of bandits stealing the gold or > silver money on the way. You are a moneylender in place A. A merchant > planning to travel to B might come to you and ask "Do you have a debt > document from a moneylender in B?" If you did, you could sell him that > debt (endorse it over to him) collecting a fee for the service. He then > could travel to B and present it there for payment. Useless for a bandit > to steal as it wasn't made out "pay to the bearer" but "pay to some > specific person" (the merchant). > > Note something here. If two banks are exchanging these IOU's no silver > or gold has changed hands. Who says that the silver
Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)
That was it. Rounding down to 9 decimal places works. Thank you! -Original Message- From: John Ralls Sent: Wednesday, May 08, 2024 10:13 PM To: Kalpesh Patel Cc: GnuCash User Subject: Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02) Kalpesh, I think your price has too many digits. Try rounding it to 10E-9. Regards, John Ralls > On May 8, 2024, at 09:05, Kalpesh Patel wrote: > > Hi GNC User community - > > > > I am developing a second F::Q module of my own. The first one works > fine but second one seems to NOT want to work no matter what. I am in > middle of debugging it and it has stomped me why not so hoping someone > might be able to help me zero in where I am falling sort on the flow > for it. I am working with F::Q v1.61_02 and GNC v4.14 > (4.14+(2023-03-25) build) running on Windows 11. (Note: I don't > believe any interface change has taken place in GNC v5.x that would cause this but correct me here if I am wrong.). > > > > Invoking GNC with debug shows that return value is #f, which means > something went wrong (run_executor is the "label" for my module and > other modules work fine from the debug output): > > > > 11:19:24 DEBUG handling-request: (currency INR USD) > > * 11:19:24 DEBUG results: ((INR (symbol . INR) (gnc:time-no-zone . > 2024-05-08 11:19:11) (last . 3/250) (currency . USD))) > > * 11:20:38 DEBUG ALPHAVANTAGE_API_KEY=NOTAREALAPIKEY > > * 11:20:39 DEBUG handling-request: (tsp C S L2030 I) > > * 11:20:43 DEBUG results: ((C (symbol . C) (gnc:time-no-zone . > 2024-05-07 12:00:00) (last . 812423/1) (currency . USD)) (S > (symbol . S) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . 4009/50) > (currency . USD)) > (L2030 (symbol . L2030) (gnc:time-no-zone . 2024-05-07 12:00:00) (last . > 237163/5000) (currency . USD)) (I (symbol . I) (gnc:time-no-zone . > 2024-05-07 12:00:00) (last . 42507/1000) (currency . USD))) > > * 11:20:43 DEBUG handling-request: (run_executor BK) > > * 11:20:43 DEBUG results: (#f) > > * 11:20:43 DEBUG handling-request: (yahoojson ^NYA) > > * 11:20:44 DEBUG results: ((^NYA (symbol . ^NYA) > (gnc:time-no-zone . 2024-05-08 12:00:00) (last . 2247813/125) > (currency . USD))) > > > > Following is debug run from command line of gnc-fq-dump (which > provides all necessary fields for quote to be valid as it does not > show '** This stock quote cannot be used by GnuCash!' message): > > > > C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" > -v run_executor BK > > {snip} > > ### [Wed May 8 11:34:40 2024] %info : { > > ###'BKISIN' => '-', > > ###'BKcurrency' => 'USD', > > ###'BKdate' => '05/08/2024', > > ###'BKisodate' => '2024-05-08', > > ###'BKmethod' => 'run_executor', > > ###'BKprice' => '57.64500045776367', > > ###'BKsuccess' => '1', > > ###'BKsymbol' => 'BK', > > ###'BKtimezone' => 'EDT' > > ### } > > Finance::Quote fields Gnucash uses: > > symbol: BK <=== required > >date: 05/08/2024 <=== recommended > > currency: USD <=== required > >last: <=\ > > nav: <=== one of these > > price: 57.64500045776367<=/ > > timezone: EDT <=== optional > > > > All fields returned by Finance::Quote for stock BK > > > > stock field value > > - - - > > BK ISIN: - > > BK currency: USD > > BK date: 05/08/2024 > > BKisodate: 2024-05-08 > > BK method: run_executor > > BK price: 57.64500045776367 > > BKsuccess: 1 > > BK symbol: BK > > BK timezone: EDT > > > > > > C:\Users\kalpesh> > > > > When running same command via YahooJSON following is the output which > works fine (I see that it does have more information returned back): > > > > C:\Users\kalpesh>perl "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump" > -v yahoojson BK > > {snip} > > Finance::Quote fields Gnucash uses: > > symbol: BK <=== required > >date: 05/08/2024 <=== recommended > > currency: USD <=== required > >last: 57.605 <=\ > > nav: <=== one of these > > price: <=/ > > timezone: <=== optional > > > > All fields returned by Finance::Quote for stock BK > > > > stock field value > > - - - > > BK close: 57.4 > > BK
Re: [GNC] Update on financequote?
Your query seems to be garbled up but from what I make out from it: yes, F::Q works fine as of v1.61_03 release if that is what you are asking. -Original Message- From: interesse Sent: Friday, May 10, 2024 7:29 AM To: gnucash-user@gnucash.org Subject: [GNC] Update on financequote? Hello everyone, Is there any news on the problem with financequote not being able to access online courses? Or is there somewhere I can see the current status? I haven't found anything online, but I'm new to it, so maybe I've overlooked it. Thank you very much! Best regards, Marco ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
You may want to look at https://github.com/ka-patel/dl_quotes/tree/main/yfinance which is Python based... -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 AM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Problem building Gnucash from source using wiki page "macOS/Quartz"
> On May 9, 2024, at 10:08, Paul Ingram wrote: > > > Trying to build gnucash-5.6 from source on a mac mini running macOS 14.4.1 in > accordance with the instructions on > https://wiki.gnucash.org/wiki/MacOS/Quartz. > > Created administrator account “gtkosx” > Switched to the new account: "su gtkosx" > Ran “sh gtk-osx-setup.sh” in a bash shell > Got the following messages: > > Installed openssl-3.2.0 … > Installed readline-8.2 … > Installed python-3.11.7 (with warnings “missing the Tk toolkit?” and “missing > the lzma lib?” > Installed pip-24.0 … > Installing collected packages: distlib, setup tools, … > Installed certifi-2024.2.2, distlib-0.3.8, … > Created virtualenv … > Locking dependencies ... > Building requirements … > Resolving dependencies … > > Error: > File > "/Users/gtkosx/.new_local/lib/python3.11/site-packages/pipenv/project.py", > line *239*, in get_requests_session_for_source > > if *self.sessions.get**(*source*[*"name"*])*: > >~~ > > KeyError: 'name' > > ✘ Locking Failed! > > > > Patch for project.py appears here: https://github.com/pypa/pipenv/issues/6106 > > > > Do I patch project.py manually and rerun gtk-osx-setup.sh? > Yes. Pipenv has merged my PR but hasn’t done a new release. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Further to the point, I've used Google Sheets financial functions to retrieve stock prices pretty quickly. Those functions can pull prices for any given date, so you could set some dates and import them that way. It's not ideal, but it could get things done in a pinch. David T. On May 10, 2024, 11:31 AM, at 11:31 AM, Leung Wing Cheong wrote: >Got it, many thanks! >Wing > >-Original Message- >From: sunfis...@yahoo.com >Sent: Friday, May 10, 2024 2:59 PM >To: Leung Wing Cheong >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] Importing historical stock prices to GnuCash in >Windows > >Of course there is. The csv importer can handle any price data, >including historical data, as long as you supply the proper dates along >with the other data elements. > >The challenge is gathering that price data in the first place. It used >to be possible to retrieve unlimited price quotes from a number of >online sources, but those days are gone, sadly. > >At one point in the past, I used a perl module to retrieve monthly >prices for all my commodities and put them into the GnuCash price >history, but the module depended on Yahoo!, which no longer allows that >level of data gathering. > >David T. > >On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong > wrote: >>Hi, >>Is there any way to import historical stock prices to GnuCash in >>Windows? >>Thanks, >>Wing >>___ >>gnucash-user mailing list >>gnucash-user@gnucash.org >>To update your subscription preferences or to unsubscribe: >>https://lists.gnucash.org/mailman/listinfo/gnucash-user >>- >>Please remember to CC this list on all your replies. >>You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Update on financequote?
Hello everyone, Is there any news on the problem with financequote not being able to access online courses? Or is there somewhere I can see the current status? I haven't found anything online, but I'm new to it, so maybe I've overlooked it. Thank you very much! Best regards, Marco ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Got it, many thanks! Wing -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 PM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.