Dashboards in Excel can update when a user makes a selection on a slicer or refreshes data. You can even use macros to automatically update a chart or dashboard for you. In this post, I'll share with you a template that I've created that will allow ...
In this article, I'll show you how you can download the latest prices for cryptocurrencies, along with percent and volume changes. The data will be downloaded via an API from coinmarketcap.com. Once you've set up the API, it becomes a breeze to pull ...
In Excel, you can create quick and easy visuals with only a formula. You don't need to insert charts or worry about if they are set up correctly. In this post, I'll show you how you can quickly create both bar and column charts. https://youtu.be ...
When displaying data, using percentages isn't always optimal, especially if you're dealing with a very tiny number. In those cases, it may be more effective to display data as a rate per 100,000 or per 1 million, depending on how small of a number y ...
The stock market is off to a rough start to 2022, with the S&P 500 falling more than 5% in just one month. Using a spreadsheet, we can analyze historical trends and patterns to identify what normally happens after such bad starts. Below, I'll us ...
Have you ever wondered how a stock has typically performed month over month? Using a spreadsheet, you can calculate monthly returns and identify patterns of which months are traditionally strong for a stock, and which ones aren't. In this example, I ...
Excel's WEEKNUM function can return the specific week that a date falls in. But to do the reverse is a bit more challenging. In this post, I'll show you how you can get the first and last day of a week (as well as anything in-between). https://y ...
The MACD line and chart is a popular tool for technical analysts who buy and sell stocks. And in this post, I'll show you how you can create it from start to finish. In my example, I've downloaded Apple's stock price history for the past year from Y ...
Correlations can be helpful in determining if there is a pattern or relationship between two sets of data. It can be useful when looking at stocks as those that are highly correlated may move together in the same direction (note: this doesn't mean t ...
A lookup is one of the more common things you can do in Excel. Whether you're using VLOOKUP, a combination of INDEX and MATCH, or the new XLOOKUP, there are no shortage of ways to accomplish it. However, in this post, I'll go over how you can do a l ...
