“For every new feature we add, we take an old one out.” – David Karp
This is a major frontend update on Screener after a pretty long time (we have been constantly improving and enriching the backend to make it smarter every day). In this update have removed many of the features which were less used or were not really useful. Against this, we have a slimmer code to maintain, a much faster application and a stronger base to expand.
1. Removed the inline notes / Added Screener Talks: We have added Screener Talks to replace the inline notes. Inline notes were hard to maintain as they not only required an active user moderation, but they also became outdated soon. Screener Talks is aimed as a collaborative platform to share interesting links related to Indian financial markets.
2. Update Screen Alerts: Till now Screener offered two types of screen alerts – alerts for new results, and alerts for the changes in top results. Alerts for new results is very much helpful and we love it our-selves (and is still available). But the option of alerts for changes in top results was complicated. Thus we have dropped the support for the screen alerts for the changes in top results (as a workaround, users can still set the limits on the filter criteria and get the similar updates). This provides a much simpler one-click screen alerts usage.
3. Theme updates: We have updated the Screener to the latest frontend frameworks (AngularJS and Twitter Boostrap). Thus the interface is better streamlined for handheld devices (such as mobile phones and tablets). We have also updated the index page to highlight few of the important features (though it still does not cover some of the most powerful aspects of the Screener).
4. Better base for the future: On the technical aspects, Screener now uses AngularJS in the place of jQuery. This is specially useful for pushing future updates. Through this update, it will become much easier for us to iterate new frontend ideas. We have also written a lot of tests during this development phase and refactored a bulk of old code. This all provides a very strong base for the future.
Thanks a lot friends for your continuous support in the form of feedback, criticism and appreciation. We love to hear from you. So continue to share your comments. Also, do let us know if anything breaks in this update :).
TL;DR: New “Export to Excel” and what-if analysis feature, 10 Quarters data in quarterly results, added basic user profile.
“We are what we repeatedly do. Excellence, then, is not an act, but a habit.” – Aristotle
The one most common habit that we investors have, is of copying the data into Excel. We do it repeatedly, for each company! On Screener we tried to improve upon it and have introduced the first testing version of “Export to Excel.”
The export to excel feature is not just a data export thing, but a pre-populated excel sheet with all the formulas and a basic what-if analysis model. And not just that, it allows the user to customize anything and even upload the customized file back on the servers to download all future files in the customized format.
Some of our users have termed it as “magic” and it indeed is. Do give it a try!
Among other features, we have added the 10 quarters data into the quarterly results for even better analysis.
We are also working on an user profile module and have set the structure for same. In the upcoming months, it will have a better integration with all the features and help users know each other better.
As usual, we did fix-up many minor bugs, did some optimizations and improved the backend code. We continue to seek your support to help us in spreading the investing love.
- Columns are movable now
- Auto detection of consolidated numbers
- Better user ratios
- Added “Spread the investing love” page
- Many fixes and optimizations
Last month had been very interesting. We have been visiting places, meeting other value investors and taking inputs to make Screener even more powerful. In the meantime we have also been optimizing and fixing things in Screener. Few of the optimizations are:
1. Movable columns (as shown in above image):
You can drag and move the result columns while screening. The Screener automatically saves and remembers the settings. Continue reading October change-log
One of the most common requests in the feedbacks had been to include consolidated in screener for screening and analysis purpose. We have integrated the support of consolidated numbers in screener now.
– Added a new line item of Operating Margin (OPM) in Annual Results Continue reading Included support for consolidated numbers and other updates recently
We have introduced a contextual noting system in the Screener to gather targeted inputs about a company. Instead of adding vague-opinions, users can leave targeted section notes on a company’s financials. A “section” with notes looks like this:
To post a note on a “section”, just click on the border next to the section you want to annotate:
As the other investors will read the company’s details, they will get a better insight about a company’s history through the notes added by other users. Together, it will help in a better decision making and sharing wisdom with all.
The idea for section notes has been inspired from DjangoBook, a guide about the Django Web framework for the Python programming language.
A feature we felt an umpteen need for, was the ability to see a specific ratio for a company in a very quick way. Screener’s quick ratio feature, does exactly that!
Quick ratios can be used to calculate complex ratios, or quickly see a particular financial figure of a company. Screener automatically remembers your settings and shows those quick-ratios for all the companies.
Screener provides complete flexibility to customize the result columns and even create our own financial ratios.
The financial ratios created are calculated on the fly for all the stocks and can be used in custom screens.
To create a custom ratio, go to create financial ratios page.
You will receive a ratio-creating form, similar to one used for creating custom screens.
Unlike screen queries, we don’t use inequalities but provide a mathematical formula for our ratio.
In above example we create a new custom ratio to calculate difference of current price of the stock from its 52-week low price.
Similarly we can create a ratio to calculate our own DCF Value ratios or any other valuation ratio.
These custom ratios can be also used in creating custom screens.
For any assistance in creating custom ratios, leave a comment below.
Screener allows the investors to create their own stock-screens or modify the existing ones.
It further allows an investors to:
– sort and customize the results
– save the stock-screen
– set email alerts for the screen
– or share the screen with others
In Screener, everything is a financial variable, just like the cells in MS Excel. Using these variables, you can create your own financial ratios and write equations to screen the stocks.
You can click on “Show all variables” to scan through all the available variables.
Stock screens can be as simple (yet effective) as
Current price < Book value.
You can further combine multiple conditions using
Current price < Book value AND
Price to Earning < 8 AND
Market Capitalization > 200
You can sort the above results and click the save button to save the screen. After saving a screen, you can set alerts for it to receive automatic updates.
If you have any problem finding some variables, or need assistance with the query creation, then you can post it here in comments and we will try to assist you.
You can use Screener to create alerts for the stock-screens and for the companies in your watchlist.
Alerts for Screens
Creating alerts for a saved stock screen is just one-click-work.
There are two options for the alerts:
– Alerts for the new results: You will get an email whenever a new company fits the criteria of the screen. It is helpful for the stock screens which are based on the figures of latest quarters. Screener automatically scans for new results and emails the list of new companies every quarter.
– Alerts for changes in top results: Often the stock-screens are made to scan the companies at the end of the spectrum. This alert automatically sorts the results and then email the top 15 companies in the list. It monitors the daily changes in prices and valuations and emails all the further changes in the top 15 results.
Alerts for Stocks
Alerts for the companies in your watchlist are enabled by default.
Screener automatically emails the new announcements and the latest annual reports for the companies added in the watchlist. This aids in taking timely decisions as you are always stay upto-date about your companies.
Screener never sends a spam email and you can opt-out for any of the above updates at any time.
How do you eat an elephant? One bite at a time.
Hello friends! Creating something is fantastic. Watching it grow is euphoric.
It’s around 3 years when we wrote the first line of Screener. At that time, it was a personal hack project built on an Excel sheet. Since then we have written (and re-written) the screener three times from scratch. Each time, we received a fantastic feedback and the application kept improving.
As we continue to work on the Screener, we will keep sharing the new updates through this blog and would love to have your feedbacks.