Help & Support
Send Feedback
Financial Functions
A couple simple functions for inserting financial data into your spreadsheets.
acmeyer9
No users
Works with
Install
Overview
Add simple financial functions to your Google Sheets!

Included functions:
CURRENT_PRICE(symbol) - returns current quote for given stock symbol
CURRENT_SHARES_OUTSTANDING(symbol) - returns current outstanding shares for given stock symbol
NET_INCOME(symbol, year) - returns net income for given stock and year (optional; returns last year if none is passed)
DEPRECIATION(symbol, year) - returns depreciation for given stock and year (optional; returns last year if none is passed)
CAPEX(symbol, year) - returns capital expenditures for given stock and year (optional; returns last year if none is passed)
THREE_YR_AVG_NET_INCOME_GROWTH(symbol) - returns 3 year average net income growth for given stock

Note: you must pass cells as the arguments for functions to work, so create a cell with the stock symbol you would like financial data on (ex. GOOG) and pass it to the above functions. This should also be done if you want a desired year data as well.

Supported financial data sources: Yahoo Finance API

More sources and functions may be added in the future.
Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu