Power BI & R & AI ChatBot: MACD Chart for Stock Price Analysis & Ask Gemini about,
The MACD (Moving Average Convergence Divergence) chart is a popular technical analysis tool and can be a valuable tool for traders and investors to make informed decisions about buying, selling, or holding stocks based on trend direction, momentum, divergence, and overbought/oversold conditions.
In this video I have demonstrated a method on how to create the (MACD) chart based on daily stock price data inputs in Power BI desktop via Power query to run R script. The approach is an approach with skipping the value assumption for the initial EMA (Exponential Moving Averages) value to calculate MACD. In the video also the detail steps to visualize the MACD chart against Stock closing prices were introduced. Finally for the purpose of MACD chart testing, the created MACD charts in power BI for a selected stock has been uploaded to the Google AI ChatBot Gemini and Gemini was asked to give it’s analysis results for stock price performance
