Save a stock screen (Updated)

3,922 views
Skip to first unread message

JK

unread,
Jul 10, 2013, 10:59:36 PM7/10/13
to google-...@googlegroups.com
This is for those interested in bookmarking a customized stock screen so you don’t have to reenter everything each day. To simplify things, I have combined info from a couple posts I made in the past on the topic and added some additional info. You will need to construct a URL to your stock screen yourself which can then be bookmarked. The URL starts with the following:


Criteria

Then we need to add some criteria. For the first criteria you add a variable to the URL called c0 and which should have a value of the criteria name. Subsequent criteria would have variable names of c1, c2, c3, etc. For each criteria you can add an optional minimum and maximum value range using the variables min0, max0 for the first criteria and min1, max1 for the second criteria. For example:


Of course you need the actual variable names for the desired criteria you want to add. To save time I have listed them below. They were found by viewing the source code of the stock screener page in my browser and searching for the text fieldToDisplayNameMap to find the section containing all the variable names (values of c0, c1,c2, etc). Each name below is listed first with no spaces followed by a space and description which you do not use.

There were some that are in the source code but do not show up on the viewable page - some work, some don't and prevent the results from loading so you will have to test those ones if you want to try any of them. Variables of this type are listed separately below the normal ones in each section.

========================================= 
Popular

ForwardPE1Year 1y fwd P/E
QuotePercChange Quote change (%)
PriceToBook Price to book
PriceSales Price to sales

Price

QuoteLast Last price
EPS EPS
QuotePercChange Quote change (%)
High52Week 52w high
Low52Week 52w low
Price52WeekPercChange 52w price change (%)
Price50DayAverage 50d avg price
Price150DayAverage 150d avg price
Price200DayAverage 200d avg price
Price13WeekPercChange 13w price change (%)
Price26WeekPercChange 26w price change (%)

NavChange Nav change
NavChangePercent Nav change (%)
NavPrior Nav prior
QuoteChange Quote change
Price1DayPercChange 1d price change (%)
Price4WeekPercChange 4w price change (%)
PriceToCashFlowPerShare Price to cash flow per share
PriceYTDPercChange YTD price change (%)

Valuation

MarketCap Market cap
PE P/E ratio
ForwardPE1Year 1y fwd P/E

MarketCapRAS Mkt cap from RAS
MarketCapShareBasis Market cap share basis
NetAssets Net assets

Dividend

DividendRecentQuarter Div recent quarter
DividendNextQuarter Div next quarter
DPSRecentYear Div per share (Recent yr)
IAD Div rate indicated annual
DividendPerShare Div per share
DividendYield Div yield (%)
Dividend Div from cash flow

IncomeDividend Income dividend

Financial Ratios

BookValuePerShareYear Book value/share
CashPerShareYear Cash/share
CurrentRatioYear Current ratio
LTDebtToAssetsYear LT debt/assets (Recent yr) (%)
LTDebtToAssetsQuarter LT debt/assets (Recent qtr) (%)
TotalDebtToAssetsYear Total debt/assets (Recent yr) (%)
TotalDebtToAssetsQuarter Total debt/assets (Recent qtr) (%)
LTDebtToEquityYear LT debt/equity (Recent yr) (%)
LTDebtToEquityQuarter LT debt/equity (Recent qtr) (%)
TotalDebtToEquityYear Total debt/equity (Recent yr) (%)
TotalDebtToEquityQuarter Total debt/equity (Recent qtr) (%)

ATAXRATE Tax rate (Recent yr)
ExpenseRatio Expense ratio
ShortInterestRatioPercent Short interest ratio (%)
TotalDebtToCapitalQuarter Total debt/capital (Recent qtr) (%)
TotalDebtToCapitalYear Total debt/capital (Recent yr) (%)
LTDebtToCapitalQuarter LT debt/capital (Recent qtr) (%)
LTDebtToCapitalYear LT debt/capital (Recent yr) (%)

Operating Metrics

AINTCOV Interest coverage
ReturnOnInvestmentTTM Return on investment (TTM) (%)
ReturnOnInvestment5Years Return on investment (5 yr avg) (%)
ReturnOnInvestmentYear Return on investment (Recent yr) (%)
ReturnOnAssetsTTM Return on assets (TTM) (%)
ReturnOnAssets5Years Return on assets (5 yr avg) (%)
ReturnOnAssetsYear Return on assets (Recent yr) (%)
ReturnOnEquityTTM Return on equity (TTM) (%)
ReturnOnEquity5Years Return on equity (5 yr avg) (%)
ReturnOnEquityYear Return on equity (Recent yr) (%)

Return13Week 13w return
Return156Week 156w return
Return1Week 1w return
Return260Week 260w return
Return4Week 4w return
Return52Week 52w return
ReturnDay 1d return
ReturnOnAssetsPTM Return on assets (PTM) (%)
ReturnOnAssetsQuarter Return on assets (Recent qtr) (%)
ReturnOnEquityPTM Return on equity (PTM) (%)
ReturnOnEquityQuarter Return on equity (Recent qtr) (%)
ReturnOnInvestmentQuarter Return on investment (Recent qtr) (%)
ReturnYTD Return YTD

Stock Metrics

Beta Beta
Float Float
InstitutionalPercentHeld Institutional percent held
Volume Volume
AverageVolume Average volume

