Help & Support
Send Feedback
Historic Alpha
For stocks traded at NYSE, NASDAQ, and AMEX: * Analyze Financials Statements * Get End-of-day (EOD) * Browse News
patternchain.com
7 users
Works with
Install
Overview
We have made easy to analyze stock market data with the following 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.
              
              
              
              
         
Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu