Re: [GNC] GC 3.2 Import Price File CSV

2018-08-24 Thread John Ralls
> On Aug 24, 2018, at 1:36 PM, Colin Law wrote: > > In Fri, 24 Aug 2018 at 17:58, Megagrumpy wrote: >> >> SUCCESS!!! It turns out that I was very carefully ensuring that I was saving >> the file from Excel in "CSV UTF-8 (Comma delimited)" format as I thought >> this was the closest match to

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Stephen M. Butler
On 08/24/2018 06:31 AM, Derek Atkins wrote: > "Stephen M. Butler" writes: > >> I tried in standard-reports and it threw errors.  Moved back up to >> report and it works.  I'm sure there is something about the code that I >> didn't change correctly for the new location. > What error(s) did it throw

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Stephen M. Butler
On 08/24/2018 12:40 AM, Geert Janssens wrote: > Op donderdag 23 augustus 2018 19:35:43 CEST schreef Stephen M. Butler: >> On 08/23/2018 09:44 AM, Geert Janssens wrote: >>> Better still: don't mess with the installation directory at all and >>> instead >>> follow >>> https://wiki.gnucash.org/wiki/Cu

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-24 Thread Colin Law
In Fri, 24 Aug 2018 at 17:58, Megagrumpy wrote: > > SUCCESS!!! It turns out that I was very carefully ensuring that I was saving > the file from Excel in "CSV UTF-8 (Comma delimited)" format as I thought > this was the closest match to the Encoding required for the import tool. > Changing to the

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-24 Thread Megagrumpy
SUCCESS!!! It turns out that I was very carefully ensuring that I was saving the file from Excel in "CSV UTF-8 (Comma delimited)" format as I thought this was the closest match to the Encoding required for the import tool. Changing to the option "CSV (comma delimited)" works. Or, as you suggested,

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-24 Thread John Ralls
> On Aug 23, 2018, at 11:48 PM, Megagrumpy wrote: > > There are no spaces in the stock definition. Also in answer to your question > about the date format. I have tried all the date formats and I never get a > failure to read the date correctly. When I import data in quicken format > from my ba

Re: [GNC] Not Getting Complete Stock Quotes with Price Database Tool

2018-08-24 Thread Ott Kekishev
Hello, Did something changes regarding Yahoo as json in GC 3.2? As I haven't managed to get it working (even though F::Q seems to fetch the data). Best regards, Ott On Fri, 24 Aug 2018 at 18:43, Les wrote: > I am using LInux Mint 18.2 and GC 2.6.17. > > Since someone a while back that switchin

Re: [GNC] Not Getting Complete Stock Quotes with Price Database Tool

2018-08-24 Thread Les
I am using LInux Mint 18.2 and GC 2.6.17. Since someone a while back that switching to Yahoo as json most of my stock quotes have been up-to-date.  My only problem is being unable to retrieve quotes for the 8 currencies (I think the last update I received was in late July).  If memory serves,

Re: [GNC] Certain Quotes not fetching (NASDAQ, OTCMKTS)

2018-08-24 Thread tref95
Erik Colson wrote > Can be. Would you mind posting a list of stock symbols (as queried by > F::Q) which did work and do not work anymore? > > best > -- > erik colson Here is the message I received using the GUI: Unable to retrieve quotes for these items: NASDAQ:MDB NASDAQ:AMD NASDAQ:ADBE

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Geert Janssens
Thanks for sharing. That information will certainly be useful for others trying to customize this report. Regards, Geert Op vrijdag 24 augustus 2018 16:35:20 CEST schreef Alex via gnucash-user: > I took the gnucash balance sheet from > > Reports -> Assets & Liabilities -> Balance Sheet > > Cl

Re: [GNC] Certain Quotes not fetching (NASDAQ, OTCMKTS)

2018-08-24 Thread Erik Colson
tref95 writes: > Hello, > > Ever since August 1, my NASDAQ and OTCMKTS quotes have not been fetching. > However, my funds and NYSE are still fetching. I am currently using > AlphaVantage, but when I switched one to YahooJSON, I still received the > error for it. > > Did something change in Augu

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Alex via gnucash-user
I took the gnucash balance sheet from Reports -> Assets & Liabilities -> Balance Sheet Clicked on the Edit report option icon on the tool bar. Changed a few options including most importantly these fields on the "Display" page  and to match the names of my bespoke files My bespoke css and

