F::Q not working... any ideas for workaround ?

D sunfish62 at yahoo.com
Sun Nov 5 00:30:28 EDT 2017


Brad, GB,

This is an approach that would be difficult to do on a Mac, since users have to specially compile Gnucash to include python bindings. I don't know about for Windows, but it may be an issue there, too.

Long term, that may be a viable approach, but if you're going to go that route, using and modifying the established tool (Finance::Quote) might be more helpful to the communities that use that tool.

Looking at the (extremely dated, and therefore perhaps incomplete or incorrect) wiki page for python in Gnucash, I see https://github.com/hjacobs/gnucash-stock-portfolio mentioned, which might be a starting point for you if you're set on using python.

David

On November 5, 2017, at 8:14 AM, brad <bradhaack at fastmail.us> wrote:

It might be possible to use this

https://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html

and then use the python backdoor to import the prices.

There might be something useful here:

https://wiki.gnucash.org/wiki/Importing_fund_or_stock_prices_from_an_OFX_file

I'm going to wait a few days to see if someone smarter gets this sorted 
out :)


On 11/04/2017 09:18 AM, GB wrote:
> Hello
>
> As other people have noticed, the Finance::Quote function is no longer
> working for folks (or rather it is something related to Yahoo!Finance API
> modifications causing issues )
>
> Is there a workaround for this?  I simply am not able to manually update
> each security in the Price Editor separately to get a full picture of my
> finances.  Is there another way to workaround this until F::Q function come
> back?
>
> Like, for instance, is there a way I can use Excel or Google spreadsheets to
> pull the quotes needed ( perhaps not from Yahoo ) and then import that that
> as a CSV into GC, or perhaps convert that to a db script to update my
> gnucash db?
>
> Sorry in advance, i know this is obtuse question.  I am not familiar with
> gc's SW design... I am just an un-informed user who is heavily reliant on
> gnucash !
>
> GB
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list