Re: [GNC] AlphaVantage now restricting users to 25 quotes

can only use one conversion. Would be interested to understand this a bit more. From: Mike Alexander Sent: 31 October 2023 06:19 To: Adrian Holbrook Cc: gnucash-user@gnucash.org Subject: Re: [GNC] AlphaVantage now restricting users to 25 quotes On 27 Oct 2023

[GNC] AlphaVantage now restricting users to 25 quotes

I have been using Alphavantage for my stock quotes for some time now using F:Q. IRecently it stopped working for me - the last valid quotes I have are dated October 20th 2023. I now get a message that they are restricting quotes to 25 per user per day. I currently import around 50 at a time but

[GNC] Unable to update prices using Yahoo as JSON

Share price updates using Yahoo as JSON are not working for some reason. Is anyone else having this problem? Tried to access the mailing list to see if anyone else is having this problem but I keep on getting an authorisation failure. ___ gnucash-user

Re: [GNC] Does anyone produce a "UK balance sheet" (FRS 102) ?

Apologies, my complaint was about General Leger... On Sat, Dec 11, 2021 at 5:02 PM Adrian Yong wrote: > Hi David, > > I asked for the same thing but was told that since entries are made using > the double entry system, Assets = Liability + Proprietorship is complied > with...

Re: [GNC] Does anyone produce a "UK balance sheet" (FRS 102) ?

transactions in the accounting period will have their balances brought forward ie. Equity... Regards, Adrian On Sat, 11 Dec. 2021, 11:42 Dr. David Kirkby, < drkir...@kirkbymicrowave.co.uk> wrote: > I realise this is not something the developers can realistically do, but I > wonder i

Re: [GNC] General Ledger amounts missing

will always be observed. However, sometimes an entry may be a negative Asset instead of being a positive Liability and this is not so easily picked up without a normal General Ledger... I have downloaded the General Ledger or Transaction Report and created my normal GL using Excel. Regards, Adrian

Re: [GNC] Big problem GC 4.6 wiping history list? Mac OS Big Sur

Hi Anita, That is my greatest fear... Hope you managed to resolve the issues.. Please share your experience... Regards, Adrian On Wed, Jun 30, 2021 at 12:07 PM Anita Graves wrote: > Please see the attached screenshot: > > I don’t know what to do but I refuse to delete the file I nee

Re: [GNC] GnuCash 4.6 Released

Hi, I am using v3.7. Is there a *procedure *for me to upgrade to v4.6 without risk loss of data ? Like, can I run two versions of GNUcash on the same data files until I am certain that the updated version is running properly ? Thank you. Regards, Adrian On Mon, Jun 28, 2021 at 9:41 PM Fross

[GNC] GnuCash v3.7 - Trial Balance giving zeros

Hi, I am using v3.7 and for FY ending 2020; I am getting zeros in my Trial Balance. It was ok for 2019. Any advice on what I should do ? Regards, Adrian ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

Re: [GNC] Gnucash 4.1

, Adrian On Wed, 5 Aug. 2020, 07:51 David H, wrote: > Hi John, > > Go to gnucash.org and click the Download GnuCash 4.1 Apple macOS >= 10.13 > :High Sierra" link if you are on High Sierra 10.13 or later, see pic > below... > > Direct link is > > https://sourceforge

Re: [GNC] Alpha Vantage problems

Thanks Adriano. Although it is not good news at least now I do not have to keep on trying out different things to work out why it is not working! Regards Adrian On Fri, Jul 10, 2020 at 8:57 PM Adriano Baldi wrote: > Hi, to all > > I have bad news! > > It looks like Alphav

Re: [GNC] Alpha Vantage problems

I have a list of about 50 stocks that used to work and do not work now - a small selection AAL.L AV.L AZN.L BATS.L BBY.L BDEV.L BEZ.L BILN.L BKG.L BME.L BP.L BRBY.L BT-A.L BVIC.L BWY.L Regards Adrian Adrian Holbrook Tel: +44 (0)1564 230038 Mob: +44 (0)777 238 3299 Skype: megagrumpy Web

Re: [GNC] Gnucash - user

Thanks for all the advice - Nabble is no longer going to be used by me. I really thought it was an inherent part of the Gnucash approach but I am happy to part with it. On Tue, Jul 7, 2020 at 2:36 PM Derek Atkins wrote: > Dear Adrian, > > On Tue, July 7, 2020 2:46 am, Adrian Holbr

Re: [GNC] Alpha Vantage problems

