none
GoogleFinance function for MS Excel - best add-in - open source? RRS feed

  • General discussion

  • I cam e across the GoogleFinance function in the Google docs. It seems that there are a couple of add-in's available for Excel.

    I am looking for some advice on which one to pick. Frankly, an open source-free option would be preferred.

    I am planning to build a dashboard for the major market segments (e.g. emerging market index, last week, last month, last quarter, year, and so on)

    • Changed type L.HlModerator Monday, March 9, 2015 3:30 AM discussion
    Sunday, March 8, 2015 4:15 PM

All replies

  • I can't answer your direct question about free addins, I haven't tried any as it's not difficult to roll your own to your own requirements. But some background info -

    AFAIK there isn't a direct Excel equivalent for the GoogleFinance function, there was the MSN addin, and built in to later versions under Data/Connections. Not sure if this is still working, it was, then it was..., not sure

    Since Excel 2007 for US stocks you can use Smart Tags, see this

    Get a stock quote

    Most third party addins appear to rely on the Yahoo Finance API, though there are others eg Bloomberg.

    In Excel 2013 you can use the new WEBSERVICES function with say an appropriate Yahoo Finance link. In all versions you can get make a Web Query manually or with code, eg I put this together as a crude example a along time ago which still seems to work

    https://groups.google.com/forum/#!topic/microsoft.public.excel.programming/LmGpxWU1-nY

    Look for my post dated "1/21/10" and the routines SampleData, AddYahooQT and UpdateWQ

    Note with the BackgroundQuery:=False the query will need to be updated manually or with code, it's only an example.

    There are different approaches with code which I'd go for using XML, much simpler than it sounds but beyond the scope of this thread.

    Monday, March 9, 2015 1:01 PM
    Moderator
  • Thanks! I am not set on Google Finance. I am happy with Yahoo Finance (or others as well).

    Trying to make it as straight forward without a lot of programming. I am looking for several metrics for each market index. I imagine somehow a function, maybe even with a wizard dialog, where I can select and index or stock and then pick a parameter for the data for the column. e.g. last price, performance last month,... asn so on.

    Tuesday, March 10, 2015 12:59 AM
  • I'm sure there are addins available that do as you describe , as I said I haven't looked at any but why not try any free ones you can find. 

    You say 'without a lot of programming' so maybe that means you are open to some and you are in a developer's forum, did you try the macro I pointed you and see if possible to adapt for your needs?

    Tuesday, March 10, 2015 10:24 AM
    Moderator
  • Apparently MS used to have a free add-in. They discontinued it and it appears to be a pay option now:
    http://financetrain.com/how-to-get-stock-quotes-in-excel-moneycentral-stock-quotes-add-in/

    I looked at the Macro. I am thinking that I would need to add/customize until I have all the fields I am looking for. Might end up doing that. I keep looking around first for a free plugin. 
    Tuesday, March 10, 2015 11:15 PM
  • Finansu (https://github.com/brymck/finansu) is an open-source Excel add-in with a variety of finance related tools, including stock quote UDF functions.

    Here's an open-source add-in that gives you UDFs for the Yahoo service: https://pmstockquote.codeplex.com/

    (Although it says 'for Excel 2013' it should work with older versions of Excel too.)

    Maybe you can try them and write back on what you find, for future users with the same question.

    -Govert



    Saturday, March 21, 2015 10:19 AM
  • Yahoo finance API is not available anymore. I have moved to MarketXLS after this change, much more reliable data.
    Thursday, July 6, 2017 2:53 AM