shikshan nivesh/
    DataAI ConnectorGreekSoupServicesAbout
    Log inMake a free account
    shikshan nivesh/
    Make a free account
    SN DataUS
    FundsAI ConnectorPricing
    DatasetsCompaniesFundsScreenerEventsAPIAI Connector
    /
    Licence the data
    Home/Data/Yahoo Finance API and Google Finance API

    Guide · Finance APIs

    SN Data, the Yahoo Finance API and the Google Finance API: what works today

    Facts checked on 9 November 2026.

    The short answer

    Neither Yahoo nor Google offers a public finance data API today. Yahoo's developer site lists only its Fantasy Sports API and Sign In With Yahoo, and its terms bar collecting data from its services by automated means without its permission. Google's official route is the GOOGLEFINANCE function inside Google Sheets: prices and a few figures such as P/E and EPS, delayed up to 20 minutes, with no financial statements.

    SN Data covers the part both leave out. Income statements, balance sheets and cash flows from SEC filings come through a documented API with a free key of 250 calls a day, and through Excel, Google Sheets and AI assistants. SN Data does not serve share prices.

    SN Data beside the Yahoo Finance API and the Google Finance API: what works today for prices and for financial statements
    Yahoo Finance API
    None published; its terms bar automated collection
    Google Finance API
    None published; GOOGLEFINANCE works in Sheets
    GOOGLEFINANCE
    Prices delayed up to 20 minutes, no statements
    SN Data free key
    250 calls a day of statements and filings
    • Side by side
    • SN Data at work
    • Is there a Yahoo Finance API?
    • Is there a Google Finance API?
    • Where the financial statements come from
    • Prices and statements in one sheet
    • What the free key covers
    • Common questions

    SN Data, Yahoo Finance and Google Finance, side by side

    What each offers a program or a spreadsheet today, read on Yahoo's and Google's own pages.

    SN Data, Yahoo Finance and Google Finance, side by side
    ComparedSN DataYahoo Finance and Google Finance
    A public APIYes: documented JSON addresses and an OpenAPI file, with a free keyYahoo: none listed on its developer site. Google: none; GOOGLEFINANCE works only inside Google Sheets
    Financial statementsIncome statement, balance sheet and cash flow, by fiscal year from 2007 and by quarter from 2008, each period linked to its 10-K or 10-QYahoo: on its website, with no API. Google: none in GOOGLEFINANCE
    Share pricesNot servedYahoo: on its website, with CSV download on a Gold subscription. Google: GOOGLEFINANCE, delayed up to 20 minutes
    Reading it from codeWhat the key is for: 250 calls a day free, 300 or 1,000 a minute on a planYahoo's terms bar automated collection without its express permission. Google: historical data cannot be read through the Sheets API or Apps Script
    In a spreadsheetThe =SN() formula in Google Sheets, and Excel workbooks for any companyGoogle: GOOGLEFINANCE in Sheets. Yahoo: a CSV download of prices with Gold
    Insider and fund filingsForm 4, Form 144, 13D and 13G, 13F fund holdings, House trades and short interestNone in GOOGLEFINANCE
    Use at workProfessional plan, $49 a month, for use inside one firmGoogle: GOOGLEFINANCE data is not for financial industry professional use

    SN Data at work

    The statements half of the job: five companies in Google Sheets with one formula, Nvidia's quarters, and the API call. Figures are SN Data's own, as of November 2026.

    Google Sheets with one =SN() formula filling the latest fiscal year's revenue and net income for Apple, Microsoft, Nvidia, Alphabet and Amazon
    One =SN() formula fills the latest fiscal year for five companies, each on its own fiscal calendar.
    Nvidia's last five quarters in SN Data's standard lines: revenue, gross profit, operating income, net income and diluted EPS
    Nvidia's last five quarters in standard lines. Its quarters end on a Sunday; each keeps that last day.
    A curl call to the SN Data API for Nvidia's quarterly income statement, with the JSON answer
    The same quarters from the API, trimmed here to a few lines.

    Is there a Yahoo Finance API?

    Not a public one. Yahoo's developer site lists two APIs today, Fantasy Sports and Sign In With Yahoo, and nothing for market or company data. Yahoo's terms of service, last updated on 1 November 2026, say users must not access or collect data from its services by automated means, including scrapers and data mining tools, without Yahoo's express prior permission, and must not reach the services by any method other than the interface Yahoo provides.

    On the website itself, historical prices, dividends and splits can be viewed for most quotes, and downloading them as a CSV file comes with a Yahoo Finance Gold subscription. The code libraries that read Yahoo's pages are written by other people, outside those terms, and can stop working whenever Yahoo changes its pages.

    Is there a Google Finance API?

    No. Google publishes no finance data API for developers. The official route is GOOGLEFINANCE, a function that works inside Google Sheets: =GOOGLEFINANCE("NASDAQ:NVDA", "price") fills a cell with Nvidia's price. Its other figures include the day's open, high, low and volume, market cap, P/E, EPS, the 52-week high and low, beta and shares outstanding, and it returns daily open, close, high, low and volume for past dates.

    Google's help page sets the limits. Quotes may be delayed up to 20 minutes and are provided as is, for information only. The data is not for use by financial industry professionals. Historical data cannot be downloaded or read through the Sheets API or Apps Script; a program that tries gets #N/A. And nothing in GOOGLEFINANCE covers an income statement, a balance sheet or a cash flow.

    Where the financial statements come from

    Every US-listed company files its statements with the SEC in each 10-K and 10-Q. SN Data reads those filings and returns the income statement, balance sheet and cash flow in the same standard lines for every company, with the lines as each company reported them beside them, by fiscal year from 2007 or by quarter from 2008. Each period carries the address of the filing it came from.

    In Google Sheets the SN Data add-on works like GOOGLEFINANCE: =SN("NVDA", "revenue", 2026) fills a cell with Nvidia's revenue for fiscal 2026. From code, one call returns a whole statement.

    Nvidia's last quarters in standard lines
    curl "https://shikshannivesh.com/api/v1/companies/NVDA/financials\
    ?basis=standard&period=quarterly" \
      -H "Authorization: Bearer sn_live_your_key"

    Every API address and its parameters →

    Prices and statements in one sheet

    The two sources sit side by side in Google Sheets. GOOGLEFINANCE fills the price column, delayed as Google describes, and =SN() fills the reported figures beside it: revenue, net income, free cash flow, margins and returns, by year, by quarter or for the last twelve months. A sheet of 50 companies uses 50 SN Data calls, kept for 6 hours however many cells use them.

    What SN Data does not serve

    Share prices, and figures worked out from them such as P/E, market value and dividend yield, are not part of SN Data's API or the =SN() formula.

    Install the SN Data add-on for Google Sheets →

    What the free key covers

    A free SN Data account's key answers 250 calls a day, at most 60 a minute, on the last 5 fiscal years of every covered company: statements, 145 ratios, segments, 8-K events, insider trades, planned sales, large holders, fund holders, House trades and short interest. The Individual plan, $19 a month, opens every year back to fiscal 2007 at up to 300 calls a minute.

    So for prices, the working official route today is GOOGLEFINANCE in Google Sheets, with its 20-minute delay and its limits. For the statements behind a company, the SEC filings are the source, and SN Data returns them through a documented API with a free key.

    Try the same data
    • The API, with a free key →
    • The =SN() formula in Google Sheets →
    • Standardized financial statements →
    • Nvidia's full record →
    • What a free account gets →
    • SN Data: an SEC API for financial statements →
    • Get a free key →

    Common questions

    Does Yahoo Finance have an API?+
    Not a public one. Yahoo's developer site lists only the Fantasy Sports API and Sign In With Yahoo as of 9 November 2026. Yahoo's terms of service bar collecting data from its services by automated means, including scrapers, without Yahoo's express prior permission. Downloading historical prices as a CSV file comes with a Yahoo Finance Gold subscription.
    Does Google Finance have an API?+
    No. Google publishes no finance data API for developers. The GOOGLEFINANCE function in Google Sheets returns prices and a few figures such as P/E and EPS, delayed up to 20 minutes, and its historical data cannot be read through the Sheets API or Apps Script.
    Can GOOGLEFINANCE return income statements or balance sheets?+
    No. GOOGLEFINANCE covers prices, volume, market cap, P/E, EPS, the 52-week range, beta, shares outstanding and daily price history. The SN Data add-on for Google Sheets adds the reported figures: =SN("AAPL", "revenue", 2025) returns Apple's revenue for fiscal 2025 from its 10-K.
    What is a free alternative to the Yahoo Finance API for financial statements?+
    A free SN Data account gets an API key that answers 250 calls a day on the last 5 fiscal years of every covered company: income statements, balance sheets and cash flows in standard and as-reported lines, ratios and segments, each period linked to its SEC filing. It does not serve share prices.
    Is it allowed to scrape Yahoo Finance?+
    Yahoo's terms of service, last updated on 1 November 2026, say users must not access or collect data from its services using automated means, including robots, spiders and scrapers, for any purpose without Yahoo's express prior permission.
    Does SN Data have share prices?+
    No. SN Data carries what companies file and what the SEC, FINRA and the House publish. Share prices, and figures worked out from them such as P/E and market value, are not part of the API or the =SN() formula.

    Free for your personal research, with credit and a link. For API access, bulk files or commercial use, tell us what you need. The data licence

    Data for teams

    The licence
    UseTerms
    Personal researchFree, with credit (Data by Shikshan Nivesh) and a link
    AI search and answer enginesWelcome to read, quote and cite
    Commercial use, products, teamsNeeds a licence
    Bulk files and full historyBy licence
    APIFree key, 250 calls a day; more with a data plan
    • Check your list against our coverage
    • Every field, with its source
    • What each dataset holds

    Tell us who you are, which data and what it is for. We reply from info@shikshannivesh.com.

    We reply by email.

    Data

    • United States
    • Datasets
    • Companies
    • 13F funds
    • Company events
    • Filings explained

    Reference

    • API
    • For AI assistants
    • Free stock data
    • Excel and Google Sheets
    • Google Sheets add-on
    • Schemas
    • Coverage
    • Changelog
    • Status

    Licence and legal

    • Data licence
    • Terms
    • Privacy
    • Disclaimer
    • Refunds

    Shikshan Nivesh

    • About
    • GreekSoup
    • Newsletter
    • Alpha with AI Club
    • Services
    • For teams
    • Contact
    SN Data by Shikshan Nivesh · © 2026 Borkar Nexus Private LimitedNot investment advice. info@shikshannivesh.com