[GNC] Enable Online Stock Price Updating in GnuCash
Geoff
cleanoutmyshed at gmail.com
Tue Jun 8 21:26:31 EDT 2021
Hi Jai
Well done. To answer your next question:
> Is there a way to properly record a stock that has
> been sold short?
Gnucash will permit you to run a negative balance on a stock, see
attached screenshot.
Note that I am not an accountant, but I think you should also book a
future liability for when the short falls due.
Hope this helps.
Regards
Geoff
=====
On 9/06/2021 10:33 am, Jai Rao wrote:
> 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
> <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
> <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
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnc_short_sell.jpg
Type: image/jpeg
Size: 212131 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210609/817bf772/attachment-0001.jpg>
More information about the gnucash-user
mailing list