Introduction and first metrics
Financial Analytics in Google Sheets
David Ardia
Professor in Quantitative Methods for Finance
Market value of a company
Stock
Slice
Stock
Slice
Stock
Stock price
Dividends
Without dividend
With dividend
Monitoring dashboard
Prices panel
Returns panel
Distribution panel
Benchmarking panel
Historical prices and dividends
Number of prices
Minimum and maximum prices
Functions COUNT(), MIN() and MAX()
Functions COUNT(), MIN() and MAX()
Functions COUNT(), MIN() and MAX()
Functions COUNT(), MIN() and MAX()
Functions COUNTIFS(), MINIFS(), and MAXIFS()
Functions COUNTIFS(), MINIFS(), and MAXIFS()
Functions COUNTIFS(), MINIFS(), and MAXIFS()
Functions COUNTIFS(), MINIFS(), and MAXIFS()