Thanks fo the advice. I was going to download the alpphvantage addon for Excel but instead used gnc-fq-dump. I can get all the NYSE stocks but nothing off the LSE using the suffix .L. Fails every time;. Adrian On Tue, Jul 7, 2020 at 12:01 PM Chris Good wrote: > Hi Adrian, how are you gett

Re: [GNC] Alpha Vantage problems

term I have changed my source to Yahoo JSON and that is working. I would just like to be able to get Alphavantage working as well so that if one fails I have a backup source. Regards Adrian On Tue, Jul 7, 2020 at 9:10 AM Chris Good wrote: > Message: 3 > Date: Tue, 7 Jul 2020 07:58:33

Re: [GNC] Gnucash - user

I registered as a new user on Gnucash mailing list. I then got an email from Nabble that asked me to click on a link to confirm my membership - see below [image: image.png] That takes me into Nabble and then I cannot post without contacting Hugo sho does not respond! Regards Adrian On Tue, Jul

[GNC] Alpha Vantage problems

download was on June 12th and since then all attempts have failed. All my shares are on the LSE. I have not checked trying to get quotes from NYSE but that would be my next test. I am using Gnucash 4.0 and Finance::Quote 1.49 Regards Adrian ___ gnucash-user

[GNC] Gnucash - user

subscribe form. I am very confused and would love a simple process that worked like a normal forum without having to go through hoops Adrian Holbrook Tel: +44 (0)1564 230038 Mob: +44 (0)777 238 3299 Skype: megagrumpy Web: www.megagrumpy.com email: adrian.holbr...@gmail.com

Re: [GNC] Potential regression: PDFs generated using "Make PDF" have a superfluous blank page

Hi Adrien, After speaking to you the last time, I tried exporting documents (ie. General Ledger) to pdf and xlsx formats and I got gibberish... I am using version 3.7... Regards, Adrian On Tue, Jun 30, 2020 at 2:47 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I ca

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

Thanks Liz.. Very valid point... I don't have much problems with GNUcash... On Tue, Jun 23, 2020 at 4:33 PM Liz Dodd wrote: > On Mon, 22 Jun 2020 20:06:05 +0800 > Adrian Yong wrote: > > > As Gnucash is still under development, > > This is a place to point out a diff

Re: [GNC] QUESTION: transaction classes (tags) like QuickBooks?

locating their files after updating... I think the current version is 3.10 and I am on 3.x... I have this fear of updating to 3.10... Maybe I will do it after my auditors confirmed that they have got everything they need... Regards, Adrian On Mon, 22 Jun. 2020, 17:52 Zi via gnucash-user, wrot

[GNC] Scheduled payment question

and have to reset the date manually and/or delete duplicates. Is there anyway to set these payments automatically? Adrian Sutton UK ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe

Re: [GNC] General Ledger

csv > will accept any separator or let you specify on import. Some choke on > anything but a comma. GnuCash gives you the flexibility to choose what you > need. > > The problem you found isn’t a problem with GnuCash, it is a limitation of > how the Windows OS recognizes files. > *Poi

Re: [GNC] General Ledger

. All your other comments are relevant if we get this file type specification step correct. Regards, Adrian On Mon, Mar 30, 2020 at 12:28 AM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 3/28/2020 11:21 PM, Adrian Yong wrote: > > I can't change the file type...

Re: [GNC] General Ledger

Thanks Fred... On Sun, 29 Mar. 2020, 16:54 Fred Bone, wrote: > On 29 March 2020 at 10:40, Adrian Yong said: > > > Hi Adrien, > > > > Below is the screenshot... I get a file type FILE. > > > > [image: image.png] > > Because you chose to give it a plain n

Re: [GNC] General Ledger

. > > Otherwise, you can still open it with Excel via the right-click menu using > a ‘open with’ option, or, start Excel first, then try to File > Open, or > Insert > Sheet from File operation. > > Regards, > Adrien > > > On Mar 28, 2020 w13d88, at 9:40 PM,

Re: [GNC] General Ledger

Hi Adrien, I tried exporting the "Export Account Tree to csv" and "Export Accounts" options. However the exported files cannot be opened in MSExcel nor Acrobat Reader DC... Regards, Adrian On Thu, Mar 19, 2020 at 8:30 AM Adrian Yong wrote: > Thanks Adrien.. > >

Re: [GNC] General Ledger

ar 18, 2020 w12d78, at 6:01 PM, Adrian Yong < > adrianyong.88p...@gmail.com> wrote: > > > > Thank you very much, Adrien, Michael and Stephen for helping me > understand > > Gnucash... > > > > I will submit the documents as

Re: [GNC] General Ledger

