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.
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.
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
There 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.