Here's how you can track the 30 stocks that make up the Dow Jones Industrial Average and sort them based on various attributes using live stock data imported from Google Finance into Google Sheets.
Macros can perform your tasks easier in Google Sheets by automating functions that can be implemented by keyboard shortcuts or command by dropdown menu. Find out how to create macros here.