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 <goodchri...@gmail.com> Sent: Monday, June 7, 2021 8:57 PM To: gnucash-user@gnucash.org Cc: jaib...@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 <jaib...@outlook.com<mailto:jaib...@outlook.com>> To: "GnuCash-User@GnuCash.Org<mailto:GnuCash-User@GnuCash.Org>" <GnuCash-User@GnuCash.Org<mailto:GnuCash-User@GnuCash.Org>> Subject: [GNC] Enable Online Stock Price Updating in GnuCash Message-ID: <sn6pr07mb499156c5dd563583c14a2edba0...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
