97 comments

[ 1.5 ms ] story [ 206 ms ] thread
source code?
Sorry it is not open sourced and we do not plan to disclose our source code in near future.
(comment deleted)
This is a very competitive field, with dozens of options. I have done extensive research myself in the past looking for screeners that provide enough functionality for my needs. I'm curious what problem you're attempting to solve vs. all the current entrants in this space? FWIW, I really like your UI + speed.

Things that I have had trouble finding executed well elsewhere (besides the super expensive tools like Factset, Bloomberg, etc) are: a) ability to program your own metrics or criteria w/ formulas and b) ability to leverage historical data beyond current and one previous fiscal year for very select data points.

By the way, I currently use Stock Rover, which has the most functionality I could find at a reasonable price. I do not like the interface but it works. Have tried many others.

That was a scratch your own itch project; just so you understand we (folks behind stockrow) are hobby investors who do not plan to pay for services like bloomberg and ycharts yet require tools and access to data in simplest possible form.

For us problem is that all screeners (and tools) that are available are either slow, dumb, lack flexibility, are really hard to use or expensive (or all of the above combined). So what we did with two friends of mine — we've created our dream product: simple and fast with all data freely available. It is still in it's infancy but we keep adding things that we need and improve it so it suits us.

Sorry to say but we do not plan custom metrics at this point as this is beyond our capabilities as investors at this points (frankly speaking we do not need them, but if voices are loud enough we might consider that options) but we do plan to introduce backtesting at some point.

I know about StockRover but for me UI is really complex; I need a screener where I can get results almost instantly without much thinking or clicking around.

Thanks for the reply. Agree w/ you on all counts for StockRover; I like your UI much better.
As a small time hobby investor, I basically gave up finding a stock screener that was affordable.

This looks great, I'd definitely pay a few dollars a month for something like this.

I've been looking for exactly this tool, looks and behaves really great Im looking forward to using it!
First off, neat tool! I see Finviz.com does much of the same for free.

> we (folks behind stockrow) are hobby investors who do not plan to pay for services like bloomberg and ycharts yet require tools and access to data

Respectfully, you do not require tools and data. You need to play a winners game and not pick stocks. Key to winning investing is to lower fees and taxes. Why?

> Contrary to their oft articulated goal of outperforming the market averages, investment managers are not beating the market: The market is beating them.

via "The Loser's Game" by Charles D. Ellis, written in 1995. www.cfapubs.org/doi/pdf/10.2469/faj.v51.n1.1865

A related podcast with the legend Charlie Ellis (via Masters in Business radio podcast). Mr. Ellis is a former chairman of the Yale University Investments Office and CFA Institute and one-time director of Vanguard Group. He also is the author of "Winning the Loser’s Game: Timeless Strategies for Successful Investing."

https://www.bloomberg.com/view/articles/2017-04-17/charles-e...

For the record - I used to work at YCharts.

One of our loved features was the Screener - we modeled to make it as easy-to-use with setting your own custom metrics and really good timeseries information.

It's cheaper than FactSet and Bloomberg, and you can try a free trial from the site pretty easily.

I am a paying customer of YCharts and like it a lot generally, but the screener is actually lacking IMO. It does not have any historical data beyond TTM, though you are correct that you can create formulaic metrics. One of the things I like to screen for is growing revenue over multiple years, not just TTM; with screener from the OP here, YCharts and many others, that's not an option.
As someone who is completely ignorant about this field of work, can someone briefly explain to me what the difference between something like stockrow.com and google finance is?
Very nice, fast, well laid out. Real-time updating would be the next best feature to implement, but it works really well friend. Hidden Gems is great. Advanced Search also very nice. Thanks a lot for making/sharing this
Thanks! Thanks a lot! Would look into realtime updates but it will be viable for news only atm; we receive financial data from our providers ~5pm NY time — so financial data is not realtime but it is updated daily.
Quick note on the UI. When looking at a ticker, the news hugs the edge of the screen. Maybe a little padding there could help.
Ah will fix that tonight! Thanks a lot.
It's nice, to the point and I really like the use of the monospaced font to make reading easier, especially any of the numbers.

Any plans to allow making user accounts? I would like to keep some stocks tracked and I am looking for a new tool.

Thanks for kind workd! And yup what you are asking for is next major feature on the list; watchlists and portfolio tracking.
Is there anyway we can signup to be notified when these features come available? This is fantastic btw.
Sorry now at the moment; watch Show HN for now ;-)
How about quickly setting up a email newsletter account to notify signups when you push out new features?
Nice project! Good timing too - I track my portfolio on google finance and they are turning that off in November.
Cool interface. Well done.

