Advance Builder- A Walkthrough into sharpely's Powerful Tool

In the previous article, we explored how to create a stock screen using sharpely’s Basic Builder. Now, it’s time to level up and dive into the Advance Builder—a tool designed for creating even the most complex stock screens quickly and efficiently.

Ready to unlock new possibilities? Let’s get started!

What Makes the Advance Builder Special?

Unlike the Basic Builder, sharpely’s Advance Builder allows you to create custom metrics and add Advance conditions to your screen. For our example, we’ll build a screen to identify:

1. Stocks showing signs of acceleration (momentum).
2. Stocks with a solid financial standing (profitability and return on capital).

To do this, we’ll even create a custom metric combining ROE and ROCE—key indicators of profitability and efficiency.

Step 1: Selecting the Universe

As with the Basic Builder, you can select your stock universe using Index, Exchange, or Custom categories.

But here’s the extra edge: the Advance Builder lets you filter by Candle timeframe. Choose between:

• 1 day
• 1 week
• 1 month

For this example, we’ll focus on daily candles for a more granular analysis.

In our example, we will select ‘All’ stocks.

Step 2: Add Conditions

The Advance Builder makes adding conditions a breeze. Just follow these steps:

• Type the metric you want to use.
• Select a comparator (e.g., greater than, less than, etc.).
• Enter a value or choose another metric to compare against.

As you type, a list of available metrics will appear—click the one you need. Once added, the condition will be highlighted in a distinct color for easy visibility.

For our screen, we’ll add conditions to find stocks that:

1. Are not stagnant or in decline.
2. Are picking up momentum.

Here’s how we’ll do it:

Metric: Price Momentum Score

Value: Between 45 and 65 (indicating stocks gradually gaining momentum)

But we want data for the recent past, not the present candles, right?

In our Advance Builder, we offer a unique feature that lets you select the ‘when the condition is supposed to be true’-- we offer 4 choices.

Since we want past data we will Select> Condition was true N candles ago. And keep N as 15. This means that 15 trading days ago stocks with 45 to 65 Price Momentum scores will be filtered out.

Now, we will add our 2nd Condition. With the past taken care of, we will now focus on the present. For that, we will choose the filter of Price Momentum Score > 75. 

In this same condition, we will add one more filter. We want to find stocks with a solid financial standing. So, we’ll create a custom metric for this. 

You can do it by clicking the ‘Add’ button next to the right. We’ve highlighted it in a green box below. (We’ve also highlighted other steps taken so you have better clarity on how our builder looks so far.)

A box will open like this:

We’ll now create our custom metric. 

1. Name your custom metric for easy identification later.
2. You can toggle between ON/OFF to set negative values to NA.
3. If you want to work with a fixed period of data then turn on the ‘Set as constant’, else keep it off.

This is how we have set it for this example:

We will now click on ‘Done’ and go back to our Condition block 2. 

In it, we will type AND. Then we type ‘CustomRateofReturn’ and set it to be greater than 15. 

We now have all the conditions ready. So we will go ahead and click on Run. Let’s see what the results are.

We got a list of 16 stocks based on the metrics we chose. 

Since the list is not that big, we won’t use the ‘Sort and Limit’ function in this case. But the process is similar to that of the Basic Builder. You can refer to it again in our previous article.

That’s it. That is how you create a screen using the Advance Builder. In the next articles, we’ll be looking at some really exciting use cases, backtesting the strategies created, and more. So, let’s go!