Stock Analysis in Google Sheets (2024)

Real-time and 30+ years of historical price data, fundamentals, analyst ratings, dividends, options and much more for over 80,000 stocks, ETFs, mutual funds, FOREX and cryptocurrencies.

Get started freeRead the docs →

Stock Analysis in Google Sheets (2)

40k+ Downloads

Stock Analysis in Google Sheets (3)

Stock Analysis in Google Sheets (4)

Turbocharge your spreadsheet

Everything you need for your analysis

Simple
We've taken care to keep our functions simple and understandable. Use the Function Generator to explore all the data options available and pull the information directly into Google Sheets.

Detailed
Over 30 years of historical price and fundamental data. Dump entire financial statements, dividend histories, options chains and more into Sheets in an instant.

Powerful
Second-accurate, real-time stock quotes for selected markets, minute-interval intra-day time series generation, technical indicators, price targets, analyst estimates and so much more...

Your analysis

Build your own investing dashboard

Forget about trawling through financial websites to find exactly what you need - design your own analysis using SheetsFinance with Google Sheets.

Fundamental Analysis
Use our historical stock data to track company growth rates and key perfomance ratios, developing your own fundamental analysis.

Dynamic, real-time watchlists
Use our real-time data and sparkline generators to build detailed, global watchlists.

Unlimited Data
We don't have any pesky data limits like some other financial APIs - you can use our service as much as you'd like!

In-built Google Sheets tools

Search and generate data in seconds

Use the in-built Function Generator, Symbol Search and Stock Screener to instantly access the data you need, no formulas required.

Function Generator
Automatically build all our functions without writing a single formula.

Stock Screener
Filter our entire database of over 80,000 financial assets with our in-built Stock Screener.

Symbol Search
Search our entire database for the financial asset you're after.

66 Markets and over 80,000 Assets

  • 🇦🇷 Argentina
  • 🇦🇺 Australia
  • 🇦🇹 Austria
  • 🇧🇪 Belgium
  • 🇧🇷 Brazil
  • 🇨🇦 Canada
  • 🇨🇳 China
  • 🪵 Commodities
  • 🌐 Crypto
  • 🇨🇿 Czech Republic
  • 🇩🇰 Denmark
  • 🇪🇬 Egypt
  • 🇪🇪 Estonia
  • 🇪🇺 Europe
  • 🇫🇮 Finland
  • 💱 FOREX
  • 🇫🇷 France
  • 🇩🇪 Germany
  • 🇬🇷 Greece
  • 🇭🇰 Hong Kong
  • 🇭🇺 Hungary
  • 🇮🇳 India
  • 🇮🇩 Indonesia
  • 🇮🇪 Ireland
  • 🇮🇱 Israel
  • 🇮🇹 Italy
  • 🇯🇵 Japan
  • 🇲🇾 Malaysia
  • 🇲🇽 Mexico
  • 🇳🇱 Netherlands
  • 🇳🇿 New Zealand
  • 🇳🇴 Norway
  • 🇵🇹 Portugal
  • 🇶🇦 Qatar
  • 🇷🇺 Russia
  • 🇸🇦 Saudi Arabia
  • 🇸🇬 Singapore
  • 🇿🇦 South Africa
  • 🇰🇷 South Korea
  • 🇪🇸 Spain
  • 🇸🇪 Sweden
  • 🇨🇭 Switzerland
  • 🇹🇼 Taiwan
  • 🇹🇭 Thailand
  • 🇹🇷 Turkey
  • 🇬🇧 United Kingdom
  • 🇺🇸 USA

Spreadsheet Templates

Free spreadsheet templates to get started quickly

Explore our library of free spreadsheet templates created by the SheetsFinance community and find the perfect sheet to kickstart your financial analysis.

Explore
Search our library of free spreadsheet templates created by the SheetsFinance community.

Download
Once you find the ideal template, make a copy and start using it immediately in Google Sheets.

Contribute
Once you're feeling confident, contribute your own templates to the community.

Stock Analysis in Google Sheets (41)

Everything you need to build your analysis

SheetsFinance is stacked with features to turn your regular Google Sheet into a powerful financial analysis tool.

  • Real-time QuotesOHLCV, ratios, sparklines and more.
  • Historical Financials30+ years of annual and quarterly statements.
  • Daily and Intra-day Time Series30+ years of daily and intra-day OHLCV data.
  • Technical IndicatorsSMA, EMA, RSI and more.
  • Dividends30+ years of dividend history, ratios and dates.
  • AnalystsPrice targets, ratings, estimates and more.

