After reading your latest blog post on custom indexes it got me thinking if I could calculate some of my excel charts directly in Optuma.
One of them operates as a lagging indicator that combines a number of factors of price, volume, and time through nested if statements. The idea being that in a chosen group of stocks I can see how many are trending with the chosen indicators.
A simplified version of my excel formula to sum the total of stocks that have their price sitting above the 20 period moving average each day.
We have a custom Market Breadth module which will calculate any true/false condition for a universe of stocks (eg CLOSE()>MA(BARS=20) in your example) to create a time series. This is an optional add-on module available here:
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.