Relative Strength Index Indicators creations in Power BI with R script data transformation



RSI or Relative Strength Index developed by J. Welles Wilder Jr. in 1978 is a popular tool used in technical analysis to gauge momentum and identify potential overbought or oversold conditions in a stock's price movement. It is a “momentum indicator” that averages price gains and losses during a specific trading period, It helps determine whether a stock is more likely to continue its current trend or change direction. It considers daily stock gains and losses, providing a value between 0 and 100, with the equilibrium level at 50.

The Interpretation of RSI Levels:  
- Overbought (RSI > 70): Indicates that the stock is overbought, and the upward trend may reverse soon. Selling could be prudent.

- Oversold (RSI < 30): Suggests that the stock is oversold, and the downward trend may reverse. Buying opportunities may arise.

There are  different types of RSI based on its moving average calculations. Here I summarize four typic types of RSI in shortlist as following:

 WilderMA RSI: The default RSI calculation (Wilder's moving average) Offers a balance between responsiveness to recent price changes and smoothing out noise for a more stable RSI.

 SMA RSI: The smoothed RSI, based on the Simple Moving Average (SMA), smooths price data evenly over a specified period, can be less responsive to recent changes compared to WilderMA RSI, and potentially leading to slower identification of trends.

 EMA RSI: Combining RSI with the Exponential Moving Average (EMA) places more weight on recent prices. making it more reactive to market movements but potentially more prone to false signals.

WMA RSI: Weighted Moving Average (WMA) - based RSI allows customization of weight distribution assigns weights to past prices with more emphasis on recent ones, offering a level of responsiveness between Wilder RSI and EMA RSI.

We may use R script package TTR to calculate the 4 types RSI and plots them in Power BI via line and stack column visual. The attached YouTube video made by me shared a way on how to make the creations happend.



Comments

Post a Comment

Popular posts from this blog

Power BI DAX Formula for Dynamic Ranking Calculations Based on User Selections and Filters

Image
  The Youtube Vidoe:  Power BI DAX: Dynamic Ranking Calculations Based on User Selections and Filters         DAX formulas from the Video: Total Opp count = DISTINCTCOUNTNOBLANK('Fact'[Opportunity ID]) Total P_Revenue = SUM('Fact'[ProductRevenue]) Total F_P_Revenue = SUM('Fact'[FactoredProductRevenue]) Selected KPIs = SELECTEDVALUE('Table_KPIs'[KPI Name]) Account value rank index =      SWITCH(         TRUE(),         [Selected KPIs]="Opportunity Numbers",RANKX(ALL('Account'[Account]),[Total Opp count],,,Dense),         [Selected KPIs]="Product Revenues",RANKX(ALL('Account'[Account]),[Total P_Revenue],,,Dense),         [Selected KPIs]="Factored Product Revenues",RANKX(ALL('Account'[Account]),[Total F_P_Revenue],,,Dense)     ) Account KPI values for sorting =      SWITCH(         TRUE(),         ...
Read more

Power BI DAX and Visualizations: Active employees across time (as x-axis) by Tenure group or age group

Image
Business Case raised by my youtube channel viewer on the 21st July 2023. In my employee tenure data, it has employee birthday, hire date and leaving date, and race, gender, etc. Do you have any idea how to create a dynamic measure of tenure and/or age, as well as a "tenure group" and "age group" that can change with the calendar date? I would like to show in a line chart the changing number of active employees across time (as x-axis). Furthermore, I would like to breakdown the number of employees by their age group or tenure group (using age group as a legend). The age or tenure group will be dynamically change according to the dates in the X-axis. Any suggestions are appreciated. My suggestions: Assumptions on what we have for the case:                         - an employee table with coloumns: table update(or registered) date,              ...
Read more

Excel VBA Tips: A Macro to Generate Line Chart Dynamically for Loan Schedule Trend Report

Image
The entire code shared in this video is designed to automate the process of creating a dynamic line chart based on loan data in the "Loan Report" sheet and display the chart on the "Charts" sheet. The chart shows trends in accumulated principal, accumulated interest, and loan remaining balance over time. The code is also flexible enough to handle both yearly and monthly loan schedule reports. The VBA codes as: Sub CreateLineChart()       '1. Variable Declarations     Dim srcSheet As Worksheet     Dim chtSheet As Worksheet     Dim lastRow As Long     Dim chartObj As Shape     Dim chartDataRange As Range     Dim xAxisRange As Range     Dim yAxisRange As Range     Dim colPrincipal As Variant     Dim colInterest As Variant     Dim colRemainingBalance, ColMonth As Variant     '2. set source and chart sheets     Set srcSheet = ThisWorkbook.Worksheets("Loa...
Read more