{"id":245,"date":"2026-07-27T16:26:17","date_gmt":"2026-07-27T08:26:17","guid":{"rendered":"https:\/\/blog.infoway.io\/en\/?p=245"},"modified":"2026-07-27T16:26:19","modified_gmt":"2026-07-27T08:26:19","slug":"live-stock-prices-in-excel-and-google-sheets-without-writing-a-single-line-of-code","status":"publish","type":"post","link":"https:\/\/blog.infoway.io\/en\/live-stock-prices-in-excel-and-google-sheets-without-writing-a-single-line-of-code\/","title":{"rendered":"Live Stock Prices in Excel and Google Sheets \u2014 Without Writing a Single Line of Code"},"content":{"rendered":"\n

If you’ve ever tried to build a stock watchlist in a spreadsheet, you already know the drill. You reach for =GOOGLEFINANCE(\"AAPL\")<\/code>, it works for US large caps, and then everything falls apart the moment you need a Hong Kong ticker, an A-share, a Japanese stock, a forex pair, or a P\/E ratio that isn’t in Google’s limited field list. Excel users have it worse, there’s no native equivalent, so people paste =WEBSERVICE(...)<\/code> hacks, install flaky browser plugins, or copy-paste from Yahoo Finance every morning.<\/p>\n\n\n\n

This guide is for the analyst, the finance student, the founder tracking a portfolio, and anyone else who wants live-ish market data in a cell<\/strong> without becoming a programmer. It’s the no-code answer to two of the most-searched questions in this space \u2014 “is there a stock price API for Excel?”<\/em> and “is there a Google Sheets stock price API?”<\/em> \u2014 and the honest answer to a third: “is there a Google Finance API?”<\/em> (there isn’t an official public one, which is exactly why so many people end up here). We’ll cover two paths:<\/p>\n\n\n\n

    \n
  1. Google Sheets stock price API<\/strong> \u2014 the easy path. The Infoway API add-on<\/a> is now live on the Google Workspace Marketplace. Install it, paste an API key, and you get formulas like =INFOWAY_PRICE(\"00700.HK\")<\/code> across US, Hong Kong, China, Japan, India, crypto, forex, and commodities.<\/li>\n\n\n\n
  2. Stock price API for Excel<\/strong> \u2014 a no-code Power Query setup that pulls the same market data from the REST API into a refreshable table, no add-on required.<\/li>\n<\/ol>\n\n\n\n

    No Python, no scripts, no cron jobs. Just cells.<\/p>\n\n\n\n

    Why the Google Finance API and GOOGLEFINANCE<\/code> Aren’t Enough<\/h2>\n\n\n\n

    First, a myth to clear up: there is no official, public Google Finance API.<\/strong> Google retired the original Google Finance API back in 2012. What survives is the GOOGLEFINANCE<\/code> spreadsheet function<\/em> inside Google Sheets \u2014 so every search for “google finance api stock price,” “google finance api excel,” or “calling google finance api to get stock prices from excel” is really looking for either that function or a proper replacement. Same story for pulling Yahoo Finance into Excel<\/strong>: there’s no supported Yahoo Finance API either, which is why those =WEBSERVICE()<\/code> scrapers keep breaking.<\/p>\n\n\n\n

    GOOGLEFINANCE<\/code> itself is genuinely useful, and genuinely limited. The gaps that send people looking for something else are always the same:<\/p>\n\n\n\n

    Limitation<\/th>What it means in practice<\/th><\/tr><\/thead>
    US-centric coverage<\/strong><\/td>Non-US tickers are hit-or-miss; many Asian and emerging-market symbols simply return #N\/A<\/code>.<\/td><\/tr>
    Thin fundamental data<\/strong><\/td>You get price, volume, and a handful of ratios \u2014 no full income statement, cash flow, EPS estimates, or beat\/miss data.<\/td><\/tr>
    No control over the source<\/strong><\/td>It’s a black box. When Google changes a symbol mapping or drops an exchange, your sheet breaks and there’s no support channel.<\/td><\/tr>
    Excel has nothing native<\/strong><\/td>Microsoft’s “Stocks” data type is US-focused and can’t be scripted into custom dashboards \u2014 there’s no built-in Excel API for stock prices.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Third-party plugins fill some of this, but they tend to be single-market, break on updates, or lock the useful parts behind a subscription with no free tier to test first. The approach below fixes coverage and fundamentals in one shot, and the Google Sheets path needs zero setup beyond an install and an API key.<\/p>\n\n\n\n

    Path 1: A Google Sheets Stock Price API with the Infoway Add-on (No Code)<\/h2>\n\n\n\n

    Step 1 \u2014 Install the add-on<\/h3>\n\n\n\n

    Open the Marketplace listing<\/a> and click Install<\/strong>:<\/p>\n\n\n\n

    \"google<\/figure>\n\n\n\n

    Google will ask for permission to run the add-on inside your spreadsheets. <\/p>\n\n\n\n

    Once installed, it lives on the sidebar of your Google Sheets:<\/p>\n\n\n\n

    \"google<\/figure>\n\n\n\n

    Step 2 \u2014 Get a free API key<\/h3>\n\n\n\n

    Every formula needs an API key to return data. Create a free account at https:\/\/infoway.io\/en\/create-account<\/a><\/strong> \u2014 no credit card required for the trial tier. Copy the key from your dashboard.<\/p>\n\n\n\n

    Step 3 \u2014 Save your key in the sidebar<\/h3>\n\n\n\n

    In your sheet, click the Infoway API icon on the sidebar to open the panel, paste your API key, and save it:<\/p>\n\n\n\n

    \"infoway<\/figure>\n\n\n\n

    That’s the entire setup. From now on, the custom formulas work in any cell.<\/p>\n\n\n\n

    Step 4 \u2014 Type a formula<\/h3>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span>