Hi,
I would like to display a graph (I’m using Thimo’s ApexCharts.js and he said that this is a General Bubble question not a question for him) that shows performance of a selected stock and the S&P 500. Stock price is quarterly. Both are stored in my bd like this:
In order to compare the selected stock and the S&P 500, I have to convert the starting price of each stock to 100 with this formula (100/Stock Price:First Item) then multiply the integer (100/Stock Price:First Item) to the rest of the stock prices.
In a repeating group it would look like this:
Stock Price:First Item
Stock Price: Second Item * 100/Stock Price:First Item
Stock Price: Thirds Item * 100/Stock Price:First Item
Stock Price: Fourth Item * 100/Stock Price:First Item
ETC.
***My question is how do I display this data from a repeating group in a graph or is there another way to compare two stocks that need to be converted to 100 first?
Thanks in advance for the support.