Build an Earnings Analysis Dashboard in Google Sheets скачать в хорошем качестве

Build an Earnings Analysis Dashboard in Google Sheets

In this walkthrough, we use the SheetsFinance extension in Google Sheets to build a dynamic earnings analysis dashboard. This is a super simple yet powerful template for accessing the TTM quarterly EPS and revenue data for any global financial asset. SheetsFinance gives you access to over 70,000 global financial assets via a series of highly customisable functions. In-built tools like the Function Generator and Stock Screener streamline your spreadsheet building allowing you to forget about the data collection and focus solely on your analysis. 🌎 0:00 Intro 0:43 Getting the earnings data 3:32 Calculating surprise factors 5:25 Using =IFERROR() to handle sheet errors (GOOD TIP!!) 6:26 Building the charts 8:26 Completed template Here's the template, remember to MAKE A COPY (File - Make a copy): https://docs.google.com/spreadsheets/... Get the extension on Google Workspace Marketplace: https://workspace.google.com/u/0/mark... 🔎 Everything you need to know is in the docs: www.sheetsfinance.com/docs