The blog

Learn everything SheetsFinance from our community of contributors.

How to Access 30+ Years of Historical Stock Data in Google Sheets: From Single Stocks to Massive Portfolios 📊

Learn how to instantly pull historical End of Day (EOD) stock data for any trading day in the last 30+ years in Google Sheets.

AM

Antoine M.

Analyst

How to Connect Your Brokerage Accounts to Google Sheets

Learn how to securely link your brokerage accounts to Google Sheets using SheetsFinance. View your holdings, transactions, orders, options, balances, and more — all in one place.

DM

David Marcuson

Founder

How to Get Company Revenue Segmentation by Product or Geography in Google Sheets

Learn how to pull in live revenue segment data from SEC filings into Google Sheets using SheetsFinance. Analyze company performance by geography or product line to make informed financial decisions.

AM

Antoine Mauger

Analyst

Unlock 30+ Years of Intra-day and Daily Historical Stock Data in Google Sheets 📈

Discover how to access detailed intra-day stock data and over 30 years of historical OHLCV data using the SheetsFinance SF_TIMESERIES function in Google Sheets.

DM

David Marcuson

Founder

Accessing Real-time Insider Trading Data in Google Sheets

Learn how to fetch insider trading data directly from SEC reporting (US Only) as well as quarterly summaries in Google Sheets with the Sheets Finance add-on.

AM

Antoine Mauger

Analyst

Pull Live Stock, Crypto, FOREX and Commodities News Into Google Sheets

Learn how to fetch live news pieces on equities, cryptocurrencies and more in Google Sheets with the Sheets Finance add-on.

AM

Antoine Mauger

Analyst

Building a DCF model in Google Sheets

Learn how to build a Discounted Cash Flow (DCF) model in Google Sheets that automatically fetches financial data using the Sheets Finance add-on.

AM

Antoine Mauger

Analyst

Build a Real-time Cryptocurrency Watchlist in Google Sheets

Turn your Google Sheet into a cryptocurrency watchlist with real-time data from across the globe. Tracking stocks, cryptocurrencies, commodities, FOREX and more all in one place.

AM

Antoine Mauger

Analyst

Track Indian Stock Markets (NSE & BSE) in Real-Time with Google Sheets 🇮🇳

Learn how to track the NSE and BSE in real-time using Google Sheets and the SheetsFinance add-on. Access real-time stock prices and 30+ years of historical data, financial statements, ratios and more for Indian stocks.

DM

David Marcuson

Founder

Build a Real-time Global Stock Watchlist in Google Sheets

Turn your Google Sheet into a global watchlist with real-time data from across the globe. Tracking stocks, cryptocurrencies, commodities, FOREX and more all in one place.

AM

Antoine Mauger

Analyst

Track US Stock Markets (NYSE & NASDAQ) in Real-Time with Google Sheets 🇺🇸

Learn how to track the NYSE and NASDAQ in real-time using Google Sheets and the SheetsFinance add-on. Access real-time stock prices, 30+ years of historical data, financial statements, ratios, and more for US stocks.

DM

David Marcuson

Founder

Understanding Quality: The Business Owner's Perspective

What does quality mean? How do we identify a company with a durable competitive advantage? Let's explore the key metrics and indicators that help us find companies with consistent and predictable growth.

AM

Antoine Mauger

Analyst

Calculating the Daily Total Return of a Stock in Google Sheets

In this article, we explore the simple, yet often overlooked, metric of total return and how to calculate it in Google Sheets using the SheetsFinance add-on.

DM

David Marcuson

Founder

20 Years of Historical Financial Statements

In this article, we show you how to access 20 years of historical financial data for any stock in our database using a free template provided by SheetsFinance.

AM

Antoine Mauger

Analyst

Keeping Track of Dividends in Google Sheets

Learn how to turn Google Sheets into a powerful dividend tracking tool with a few simple functions.

AM

Antoine Mauger

Analyst