Re: [GNC] Not Getting Complete Stock Quotes with Price Database Tool

2018-08-24 Thread David T. via gnucash-user
Dan, You are not alone with this problem; numerous users have lamented the ongoing saga of retrieving commodity prices online since Yahoo! decided to pull the plug on its quote system. AlphaVantage has been the solution that everyone here flocked to, and now AlphaVantage is altering its enforce

Re: [GNC] Not Getting Complete Stock Quotes with Price Database Tool

2018-08-24 Thread Dan Nelms
Thanks for your reply, derek. Alpha Vantage wants $19.95 a month for a premium API number that would solve the problem, but if I only wants updates once or so a week, it's not worth it. Maybe GnuCash could provide a check box indicator in the Price Tool where I could limit my API calls to 5 at a ti

Re: [GNC] Not Getting Complete Stock Quotes with Price Database Tool

2018-08-24 Thread Derek Atkins
Hi, Dan Nelms writes: [snip] > What happened on August 1? Did Alpha Vantage start enforcing their 5 > calls per minute limit for their free API numbers? [snip] Yes. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek --

Re: [GNC] How Jobs Work ( was Re: Business Account Set Up Question & Customer Billing Question)

2018-08-24 Thread Derek Atkins
Hi, Adrien Monteleone writes: > Aha! > > ‘Purchase Order’ is easier to grok for this. > > Would that be a terribly difficult fix? Would a bug report be welcome > or are there messy implications by changing it? At least one I can > think of would be users wanting to create a single ‘PO’ document

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Derek Atkins
"Stephen M. Butler" writes: > I tried in standard-reports and it threw errors.  Moved back up to > report and it works.  I'm sure there is something about the code that I > didn't change correctly for the new location. What error(s) did it throw when it was in standard-reports? Did you change t

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Geert Janssens
Op vrijdag 24 augustus 2018 12:57:47 CEST schreef Alex via gnucash-user: > I've come to this thread and V3.2 a bit late. Installed V3.2 a week or > so ago. > > I too had problems with my bespoke balance sheet which, as a linux user, > is in my .local/share/gnucash directory. > > Couldn't open any

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Alex via gnucash-user
I've come to this thread and V3.2 a bit late. Installed V3.2 a week or so ago. I too had problems with my bespoke balance sheet which, as a linux user, is in my .local/share/gnucash directory. Couldn't open any of my old balance sheets from Reports -> Saved Report Configuarations Solved th

Re: [GNC] GC 3.2 Import Price File CSV

2018-08-24 Thread Megagrumpy
There are no spaces in the stock definition. Also in answer to your question about the date format. I have tried all the date formats and I never get a failure to read the date correctly. When I import data in quicken format from my bank it tends to be in M-D-Y format for some reason. I have also

[GNC] Certain Quotes not fetching (NASDAQ, OTCMKTS)

2018-08-24 Thread tref95
Hello, Ever since August 1, my NASDAQ and OTCMKTS quotes have not been fetching. However, my funds and NYSE are still fetching. I am currently using AlphaVantage, but when I switched one to YahooJSON, I still received the error for it. Did something change in August? Is this related to waiting f

[GNC] Fixed Asset Budgeting tutorial

2018-08-24 Thread David Briggs
Good morning (at least in a lot of places): I am trying to figure out how to do fixed asset budgeting vs. current asset budgeting. I can find tutorials that explain the latter, but not the former. Is it any different than current asset budgeting? It seems to be. Can someone point

Re: [GNC] Balsheet-eg.scm problem

2018-08-24 Thread Geert Janssens
Op donderdag 23 augustus 2018 19:35:43 CEST schreef Stephen M. Butler: > On 08/23/2018 09:44 AM, Geert Janssens wrote: > > Better still: don't mess with the installation directory at all and > > instead > > follow > > https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report > > to load your