Custom Technical Ranking System from Excel data


I’ve been reading the blog posts on created a custom technical ranking system, and wanted to inquire if there is a way of creating this ranking from excel data that is imported, rather than using scripting.

In my Excel work I have created a custom technical ranking system that characterizes a stock/index, etc as:

Very Strong




Very Weak

Of course, these rankings can be converted to a numerical system such as Very Strong = 5, Strong = 4, etc.

So, I would be very interested to know if this time series can be imported to Optuma, and then create and display the ranking system as explained in the blog.



Hi Paul,

Yes, Optuma can do that. Have a look at this article and let us know if you have any questions.

All the best