BetaDown Beta down from RAS
BetaRAS Beta from RAS
BetaUp Beta up from RAS

Margins

GrossMargin Gross margin (%)
EBITDMargin EBITDA margin (%)
OperatingMargin Operating margin (%)
NetProfitMarginPercent Net profit margin (%)

EBITD EBITDA
EarningsAfterTaxes Earnings after taxes
EarningsBeforeTaxes Earnings before taxes
ANI Earnings after taxes (Recent yr)
CapitalGain Capital gain
ACOGS Cost of goods sold

Growth

NetIncomeGrowthRate5Years 5y net income growth rate
RevenueGrowthRate5Years 5y revenue growth rate
RevenueGrowthRate10Years 10y revenue growth rate
EPSGrowthRate5Years 5y EPS growth rate
EPSGrowthRate10Years 10y EPS growth rate

NextYearEPS Next year EPS
NetIncomeChangePerc Net income change (%)

=========================================

So to begin constructing the URL decide which of the above criteria you want to add and the minimum and maximum values of each if any. Then add them to the URL such as below where I have created an example screen to show companies that have a market cap of 100 million ...


add last quote price between $1 and $5 ...


add 52 week low of at least $0 ...


add 52 week high of at least $5 ...


add 52 week price change % between –99.99 and 0 ...


This example screen could be used to find companies whose stock price has dropped the most in the past 52 weeks.

In addition to the criteria we can add some additional optional variables to the URL:

Region

To add the region add ...

&region=

Using one of the following values

au Australia 
be Belgium
ca Canada
cn China
dk Denmark
ee Estonia
fi Finland
fr France
de Germany
hk Hong Kong
il Israel
in India
is Iceland
it Italy
jp Japan
kr Korea
lt Lithuania
lv Latvia
nl Netherlands
nz New Zealand
pt Portugal
ru Russia
sg Singapore
se Sweden
tw Taiwan
uk United Kingdom
us United States

So for example to restrict the region to the United States ...


Exchange

To add the exchange

&exchange=

Values will vary depending on what region you have selected. Look in the exchange drop down form menu on the page for the value containing no spaces between the parentheses. For example for the US, use one of the following values.

AllExchanges
NASDAQ
NYSE
NYSEARCA
NYSEMKT
OTCBB
OTCMKTS

So for example to only show stocks on NASDAQ ...


Sector

To add the sector

&sector=

Using one of the following values

AllSectors All Sectors 
REUTERS_01 Basic materials 
REUTERS_02 Capital goods 
REUTERS_03 Conglomerates 
REUTERS_04 Consumer cyclical 
REUTERS_05 Consumer/Non-cyclical 
REUTERS_06 Energy 
REUTERS_07 Financial 
REUTERS_08 Healthcare 
REUTERS_09 Services 
REUTERS_10 Technology 
REUTERS_11 Transportation 
REUTERS_12 Utilities 

So for example to show all sectors ...


Currency

To add the currency

&currency=

Values will vary depending on what region you have selected. Some examples include the following values

AUD
CAD
CNY
EUR
GBP
HKD
JPY
USD

So for example to show US dollar ...


Criteria to sort by

To add the sort by

&sort=

Use one of the criteria names you used as the value for the above variable.

So for example to sort the results by the 52 week price change % ...


Sort Order

To add the sort order

&sortOrder=

Use -1 or 1

So for example to sort the results by lowest to highest ...


Bookmark It

Once you have the URL the way you want, copy and paste it into your browser and bookmark it. If you need to make any changes to it, make the changes in the URL instead of the pages form fields and then if needed bookmark it again. For example I have a few versions of the same screen bookmarked with different market cap criteria.

Hopefully Google will eventually provides a simpler way to bookmark or otherwise save a stock screen but until then hopefully this will help. If anyone has a problem, please post the URL you are trying to create and describe what is not working as expected and I'll take a look at it. 

Ram Reddy

unread,
Jul 21, 2013, 7:26:18 AM7/21/13
to google-...@googlegroups.com
Thanks JK...Appreciate the effort that you put into developing this. I am going to try this next week.
Been very frustrated with the Stock Screener especially after the Quote and Price Change problem (not allowing Negative Values) that you encountered as well. I started using my Fidelity account Stock Screener and that served my needs (hope Google Finance looks at Fidelity and learns something).

JK

unread,
Jul 25, 2013, 5:11:47 PM7/25/13
to google-...@googlegroups.com
Your welcome Ram, good luck creating your screen and if you have any problems let me know.

Ahmed AL-MAMUN

unread,
Feb 28, 2016, 9:10:25 PM2/28/16
to Google Finance
Hi JK. This is an amazing post. Exactly what I was looking for. You saved me a lot of time. Great work. Thanks a lot. 

George Aliferis

unread,
Sep 26, 2017, 10:40:25 PM9/26/17
to Google Finance
Hi it looks like these URLs are no longer working, is anyone aware of an update?

Ahmed AL-MAMUN

unread,
Oct 31, 2017, 10:59:54 PM10/31/17
to Google Finance
Hi. This was working before. I have used this method many times, but it doesn't work any more. Any idea what is wrong?


On Thursday, 11 July 2013 12:59:36 UTC+10, JK wrote:
Reply all
Reply to author
Forward
0 new messages