Where are you guys getting your data from? How fresh is your data?

Thanks! We buy it from various data providers. News are almost realtime and financial data is updated daily starting 5pm (NYT time).
What are people using for portfolio tracking? Google Finance is shutting down portfolios so I'm looking for an alternative.
We do plan to introduce watchlists and portfolios for user tracking in near future. No ETA's though as this is a hobby weekend project
I work at wallmine and we've just released a simple tool for importing Google Finance portfolios:

https://wallmine.com/google-finance-portfolio-alternative

Let me know your thoughts!

(comment deleted)
Looks good but I can find no information about the wallmine company. Are they stealth or something?

Feel free to email neurofog <at> gmail <dot> com

Seeking Alpha, the free piece of the service. It ties my portfolio to constant official news and internal opinion articles with comments at the bottom, lets you follow some authors, has a web and an app version, and a few other things. It's just not very good at cost basis stuff, and it's a pain to enter that stuff in. It also doesn't persist the cost basis between my web and app account, strangely. It gets angry at adblocking but still lets you use the free version of the site.
Check out Personal Capital. Really clean interface. I have all my checking, saving, credit, loan, asset values, and investments in their site which gives a nice running tally of your total net worth.
Google Spreadsheet
this is rad! any way to screen for >1 year since IPO and within 5% of the peak?
Thanks! Not possible with IPO for now but the other thing you are looking for is 52 High Change — https://stockrow.com/screener/3ea3c22a-c913-4512-8f84-c47453...
Awesome, the UI is really straightforward, you did a great job!

I usually look for companies up to a year past their lock out date that have some momentum as my goto investments. sadly yahoo finance has closed their api, and i haven't found a decent replacement yet.

It would be cool to pick a few stocks and generate the filtering criteria that's common amongst them.
Where do you get your data? How reliable is it?
Where do you get stock data in general? I've seen many people use the data but never obtain the data.
Generally third party apps will get data from market data providers like xignite etc. And where does xignite get the data? They pay for sessions to receive market data directly from all of the exchanges they care about. This data is not cheap from either source.
Not cheap — not necessary. There are data providers like tiingo, quandl, intrinio (just to name a few) that provide quite a lot of data for reasonable prices.
That's true, everything is relative and it also depends what scale of market data you require. I think it's quite cheap to get end of day stock prices but if you want real time market data it gets steep. The closer you get to actual real time the more expensive seems to be the trend.
There is https://www.alphavantage.co which is free now but we've stayed away from them since they were not replying to our enquiries and they do not have any ToS available.

Cheapest realtime stock prices I've seen were ~500$; don't remember where that was though.

(comment deleted)
We buy it from various data providers. There are some errors here and there (we fix what we can) but overall data is of high quality.
I like the overview page's pros/cons and the clean design. Nice tool, will try it out for a few weeks.
Thanks, for me thats the first page I check about every company to get really quick insight.
What are you using for a charting engine? I really like the time period selector
We are using highstock from highcarts
I use tiingo.com which is also great (no affinity, just a happy user)
this is nice, really like the chart. But the stock price does not seem accurate.
Any specific examples? Apart from small errors here and there data should be accurate.
Tangent:

There's a link at the bottom to Google Finance. If you click through, the charts required Flash. Google Chrome is blocking Flash.

I bet that's a source of strife for the Finance team over at Google...

If you open up a portfolio in Google Finance, you're greeted with this warning:

> Google Finance is under renovation. As a part of this process, the Portfolios feature won't be available after mid-November 2017. To keep a copy, download your portfolio.

I wish the android app would update, it's from 2011
Yeah I don't get it either why up to this point they did not fix it? For company of such size it will take almost nothing to get rid of flash there and replace it with JS
This is really promising. I have tested many free screeners and they are really bad from UX perspective.

Can I filter by Sector and other category variables? I'm only focusing on tech sector and would like to build filters for various subcategories. I couldn't do it on mobile.

You can filter by sector on bigger device (tablet or laptop/desktop) but not on mobile. We will think about what can be done there, no promises though!
A new stock screener? If there wasn't a better example that the stock market is about to pull back... I remember working on a stock screener in 2006...
thinkorswim platform screener is king imo. you can create custom formulas for screening using almost any study (custom or preset). Also can be used for options / spread screening.

Ameritrade account is required though.

I like your project. Great work. I created a bookmark.
Looks really good and like something I'd use. BTW, one small typo I noticed and can't unnotice: "Availible operators" :-)
(comment deleted)
How do you get the data?
We buy it from various data vendors