BTW... just occurred to me... maybe this could be a watershed moment. Think about it: ALL those old Perl and Python libraries out there are fetching data from mainly Yahoo and Google APIs. Now that these are gone, they're ALL going to break, as well as a ton of software using those.
Maybe it's time to create a brand new project, to support a very many data sources... Say, in Python3, with type annotations, and a really simple and nice API... Just an idea. On Sat, Dec 9, 2017 at 9:40 PM, Martin Blais <[email protected]> wrote: > Both sources gone indeed. Makes me a bit sad. > It would be real nice to find a good replacement source of free delayed > market data quotes to pull from. > > yegle@'s App Script is a good idea re. Google Finance quotes. > > Another similar idea, which perhaps would require a bit less setup by the > user having to click for permissions and enabling APIs and creating this > "app script" and such would be to "programmatically" create a Sheets docs > using the Sheets API and insert =GOOGLEFINANCE() calls in the spreadsheet > and let it evaluate all the cells at once. This could be done with a Python > script, not entirely unlike this: > https://bitbucket.org/blais/beancount/src/de867919655ed57158579b6d8d6dce > 98ead0706c/beancount/tools/sheets_upload.py?at=default& > fileviewer=file-view-default > Basically have the script > - create a new sheets doc in your account (automatically) > - insert formulas > - wait until it updates the cell values (how to know if it's done? Not > sure) > - download the values locally > - delete the doc > But maybe that's a bit of a Rube Goldberg machine... > > Perhaps ultimately the best thing to do would be to write price fetchers > straight from the exchanges websites, e.g. NASDAQ, NYSE, etc. > http://www.nasdaq.com/symbol/vti > For our pedestrian and very personal finance usage delayed data - which is > what Y. and G. were providing anyway - scraped off the web page is totally > fine IMO; I'd ignore the expensive API and just scrape NASDAQ or NYSE > perhaps. > > > > On Fri, Dec 8, 2017 at 1:39 PM, yegle <[email protected]> wrote: > >> I think this is doable using Google App Script, similar to this PR >> https://github.com/bitly/oauth2_proxy/pull/497 >> >> Sample Google App Script: >> >> ``` >> function GetStockPrice() { >> var files = DriveApp.searchFiles("name = 'beancount_get_stock_price' >> and mimeType ='" + MimeType.GOOGLE_SHEETS + '"'); >> var cell; >> if (files === null) { >> cell = SpreadsheetApp.open(files.next()).getActiveCell(); >> } else { >> cell = SpreadsheetApp.create('beancount_get_stock_price').getActive >> Cell(); >> } >> cell.setFormula('=GoogleFinance("GOOG", "price")'); >> Logger.log(cell.getValue()); >> } >> ``` >> >> On Fri, Dec 8, 2017 at 5:17 AM, Justus Pendleton <[email protected]> >> wrote: >> >>> See the bug report I filed a week ago. Google quotes are gone for good, >>> with no workaround I know. A new price source needs to be written. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Beancount" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> To view this discussion on the web visit https://groups.google.com/d/ms >>> gid/beancount/02cd79f2-98c5-4ffd-9983-f6d88f84c663%40googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Yuchen Ying >> https://about.me/yegle >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Beancount" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> To view this discussion on the web visit https://groups.google.com/d/ms >> gid/beancount/CAFL5w3VXd26FVsou-%2BbDDxLeWE8ad2Q3Jw20%2BboUf >> hpcG%2BJ4_A%40mail.gmail.com >> <https://groups.google.com/d/msgid/beancount/CAFL5w3VXd26FVsou-%2BbDDxLeWE8ad2Q3Jw20%2BboUfhpcG%2BJ4_A%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhMYVQgeA4oRdgn6D50jmWEivedM0Z8z%2BUfSUn-fPbFFyA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
