Allow csv import of historical quotes
Ever since the online quotes support ended, update stock prices has become a tedious process. The user must go through the gui, find each stock and enter each price one at a time.
Yahoo and others allow users to export stock information to a .csv file. Provide a mechanism to allow users to import stock prices from a .csv file. Perhaps something similar to how users can now import transaction data from .csv.
James Nemanich
shared this idea
-
Lloyd Moore commented
I would like to add that this feature, even in a simple form, would allow access to multiple quote services and would allow developers a very easy way to provide quotes from most any service. In particular FMP API provides a similar service to Alphavantage but at much lower cost: https://site.financialmodelingprep.com/pricing-plans
The free tier for example provides 10x the quotes of the Alphavantage free tier and would likely be sufficient for many more people. -
Rich
commented
the information at https://wiki.gnucash.org/wiki/Stocks/get_prices seems to indicate that gnucash could be updated from a csv file. I am not the programmer that can make this happen, but it seems someone, perhaps with the gnucash project, could handle.
-
Anonymous
commented
alphavantage rejects requests more often than it accepts them. I can get stock price info in .csv form through my brokerage account. It would be great to be able to import that into the price database.
-
James Nemanich
commented
Sorry about the double post. Can you please post the content of the link here? I do not have access to the admin fourms.
-
James Nemanich
commented
"That was only a few days correct. Please read"
I did read that and tried to implement the "solution."The problem is that Alpha Vantage has become so overwhelmed that 95% of the requests made to it are ignored and cause GNUCash to hang. The only way I can get control back is to manually kill the perl command window.
When I am lucky and can get the process to complete, about 1/2 of the prices do not get updated because the individual price retrieve failed.
Is there some other solution that I am not understanding? The Finance::Quote module documentation suggests that it supports dozens of sources, but none of them seem to work.
I don't want historical quotes. I just want to get all the current quotes with out having to manually input each one into the GUI. Can you please change the title back? The request has nothing to do with historical data.
-
> Ever since the online quotes support ended, update stock prices has become a tedious process. The user must go through the gui, find each stock and enter each price one at a time.
That was only a few days correct. Please read
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3FThere is already
https://gnucash.uservoice.com/admin/forums/101223-feature-request/suggestions/4011596-provide-support-for-importing-historic-stock-quote but that is very complex.So the remaining part is: Allow csv import of historical quotes.
I will update the title.
