Browse critical information on hundreds of thousands of startups to identify your next customer, competitor, or investment.
Works with:
1K+
Overview
We have developed the following custom functions to help you access information on Private and Public Companies:

PRIVATE COMPANIES FUNCTIONS:

=RaisedBetween(amount1, amount2)
                
amount1 - Returns only startups with funding over entered amount (in millions).
amount2 - Returns only startups with funding over entered amount (in millions).
                
Example:  =RaisedBetween(2,5) - Returns all growing startups with funding between 2 and 5 millions.


                
              
           
=FoundedBetween(since, until)
              
since - Returns only growing startups founded in OR after entered year.
until - Returns only growing startups founded until entered year.
                
Example:  =FoundedAfter(2014",2015) - Returns all growing startups founded between 2014 and 2015.
              
                                        
=StartupCity(city)
              
city - Returns only growing startups where HQ is located in defined city.
                
Example:  =StartupCity("New") - Returns all growing startups where city's name has the word 'New' in it.
              
                                    
=StartupVertical(vertical)
              
vertical - Returns only growing startups under defined vertical.   
                               
Example:  =StartupVertical("Tech","yes") - Returns all growing startups with contact information where vertical has the word 'Tech' in it.
                           
          
=SentimentScore(score)
              
score - Returns only growing startups where Social and Regular Media Sentiment is over entered score.
                 
                
Example:  =SentimentScore("0.5") - Returns all growing startups with sentiment score over 0.5. (See our docs to understand meaning).
              
              
              
=ScaleIndex(index)
              
index - Returns only growing startups with scalability level over defined index.
                  
                
Example:  =ScaleIndex("0.1") - Returns all growing startups with scalability index over 0.1 (See our docs to understand meaning).
              
                     
Powered by Patternchain.
              
If you have any questions, don't hesitate to contact us at support@patternchain.com

PUBLIC COMPANIES FUNCTIONS:

=BalanceSheet(ticker, fiscalYear)
                
ticker - Enter stock ticker.
fiscalYear - Enter fiscal year .
                
Example:  =BalanceSheet("MSFT","2012") - Returns Microsoft Balance Sheet from 10-K of fiscal year 2012
                
              
=IncomeStatement(ticker, fiscalYear)
                
ticker - Enter stock ticker.
fiscalYear - Enter fiscal year .
                
Example:  =IncomeStatement("MSFT","2012") - Returns Microsoft Income Statement from 10-K of fiscal year 2012
                
              
              
=Cashflow(ticker, fiscalYear)
                
ticker - Enter stock ticker.
fiscalYear - Enter fiscal year .
                
Example:  =Cashflow("MSFT","2012") - Returns Microsoft Cashflow Statement from 10-K of fiscal year 2012



=EOD(ticker, startDate, endDate)
              
ticker - Enter stock ticker.
startDate - Enter *since* when you need EOD information about ticker.
endDate - Enter *until* when you need EOD information about ticker.
                
Example:  =EOD("MSFT", "2012-11-01","2017-05-01") - Returns Ticker EOD information for every day the market was open during specified period.
              
              
                            
              
=NewsOnStock(ticker)
              
ticker - Enter stock ticker.
                
Example:  =NewsOnStock("MSFT") - Returns the latest news on Microsoft from local newspapers and from specialized media.
              
              
          
         
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
Patternchain will ask for the permissions shown below. Learn more
Patternchain will need access to your Google account
This will allow Patternchain to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Patternchain
December 26, 2017
Simply the best...
Is this review helpful?
Yes
No
Profile Picture
Simon Tuck
June 21, 2018
Stupid. I entered my key and every time I try to use it; it tells me to register. Garbage.
Is this review helpful?
Yes
No
1-2 of 2
Search
Clear search
Close search
Google apps
Main menu