Add-ons
Check out the store for many more
Add-on

Historic Alpha


(0)
offered by patternchain.com
89 users

Overview

For stocks traded at NYSE, NASDAQ, and AMEX: * Analyze Financials Statements * Get End-of-day (EOD) * Browse News
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.
              
              
              
              
         

Details

Version: 6
Updated: August 15, 2017
Language: English