; On 3/18/2020 1:52 PM, Stephen M. Butler wrote: > > Adrian, > > > > I give my CPA three items: > > > > 1. Balance Sheet. > > > > 2. Profit Loss statement > > > > 3. Transaction Report of all transactions for the year sorted by > > acc

Re: [GNC] General Ledger

Thank you very much for your assistance. I submit the following to the auditors: 1) P 2) Balance Sheet 3) Journal 4) General Ledger 5) Funds(Cash) Flow Statement 6) Trial Balance That's because they don't use QuickBooks... Regards, Adrian On Wed, 18 Mar. 2020, 13:21 Adrien Monteleone

Re: [GNC] General Ledger

will be provided with a General Ledger which is a collation of all transactions sorted into each of the accounts. If the auditors uses Gnucash, all I need to do is to furnish them with gnucash data file and my problem would vanish... But Regards, Adrian On Wed, 18 Mar. 2020, 01:28 Adrien

Re: [GNC] General Ledger

accounting. Somehow, I have to generate a report on each account and collate them manually into one collection.. Regards, Adrian On Tue, 17 Mar. 2020, 13:39 Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > If you mean you want to see the individual transaction activity in your &

Re: [GNC] General Ledger

with a single line in the report called ‘Retained Earnings’ or > ‘Retained Losses’) > > Regards, > Adrien > > > On Mar 16, 2020 w12d76, at 11:29 PM, Christopher Lam < > christopher@gmail.com> wrote: > > > > Try the customer report in the experimental m

Re: [GNC] General Ledger

Thanks Christopher On Tue, 17 Mar. 2020, 13:19 Christopher Lam, wrote: > If it fits your needs then yes > > On Tue, 17 Mar 2020, 12:47 pm Adrian Yong, > wrote: > >> Hi Christopher, >> >> That means I have to generate a report for each of the accounts ie Cas

Re: [GNC] General Ledger

Hi Christopher, That means I have to generate a report for each of the accounts ie Cash in Bank, Trade Debtors, each customer at a time ? Regards, Adrian On Tue, 17 Mar. 2020, 12:29 Christopher Lam, wrote: > Try the customer report in the experimental menu. > > On Tue, 17 Mar 2020,

Re: [GNC] General Ledger

customer... Otherwise, how would one audit the transactions for a particular customer ? Regards, Adrian On Tue, 17 Mar. 2020, 11:33 Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > Is this a duplicate question? > > Something very similar appeared on this list just

[GNC] General Ledger

Hi, I am trying to generate a General Ledger which lists all the transactions for the period, opening balance and closing balance for each account and or subaccount. Can someone guide me through the General Ledger process to achieve this, please ? Regards, Adrian

[GNC] General Ledger

Hi, Is a General Ledger in GNUcash, the same as for general accounting practices where transactions, opening and closing balances are listed for every account and subaccounts ? Regards, Adrian ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: [GNC] GC 3.2 Import Price File CSV

Thanks for your response. Can you tell me when the spam was sent? I did have some problems some time ago but have changed my password a couple of times since then. Get Outlook for Android From: gnucash-user on behalf of Liz Sent:

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

keep track of, but the goal should always be to use transactions to > show an accurate picture of what happened. What happened is NOT that you > saved money on future purchases. What happened is you received a gift of > $70 in the form of a stored value card. > > But by all means, ask a C

Re: How to create an asset with a reduced value compared to my regular currency (dollars)

Tommy Trussell wrote >> Adrian: >> In the case at hand I spent $430 on the gift card and when I buy >> something >> that costs $100, I'm really only spending $86. That's what makes sense >> to >> me for how this ought to be counted. Since I don't know the c

RE: How to create an asset with a reduced value compared to my regular currency (dollars)

that has a 15% discount, I’m curious about how it can be done at all. Is it indeed a simple matter to set it up the way I wanted? From: Christopher Lam [mailto:christopher@gmail.com] Sent: Friday, December 1, 2017 3:21 To: Mariano, Adrian V. <adr...@mitre.org> Cc: gnucash-user@gnuca

How to create an asset with a reduced value compared to my regular currency (dollars)

I bought a $500 gift card for $430 this week. I would like to add this to gnucash as some kind of asset so that as I spend it, the correctly scaled amount gets transferred to the expense account I use. In other words, if I spend $100 from this account it's really only $86. I tried to do this

Re: Finance-Quote 1.47 released!

Thanks for your response - i tried Morningstar GB but got no response at all - normally I get the reply "Unable to retrieve quotes ..." but this time it looked like it had worked but no updates in the price editor. From: gnucash-user