Testimonials

What our community is saying

“WOW, this is the one. It gets you everything you need. It is normally very hard to get data across so many stock exchanges real time or near real time. A quick review of accessible functions will convince you.”

“SheetsFinance is probably the best Excel add-in one can find for markets data. Democratizes access to pro tools with excellent coverage breadth that continues to grow. Customer support is helpful and responsive. Solid documentation too. Lastly, the pace of product improvement in terms of features or new data coverage is excellent. This vastly improves the value one gets out of the subscription. Can't recommend this enough.”

“Great! Simple and effective. Going to use this in all of my investing and trading spreadsheets.”

“Gives you all the finance items that google finance doesn't have. At this price, its a steal! If you do any stock analysis using google sheets, Just get it.”

“This is by far the most impressive tool I've used to do stock analysis as a retail investor. I've spend 100s of hours using dozens of online tools. They all have some sort of benefit, but I've always come back to the idea that it would be much better if I could just access the raw data and then chop it up however I need to to uncover insights about the companies. I finally found a means to do that, and imo it is done in the smartest way possible. Genuinely this is a massive value and an incredibly powerful implementation of what I've been hoping for for so long. Incredible work! Thank you.”

Stock Analysis in Google Sheets (2024)
Top Articles
Sinking Funds: What They Are and How They Could Help You
Town May Be Single-Parent Capital of U.S. : Michigan: Benton Harbor leads the way to uncertain era of divorce, early widowhood, out-of-wedlock births.
English Bulldog Puppies For Sale Under 1000 In Florida
Katie Pavlich Bikini Photos
Gamevault Agent
Pieology Nutrition Calculator Mobile
Hocus Pocus Showtimes Near Harkins Theatres Yuma Palms 14
Hendersonville (Tennessee) – Travel guide at Wikivoyage
Compare the Samsung Galaxy S24 - 256GB - Cobalt Violet vs Apple iPhone 16 Pro - 128GB - Desert Titanium | AT&T
Vardis Olive Garden (Georgioupolis, Kreta) ✈️ inkl. Flug buchen
Craigslist Dog Kennels For Sale
Things To Do In Atlanta Tomorrow Night
Non Sequitur
Crossword Nexus Solver
How To Cut Eelgrass Grounded
Pac Man Deviantart
Alexander Funeral Home Gallatin Obituaries
Energy Healing Conference Utah
Geometry Review Quiz 5 Answer Key
Hobby Stores Near Me Now
Icivics The Electoral Process Answer Key
Allybearloves
Bible Gateway passage: Revelation 3 - New Living Translation
Yisd Home Access Center
Pearson Correlation Coefficient
Home
Shadbase Get Out Of Jail
Gina Wilson Angle Addition Postulate
Celina Powell Lil Meech Video: A Controversial Encounter Shakes Social Media - Video Reddit Trend
Walmart Pharmacy Near Me Open
Marquette Gas Prices
A Christmas Horse - Alison Senxation
Ou Football Brainiacs
Access a Shared Resource | Computing for Arts + Sciences
Vera Bradley Factory Outlet Sunbury Products
Pixel Combat Unblocked
Movies - EPIC Theatres
Cvs Sport Physicals
Mercedes W204 Belt Diagram
Mia Malkova Bio, Net Worth, Age & More - Magzica
'Conan Exiles' 3.0 Guide: How To Unlock Spells And Sorcery
Teenbeautyfitness
Where Can I Cash A Huntington National Bank Check
Topos De Bolos Engraçados
Sand Castle Parents Guide
Gregory (Five Nights at Freddy's)
Grand Valley State University Library Hours
Hello – Cornerstone Chapel
Stoughton Commuter Rail Schedule
Nfsd Web Portal
Selly Medaline
Latest Posts
Article information

Author: Jerrold Considine

Last Updated:

Views: 6257

Rating: 4.8 / 5 (58 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Jerrold Considine

Birthday: 1993-11-03

Address: Suite 447 3463 Marybelle Circles, New Marlin, AL 20765

Phone: +5816749283868

Job: Sales Executive

Hobby: Air sports, Sand art, Electronics, LARPing, Baseball, Book restoration, Puzzles

Introduction: My name is Jerrold Considine, I am a combative, cheerful, encouraging, happy, enthusiastic, funny, kind person who loves writing and wants to share my knowledge and understanding with you.