Re: [GNC] Import of CSV

David, I know cleared is not the same as reconciled. The CSV did mark the items as "cleared". However, what I was referring to was that there is no check box at the bottom to reconcile after import as there is with OFX/QFX. Thank You, Gyle McCollam Gyle McCollam

Re: [GNC] I'm looking at installing GnuCash but has a couple of questions first

On 12/04/2024 21:28, Robert Dew wrote: Thanks for the offer Graham I'm getting more and more inclined towards the X11 track. I will need to do a little experimenting with having  X11 and CLI on the same VM to see if they "Play nicely" together or if I'll need to run up a separate VM just for

Re: [GNC] Finance::quote YahooJSON

I am currently using modified YahooJSON.pm module for my needs and seems to be working from the States. It is pulling data so far. Head over to https://github.com/ka-patel/dl_quotes/blob/main/FinanceQuote/YahooJSON.pm if you are interested in its early release before Bruce can do his vetting

[GNC] how to find open invoices

Hello,     I often have invoices that are open (in progress) that are not ready to post.  Is there a way to see a list of these?  The only way I have found to do so is to remember ahead of time a customer has an open invoice and find it.  This is quite error prone. Thank you, Ted

Re: [GNC] Finance Quotes Yahoo off the rails again?

Just a quick status. Just an FYI, I have worked on getting a PR ready using kalpesh Patel's changes. I tried applying the same logic to the CurrencyRates/YahooJSON.pm currency module with no luck. In that case I quickly modified the currency module to utilize the "v8" API. I admit, I suck at

Re: [GNC] Finance::quote YahooJSON

I might be concluding wrong on this one. Libre Office Calc will accept them, and I just saved them again. But I think there might be more variables. It is detected as UTF16 by Libre Office Calc, so it might be a character set issue. Also, I do need to get my Gnucash upgraded, I am on 4.5 at

[GNC] importing or pasting reports into spreadsheets

I have found that I can select the text of reports directly in GnuCash, then paste it into a Libre Office Calc spreadsheet. The problem then is that values are preceded with a dollar sign in the US and it seems that they are not currency numbers but some form of text, as numeric operators do not

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

David T, Nice, but I am told pedagogy suggests even the best explanations are best packaged with examples, like on a nice web page.  In fact, the Finance Quote process itself might be divided into three processes: a gnucash call to extract the symbols and sources as a CSV, a web scraper

Re: [GNC] importing or pasting reports into spreadsheets

Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps! Cheers

Re: [GNC] Finance Quotes Yahoo off the rails again?

WooHoo! I'll give it a go once it's out. Thanks! -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Saturday, April 13, 2024 10:08 PM To: GnuCash User Subject: Re: [GNC] Finance Quotes Yahoo

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

David, My goal in the example was not pedagogical; it was to give others in the community information that they might use for themselves. I'm pretty sure that in the earlier thread, I gave all the information necessary (including actual cell formulae) for others to test it for themselves. If