TopMiniSite
-
4 min readTo get stored data by delimiter (;) in MySQL, you can use the SUBSTRING_INDEX function along with the LOCATE function. To extract values between delimiters, you would first check for the position of the delimiter using the LOCATE function, then use the SUBSTRING_INDEX function to extract the substring between delimiters. You can use this approach to retrieve stored data that is separated by a specific delimiter in a MySQL database.
-
4 min readTo calculate the Rate of Change (ROC) in TypeScript, you would need to first determine the initial and final values of the quantity you are measuring over a specific time period. Subtract the initial value from the final value to get the change in quantity. Then divide the change in quantity by the initial value and multiply by 100 to get the rate of change expressed as a percentage.
-
8 min readTo create a Commodity Channel Index (CCI) in Swift, you first need to define the variables that will be used for calculations. These variables include typical price, simple moving average (SMA), and mean deviation. Once you have the variables defined, you can calculate the typical price by averaging the high, low, and close prices. Next, calculate the SMA by adding up the typical prices and dividing by the desired period length.
-
6 min readOn-Balance Volume (OBV) is a technical analysis indicator that measures positive and negative volume flow. It can help traders identify whether there is buying or selling pressure on a particular asset.To calculate OBV in C++, you would typically iterate through the historical price data of the asset and compare the current volume to the previous volume. If the current closing price is higher than the previous closing price, you add the current volume to the OBV.
-
5 min readTo calculate Average Directional Index (ADX) in Clojure, you first need to gather the necessary data including high, low, and closing prices for a specific time period. Then, calculate the True Range (TR), Positive Directional Movement (+DM), and Negative Directional Movement (-DM) using the high and low prices.Next, calculate the Directional Movement Index (DX) by dividing the absolute difference between +DM and -DM by the sum of +DM and -DM.
-
5 min readTo create Moving Average Convergence Divergence (MACD) using Go, you first need to calculate the Exponential Moving Averages (EMAs) of the closing prices of the stock or asset you are analyzing. Typically, a 12-period EMA and a 26-period EMA are used for the MACD calculation.Once you have calculated the EMAs, subtract the 26-period EMA from the 12-period EMA to get the MACD line. This line represents the convergence and divergence of the two moving averages.
-
6 min readTo calculate pivot points in C++, you first need to have the high, low, and closing prices of a financial asset for a given period. The pivot point is a technical analysis indicator used to determine potential support and resistance levels for a security.To calculate the pivot point, you can use the following formula:Pivot Point = (High + Low + Close) / 3Once you have calculated the pivot point, you can also determine support and resistance levels using additional formulas.
-
4 min readIn technical analysis, Support and Resistance levels are crucial in understanding the behavior of the market and making informed trading decisions. Support level is a price level at which a stock or market tends to stop falling and bounce back up, while Resistance level is a price level at which a stock or market tends to stop rising and start to decline.
-
7 min readA stochastic oscillator is a technical analysis tool used to determine overbought or oversold conditions of a security. In JavaScript, you can compute the stochastic oscillator by first calculating the %K and %D values using a set formula. %K is calculated by taking the closing price of the security, subtracting the lowest low price over a specified period, and dividing by the highest high price minus the lowest low price over the same period.
-
6 min readCalculating Bollinger Bands using SQL involves several steps. First, you need to calculate the moving average of a particular dataset over a specified period (e.g. 20 days). Next, calculate the standard deviation of the dataset over the same period. Finally, calculate the upper and lower bands by adding and subtracting two times the standard deviation from the moving average. By executing these calculations in SQL, you can create a table that displays the Bollinger Bands for the dataset.
-
5 min readTo calculate the Chaikin Money Flow (CMF) using JavaScript, you first need to gather the necessary data, which typically includes the closing prices, high prices, low prices, and volume for a specific financial instrument over a certain period of time.Once you have the data, you can proceed to calculate the Money Flow Multiplier (MFM) for each period by finding the typical price (average of high, low, and close) and multiplying it by the volume.