How to add Customized Columns (and Analysis) to Your Watchlists – Repost
In five minutes Darren shows you how to add custom analysis columns, including studies, trend changes based on moving averages and more to your watchlists. To see his video on how to create a watchlist, click the video below. Optuma is incredibly flexible. If you’re unsure how to implement a custom column after watching this video, contact us!
How to add Customized Columns (and Analysis) to Your Watchlists
by Darren Hawkins
Hi everyone. Quick video showing you how to add your own custom columns to a watch list. If you saw the other video on our site regarding creating watch lists, you’ll know that you can do it through various different ways such as manually typing the tickers or opening a folder from the Security Selection window, Scan Results, or from a CSV file.
If we click F3 on the keyboard, open up the Security Selection window, you’ll see a tab there called Symbol List. I’ve already linked a CSV file called My Stocks. Just got a list of symbols there that I want to keep track of. Open, open list as Watch List. Now I’ll open those columns. To add additional columns click the Plus, New Script Column to open the Script Editor window.
Let’s say I want the RSI value. I’ll type RSI, hit enter. To see the default parameters, I’m going to click on the Text, that opens up this window. I’m going to change it from a 14. to, I’m sorry from a 10 to 14.RSI. In a watch list, the time frame by default is a day, so that is the daily value of the 14.RSI. If we don’t save that script, we can just change the column headings. We can call it RSI 14 and change the column type to a number and set the decimals and so forth.
Now, if you wanted to do a weekly, we can New Script Column, same process, RSI, click on the Text, change to 14 and this is where we change the time frame from Default to Week. You don’t have to know how to type all the syntax into the formula. As you click the window there or the properties in the window, it’ll automatically be added for you and then you can click Apply, so that’s now the weekly value. Again, we can change the column type and make it look how we want it to look and edit the column RSI Weekly.
A couple of other types of columns we can add, a popular one is Change, Percentage Change, so literally just type Change, click on the Text again. Let’s say we want to do a three month change. Change the interval to 3, interval type to Month and then Apply. General Electric, over the last three months, is down 5.85%.
One final column I’ll add is a True/False. That’s simply a formula that is either True or False. Let’s say we want moving average 200., simple based on the close. We want to know if it’s sloping up, so Simply is up. That kind of gives us a general idea of the long term trend. Pick Apply and that column will now open as a or display True/False. If we open up General Electric there, zoom in a bit, at the 200 moving average. You can see that’s sloping up as opposed to Ebay, you can just see it’s just turned the corner and is now sloping down. I’ll just change these column labels so that’s Three Month Percent and this is MA 200 up.
If this is a layout that you want to keep for future watch lists, you can see that it’s on the top left there, No Layout. If I type, I’ll just call this Test. Now, every time I open up a watch list … Let’s do say the ASX Top 100. Open list as Watch list. I can then apply that test layout and as it goes to the 100, it adds those columns as they were created with the same format and positioning. If you want to move them around, just click and drag. If you want to change a layout, I’ve got another one here called Performance. That’s going to go through and recalculate based on different time frames, weekly, monthly, year-to-date, so on and so forth.
Just a quick overview on adding custom columns. If you have any questions be sure to drop us a line. Visit us at Optima.com, sign up for the blog and you’ll be notified when new articles and videos are made available. Thanks very much.
Darren Hawkins, MSTA
Senior Software Specialist at Optuma
Darren is the senior Software Specialist at Optuma. He joined the company in 2009 after attending an introductory technical analysis course. Darren now instructs users all over the world, from experienced Wall Street traders and professional money managers to individual traders drawing their first trendlines.
Darren grew up in the UK and attended college in the USA where he earned a BA in Economics from St Mary's College of Maryland. He went on to spend a few years working at the Nasdaq Stock Market in Washington DC. Going on to live and work in Australia, UK and currently USA, Darren has a broad understanding of the individual needs of traders and investors utilising a wide range of methodologies.
In 2014 Darren passed the UK-based Society of Technical Analysts diploma course, and is looking forward to soon becoming a candidate for the Market Technicians Association's CMT programme.
When not looking at charts, Darren keeps a keen eye on England's cricket team—especially if they are playing against Australia. He recently moved to Charlotte, North Carolina with wife Wendy and their labrador, Gabba.