[GNC] Enable Online Stock Price Updating in GnuCash

Tue Jun 8 20:33:14 EDT 2021

Chris & Geoff,

Thanks for your help - I was able to get it to work
1. I went to     https://www.alphavantage.co/support/#api-key

      I got a free API Key

         I went to GnuCash -> Edit -> Preferences -> Online Quotes -> and input the Alpha Vantage API Key

2. I re-ran the "Install Online Price Retrieval for GnuCash" - from the Start Menu

         This time I let it run overnight - even though it looked like it was stalled after about 30 minutes

               In the morning it said that it succeeded

                    I ran the CMD Prompt

                         Went to the directory:  C:\Program Files (x86)\gnucash\bin

                                I typed in:   "perl gnc-fq-check

                                     It showed several quote sites as being available

I would recommend that someone update the GnuCash Tutorial to reflect the above (for Windows)

  *   Main part was probably to wait overnight for the "Install Online Price Retrieval for GnuCash" to finish
  *   Also in the tutorial where it says to run "gnc-fq-update" in the shell (cmd) prompt - it would be better to say run it by typing "perl gnc-fq-update"

Different question:  Is there a way to properly record a stock that has been sold short?

Thanks,

Jai Rao

-----Original Message-----
From: Chris Good <goodchris96 at gmail.com>
Sent: Monday, June 7, 2021 8:57 PM
To: gnucash-user at gnucash.org
Cc: jaibrao at outlook.com
Subject: RE: Enable Online Stock Price Updating in GnuCash

Message: 11

Date: Fri, 4 Jun 2021 04:37:09 +0000

From: Jai Rao <jaibrao at outlook.com<mailto:jaibrao at outlook.com>>

To: "GnuCash-User at GnuCash.Org<mailto:GnuCash-User at GnuCash.Org>" <GnuCash-User at GnuCash.Org<mailto:GnuCash-User at GnuCash.Org>>

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

Message-ID:

<SN6PR07MB499156C5DD563583C14A2EDBA03B9 at SN6PR07MB4991.namprd07.prod.outlook.

com>

Content-Type: text/plain; charset="us-ascii"

Sir / Madam,

I am trying to enable Online Stock Price Updating in GnuCash - (in Windows 10).

  *   I have installed Strawberry Perl

     *   Then I ran the "Install Online Price Retrieval for GnuCash" - from

the Start Menu

        *   This goes thru a long process in the CMD Prompt (Shell) window

           *   It seems to make it to the end - see picture below:

           *   [cid:6644e8d2-a3a2-4004-9571-53b898113207]

           *   Then I open a new CMD Prompt and type:  "perldoc

Finance::Quote"

              *   It says that there is no documentation for this

  *   I then tried to go to the GnuCash Wiki page - but I was not able to

get anyhere.

I also could not figure out how to do the Root Shell to run "gnc-fq-update"

Can you please let me know what to do?

Thanks,

Jai Rao

-------------- next part --------------

A non-text attachment was scrubbed...

Name: image.png

Type: image/png

Size: 78003 bytes

Desc: image.png

URL:

<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2Fattachments%2F20210604%2Fc358e8&data=04%7C01%7C%7C0c7c7aaa6f12423fd66708d92a20c0c8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637587142425060741%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=blJ41e6nurNm35%2BwGPii2H40EaFXnF9P621TfGzGSQQ%3D&reserved=0

8c/attachment.png>

-------------- next part --------------

A non-text attachment was scrubbed...

Name: Outlook-q35xlm5e.png

Type: image/png

Size: 68180 bytes

Desc: Outlook-q35xlm5e.png

URL:

<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2Fattachments%2F20210604%2Fc358e8&data=04%7C01%7C%7C0c7c7aaa6f12423fd66708d92a20c0c8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637587142425060741%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=blJ41e6nurNm35%2BwGPii2H40EaFXnF9P621TfGzGSQQ%3D&reserved=0

8c/attachment-0001.png>

-------------- next part --------------

A non-text attachment was scrubbed...

Name: Outlook-udrywjix.png

Type: image/png

Size: 68180 bytes

Desc: Outlook-udrywjix.png

URL:

<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2Fattachments%2F20210604%2Fc358e8&data=04%7C01%7C%7C0c7c7aaa6f12423fd66708d92a20c0c8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637587142425060741%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=blJ41e6nurNm35%2BwGPii2H40EaFXnF9P621TfGzGSQQ%3D&reserved=0

8c/attachment-0002.png>

-------------- next part --------------

A non-text attachment was scrubbed...

Name: Outlook-0cdyg2x0.png

Type: image/png

Size: 68180 bytes

Desc: Outlook-0cdyg2x0.png

URL:

<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.gnucash.org%2Fpipermail%2Fgnucash-user%2Fattachments%2F20210604%2Fc358e8&data=04%7C01%7C%7C0c7c7aaa6f12423fd66708d92a20c0c8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637587142425060741%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=blJ41e6nurNm35%2BwGPii2H40EaFXnF9P621TfGzGSQQ%3D&reserved=0

8c/attachment-0003.png>

------------------------------

Hi Jai Rao,

I don't think you need to run qnc-fq-update with Administrative privileges (the Windows equivalent of Linux root), but to do so:

Click in the Cortana Ask me anything field to the right of the Start button, begin typing "cmd", a search menu should appear. The menu should display "Command Prompt". Right click on "Command Prompt", and select "Run as administrator".

I suggest you use the instructions in

https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FOnline_Quotes%23Helper_Scripts&data=04%7C01%7C%7C0c7c7aaa6f12423fd66708d92a20c0c8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637587142425070467%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=AJ%2FKL%2BANZZR2HAIq57GKtJyR%2BVjEbSjGf0ZtylWPSIU%3D&reserved=0 to run gnc-fq-check to see if there is a problem with your Finance::Quote installation, and it that doesn't find an error, use gnc-fq-dump to test, like say:

perl gnc-fq-dump alphavantage IBM

(There was a typo in

https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FOnline_Quotes%23Source_Alphavantage.2C_US&data=04%7C01%7C%7C0c7c7aaa6f12423fd66708d92a20c0c8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637587142425070467%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ILrtUaD5X6KHL7h%2BxPYXGVLJ1TW4eUpCY%2FSYJlprjhs%3D&reserved=0 that made it difficult to see the Windows alphavantage instructions on that page which I have now fixed.)

If you find a problem, we should be able to help you fix it.

Regards, Chris Good