Running total Running total is a very handy and useful tool. Definition From Wikipedia: “Running total is the summation of a sequence of numbers which is updated each time…
Category: Analytics
Calculating Moving Average in SQL
Definition Moving Average is the classical method of time series decomposition to estimate the trend-cycle. You can calculate it for any period of time. Variations of moving average are:…
Calculating a price trend for crypto or stock prices with T-SQL using Linear Regression
This post explains the solution using stock price data. But you can eventually use Bitcoin data or other cryptocurrency data to do the same calculations. This is a framework for predicting future values regardless of data input.