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/de867919655ed57158579b6d8d6dce98ead0706c/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'). > getActiveCell(); > } > 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/ > msgid/beancount/CAFL5w3VXd26FVsou-%2BbDDxLeWE8ad2Q3Jw20% > 2BboUfhpcG%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%2BhNR9dn2F0EWSie3Hh-dj5cRgKJCYs7TFkoDEdMmijrf7g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
