Moving averages can be useful in data analysis, when looking at trends both in finance and in the stock market. You can look at 30, 60, 90 day trends, and even longer or shorter durations. There's also a difference between whether you are looking at ...
Do you buy stocks? Help track your transactions and your returns with this stock trading template. This is an update over the previous stock trading template, offering more reports and analysis, and the ability to more easily track your portfolio's ...
Do you need to create weekly sales reports that compare the same days of the week? This kind of analysis can be tricky to ensure that you are comparing the same day of the week against the same week in the previous year. Simply comparing dates may n ...
What is the PEG Ratio? The Price/Earnings to Growth (PEG) Ratio is a metric that enhances the traditional price-to-earnings (P/E) ratio by incorporating the company's earnings growth rate into the calculation. This ratio is calculated by dividing ...
Do you have year-to-date values and need to calculate running totals? What about if you have criteria you want to track running totals for? In this post, I'll show you how to accomplish both and how you can create a custom function in Power Query th ...
Have data in Power Query that you want to sum up and group by category? In this post, I'll show you how you can sum up values in Power Query to help you analyze your information. In this example, I'm going to use daily sales values by different sale ...
A common problem you might come across with data is that it may sometimes contain missing values. You can remove the data entirely or you can replace the values with something else. If you remove it, you might throw away other useful data related to ...
Do you want an easy way to pull in crypto prices for multiple coins? Using Power Query in Excel, you can accomplish this by connecting to a website such a coingecko.com and downloading the historical values. Below, I'll show you how you can pull in ...
Crypto coin dominance is a vital metric in the cryptocurrency market, providing insights into the relative market strength of a particular cryptocurrency, compared to the overall market. It reflects the proportion of a specific cryptocurrency's mark ...
Inflation is a critical economic indicator, reflecting the rate at which the general level of prices for goods and services is rising, and subsequently, how that erodes the purchasing power of money. To gauge inflation accurately, economists and pol ...
